IBM Support

PI98126: OBJECT LEVEL LRSN FOR TRUE HTAP

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • DB2 12 FOR Z/OS NEW FUNCTION - Object Level LRSN for true HTAP
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users of QUERY                           *
    * ACCELERATION who use Hybrid Transactional/                   *
    * Analytical Processing (HTAP).                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * APAR PI98126 provides object level                           *
    * LRSN support for accelerator function                        *
    * "Hybrid Transactional/Analytical                             *
    * Processing" (HTAP).                                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    With the two APARs PI83286 and PI83288, Db2 for z/OS provided
    accelerator function "Hybrid Transactional/Analytical
    Processing" (HTAP) for QUERY ACCELERATION together with the
    IBM Db2 Analytics Accelerator (IDAA) V5 for z/OS and Change
    Data Capture (CDC). The three products provide HTAP support by
    way of a "delay protocol" that is used by the accelerator to
    delay running a query on an accelerator for a user-specified
    amount of time until the most recently committed Db2 data
    changes, current as of the time of the query's OPEN, have been
    replicated to the accelerator. This means that Db2 retrieves
    the latest Db2 log to make sure the accelerated query results
    include the most recently committed data. When IdAA uses it to
    determine a delay, it will hold up the accelerated query until
    the point of the Db2 log position captured by Db2 at the time
    the query OPEN is executed, which is longer than necessary.
    
    Additional Keywords:
    IDAAV5R1/K IDAAV7R1/K
    

Problem conclusion

Temporary fix

Comments

  • In this APAR, object level LRSN support will be provided to
    reduce the delay executing a query on an accelerator.
    
    Specifically, a last write declaim value is tracked for each
    object, namely pageset/partition. For data-sharing, it is
    LRSN and for non data-sharing it is RBA. Db2 will initialize
    the last write declaim value when the object is physcially
    opened, and update it when the write declaim is released
    during commit. For data-sharing, Db2 will also update the
    last write declaim value when the member becomes the only
    updater of the object.
    
    IDAA will use the last write declaim LRSN Db2 returned for
    the objects of an accelerated query to determine how long to
    hold up the accelerated query while it waits for CDC to
    catch up on the log apply.
    

APAR Information

  • APAR number

    PI98126

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-05-17

  • Closed date

    2019-01-15

  • Last modified date

    2019-03-01

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

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

    UI60721

Modules/Macros

  • DSNB5SCM DSNODALN DSNB5SCO DSNIDILS DSNB1LCM DSNB1CLM DSNB1PPP
    DSNB1PCK DSNB1DDN DSNB1PCP DSNKFLRR DSNB1LSN DSNB1OPS DSNKNXT2
    DSNKPOSI DSNB1LDA DSNB1OPP DSNKINSL DSNIRPRE DSNIOST2 DSNB1CSX
    DSNB1GFP DSNB1RCM DSNIRNXT DSNB1SCR DSNURFUI DSNKDLE  DSNKFLST
    DSNISRTI DSNNOCLN DSNIONX2 DSNGDCOB DSNB1CNE DSNIACCH DSNIRIDL
    DSNIADR  DSNB1SWS DSNOLDEL DSNIONXP DSNB1OPL DSNILCLO DSNB1SWD
    DSNIDLDU DSNUKNFK DSNWDFSH DSNUULXA DSNIDLEO DSNODEAL DSNIFPS1
    DSNISFX2 DSNB1LRR DSNISFS  DSNOLSCN DSNIBHUN DSNIRELU DSNB1PMI
    DSNIRELS DSNWDFBM DSNIXLDI DSNIIEPL DSNB1CPS DSNIHDUP DSNB1CPP
    DSNWDFTS DSNB1PM2 DSNIRSET DSNB1CPL DSNKFTCH DSNB1GC1 DSNB1DRN
    DSNB1GBS DSNKDPEP DSNB1PMT DSNIOW   DSNB1LPL DSNOALLO DSNKISPL
    DSNKSDEA DSNISMRT DSNB1RLS DSNB1DRA DSNKDPG  DSNB1RDL DSNIRFNX
    DSNKDPED DSNB1GET DSNB1POC DSNISFRL DSNKFPRV DSNB5RAP DSNIRPRV
    DSNKCKOP DSNISRID DSNB1NOT DSNIKDEF DSNB1REL DSNILREP DSNB1CHK
    DSNISGRT DSNKFTRR DSNB1DCM DSNB1RWI DSNB1LDN DSNUKIFK DSNIREPR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI60721

       UP19/02/02 P F902

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":"12.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":"12.0","Edition":""}]

Document Information

Modified date:
01 March 2019