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