Question & Answer
Question
Why does 'db2 list tablespaces show detail' hang in DB2 v10.1 after a write suspend command?
Answer
After a 'db2 set write suspend' command is issued, the 'db2 list tablespaces show detail' hangs in 10.1 but works fine is db2 v9.7.
Example:
db2 connect to <dbname>
db2 set write suspend for database
db2 list tablespaces show detail
The 'db2 list tablespaces show detail' hangs or does not respond until a "db2 set write resume for database" command is issued from another window. This is because of changes made in the latching protocols between v9.7 and v10.1.
If a 'db2 set write suspend' has been issued then you can get the tablespace information by:
1). Use 'db2 list tablespaces' command without the 'show detail'
2). Use db2pd -db <dbname> -tablespaces
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21695175