Results 1 to 13 of 13
  1. #1
    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.

  2. #2
    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.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,428
    db2diag.log
    db2pd -tablespaces

  4. #4
    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 Attached Files

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,428
    Install the latest fixpack, then restore the database from the backup that you no doubt have.

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,258
    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

  7. #7
    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...

  8. #8
    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??

  9. #9
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,428
    Quote Originally Posted by shore View Post
    given full rights (777) to all the container files.
    That was wrong.

  10. #10
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,428
    Quote Originally Posted by shore View Post

    Now what is .DAT.Z file means??
    Someone not too smart tried to free up disk space.

  11. #11
    Join Date
    Jul 2004
    Posts
    295
    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...

  12. #12
    Join Date
    Aug 2011
    Location
    Mumbai,India
    Posts
    49
    Thanks a lot guys...

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

  13. #13
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •