SAP Knowledge Base Article - Preview

2520447 - DB6: How to recreate the temporary tablespaces


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

db2 list tablespaces show detail

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

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.



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


Offline, PSAPTEMP16, SYSTOOLSTMPSPACE, SQL1585N, recreate , KBA , systoolstmpspace , offline , psaptemp16 , 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 ONE Support launchpad (Login required).

Search for additional results

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