PI79574: OPTIONALLY ROLLBACK DATA LOADED TO IDAA WHEN DB2 DISCARDS RECORDS ALREADY LOADED TO IDAA

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Provided a option for the Loader to rollback all data loaded to
  the IDAA anytime DB2 discards a record that the Loader already
  delivered to the IDAA.  An example of when this type of DB2
  discard occurs is when data delivered to both the IDAA and DB2
  is later discarded by DB2 due to a unique index violation.
  Currently when these types of discards occur, the Loader
  disables acceleration on the target table,
  and leaves the discarded records in the IDAA.
  This enhancement will introduce a new HLO STC option (in the
  options file): "ACCEL_WHEN_DB2_DISCARDS".  Valid values are
  "ROLLBACK" or "DISABLE_ACCELERATION".  The default value is
  DISABLE_ACCELERATION.
  When ROLLBACK is specified, the Loader will delay committing
  the data loaded to the IDAA until after the DB2 LOAD utility
  has completed.  If the Loader detects that DB2 has discarded
  records loaded to the IDAA, all loaded data will be rolled
  back, leaving the original IDAA data intact.  Data loaded to
  DB2 will not be affected by this rollback.
  Also, query acceleration will not be disabled on the target
  table. The job step will end with return code 4. Note that
  when discard datasets are provided to the DB2 LOAD utility,
  the Loader may direct DB2 LOAD to discard records.
  For example, this can happen when an invalid DATE value is
  detected in the SYSREC data.  In this case the discarded
  record is never delivered to the IDAA so the ROLLBACK
  setting does not come into play.
  When DISABLE_ACCELERATION is specified the Loader will behave
  as it always has, leaving the loaded data in the IDAA and
  disabling query acceleration on the target table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Analytics Accelerator Loader    *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Provided a option for the Loader to     *
  *                      rollback all data loaded to the IDAA    *
  *                      anytime DB2 discards a record that      *
  *                      the Loader already delivered to the     *
  *                      IDAA. An example of when this type of   *
  *                      DB2 discard occurs is when data         *
  *                      delivered to both the IDAA and DB2 is   *
  *                      later discarded by DB2 due to a unique  *
  *                      index violation. Currently when these   *
  *                      types of discards occur, the Loader     *
  *                      disables acceleration on the target     *
  *                      table, and leaves the discarded         *
  *                      records in the IDAA.                    *
  *                      This enhancement will introduce a new   *
  *                      HLO STC option (in the options file):   *
  *                      "ACCEL_WHEN_DB2_DISCARDS".              *
  *                      Valid values are "ROLLBACK" or          *
  *                      "DISABLE_ACCELERATION".  The default    *
  *                      value is DISABLE_ACCELERATION.          *
  *                      When ROLLBACK is specified, the Loader  *
  *                      will delay committing the data loaded   *
  *                      to the IDAA until after the DB2 LOAD    *
  *                      utility has completed.  If the Loader   *
  *                      detects that DB2 has discarded records  *
  *                      loaded to the IDAA, all loaded data     *
  *                      will be rolled back, leaving the        *
  *                      original IDAA data intact.  Data        *
  *                      loaded to DB2 will not be affected by   *
  *                      this rollback. Also, query acceleration *
  *                      will not be disabled on the target      *
  *                      table. The job step will end with       *
  *                      return code 4. Note that when discard   *
  *                      datasets are provided to the DB2 LOAD   *
  *                      utility, the Loader may direct DB2 LOAD *
  *                      to discard records. For example, this   *
  *                      can happen when an invalid DATE value   *
  *                      is detected in the SYSREC data.  In     *
  *                      this case the discarded record is never *
  *                      delivered to the IDAA so the ROLLBACK   *
  *                      setting does not come into play.        *
  *                      When DISABLE_ACCELERATION is specified  *
  *                      the Loader will behave as it always has *
  *                      leaving the loaded data in the IDAA and *
  *                      disabling query acceleration on the     *
  *                      target table.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code to fix this problem has been changed.
  

Problem conclusion

Temporary fix

Comments

• APPLY the fix.
  

APAR Information

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

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

  UI47560

Modules/Macros

•    HLO$$PRM HLODTDOP HLOMSGEN HLOOPTS  HLOPINIX
  HLORBKU1 HLOSINIT HLOSPRMP HLOSPRMV HLOSTCJ  HLOSTSRV HLOUBKU1
  HLOUHAL1 HLOUMAIN
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R210 PSY UI47560

     UP17/06/16 P F706

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.