IBM Support

PI71903: ENHANCEMENTS FOR IFCID 366 AND IFCID 376

A fix is available

Subscribe

You can track all active APARs for this component.

 

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