PH51155: ADMIN TOOL:Z.2H CAUSES SQLCODE = -104, ERROR:ILLEGAL SYMBOL WHEN DSNHDECP DECIMAL PARM IS SET TO COMMA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Admin Tool option Z.2H generates a SELECT statement with invalid
  syntax involving use of a comma as a parameter delimiter. The
  comma used as a delimiter must be separated from other elements
  by a space, both before and after it. This is required syntax
  only when a comma is used as a decimal point with DSNHDECP. This
   is DSNHDECP's way of recognizing it as something other than a
  decimal point when paired with a numeral inside the parameter
  list.
  
  
  Partial SQL that is invalid:
  
  
  case when cputime is null then repeat(' ',11)
  
  Normally, this is allowed syntax. However, when the DECIMAL
  parameter is set to COMMA in DSNHDECP, this must be coded like
  this:
  
  
  'case when cputime is null then repeat(' ' , 11)'
  
  
  This is generated by panel ADB2ZH, newly added for V13 new
  function.
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS on *
  *                 Db2 13 who use the DSNHDECP option to        *
  *                 recognize commas as decimal points           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users might encounter SQL code -104 and *
  *                      message DSNT408I when DSNHDECP is set   *
  *                      to recognize commas as decimal points.  *
  *                      This error can occur when using the new *
  *                      Z.2H feature in Db2 Admin Tool 13.1 to  *
  *                      query utility history (options 1, 3, 4, *
  *                      5, 6, and 7).                           *
  ****************************************************************
  When DSNHDECP is using a comma as decimal point, commas used as
  parameter delimiters in SQL function parameter lists must be
  separated from parameters by space characters. The query
  used for option Z.2H does not have these required space
  characters. This APAR corrects this problem by adding the spaces
  before and after all commas used as parameter list delimiters in
  the SQL functions used in the query.
  
  Keywords: MSGDSNT408I SQLCODE104M
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI91045

Modules/Macros

• ADB2Z2H
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI91045

     UP23/03/23 P F303

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.