Using system temporary table spaces

Used mostly for sorts or joins, which are managed by DB2 (so there is no intervention necessary), a system temporary table space can also be used for reorganizations. This is what we'll discuss here.

Getting ready

Identify a system temporary table space that matches the page size of the table space containing the table you want to reorganize.

How to do it...

1. Connect to database:

   	[db2inst1@nodedb21 ~]$ db2 connect to nav
   
   	   Database Connection Information
   
   	 Database server        = DB2/LINUXX8664 9.7.4
   	 SQL authorization ID   = DB2INST1
   	 Local database alias   = NAV
   

2. List table spaces:

   You will get the table space ID to manipulate the containers for this table space as well as the page size and other relevant information.

   	[db2inst1@nodedb21 ~]$ db2 list tablespaces show detail
   	….
   	 Tablespace ID            = 3
   	 Name                     = NAV_TBLS
   	 Type                     = Database managed space
   	 Contents                 = All permanent data. Large...