PI91462: THE SQL PROCESSOR IN LOG ANALYSIS TOOL NOT HANDLING USER DEFINEDDATATYPES FOR VARCHAR, VARGRAPHIC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The Fast SQL processor cannot correctly process User Defined
  Datatypes for VARCHAR and VARGRAPHIC columns. This results
  in an ABEND when the SQL is executed. The SQL works correctly
  in other dynamic processing utilities. This APAR will create
  the SQL in a way that will work in FAS and other utilities
  as well.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA350                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Fast SQL processor cannot correctly *
  *                      process User Defined                    *
  *                      Datatypes for VARCHAR and VARGRAPHIC    *
  *                      columns. This results                   *
  *                      in an ABEND when the SQL is executed.   *
  *                      The SQL works correctly                 *
  *                      in other dynamic processing utilities.  *
  *                      This APAR will create                   *
  *                      the SQL in a way that will work in FAS  *
  *                      and other utilities                     *
  *                      as well.                                *
  *                                                              *
  ****************************************************************
  * 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:

Modules/Macros

• ALABSQL
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI53196

     UP18/01/25 P F801

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.