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

    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.

    thanks
    Paul

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

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

    regds
    paul

  4. #4
    Join Date
    Apr 2008
    Posts
    39
    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.

    thanks
    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
  •