Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Posts
    14

    Unanswered: Rollforward Pending State for few partitions

    Hi,

    i done a redirect restore of a huge database. during the rollforward to PIT i see few partitions are in active, if i issue the rollforward command i get a "database currently inuse" message. i am unable to move further.

    please suggest.

    thanks
    DPF

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    db2level - platform
    describe the implementation
    describe the scenario to backup-restore-rollforward being used
    display all error messages....

    check db2diag log
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Apr 2011
    Posts
    14

    senario

    1. online backup with exclude logs same timstamp for all partitions & catalog node
    2. 9.7.0.5---AIX
    3. during rollforward i get the error for 7 th partition it is unable to get the logs from the overflow log path
    4. if i query the status for rollforward
    below is the error.
    SQL2036N The path for the file or device
    "/db2/TST/NODE0000/log_dir/NODE0007/PRO/C0000000/NODE0000/" is not valid.



    14-03-29-04.15.34.746468+060 I9263292A314 LEVEL: Error
    PID : 15335484 TID : 1 PROC : db2bp
    INSTANCE: db2tst NODE : 000
    EDUID : 1
    FUNCTION: DB2 UDB, data protection services, sqlpsrllf, probe:317
    MESSAGE : Rollforward failed to connect to database. sqlcode -2036.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Where I come from, DBA's are shot for using "exclude logs" in an online backup command. Try using the NORETRIEVE option on the rollforward and see what happens.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    1. Can you show the values of the following db parameters:
    LOGPATH, OVERFLOWLOGPATH, LOGARCHMETH*
    2. What rollforward command exactly did you use?
    3. This directory path really looks strange:
    /db2/TST/NODE0000/log_dir/NODE0007/PRO/C0000000/NODE0000/
    Where did you place your logs for each node for the rollforward command?
    Regards,
    Mark.

Posting Permissions

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