2520447 - DB6: How to recreate the temporary tablespaces

You find the following temporary tablespaces are offline, and want to recreate them or the tablespace storage has become full.

• PSAPTEMP16
• SYSTOOLSTMPSPACE
• MESSAGE : ADM6017E The following table space is full. Table space name:"PSAPTEMP16"
  
  

For the offline status checks, run the command 

db2 list tablespaces show detail

 Tablespace ID                     = 1
 Name                                 = PSAPTEMP16
 Type                                   = System managed space
 Contents                             = System Temporary data
 State                                   = 0x'00004000'
Detailed explanation:
 Offline
    
 Tablespace ID                       = 2
 Name                                 = SYSTOOLSTMPSPACE
 Type                                   = System managed space
 Contents                             = User Temporary data
 State                                   = 0x'00004000'
 Detailed explanation:
 Offline

• Offline Example:
  
  You may get various errors due to this offline status. For example
  
  - Backup fails with SQL2048N Reason code: "6".=
  - SQL1585N A temporary table could not be created because there is no available system temporary table space that has a compatible page size
  
  
  
• Temporary tablespace sorage Full example:
  
  - Support Pack Upgrade:  SUM/deploy_api.1.log may contain the following error. 
  
  An error may also appear in the JAVA SUM Deployment logs pertaining toSQL error occurred on connection rixsapajv000:AJV:SAPSR3DB: code=-4,225, state="<null>", message="[jcc][103][10843][4.19.49] Non-recoverable chain-breaking exception occurred during batch processing. The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null";SQL statement is "INSERT INTO "J2EE_CONFIGENTRY"("CID","NAMEHASH","NAME","DTYPE","FBLOB","ISFILE") VALUES(?, ?, ?, ?, ?, 1)".[EXCEPTION]com.ibm.db2.jcc.am.SqlException: [jcc][103][10843][4.19.49] Non-recoverable chain-breaking exception occurred during batch processing. The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=nullWhen
  Checking the db2diag.log for DB6, you see an issue with the PSAPTEMP tablespace storage limit reached.
  MESSAGE : ADM6017E The following table space is full. Table space name:
  "PSAPTEMP16". Table space identifier: "3". Container path:
  "/db2/<SID>/<temp_directory>/db2<SID>/NODE0000/<SID>/T0000003/C0000002.TMP". Container identifier: "2".
  * See step 5 under Note below 

• SAP on IBM Db2 for Linux, UNIX, and Windows
• Database is using automatic storage

Offline, PSAPTEMP16, SYSTOOLSTMPSPACE, SQL1585N, recreate, SUM, upgrade, installation, ABAP, API, Deploy, J2EE_CONFIGENTRY, ERRORCODE=-4225, , KBA , offline , psaptemp16 , systoolstmpspace , sql1585n , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , How To