Connection to a remote DB2 FILE (not server)
Posted on 2006-06-27
Remote DB2 server owned by a vendor.
They make a mirror copy of the .db file and place onto a share i have access to.
The share is remotely accessed over a T1, and the db size is 500MB.
I would prefer not to have to copy the database every day so is there a way to attach to the database file across the network to the share?
I am absolutely new to db2 as it is only needed for this connector but I do have a large background in SQL.
I do have a copy of DB2 Viper installed on a local machine and wish to use that machine as my data source (for web reporting via ColdFusion), so i will need the solution to not require a user to be logged into the local machine in order to make it work.
If there are alternative ways to approach this, i am all ears. But having no background with db2 I am leaving this up to you, the experts to lead me in the right direction.