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 > Error accessing a table space container

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Location: Mumbai,India
Posts: 49
Error accessing a table space container

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.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Location: Mumbai,India
Posts: 49
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.
Reply With Quote
  #3 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,393
db2diag.log
db2pd -tablespaces
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Location: Mumbai,India
Posts: 49
$ 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.
Attached Files
File Type: zip db2diag.zip (1.38 MB, 8 views)
Reply With Quote
  #5 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,393
Install the latest fixpack, then restore the database from the backup that you no doubt have.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,196
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
__________________
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
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Location: Mumbai,India
Posts: 49
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...
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Location: Mumbai,India
Posts: 49
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??
Reply With Quote
  #9 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,393
Quote:
Originally Posted by shore View Post
given full rights (777) to all the container files.
That was wrong.
Reply With Quote
  #10 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,393
Quote:
Originally Posted by shore View Post

Now what is .DAT.Z file means??
Someone not too smart tried to free up disk space.
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Jul 2004
Posts: 292
Quote:
Originally Posted by n_i View Post
Someone not too smart tried to free up disk space.
LOL

Yup looks like someone compressed your container dude...
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Location: Mumbai,India
Posts: 49
Thanks a lot guys...

I have uncompressed the file. and Now it is working fine.
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 746
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)
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