The correct method to reset the silent State of the DB2 tablespace

You may encounter some problems when resetting the silent State of the DB2 tablespace. The following describes how to reset the silent State of the DB2 tablespace.
Correct Method to reset the silent State of the DB2 tablespace:
The cause is that the reset operation is incorrect. The RESET option of the silent command takes effect only when executed by the user who previously issued the silent command. Even if another RESET is successfully executed, the silent State set by the original user cannot be removed. Therefore, the correct steps to remove the tablespace silent State are as follows:
A) users looking for silent DB2 tablespace:
With the reports generated by the db2dart tool, we can query the users who issued the QUIESCE command. The procedure is as follows:
B) stop a DB2 instance:
Db2stop force
C) generate the DB2DART report:
Db2dart <database alias>/DTSF
D) Find the user who sends the silent command from the report:
According to the command execution result prompt, find the report file generated by DB2DART and open the file. For silent tablespace, you can find similar information in the file:
Information for Tablespace ID: 2 ----------------------------------- Tablespace name: USERSPACE1 Table space flags (HEX): 0101 Table space type: System Managed Space (SMS) Page size: 4096 Extent size: 32 Prefetch size: 32 Version: 9 Tablespace state: 2 Number of quiescers: 1 1) Userid of quiescer: DB2INST1 Quiesce state: 2 Tbspace ID of quiesced object: 2 Table ID of quiesced object: 3 edu id: 0 Agent ID: 0 ......
So that the earliest user who sent the silent command is DB2INST1.
E) Perform the reset operation with the correct user logon:
Run the reset command after logging on to the DB2INST1 User:
Db2 quiesce tablespaces for table db2inst1. staff reset
Connect to the database after the command is successful
F) Verify the DB2 tablespace status:
Db2 list tablespaces ...... Tablespace ID = 2 Name = USERSPACE1 Type = System managed space Contents = Any data State = 0x0000 Detailed explanation: Normal ......
The preceding output indicates that the reset silent command is successfully executed and the tablespace status is normal. All Tables in the table can be normally accessed. Now, the operation to remove the tablespace silent status and restore the tablespace status to normal is completed.


Author's nickname