SAP Knowledge Base Article - Preview

2520447 - DB6: How to recreate the temporary tablespaces

Symptom

You find the following temporary tablespaces are offline, or the temporaray tablespaces become full.
You want to recreate them.

  • PSAPTEMP16
  • SYSTOOLSTMPSPACE

For the offline status checks, run following 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 full example:

    • SP update log (deploy_api.1.log)

      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=null

    • db2diag.log:

      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".


Read more...

Environment

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

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.