IBM Support

db2 list tablespaces show detail hangs in 10.1

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

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Tablespaces","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.8;9.7;9.5;10.1;10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21695175