PK69727: FAST APPLY SQL DOES NOT PROPERLY PARSE REAL OR FLOAT COLUMNS WHEN A COMMA IS THE DEFAULT DECIMAL POINT FOR THE DB2 SUBSYSTEM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a comma is the default decimal point of a DB2 subsystem,
  numbers that use periods can still be used in an SQL statement.
  However, Fast Apply SQL does not account for this and will
  improperly parse SQL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Currently DB2 Log Analysis restricts    *
  *                      strings in the where clause to a        *
  *                      maximum of 40 bytes. Any string that    *
  *                      takes more than 40 bytes to represent   *
  *                      will be put in a SUBSTR function. This  *
  *                      APAR will do away with the use of the   *
  *                      SUBSTR in most cases by raising         *
  *                      the limit to a much higher value.       *
  ****************************************************************
  * 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:

  UK39103 022PC5Ÿ UK39104 022PC5Ÿ 014PC3Ÿ

Modules/Macros

•    ALA@FSP  ALA@MNT  ALACRRF  ALACURR  ALAEDIT
  ALAEXTF  ALAFA    ALAFRMTR ALAIXP   ALALF3   ALAMLS   ALAMSP
  ALASUBG
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R230 PSY UK39103

     UP08/08/28 P F808

• R310 PSY UK39104

     UP08/08/28 P F808

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.