A fix is available
APAR status
Closed as new function.
Error description
Enhancements for IFCID 366 and IFCID 376 . . Additional keywords: IFCID366 IFCID376
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 11 for z/OS users of the IFCID 366 * * and IFCID 376 trace. * **************************************************************** * PROBLEM DESCRIPTION: This APAR enhances both the IFCID 366 * * and IFCID 376 trace. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR contains the following enhancements to the IFCID 366 and IFCID 376 trace: (1.) If statement id (QW0366SI / QW0376SI) is 0, then SQL text is traced in new field QW0366SQL_Var / QW0376SQL_Var (up to 4000 chars). Note: Dynamic DML that is not cached will show stmt id = 0. (2.) Trace for trace function code (QW0366FN / QW0376FN) 7 and 8 is enhanced to contain the following new fields: - schema (QW0366SC_Var / QW0376SC_Var) - specific name (QW0366PR_Var / QW0376PR_Var) - incompatible parameters' ordinal numbers, and source and target data types (QW0366INC_Var / QW0376INC_Var) Note: data type numbers are documented with SQLDA.
Problem conclusion
Temporary fix
Comments
The DB2 11 for z/OS IFCID 366 and IFCID 376 trace was enhanced. APAR PI76402 will be used to make enhancements for IFCID 376 in DB2 12 for z/OS. Additional Keywords: IFCID366 IFCID376 ×**** PE17/07/06 FIX IN ERROR. SEE APAR PI84045 FOR DESCRIPTION ×**** PE17/07/06 FIX IN ERROR. SEE APAR PI84045 FOR DESCRIPTION ×**** PE18/07/09 FIX IN ERROR. SEE APAR PI99258 FOR DESCRIPTION
APAR Information
APAR number
PI71903
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-07
Closed date
2017-04-06
Last modified date
2018-07-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PI76402 UI46243
Modules/Macros
DSNDQW05 DSNHXLTR DSNNOBSC DSNNOBSE DSNNOIRT DSNNOSCO DSNNOSER DSNNQOPM DSNNQSCN DSNTCRCI DSNXEDP DSNXEDSC DSNXEDS1 DSNXEET DSNXERT DSNXERT2 DSNXOBFF DSNXOLTD DSNXRAIT DSNXRBN9 DSNXRIB9 DSNXRID9 DSNXRIHB DSNXRIHD DSNXRIHL DSNXRIHR DSNXRIHS DSNXRIS9 DSNXRIVR DSNXRME9 DSNXRMXE DSNXROHE DSNXRRSP DSNXRSBC DSNXRSB9 DSNXRSTP DSNXRSTS DSNXRTIM
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI46243
UP17/04/21 P F704
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
16 July 2018