Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2012
    Posts
    3

    Unanswered: db2 doesnot generate redirect script

    Hello,

    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?

    regards
    yasemin

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    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?

  3. #3
    Join Date
    Aug 2012
    Posts
    3
    Hi,

    dmsprdn1:db2dmp 1> db2level
    DB21085I Instance "db2dmp" uses "64" bits and DB2 code release "SQL09074" with
    level identifier "08050107".
    Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23236", and Fix Pack
    "4".
    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


    and,

    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.

    regards
    yasemin

  4. #4
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    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.

  5. #5
    Join Date
    Aug 2012
    Posts
    3
    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
    code: "".

    I did relink db2conf and problem is solved.

    regards
    yasemin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •