DB2 FOR LUW / DB2FORLUW / 970 - DB2

With "-g" option, db2diag filters the db2diag.log file based on 
the search string 
given. "function~=" denotes PERL regular expression for the 
field "function". On the 
other hand, comma is used for separating multiple field names, 
for example 
 
   db2diag -g 'function~=/someFunctionName.*? regex/ , 
PID=12321' 
 
so that PID can also be used to filter the log records at the 
same time; it acts as the AND operator between multiple fields. 
 
However, when there is a comma within the PERL regular 
expression, the defect causes db2diag to try parse the remainder 
of the regular expression coming after the comma as a field 
name. 
 
Below are examples which could cause the failure and their 
corresponding error messages. 
 
 
db2diag -g 'function~=/sqlfLogUpdateCfgParam, /' 
=>db2diag: Field name "/" does not exist. 
 
db2diag -g 'function~=/sqlfLogUpdateCfgParam, 
probe:20|sqluxGetDegreeParallelism, 
probe:481|sqluMCReadMediaHeader, probe:2116/' 
=>db2diag: Invalid operator ":20|sqluxGetDegreeParallelism, 
probe:481|sqluMCReadMediaHeader, probe:2116/" is used for a 
field comparison 
 
db2diag -g 'function~=/sqlfLogUpdateCfgParam, /,pid:=test' 
=>db2diag: Field name "/,pid:=test" does not exist.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All db2diag users with db2_v97fp3 and later releases on any  * 
* hardware.                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2diag -g 'function~=/sqlfLogUpdateCfgParam, /'             * 
* =>db2diag: Field name "/" does not exist.                    * 
*                                                              * 
* db2diag -g 'function~=/sqlfLogUpdateCfgParam,                * 
* probe:20|sqluxGetDegreeParallelism,                          * 
* probe:481|sqluMCReadMediaHeader, probe:2116/'                * 
* =>db2diag: Invalid operator ":20|sqluxGetDegreeParallelism,  * 
* probe:481|sqluMCReadMediaHeader, probe:2116/" is used for a  * 
* field comparison                                             * 
*                                                              * 
* db2diag -g 'function~=/sqlfLogUpdateCfgParam, /,pid:=test'   * 
* =>db2diag: Field name "/,pid:=test" does not exist.          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 V9.7 Fix Pack 4 or newer.                      * 
****************************************************************

DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 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 V9.7 Fix Pack 4 
 
Commas within PERL regular expression will not cause failures.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

15.10.2010
12.03.2012
12.03.2012

9.7.FP4