Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: Restore db not completing all tablespaces

    I'm on DB2 v9.1 and trying to restore a database on testhadr from a backup on test. Here is the restore command I'm running and below is the message:

    db2 restore db copd811 from . taken at 20100511140502 on /db2syscat/ replace existing

    SQL2563W The restore process has completed successfully, but one or more
    table spaces from the backup were not restored

    Earlier I restored the test system just fine, so I'm thinking that there are setup problems.


    Then there are errors in the db2diag.log:
    2010-05-11-14.30.58.711510-300 I3327A358 LEVEL: Error
    PID : 4391072 TID : 1 PROC : db2bm.14942404.0 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
    MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
    "Container not accessible"

    2010-05-11-14.30.58.712809-300 I3686A393 LEVEL: Error
    PID : 4391072 TID : 1 PROC : db2bm.14942404.0 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
    DATA #1 : String, 110 bytes
    Error checking container 0 (/db2_data/snapshot/copd811/container1/ts_snapdata.db2) for tbsp 17. Rc = 860F000A

    2010-05-11-14.30.58.733123-300 I4080A897 LEVEL: Error (OS)
    PID : 12517626 TID : 1 PROC : db2pfchr 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloFilePreallocationOnFSWithFastExtend, probe:70
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
    DIA8312C Disk was full.
    CALLED : OS, -, ioctl
    OSERR : ENOSPC (28) "No space left on device"
    DATA #1 : signed integer, 4 bytes
    0
    DATA #2 : signed integer, 4 bytes
    28
    DATA #3 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    0x0FFFFFFFFFFFD5D0 : 0000 0003 0000 0088 ........
    DATA #4 : File size, 8 bytes
    1024
    DATA #5 : unsigned integer, 8 bytes
    4096
    DATA #6 : Logical page size, PD_TYPE_MEM_PAGE_SIZE, 4 bytes
    4096
    DATA #7 : unsigned integer, 8 bytes
    31276032
    DATA #8 : unsigned integer, 8 bytes
    7635
    DATA #9 : unsigned integer, 8 bytes
    1

    2010-05-11-14.30.58.736211-300 I4978A402 LEVEL: Error
    PID : 12517626 TID : 1 PROC : db2pfchr 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloFilePreallocationOnFSWithFastExtend, probe:200
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
    DIA8312C Disk was full.
    DATA #1 : Codepath, 8 bytes
    2:4:5:10:15:16

    2010-05-11-14.30.58.741294-300 I5381A897 LEVEL: Error (OS)
    PID : 11534340 TID : 1 PROC : db2pfchr 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloFilePreallocationOnFSWithFastExtend, probe:70
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
    DIA8312C Disk was full.
    CALLED : OS, -, ioctl
    OSERR : ENOSPC (28) "No space left on device"
    DATA #1 : signed integer, 4 bytes
    0
    DATA #2 : signed integer, 4 bytes
    28
    DATA #3 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    0x0FFFFFFFFFFFD5D0 : 0000 0003 0000 0088 ........
    DATA #4 : File size, 8 bytes
    1024
    DATA #5 : unsigned integer, 8 bytes
    4096
    DATA #6 : Logical page size, PD_TYPE_MEM_PAGE_SIZE, 4 bytes
    4096
    DATA #7 : unsigned integer, 8 bytes
    31276032
    DATA #8 : unsigned integer, 8 bytes
    7635
    DATA #9 : unsigned integer, 8 bytes
    1

    2010-05-11-14.30.58.743373-300 I6279A402 LEVEL: Error
    PID : 11534340 TID : 1 PROC : db2pfchr 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloFilePreallocationOnFSWithFastExtend, probe:200
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
    DIA8312C Disk was full.
    CALLED : OS, -, ioctl
    OSERR : ENOSPC (28) "No space left on device"
    DATA #1 : signed integer, 4 bytes
    0
    DATA #2 : signed integer, 4 bytes
    28
    DATA #3 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    0x0FFFFFFFFFFFD5D0 : 0000 0003 0000 0088 ........
    DATA #4 : File size, 8 bytes
    1024
    DATA #5 : unsigned integer, 8 bytes
    4096
    DATA #6 : Logical page size, PD_TYPE_MEM_PAGE_SIZE, 4 bytes
    4096
    DATA #7 : unsigned integer, 8 bytes
    31276032
    DATA #8 : unsigned integer, 8 bytes
    7635
    DATA #9 : unsigned integer, 8 bytes


    2010-05-11-14.30.58.743373-300 I6279A402 LEVEL: Error
    PID : 11534340 TID : 1 PROC : db2pfchr 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloFilePreallocationOnFSWithFastExtend, probe:200
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
    DIA8312C Disk was full.
    DATA #1 : Codepath, 8 bytes
    2:4:5:10:15:16

    2010-05-11-14.30.58.762727-300 I6682A344 LEVEL: Error
    PID : 4391072 TID : 1 PROC : db2bm.14942404.0 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, buffer pool services, sqlbSetPoolCont, probe:1360
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
    DIA8312C Disk was full.

    2010-05-11-14.30.58.772280-300 E7027A381 LEVEL: Error
    PID : 4391072 TID : 1 PROC : db2bm.14942404.0 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, database utilities, sqludProcessSPCS, probe:3608
    DATA #1 : <preformatted>
    Problem restoring table space SNAPDATA (17).
    Function return code: 0, container return code = -2062614516.

    2010-05-11-14.30.58.772506-300 E7409A307 LEVEL: Warning
    PID : 4391072 TID : 1 PROC : db2bm.14942404.0 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, database utilities, sqludProcessSPCS, probe:3640
    DATA #1 : <preformatted>
    Skipping table space SNAPDATA.

    2010-05-11-14.35.16.739751-300 I7717A314 LEVEL: Warning
    PID : 9437314 TID : 1 PROC : db2med.14942404.0 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1270
    MESSAGE : Media controller -- all restore files processed

    2010-05-11-14.35.19.057464-300 E8032A505 LEVEL: Warning
    PID : 14942404 TID : 1 PROC : db2agent (COPD811) 0
    INSTANCE: db2inst1 NODE : 000 DB : COPD811
    APPHDL : 0-26 APPID: *LOCAL.db2inst1.100511193057
    AUTHID : DB2INST1
    FUNCTION: DB2 UDB, database utilities, sqludBMResponse, probe:695
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes

    Could someone help me with what I could check or begin looking at with these errors and warnings?

    Thank you.

    CC

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Did you actually look at the log file fragment that you posted? If not, you should - it's all in there.

  3. #3
    Join Date
    Feb 2007
    Posts
    84

    New to DB2

    I'm pretty new to DB2 and have never encounter this issue before. Im learning as I go. I'm not an expert!

    Thank you.

    CC

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You have already been told what you need to do. Read All the messages that you posted and ask yourself this: why would all of the data not be restored?

    Andy

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by rockycj View Post
    I'm pretty new to DB2 and have never encounter this issue before. Im learning as I go. I'm not an expert!
    I think it's more about reading comprehension than DB2.

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    how about this : "Disk full."
    this is the first message that would indicate some errors..
    pd/psi is very important
    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

Posting Permissions

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