The SYSTOOLSPACE table space is a user data table space used by the DB2® administration tools and some SQL administrative routines for storing historical data and configuration information.
The SYSTOOLSPACE table space is created the first time any of the above are used. The db2look command, administrative task scheduler, ALTOBJ, ADMIN_COPY_SCHEMA, and ADMIN_DROP_SCHEMA procedures are exceptions; the SYSTOOLSPACE table space must be created before you can use them.
The SYSTOOLSTMPSPACE table space is a user temporary table space used by the REORGCHK_TB_STATS, REORGCHK_IX_STATS and the ADMIN_CMD procedures for storing temporary data. The SYSTOOLSTMPSPACE table space will be created the first time any of these procedures is invoked (except for ADMIN_CMD).
If the default definition for either table space is not preferred, you can create the table spaces manually (or drop and recreate them if they have already been created automatically). The table space definitions may vary (for example, you can use a DMS or SMS table space, or you can enable or disable automatic storage), however the table spaces must be created in the IBMCATGROUP database partition group. If you attempt to create them in any other database partition group, error SQL1258N will be returned.
Following is an example of how to create the SYSTOOLSPACE and SYSTOOLSTMPSPACE table spaces manually. This example uses the same definitions that are used when table spaces are created automatically.
CREATE TABLESPACE SYSTOOLSPACE IN IBMCATGROUP MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 4 CREATE USER TEMPORARY TABLESPACE SYSTOOLSTMPSPACE IN IBMCATGROUP MANAGED BY AUTOMATIC STORAGE EXTENTSIZE 4
CREATE TABLESPACE SYSTOOLSPACE IN IBMCATGROUP MANAGED BY DATABASE USING ( FILE 'SYSTOOLSPACE' 32 M ) AUTORESIZE YES EXTENTSIZE 4 CREATE USER TEMPORARY TABLESPACE SYSTOOLSTMPSPACE IN IBMCATGROUP MANAGED BY SYSTEM USING ( 'SYSTOOLSTMPSPACE' ) EXTENTSIZE 4
By default, the use of SYSTOOLSTMPSPACE will be granted to PUBLIC as long as the database is not created using restricted access.