IBM Support

How to find the table by quiescer object ID?

Question & Answer


Question

For some reason, one of my tablespaces is not in normal state and I see following output in the tablespace snapshot. Tablespace information for node number = 1 Tablespace State = 0x'00000001' Detailed explanation: Quiesced: SHARE Quiescer authorization ID = DB2INST1 Quiescer agent ID = 0 Quiescer tablespace ID = 65530 Quiescer object ID = 34445 Quiesce state = 1 In order to reset the tablespace state, I need to find out for which table this tablespace is quiesced, but I can not find a table with TABLEID=34445 in syscat.tables view, how can I identify the table by this quiescer object ID?

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

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:
30 April 2025

UID

swg22013078

Page Feedback