PH65647: DB2ZAI USER MAY SEE SYNTAX ERROR SQLCODE104 WHEN THE DSNHDECP DECIMAL VALUE IS SET TO COMMA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the DSNHDECP DECIMAL POINT IS value is set to COMMA in the
  target Db2 subsystem , Db2ZAI user interface users may receive
  SQLCODE -104 or SQLCODE -170 .
  .
  Additional keywords: DB2AIV1R6/K SQLCODE104 SQLCODE170
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Db2 AI for z/OS version 1.6.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Here is the list of problems            *
  *                      addressed :                             *
  *                                                              *
  *                      - When the DSNHDECP DECIMAL option is   *
  *                      set to COMMA in the target Db2          *
  *                      subsystem, Db2ZAI user interface users  *
  *                      might receive SQLCODE -104 or -170      *
  *                      even with PH64915 applied.              *
  *                                                              *
  *                      - When the DSNHDECP DECIMAL option is   *
  *                      set to COMMA in the metadata Db2        *
  *                      subsystem, Db2ZAI users might           *
  *                      rececive SQLCODE -104.                  *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  Here is a summary of the reported Db2ZAI issues:
  
  - When the DSNHDECP DECIMAL option is set to COMMA in the
  target Db2 subsystem, Db2ZAI user interface users may receive
  SQLCODE -104 while viewing the SQL optimization dashboard and
  SQLCODE -170 while using different filters.
  
  - When the DSNHDECP DECIMAL option is set to COMMA in the
  metadata Db2 subsystem, Db2ZAI users may receive SQLCODE -104
  while submitting sample JCL for creating metadata objects.
  
  Additional keywords:
  
  DB2AIV1R6/K SQLCODE104 SQLCODE170
  

Problem conclusion

• - The Db2ZAI processes are updated to support COMMA for the
  DSNHDECP DECIMAL option.
  

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:

  UO03096

Modules/Macros

• COYAKIRA COYIMC01 COYNOD02 COYREADM COYU060C COYU061C
  

Fix information

• Fixed component name

  DB2 AI FOR Z/OS

• Fixed component ID

  5698CGN00

Applicable component levels

• R160 PSY UO03096

     UP25/05/20 I 1000

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.