|
Problem IC71946
|
Status: Closed |
"DB2DIAG -G" FAILS IF PERL REGEX IS PROVIDED WITH COMMA |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* 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. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
First Fixed in DB2 V9.7 Fix Pack 4
Commas within PERL regular expression will not cause failures. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.10.2010
12.03.2012
12.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
