We are running our Datamart on DB2 9.5 fixpack2a on Windows and my question is about Backups.
We run all of our DEV and test Database Backups over the network via a UNC path like this:
Code:
CONNECT TO MYDB user db2admin using db2admin;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE MYDB user db2admin using db2admin TO "\\kocetl01\DB2DatabaseBackups\MYDB" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO MYDB user db2admin using db2admin;
UNQUIESCE DATABASE;
CONNECT RESET;
the db2admin account is just a local db2 account and our DB2 Services are all started with Local System. the permissions on the share
\\kocetl01\DB2DatabaseBackups\MYDB is EVERYONE\FULL CONTROL
Now for our Production environment. The above code (and path \\kocetl01\DB2DatabaseBackups\MYDB) work fine from our Production DB2 machine, but the requirement is to backup our Production Database to this path
\\kocxraid01\DB2DatabaseBackups\MYDB. the permissions on this share are read\write to the DBA group but the backup always fails with an "invalid path" error. I am forced to write the backups locally and then xcopy them over to \\kocxraid01\DB2DatabaseBackups\MYDB
My question is ..... what kind of permissions need to be on the destination 'share' in order for DB2 to be able to write it's backups there (short of EVERYONE\FULL CONTROL)?????
I know that if the network admins would open up this share to EVERYONE\FULL CONTROL the backups will work... but that's NOT going to happen..
Does anyone have any ideas?