SAP Knowledge Base Article - Preview

2520447 - DB6: How to recreate the temporary tablespaces

Symptom

You find the following temporary tablespaces are offline, and want to recreate them.

  • PSAPTEMP16
  • SYSTOOLSTMPSPACE
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

You may get various errors due to this offline status. For example:

  1. Backup fails with SQL2048N Reason code: "6".
  2. SQL1585N A temporary table could not be created because there is no available system temporary table space that has a compatible page size.

Read more...

Environment

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

Keywords

Offline, PSAPTEMP16, SYSTOOLSTMPSPACE, SQL1585N, recreate , KBA , temp tablespace offline , offline , psaptemp16 , systoolstmpspace , sql1585n , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration with DB2 Universal Database , How To

About this page

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

Search for additional results

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