Table Space Offline

jyoung · #1 (**permalink**) 08-12-08, 09:51

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.

przytula_guy · #2 (**permalink**) 08-12-08, 10:34

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

jyoung · #3 (**permalink**) 08-12-08, 11:12

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.

jyoung · #4 (**permalink**) 08-12-08, 11:22

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.

jyoung · #5 (**permalink**) 08-12-08, 15:47

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech