PK75680: SELECTING 'Y' ON THE "CURRENT ROW BY KEY" MAY LEAD TO S0C4, -311 OR -804 SQLCODES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Some types of table indexes for Log Analysis were being
  improperly handled.  These columns would cause the current row
  to be improperly built and Log Analysis would be put into an
  unstable state resulting in either S0C4 or SQL errors
  -311 or -804.
  ABENDS0C4 ABEND0C4 S0C4 0C4 SQLCODE311 SQLCODE804
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Some types of table indexes for Log     *
  *                      Analysis were being improperly handled. *
  *                      These columns would cause the current   *
  *                      row to be improperly built and Log      *
  *                      Analysis would be put into an unstable  *
  *                      state resulting in either S0C4 or SQL   *
  *                      errors -311 or -804.                    *
  ****************************************************************
  * 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:

  UK44046 UK44047

Modules/Macros

•    ALA@FD26 ALA@FD28 ALA@FFN6 ALA@FFN8 ALA@FSP
  ALA@MNT  ALAALA   ALAA53   ALABSQL  ALACURR  ALAFR1V  ALAFR6
  ALAGEN1  ALAIN3   ALALB3   ALAOBD   ALASBDB  ALASBDF  ALASQL7A
  ALASQL8A ALASQL9A ALASQ8CA ALASQ9CA ALASUBC  ALAZT530
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R230 PSY UK44046

     UP09/02/21 P F902

• R310 PSY UK44047

     UP09/02/21 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.