Using user temporary table spaces

User temporary table spaces are used for storing temporary tables used by an application. Tables created within this table space are dropped when the application disconnects from the database.

Getting ready

Check whether there is any other user temporary table space with the same page size. Only one per page size is enough.

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 the table spaces:

   Let's see if there are any existing table spaces, but with the same page size; the show detail option is used to include the page size in the output.

   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
   	           Tablespaces for Current Database
   

   ...