Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Restore db not completing all tablespaces

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-11-10, 16:09
rockycj rockycj is offline
Registered User
  
Join Date: Feb 2007
Posts: 73
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
Reply With Quote
  #2 (permalink)  
Old 05-11-10, 16:14
n_i n_i is offline
:-)
  
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Did you actually look at the log file fragment that you posted? If not, you should - it's all in there.
Reply With Quote
  #3 (permalink)  
Old 05-11-10, 16:40
rockycj rockycj is offline
Registered User
  
Join Date: Feb 2007
Posts: 73
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
Reply With Quote
  #4 (permalink)  
Old 05-11-10, 16:45
ARWinner ARWinner is offline
Registered User
  
Join Date: Jan 2003
Posts: 3,575
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
Reply With Quote
  #5 (permalink)  
Old 05-11-10, 22:14
n_i n_i is offline
:-)
  
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
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.
Reply With Quote
  #6 (permalink)  
Old 05-12-10, 05:27
przytula_guy przytula_guy is offline
Registered User
  
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
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
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.