PI60337: DROP/RECREATE SPECIFIC DLCDB OBJECTS IN SUPPORT OF DYX V1.5 APAR PI40921

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR provides the following:
  1) a new SHAASAMP member (HAADDLD) that contains DDL to
  DROP/RECREATE the following DLCDB tablespaces:
  a) DLCDB.ACTGRP (contains table DLC.ACTION_GROUP)
  b) DLCDB.ACTSTMT (contains AUXILIARY TABLE
  DLC.ACTION_GROUP_STMT)
  c) DLCDB.ACTOUT (contains AUXILIARY TABLE
  DLC.ACTION_GROUP_OUTPUT)
  Once the above tablespaces are dropped, note that all underlying
  data will be lost. This action is necessary due to DYX V1.5 APAR
  PI40921 (IFREQ'd with PI60337) which drops/recreates the DYXDB.
  The above DLCDB objects are involved in a Referential Integrity
  relationship with the DLCDB table SYSAUTO.ACTION. By
  Dropping/Recreating the DLCDB objects listed above, it synchs up
  the related objects so that RI errors do not occur upon
  inserting rows.
  2) An online build was erroneously made available for a job
  profile containing an Exception Profile that required Real Time
  Stats. These profiles can only be built via BATCH. The online
  build resulted in a S0C1 ABEND. Code has been changed so that a
  batch build is the only build option for job profiles that
  contain Exception profile that use Real Time Stats.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool z/OS.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides the following:       *
  *                      1. a new SHAASAMP member (HAADDLD)      *
  *                       that contains DDL to DROP/RECREATE     *
  *                       the following DLCDB tablespaces:       *
  *                      a. DLCDB.ACTGRP (contains table         *
  *                       DLC.ACTION_GROUP)                      *
  *                      b. DLCDB.ACTSTMT (contains AUXILIARY    *
  *                       TABLE DLC.ACTION_GROUP_STMT)           *
  *                      c. DLCDB.ACTOUT (contains AUXILIARY     *
  *                       TABLE DLC.ACTION_GROUP_OUTPUT)         *
  *                      Once the above tablespaces are dropped, *
  *                      note that all underlying data will be   *
  *                      lost. This action is necessary due to   *
  *                      DYX V1.5 APAR PI40921 (IFREQ'd with     *
  *                      PI60337) which drops/recreates the      *
  *                      DYXDB. The above DLCDB objects are      *
  *                      involved in a Referential Integrity     *
  *                      relationship with the DLCDB table       *
  *                      SYSAUTO.ACTION. By Dropping/Recreating  *
  *                      the DLCDB objects listed above, it      *
  *                      synchs up the related objects so that   *
  *                      RI errors do not occur upon inserting   *
  *                      rows.                                   *
  *                      2. An online build was erroneously      *
  *                      made available for a job profile        *
  *                      containing an Exception Profile that    *
  *                      required Real Time Stats. These         *
  *                      profiles can only be built via BATCH.   *
  *                      The online build resulted in a S0C1     *
  *                      ABEND. Code has been changed so that a  *
  *                      batch build is the only build option    *
  *                      for job profiles that contain Exception *
  *                      profile that use Real Time Stats.       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

  UI37911

Modules/Macros

•    HAA$$PRM HAA$$SEQ HAA$BPRD HAA$BULD HAA$BUTC
  HAA$BUTI HAA$BUTM HAA$BUTP HAA$BUTQ HAA$BUTR HAA$BUTT HAA$BUT2
  HAA#BND  HAACF2A  HAACF2B  HAADDLD  HAAFREE
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R420 PSY UI37911

     UP16/05/24 P F605

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.