var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2 doesnot generate redirect script
Iam trying to do redirect restore. I did it several times before using generate redirect script command. but now it is not working.
Last week server has been changed, storage shifted to another server. I can backup succesfully. but on the source server generate redirect command doesnot give any response.
the command is create the clp file and waiting. clp file size is zero and doesnot changing. Do you have any idea what could that be?
Any facts ?
Which DB2-version and fixpack?
What is the operating system and version?
What is the exact command-line you give?
What is the exact result? How long do you wait?
What information is in the db2diag.log?
dmsprdn1:db2dmp 1> db2level
DB21085I Instance "db2dmp" uses "64" bits and DB2 code release "SQL09074" with
level identifier "08050107".
Informational tokens are "DB2 v126.96.36.199", "s110330", "IP23236", and Fix Pack
Product is installed at "/opt/IBM/db2/V9.7".
dmsprdn1:db2dmp 2> uname -a
AIX dmsprdn1 1 7 00F7BBDB4C00
there are backup images I can see...
dmsprdn1@root </usr/openv/netbackup/bin> ./bplist -C dmsprddb-bkp -S kazooie -t 18 -l -R /
-rw-rw-r-- db2dmp dbdmpadm 115818500K Aug 25 01:09 /DB2/DMP/node0000/20120825005957/DMP.0.db2dmp.node0000.6736.20120825005957.4
-rw-rw-r-- db2dmp dbdmpadm 116871172K Aug 25 01:06 /DB2/DMP/node0000/20120825005957/DMP.0.db2dmp.node0000.6736.20120825005957.3
-rw-rw-r-- db2dmp dbdmpadm 10444820K Aug 25 01:02 /DB2/DMP/node0000/20120825005957/DMP.0.db2dmp.node0000.6736.20120825005957.2
-rw-rw-r-- db2dmp dbdmpadm 132255748K Aug 25 01:00 /DB2/DMP/node0000/20120825005957/DMP.0.db2dmp.node0000.6736.20120825005957.1
my command line is:
dmsprdn1:db2dmp 3> db2 restore database DMP load /usr/openv/netbackup/bin/nbdb2.sl64 redirect generate script /veritas/restore.clp
SQL2001N The utility was interrupted. The output data may be incomplete.
I think I waited abıut 10 or 15 minutes several times. but the size of clp file was zero and didnot changed.
So db2 9.7.4 on AIX.
Verify that the instance-owner can create files on path /veritas
Verify that the instance-owner can overwrite /veritas/restore.clp
Look for clues in the db2diag.log, as requested in my previous reply.
thank you db2mor. I looked at db2diag.log and there was an error about library like:
MESSAGE : SQL2079N An error was reported by the shared library "". Return
I did relink db2conf and problem is solved.