DB2 FOR LUW / DB2FORLUW / 970 - DB2

Collecting db2support with -d option might hang at the following 
entry: 
 
      [Select count(*) from sysibm.systables where type='T' and 
creator ...] 
 
because of locks held by other applications on system catalog 
rows/tables

**************************************************************** 
* USERS AFFECTED:                                              * 
* All platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 9.                       * 
****************************************************************

Use -nco option to avoid database connection

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 version 9.7 Fix Pack 9. 
Starting from this version isolation level used by db2support 
tool can be specified via "-il" switch, which previously was 
applicable only to optimizer mode ("-st", "-sf"). 
In order to avoid locking, db2support can be collected with 
uncommitted read (UR) isolation level, e.g. 
$ db2support . -d <db_name> -il UR

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91488 IC95240 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.04.2013
16.12.2013
16.12.2013

9.7.FP9