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