DB2 - Problem description
Problem IT07419 | Status: Closed |
'LIST TABLESPACES SHOW DETAIL' COMMAND IN DB2SUPPORT TOOL MAY CA USE DB2SUPPORT TO HANG IF DATABASE IS IN SET WRITE SUSPEND MODE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
db2support tool currently runs "list tablespaces show detail" and "list tablespace containers" commands, both of which are deprecated since v9.7. The "list tablespaces show detail" command will hang if "set write suspend on database" has also been issued on the database, due to a change in latching protocol since DB2 v10.1. This may cause the db2support tool to hang as well in such situation. db2support also runs db2pd -tablespaces -alldbs on UNIX. This will be extended to Windows environment as well to collect the tablespace related data. With this APAR, the deprecated commands are removed from the db2support utility. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Environments using DB2 v10.5 Fix Pack 6 and older. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 and Fix Pack 7 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.03.2015 23.11.2015 27.04.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |