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 > DB2 backup issue

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-12-06, 13:48
mark_maz mark_maz is offline
Registered User
 
Join Date: Feb 2002
Location: Hamilton
Posts: 138
DB2 backup issue

DB2 8.1 on AIX 5.2

We had a filesystem corruption that our unix admins were able to recover from but now we get this message when we try to run a offline backup. I checked the state on the tablespaces and everything looks fine.

any ideas???

thanks

Mark



$ db2 backup db was online to /dev/null
SQL2048N An error occurred while accessing object "Tablespace: 0, Table:
SQL00063". Reason code: "4".
$ db2 list tablespaces show detail
SQL1024N A database connection does not exist. SQLSTATE=08003
$ db2 connect to was

Database Connection Information

Database server = DB2/6000 8.1.2
SQL authorization ID = WASUA1
Local database alias = WAS

$ db2 list tablespaces show detail

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 7512
Useable pages = 7512
Used pages = 7512
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 8
Prefetch size (pages) = 8
Number of containers = 1
Minimum recovery time = 2003-10-09-16.53.06.000000

Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1

Tablespace ID = 2
Name = USERSPACE1
Type = System managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 2992
Useable pages = 2992
Used pages = 2992
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 16
Number of containers = 1
Minimum recovery time = 2003-08-29-15.36.15.000000
Reply With Quote
  #2 (permalink)  
Old 06-12-06, 15:54
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Try running db2dart against that tablespaces (and other, too). Also, check that the owner of the files is the db2 instance owner - your admins might have messed up file permissions.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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