PI83082: ALAA068E ERROR WHEN THE DB2 DATASET FOR A PARTITION HAS BEEN DELETED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a partition by growth TABLESPACE is compressed and has an
  empty partition deleted during a REORG, Log Analysis Tool could
  issue an ALAA068E message and end. This will occur if data from
  the DB2 log was found during the reporting timeframe from this
  now empty partition. Log Analysis Tool encountered the error
  while trying to check the compression dictionary form the
  TABLESPACE in order to bypass the IC.
  Now when the partition has been deleted, the product will
  bypass the message and use the dictionary from the IC.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: UAERS OF ALA 350                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: ************PI82850******************** *
  *                       When using share level image copies a  *
  *                      flag can be set to make                 *
  *                       sure another image copy is used        *
  *                      because a row on a page was             *
  *                       updated after the start of the image   *
  *                      copy but is not contained               *
  *                       in that image copy.                    *
  *                       When this flag does not get reset      *
  *                      properly and image copy by              *
  *                       partition are in use, it is possible   *
  *                      that an older image copy                *
  *                       will be requested. This causes older   *
  *                      archive log files to be                 *
  *                       read that are not needed or an         *
  *                      allocation error on the older           *
  *                       image copy or older archive log        *
  *                      datasets because either no              *
  *                       longer exists.                         *
  *                      *************************************   *
  *                      ***********PI83082*******************   *
  *                       When a partition by growth             *
  *                      TABLESPACE is compressed and has an     *
  *                       empty partition deleted during a       *
  *                      REORG, Log Analysis Tool could          *
  *                       issue an ALAA068E message and end.     *
  *                      This will occur if data from            *
  *                       the DB2 log was found during the       *
  *                      reporting timeframe from this           *
  *                       now empty partition. Log Analysis      *
  *                      Tool encountered the error              *
  *                       while trying to check the compression  *
  *                       dictionary form the                    *
  *                       TABLESPACE in order to bypass the IC.  *
  *                       Now when the partition has been        *
  *                      deleted, the product will               *
  *                       bypass the message and use the         *
  *                      dictionary from the IC.                 *
  *                       Now when the partition has been        *
  *                      deleted, the product will               *
  *                       bypass the message and use the         *
  *                      dictionary from the IC.                 *
  *                      **************************************  *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  

Problem conclusion

• APPLT 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:

  UI48262

Modules/Macros

• ALALF1   ALALPD   ALARE64
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI48262

     UP17/06/29 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.