Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2016
    Posts
    6

    Angry Answered: Unable to restore the Db2 backup

    Hi All,
    I am unable to restore the Db2 backup. Getting error while executing the following line
    DB2 Version : 9.7, AIX Version 5.3
    HTML Code:
    rollforward db VATAMC2 stop
    HTML Code:
    SQL0752N  Connecting to a database is not permitted within a logical unit of
    work when the CONNECT type 1 setting is in use.  SQLSTATE=0A001
    Attached are the set of commands that I executed to restore the db.
    I am getting Error due to the last statement only and the rest all the statements are executed successfully.

    Logs attached.
    Can someone help me out with the same?
    Attached Files Attached Files

  2. Best Answer
    Posted by mark.b

    "Hi,

    Have you seen the following error in the db2diag.log?
    Code:
    2016-03-11-01.57.33.801759-360 I7811637A522       LEVEL: Error
    PID     : 151770               TID  : 13109       PROC : db2sysc 0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 13109                EDUNAME: db2bm.2572.0 (VATAMC2) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
    MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
              "Container not accessible"
    DATA #1 : <preformatted>
    Error checking container 0 (/dsexp11/cont/tbs60/cont1) for tbsp 56.  Rc = 870F0011
    You should use with "generate script" clause to see, which else containers you have to redefine to successfully restore the database.

    P.S.:
    Seems that you have AIX IOCPs not enabled.
    You should enable them.
    Configuring IOCP on AIX"


  3. #2
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    You cannot issue a rollfoward until (and unless) the restore has completed *without errors*.
    In your case, the db2diag shows the reason, so you must correct the script appropriately , repeat the restore and do not rollforward unless the restore successfully completes...

    Insufficient space in tablespace DMS_TB6_TS; you must have at least 6402208
    usable pages. (The "usable pages" total does not include pages used
    internally by DB2, so the value specified on the SET TABLESPACE
    CONTAINERS operation should be increased by one extent per container.
    Based on the latest SET TABLESPACE CONTAINERS values specifed, the
    tablespace should have 6402272 pages in total

  4. #3
    Join Date
    Feb 2016
    Posts
    6

    Already tried that

    I had already corrected this error of table space.... still getting the same error message....

  5. #4
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    Post proof that the restore completed successfully before you start the rollforward, and post the latest messages that are in the db2diag.

  6. #5
    Join Date
    Feb 2016
    Posts
    6

    proof

    $ db2 -tvf db_restore.sql
    restore db PRODVAT user mstadmin using from /data/db2_backupfs taken at 20160304 into VATAMC2 redirect without prompting
    SQL1277W A redirected restore operation is being performed. Table space
    configuration can now be viewed and table spaces that do not use automatic
    storage can have their containers reconfigured.
    DB20000I The RESTORE DATABASE command completed successfully.

    set tablespace containers for 29 using (path '/data/VAT_AMC2/tbs29/cont1')
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 46 using (path '/data/VAT_AMC2/tbs46/cont1')
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 47 using (path '/data/VAT_AMC2/tbs47/cont1')
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 43 using (path '/data/VAT_AMC2/tbs43/cont1')
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 48 using (path '/data/VAT_AMC2/tbs48/cont1')
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 44 using (path '/data/VAT_AMC2/tbs44/cont1')
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 34 using (file '/data/VAT_AMC2/tbs34/cont1' 589824)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 35 using (file '/data/VAT_AMC2/tbs35/cont1' 4680192, file '/data/VAT_AMC2/tbs35/cont1a' 4680192)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 36 using (file '/data/VAT_AMC2/tbs36/cont2' 3669984, file '/data/VAT_AMC2/tbs36/cont2a' 3669984)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 37 using (file '/data/VAT_AMC2/tbs37/cont1' 3898624, file '/data/VAT_AMC2/tbs37/cont1a' 3898624)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 38 using (file '/data/VAT_AMC2/tbs38/cont1' 6402272, file '/data/VAT_AMC2/tbs38/cont1a' 1647892)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 39 using (file '/data/VAT_AMC2/tbs39/cont1' 3669976 , file '/data/VAT_AMC2/tbs39/cont12a' 3669976, file '/data/VAT_AMC2/tbs39/cont12b' 3669976, file '/data/VAT_AMC2/tbs39/cont13a' 3669976)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 40 using (file '/data/VAT_AMC2/tbs40/cont1' 5509291, file '/data/VAT_AMC2/tbs40/cont1a' 5509290, file '/data/VAT_AMC2/tbs40/cont1b' 5509290)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 41 using (file '/data/VAT_AMC2/tbs41/cont1' 2294656)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 42 using (file '/data/VAT_AMC2/tbs42/cont1' 4718592)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 45 using (file '/data/VAT_AMC2/tbs45/cont1' 1987872, file '/data/VAT_AMC2/tbs45/cont2' 1987872)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 49 using (file '/data/VAT_AMC2/tbs49/cont1' 4476974, file '/data/VAT_AMC2/tbs49/cont2' 4476973, file '/data/VAT_AMC2/tbs49/cont3' 4476973)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 50 using (file '/data/VAT_AMC2/tbs50/cont1' 3744512)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 51 using (file '/data/VAT_AMC2/tbs51/cont1' 5639424)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 52 using (file '/data/VAT_AMC2/tbs52/cont1' 4132096)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 53 using (file '/data/VAT_AMC2/tbs53/cont1' 3932160)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 54 using (file '/data/VAT_AMC2/tbs54/cont1' 4469376, file '/data/VAT_AMC2/tbs54/cont2' 4469376, file '/data/VAT_AMC2/tbs54/cont3' 4469376)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    set tablespace containers for 55 using (file '/data/VAT_AMC2/tbs55/cont1' 4194304, file '/data/VAT_AMC2/tbs55/cont2a' 4194304, file '/data/VAT_AMC2/tbs55/cont2b' 4194304, file '/data/VAT_AMC2/tbs55/cont3a' 4194304)
    DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

    restore db PRODVAT continue
    SQL1277W A redirected restore operation is being performed. Table space
    configuration can now be viewed and table spaces that do not use automatic
    storage can have their containers reconfigured.
    DB20000I The RESTORE DATABASE command completed successfully.

    rollforward db VATAMC2 stop

    SQL0752N Connecting to a database is not permitted within a logical unit of
    work when the CONNECT type 1 setting is in use. SQLSTATE=0A001

  7. #6
    Join Date
    Feb 2016
    Posts
    6

    Logs

    logs_new_03112016.txt attached
    Attached Files Attached Files

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

    Have you seen the following error in the db2diag.log?
    Code:
    2016-03-11-01.57.33.801759-360 I7811637A522       LEVEL: Error
    PID     : 151770               TID  : 13109       PROC : db2sysc 0
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 13109                EDUNAME: db2bm.2572.0 (VATAMC2) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
    MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
              "Container not accessible"
    DATA #1 : <preformatted>
    Error checking container 0 (/dsexp11/cont/tbs60/cont1) for tbsp 56.  Rc = 870F0011
    You should use with "generate script" clause to see, which else containers you have to redefine to successfully restore the database.

    P.S.:
    Seems that you have AIX IOCPs not enabled.
    You should enable them.
    Configuring IOCP on AIX
    Regards,
    Mark.

  9. #8
    Join Date
    Feb 2016
    Posts
    6
    Thanks Mark.. Additional Tablespaces/Containers were created which were missing in the script which I was executing... Generate Script Clause worked and I am able to restore the database now...

Tags for this Thread

Posting Permissions

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