PI74208: ERROR MESSAGE ALAA564E WITH LONGVAR TYPE COLUMN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error message ALAA564E will occur if advanced filters are used
  on a column that has a data type of LONGVAR. This data type of
  LONGVAR can only exist if the table was created pre-DB2 V9.
  This only comes into play if advanced filters are used against
  that specific column(s).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA 340 and 350                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:  A C03 abend may occur while using      *
  *                      continuous mode and requesting          *
  *                      the continuous mode file report.        *
  *                      The C03 abend indicates a file          *
  *                      has been left open during program       *
  *                      termination. The file (which            *
  *                      is the continuous mode file report      *
  *                      program, so the C03 abend is actually   *
  *                      masking a previous error.               *
  *                                                              *
  *                      User abends U075 and/or U077 are        *
  *                      possible while materializing            *
  *                      XML data. The underlying XML table(s)   *
  *                      must have DATA CAPTURE                  *
  *                      CHANGES on for this to occur.           *
  *                                                              *
  *                      Error message ALAA564E will occur if    *
  *                      advanced filters are used               *
  *                      on a column that has a data type of     *
  *                      LONGVAR. This data type of              *
  *                      LONGVAR can only exist if the table     *
  *                      was created pre-DB2 V9.                 *
  *                      This only comes into play if advanced   *
  *                      filters are used against                *
  *                      that specific column(s).                *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  

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:

  UI44204 UI44205

Modules/Macros

• ALAAFVL  ALAAFWC  ALACFREP ALAGEN1  ALALB2
  ALALFP   ALARXML  H237340  H237350J
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R340 PSY UI44204

     UP17/02/02 P F702

• R350 PSY UI44205

     UP17/02/02 P F702

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.