Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2005
    Posts
    31

    Unanswered: Table Space Offline

    I defined a database and loaded the data and the application is able to access the data without problems. When I do the command:
    db2 list table spaces show detail
    It shows one of the table spaces (USERSPACE1) offline. Not sure if this is a problem since the application does not use that table space..

    Here is the output:
    Code:
               Tablespaces for Current Database
    
     Tablespace ID                        = 0
     Name                                 = SYSCATSPACE
     Type                                 = System managed space
     Contents                             = Any data
     State                                = 0x0000
       Detailed explanation:
         Normal
     Total pages                          = 4594
     Useable pages                        = 4594
     Used pages                           = 4594
     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                        = 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                                 = Database managed space
     Contents                             = Any data
     State                                = 0x4000
       Detailed explanation:
         Offline
    
     Tablespace ID                        = 3
     Name                                 = LSFGENDATA
     Type                                 = Database managed space
     Contents                             = Any data
     State                                = 0x0000
       Detailed explanation:
         Normal
     Total pages                          = 1536000
     Useable pages                        = 1535984
     Used pages                           = 23616
     Free pages                           = 1512368
     High water mark (pages)              = 23616
     Page size (bytes)                    = 4096
     Extent size (pages)                  = 16
     Prefetch size (pages)                = 16
     Number of containers                 = 1
    
     Tablespace ID                        = 4
     Name                                 = LSFGENINDEX
     Type                                 = Database managed space
     Contents                             = Any data
     State                                = 0x0000
       Detailed explanation:
         Normal
     Total pages                          = 1536000
     Useable pages                        = 1535984
     Used pages                           = 32720
     Free pages                           = 1503264
     High water mark (pages)              = 32720
     Page size (bytes)                    = 4096
     Extent size (pages)                  = 16
     Prefetch size (pages)                = 16
     Number of containers                 = 1
    I also noticed that the type is database managed rather than system managed. All the other databases that have been defined set this to system managed. Thank you.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    alter tablespace xx switch online should bring it back
    it means the tables in this ts are not being used or there are none
    whatever is specified when you create ts is executed
    if not what you need, change the command to drop/create the ts
    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

  3. #3
    Join Date
    Jul 2005
    Posts
    31
    If the application does not use this table space and I did not define any tables to it do I need it? This was set up automatically when I defined the table using IBM'S DB2 control center. Is this used by the system to keep track of information or can I ignore the error? I did try to put it back online, but it gave me an error. It said that the container could be missing (it is not) or that something is corrupted and some other possible reasons. Thank you for your response.

  4. #4
    Join Date
    Jul 2005
    Posts
    31
    Ok I received an error message when I tried the command you suggested. I received this error:
    SQL0293N Error accessing a table space container.

    Explanation:

    This error may be caused by one of the following conditions:
    o A container (directory, file or raw device) was not found.
    o A container is not tagged as being owned by the proper table
    space.
    o A container tag is corrupt.

    The container is available. I am not sure about the corrupted tag. Can you tell me how to determine if the container tag is corrupt or better yet point me to some documentation on it? Thank you.

  5. #5
    Join Date
    Jul 2005
    Posts
    31
    I finally decided that this was a default table space defined when the data base was created. I have dropped it since I defined data spaces for my application after the database was created. Thank you.

Posting Permissions

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