Hi,

I am facing error when trying to access RMOBJECTS table of RMDB database.

$ db2 "select count(*) from rmadmin.rmobjects"
SQL0293N Error accessing a table space container. SQLSTATE=57048

Request help.

ITs DB2v9.7 FP2

RMDB is content manager database.

RMOBJECTS is a table used to store references of LOBS used in Content Manager.

RMOBJECTS reside in OBJECTS tablespace which is SMS.

OBJECTS tablespace contain 2 tables (RMOBJECTS and RMAGGREGATE)

I am able to access table rmadmin.RMAGGREGATE.

$ db2 "select count(*) from rmadmin.RMAGGREGATE"

1
-----------
0

1 record(s) selected.

but while accessing RMOBJECTS table i am facing error.

$ db2 "select count(*) from rmadmin.rmobjects"
SQL0293N Error accessing a table space container. SQLSTATE=57048
$

Request help.

db2diag.log
db2pd -tablespaces

$ db2pd -db rmdb -tablespaces

Database Partition 0 -- Database RMDB -- Active -- Up 2 days 03:38:50 -- Date 09/15/2011 19:01:59

Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
0x0700000087599520 0 SMS Regular 4096 32 No 32 1 1 On 1 0 31 SYSCATSPACE
0x070000008759CC60 1 SMS SysTmp 4096 32 No 32 1 1 On 1 0 31 TEMPSPACE1
0x070000008759E360 2 SMS Regular 4096 32 No 32 1 1 On 1 0 31 USERSPACE1
0x070000008D064100 3 SMS Regular 32768 32 No 32 2 2 On 1 0 31 OBJECTS
0x070000008D067600 4 SMS Regular 4096 32 No 32 3 3 On 1 0 31 SMS
0x070000008D06AB00 5 SMS Regular 32768 32 No 32 4 4 On 1 0 31 PARTS
0x070000008D06E240 6 SMS Regular 32768 32 No 32 5 5 On 1 0 31 BLOBS
0x070000008D0720C0 7 SMS Regular 32768 32 No 32 6 6 On 1 0 31 REPLICAS
0x070000008D0755C0 8 SMS Regular 4096 32 No 32 7 7 On 1 0 31 TRACKING
0x070000008D078AC0 9 SMS Regular 32768 32 No 32 8 8 On 1 0 31 VALIDATEITM
0x070000008D07BFC0 10 SMS Regular 4096 32 No 32 1 1 On 1 0 31 SYSTOOLSPACE
0x070000008D080080 11 SMS Regular 32768 32 No 32 9 9 On 1 0 31 OBJPARTS
0x070000008D083580 12 SMS UsrTmp 4096 4 Yes 4 1 1 On 1 0 3 SYSTOOLSTMPSPACE

Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers PathsDropped
0x0700000087599520 0 69912 69912 69912 0 0 0 0 0x00000000 1283388857 0 No
0x070000008759CC60 1 1 1 1 0 0 0 0 0x00000000 0 0 No
0x070000008759E360 2 1 1 1 0 0 0 0 0x00000000 0 0 No
0x070000008D064100 3 251959 251959 251959 0 0 0 0 0x00000000 1294401818 0 No
0x070000008D067600 4 195 195 195 0 0 0 0 0x00000000 1283081941 0 No
0x070000008D06AB00 5 1 1 1 0 0 0 0 0x00000000 1283018016 0 No
0x070000008D06E240 6 10 10 10 0 0 0 0 0x00000000 0 0 No
0x070000008D0720C0 7 15 15 15 0 0 0 0 0x00000000 1283079224 0 No
0x070000008D0755C0 8 16 16 16 0 0 0 0 0x00000000 1283079225 0 No
0x070000008D078AC0 9 15 15 15 0 0 0 0 0x00000000 1283090551 0 No
0x070000008D07BFC0 10 102 102 102 0 0 0 0 0x00000000 1284566184 0 No
0x070000008D080080 11 6 6 6 0 0 0 0 0x00000000 1283018015 0 No
0x070000008D083580 12 1 1 1 0 0 0 0 0x00000000 1283098783 0 No

Tablespace Autoresize Statistics:
Address Id AS AR InitSize IncSize IIP MaxSize LastResize LRF
0x0700000087599520 0 No No 0 0 No 0 None No
0x070000008759CC60 1 No No 0 0 No 0 None No
0x070000008759E360 2 No No 0 0 No 0 None No
0x070000008D064100 3 No No 0 0 No 0 None No
0x070000008D067600 4 No No 0 0 No 0 None No
0x070000008D06AB00 5 No No 0 0 No 0 None No
0x070000008D06E240 6 No No 0 0 No 0 None No
0x070000008D0720C0 7 No No 0 0 No 0 None No
0x070000008D0755C0 8 No No 0 0 No 0 None No
0x070000008D078AC0 9 No No 0 0 No 0 None No
0x070000008D07BFC0 10 No No 0 0 No 0 None No
0x070000008D080080 11 No No 0 0 No 0 None No
0x070000008D083580 12 No No 0 0 No 0 None No

Containers:
Address TspId ContainNum Type TotalPgs UseablePgs PathID StripeSet Container
0x070000008759A9E0 0 0 Path 69912 69912 - 0 /data2/db2inst2/rmspace0
0x070000008759E120 1 0 Path 1 1 - 0 /data2/db2inst2/rmspace1
0x070000008759F820 2 0 Path 1 1 - 0 /data2/db2inst2/rmspace2
0x070000008759FA60 3 0 Path 251959 251959 - 0 /data2/db2inst2/rmspace3
0x070000008759FCA0 4 0 Path 195 195 - 0 /data2/db2inst2/rmspace4
0x070000008D06BFC0 5 0 Path 1 1 - 0 /data2/db2inst2/rmspace5
0x070000008D06F700 6 0 Path 10 10 - 0 /data2/db2inst2/rmspace6
0x070000008D06F940 7 0 Path 15 15 - 0 /data2/db2inst2/rmspace7
0x070000008D06FB80 8 0 Path 16 16 - 0 /data2/db2inst2/rmspace8
0x070000008D06FDC0 9 0 Path 15 15 - 0 /data2/db2inst2/rmspace9
0x070000008D07D480 10 0 Path 102 102 - 0 /data2/db2inst2/rmspace10
0x070000008D07F700 11 0 Path 6 6 - 0 /data2/db2inst2/rmspace11
0x070000008D07F940 12 0 Path 1 1 - 0 /data2/db2inst2/rmspace12
$

Diaglog has been attached for reference.

Install the latest fixpack, then restore the database from the backup that you no doubt have.

have you touched some files - changed ownership - authorities
check : /data2/db2inst2/rmspace3/SQL00002.DAT
something is wrong for that file
it is possible that the ok-table does not have any pages in this container

I have not changed ownership of that file... but hv given full rights (777) to all the container files.

Is there any way to recover the table without restore,rollforward??

And how this happnd?? Would like to know the possibilities of corruption...

One more thng which i hv noticed is.

files of tablespace OBJECTS resides in /data2/db2inst2/rmspace3 folder.

files inside it are :

-rwxrwxrwx 1 db2inst2 db2grp1 512 Dec 03 2010 SQLTAG.NAM
-rwxrwxrwx 1 db2inst2 db2grp1 131072 Dec 03 2010 SQL00003.INX
-rwxrwxrwx 1 db2inst2 db2grp1 32768 Dec 03 2010 SQL00003.DAT
-rwxrwxrwx 1 db2inst2 db2grp1 2053298217 Sep 09 14:41 SQL00002.DAT.Z
-rwxrwxrwx 1 db2inst2 db2grp1 4149379072 Sep 09 14:41 SQL00002.INX

Now what is .DAT.Z file means??

That was wrong.

Someone not too smart tried to free up disk space.

LOL

Yup looks like someone compressed your container dude...

Thanks a lot guys...

I have uncompressed the file. and Now it is working fine.

Not finished yet. You need a another tool:
http://www.toolstation****/images/li...bbig/45603.jpg
and the balls of the guy who messed with your tablespaces.............

give it a swing

(same happened to me last month. for met it was the cache folder of the content manager on demand system........ it will not happen again)