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