PQ90502: POSSIBLE BAD OUTPUT WHEN FILTERING ON SPECIFIC TYPES OF DML ACTIVITY ALAA172E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When filtering on only UPDATEs, it is possible the results in
  the detail report will be be bad because INSERTs and DELETEs
  that occurred during the general report timeframe are excluded
  from the extract file (EXTFILE DD). These records, though not
  desired in this case for reporting purposes, must be included
  in the extract file for full row materialization purposes
  **************
  KEYWORDS
  ALAA172E-SQL stmt not valid due to: WHERE clause could not be
  generated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When filtering on only UPDATEs, it is   *
  *                      possible the results in the detail      *
  *                      report will be be bad because INSERTs   *
  *                      and DELETEs that occurred during the    *
  *                      general report timeframe are excluded   *
  *                      from the extract file (EXTFILE DD).     *
  *                      These records, though not desired in    *
  *                      this case for reporting purposes, must  *
  *                      be included in the extract file for     *
  *                      full row materialization purposes       *
  *                      KEYWORDS                                *
  *                      ALAA172E-SQL stmt not valid due to:     *
  *                      WHERE clause could not be               *
  *                      generated.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

Modules/Macros

•    ALAA16
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R210 PSY UQ90656

     UP04/07/20 P F407

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.