IBM Support

Temporary automatic storage table space becomes offline after host reboot

Troubleshooting


Problem

After rebooting a server and activating a database, Db2 is not able to bring temporary table spaces online.  This problem only exists for SMS temporary automatic storage table spaces, not for DMS or non-Automatic Storage table spaces.

Symptom


Querying MON_GET_TABLESPACE shows SMS temporary automatic storage table spaces with a TBSP_STATE value of OFFLINE:
  
db2 "SELECT VARCHAR(TBSP_NAME, 30) AS TBSP_NAME, TBSP_ID, TBSP_TYPE, TBSP_CONTENT_TYPE, TBSP_USING_AUTO_STORAGE, TBSP_STATE FROM TABLE(MON_GET_TABLESPACE('',-2)) AS T WHERE TBSP_TYPE='SMS' AND TBSP_CONTENT_TYPE LIKE '%TEMP' AND TBSP_USING_AUTO_STORAGE=1 ORDER BY TBSP_ID"


TBSP_NAME                      TBSP_ID              TBSP_TYPE  TBSP_CONTENT_TYPE TBSP_USING_AUTO_STORAGE TBSP_STATE
------------------------------ -------------------- ---------- ----------------- ----------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TEMPSPACE1                                        1      SMS        SYSTEMP                                 1 OFFLINE
USERTEMP1                                         2      SMS        USRTEMP                                 1 OFFLINE
TEMPSPACE_32K                                     4      SMS        USRTEMP                                 1 OFFLINE

  3 record(s) selected.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PlZAAU","label":"Database Objects-\u003ETablespaces"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

ibm16565737

Page Feedback