A fix is available
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":"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":"12.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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 March 2019