Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007

    Unanswered: tablespace RF pending

    db2 9.1 linux

    After restore redirect from DB1 into DB2 tablespace is in rollforward pending state , coz of space issue while rolling forward in DB2 database which is in diff server

    diag says even when i do tbs level rollforward

    EDUID : 5616 EDUNAME: db2agent (SAMPLE2)
    FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPoolAct, probe:10
    MESSAGE : ZRC=0x8002003C=-2147352516=SQLB_BAD_CONTAINER_PATH
    "Bad container path"

    IS there option to restore tablespace level online, DB is diff, DB1 source DB2 is target ... rebuilt tablespace options will this help, please suggest.


  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    it means that you specified a wrong container path while doing the redirect restore or you did not specify the path at all
    check the tablespace in diaglog and check the set container....
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Oct 2007
    no while doing redirect restore and while setting the container it was sucessful, while rollfoward i gettting this error.


  4. #4
    Join Date
    Apr 2008
    it is advised to use full offline backup image while doing a redirected restore to avoid the step of rollforward. but if it can't possible in your case then try to rebuilt the database along with redirected restore.

    naval k

Posting Permissions

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