IBM Support

PH00574: ENABLING APAR FOR DB2 11 AND 12 FOR Z/OS NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Enabling APAR for Db2 11 and 12 for z/OS new function.
    This is the enabling APAR for PH00287.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Db2 11 for z/OS and Db2 12 for                  *
    * z/OS who use IBM DB2 Analytics Accelerator                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * IBM Db2 Analytics Accelerator                                *
    * customers will be able to track metrics                      *
    * at the statement level or the                                *
    * accounting info at thread level for                          *
    * HTAP dynamic queries.                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This new function APAR now adds new support for monitoring
    info at the statement level in IFCID 316 and accounting info
    at the thread level in IFCID 3 related to HTAP dynamic queries.
    
    This APAR has a functional dependency on the IBM Db2 Analytics
    Accelerator V5.1.6 or higher. Without the server support,
    no statement level monitoring info or accounting info related
    to HTAP dymanic queries will be reported.
    
    This APAR enables Db2 to report SQL statement level monitoring
    and accounting statistics related to HTAP dynamic queries in
    IFCID 316 or IFCID 3.
    
    The DSN_STATEMENT_CACHE_TABLE changes:
    The following columns in DSN_STATEMENT_CACHE_TABLE are filled
    with execution statistics as the HTAP dynamic cache statement
    is accelerated.
    
    Column         Data Type   Description
    -----------------------------------------------------------
    STAT_ACC_TWDP  BIGINT      Accumulated time waited for
    Delay Protocol
    -----------------------------------------------------------
    STAT_ACC_NWDP  BIGINT      Accumulated # of statements with
    WaitTime4DelayProtocol Expired
    
    Instrumentation changes:
    1. IFCID 316 will have 2 additional fields to report the
    statement level statistics for HTAP dynamic queries in
    QW0316's section 2 per accelerator. The 316 changes are
    reflected in the DSNDQW04 copy file and related Db2
    documentation on IFCID 316
    2. IFCID 3 will have 2 additional fields to report the
    thread level accounting statistics for HTAP dynamic queries
    in QW0003's section 13 per accelerator. The IFCID 3 changes
    are reflected in the DSNDQ8AC copy file and related Db2
    documentation on IFCID 3
    

Problem conclusion

Temporary fix

Comments

  • Db2 will now support Accelerator Statement Level Monitoring and
    accounting statistics for HTAP dynamic queries
    
    Additional keywords: IDAAV5R1/K IDAAV7R1/K
    ×**** PE19/04/05 FIX IN ERROR. SEE APAR PH10672  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PH00574

  • 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

    2018-07-16

  • Closed date

    2018-12-07

  • Last modified date

    2019-04-30

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI60151 UI60152

Modules/Macros

  • DSNXECW  DSNXECWA DSNWVAPR DSNWVZIT DSNGEPSH DSNWZDG2 DSNX8SMF
    DSNXERT  DSNXOD12 DSNTXTA  DSNTXTB  DSNXEUFP DSNXERDS DSNXECWU
    DSNXECSS DSNXELX  DSNXECST DSNWARDS DSNXEIST DSNLZMON DSNWVZPS
    DSNTESC  DSNWVCSP DSNXERT2 DSNWVCST DSNB1TAD DSNWAACT DSNWVZSA
    DSNDQ8AC DSNDQW04 DSNTXACT DSNXECLF DSNWAAPI DSN@DMEM DSNADMEM
    DSNXEUCS DSNTINS3 DSNWACDF DSNWVSMT DSNTLRAC DSNWAFRR DSNXTAD
    DSNTXSTB
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI60152

       UP18/12/13 P F812

  • RC10 PSY UI60151

       UP18/12/11 P F812

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":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":""},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":""}]

Document Information

Modified date:
30 April 2019