suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT29836 Status: Closed

DB2SUPPORT MIGHT REQUIRE A LONG TIME TO COMPLETE ON AIX SYSTEM WITH A
LARGE NUMBER OF LOGICAL VOLUMES AND VOLUME GROUPS.

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
Db2support tool might require a long time to complete on AIX
system which have a large number of volume groups and logical
volumes. Slow section will be the one after:
"Basic operating system and hardware information"

is displayed on the screen. db2support.log file, included in the
final archive, will indicate a long time spent within "Disk"
section, e.g:

...
2019-01-01-20.26.29.690710 [db2os.C:820] -> Disk
2019-01-01-21.34.54.108958 [db2os.C:820] -> Disk
...
(over 1h here in the example)

During the data collection the following command will be
executing on the system (this can be checked e.g. in "ps"):

sh -c for vg in `lsvg -o`; do for fs in `lsvgfs $vg`; do printf
"%-22s" $fs; for disk in `lsvg -p $vg | tail +3 | awk '{print
$1}'`; do lspv -l $disk | grep -q " ${fs}$" && printf "%-8s"
$disk; done; echo; done; done

This section will be executed regardless of "-s/-system_detail"
switch being used or not
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
****************************************************************
Local Fix:
There is no switch to disable lsvg collection by db2support on
AIX. The only way to skip the step is to force command failure
by e.g. creating temporarily a "dummy" lsvg executable in PATH
to force a failure of the command. E.g.:

$ touch ./lsvg
$ chmod +x lsvg
$ export PATH=$(pwd):$PATH
$ db2support 
$ rm ./lsvg

This will *not* affect other diagnostics collected by
db2support.
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
25.07.2019
16.01.2020
16.01.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)