PH02052: IAG2 NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Function
  Including a fix for ABEND04E RC00C90101 00C90101 DSNIBHUN:500C
  causing Db2 crash ABEND04F.
  
  Additional Keyword: DB2IAG2/K
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 customers using                                   *
  * Insert Algorithm 2 (IAG2) which is                           *
  * available for use with UTS MEMBER CLUSTER.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When IAG2 is automatically                                   *
  * deactivated due to an internal reason                        *
  * or a  space shortage scenario, there                         *
  * is no non-disruptive mechanism to                            *
  * re-enable IAG2 functionality for a                           *
  * partition.  The customer must stop                           *
  * and start the partition to resume                            *
  * IAG2 which creates an outage.                                *
  *                                                              *
  * Also,                                                        *
  * DSN6SPRM.DEFAULT_INSERT_ALGORITHM,                           *
  * is not Online changeable.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Code is added to initiate restart of IAG2 automatically
  in a timely manner until successful.  The first re-enable
  attempt is  made 75 seconds and 10,000 INSERTs after
  IAG2 is disabled. IAG2 will be successfully restarted once
  the underlying problem is resolved automatically or
  manually as the case may be.
  Other changes:
  -DSNI055I message text has been modified to show the
  Object name.
  -DSNI087I is a new message to indicate that IAG2 has
  been re-enabled.
  -A modified version of the 105 diagnostic log record
  is written to indicate successful re-enable of IAG2.
  -Non-critical space map updates will be done under s latch
  to improve performance.
  -Code has been added to prevent data page contention between
  concurrent IAG1 and IAG2 transactions.  This is done
  by preventing IAG1 members from using data pages on the
  IAG2 page pipe.
  -Code has been fixed to prevent ABENDs such as DSNIBHUN:500C
  and DSNKINSL:5033 which result from IAG1 and IAG2 running
  concurrently on the same table space.
  Please refer to the IBM Knowledge Center for general
  information:
  https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/home/
  src/tpc/db2z_12_prodhome.html
  Information specific to this APAR can be found in:
  Topic title: Insert algorithm 2
  https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/perf/
  src/tpc/db2z_insertalgorithm2.html
  Topic title: DSNI055I
  https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/msgs/
  src/tpc/dsni055i.html
  Topic title: DSNI087I
  https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/msgs/
  src/tpc/dsni087i.html
  Topic title: Base release enhancements after the Db2 12
  initial release
  https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/wnew/
  src/tpc/db2z_minorenhancementsinapars.html
  ADDITIONAL SYMPTOMS: ABEND04E RC00C90101 DSNISFPI ERQUAL5001
  

Problem conclusion

• Once the root cause of the problem has been addressed, DB2 will
  automatically re-enable IAG2 functionality for the partition
  without impacting running workloads.
  Default Insert Algorithm zparm is now online changeable.
  Upon migration from V11, with this PTF installed, the default
  value of the Default Insert Algorithm zparm is 2, so IAG2 is
  active.
  

Temporary fix

Comments

• When the root cause of the problem has been resolved,
  Db2 will automatically re-enable IAG2 functionality for
  the partition without impacting running workloads.
  Changes have been made to prevent abends such as
  DSNIBHUN:500C and DSNKINSL:5033 which could result from
  IAG1 and IAG2 running in parallel in data sharing mode.
  DSNI055I IAG2 disable message with REASON=0000000C and
  REASON FOR ERROR=00C9009C has been fixed to return
  REASON=00000008  with REASON FOR ERROR=00C9009C to
  correctly indicate resource not available.
  Also, the -SET SYSPARM command now supports online
  change of DSN6SPRM.DEFAULT_INSERT_ALGORITHM.
  
  Additional keywords:
  00C90101 RC00C90101 DSNIBHUN 500C ERQUAL500C
  DSNKINSL 5033 ERQUAL5033
  REASON = 0000000C  with REASON FOR ERROR=00C9009C
  

APAR Information

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

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

  UI61453

Modules/Macros

• DSNKLOD2 DSNDQJ00 DSNISGSU DSNISEGD DSNDQIST DSNISFPI DSNB1CPP
  DSNFIDIR DSNKINSL DSNKIXDB DSNICMT2 DSNIVOBD DSNIPPHO DSNGDAPT
  DSNIPTYM DSNGDADP DSNITCUS DSNGDADB DSNIASFP DSNISMRT DSNKFTOM
  DSNURFIT DSNIDLOD DSNIFNP  DSNISRTI DSNISNPG DSNPRST0 DSNZOVTB
  DSNISFRC DSNIRCSB DSN1LOUT DSNPCPS0 DSNFCDIR DSNISFAS DSNILPG
  DSNIHLOD DSNIFOD  DSNIDMPS DSNB1SWS DSNISFRO DSNGDACL DSNISCHV
  DSNIARPL DSNILREP DSNISGRT DSNKUSET DSNILCUR DSNIRELK DSNISGSP
  DSNKTRAV DSNISGNS DSNISGSS DSNIETRV DSN1LDET DSNUGRST
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI61453

     UP19/03/12 P F903

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.