home clear 64x64
en blue 200x116 de orange 200x116 info letter User
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 IC69414 Status: Closed

SOME DATA NOT COLLECTED BY DB2COS / DB2FODC SCRIPTS IN DB2 V9.5 ON SOME
LINUX DISTRIBUTIONS DUE TO ARGUMENTS TO SORT

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
The collection of some data in the db2cos / db2fodc script may 
not work for all Linux distributions due to different 
requirements in handling arguments to "sort". 
 
The current scripts include a call to sort such as: 
sort +5 -rn 
 
That syntax will work on SUSE Linux; however, some distributions 
(such as Redhat) require the "-k" option to be included so that 
the syntax would instead be: 
sort -k +5 -rn 
 
 
The result of this is that some data may not be collected (such 
as ps output): 
$ cat pself.fullstack 
 11:33:02 up 1 day, 12:09,  6 users,  load average: 128.84, 
126.31, 119.53 
sort: open failed: +5: No such file or directory
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Some Linux Distributions such as Redhat                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See above.                                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Fix Pack 7 or later.                              * 
****************************************************************
Local Fix:
On impacted distributions, manually collect impacted data.
available fix packs:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in Version 9.5 Fix Pack 7.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.06.2010
19.10.2010
19.10.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP7
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.7 FixList
9.5.0.7 FixList