PQ65950: SQLCODE104 USING CDI LINE COMMAND FROM PANEL ADB21T WHEN COMMA IS USED AS DECIMAL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Admin Tool panel adb21t using CDI line command to show
  column distribution information ( statistics ) an sqlcode104
  occurs if comma is used as decimal . MSGDSNT408I appears as:
  .
  DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL ",2". SOME
     SYMBOLS THAT MIGHT BE LEGAL ARE: , FOR WITH FETCH QUERYNO
     OPTIMIZE)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who use CDI line     *
  *                 command from panel ADB21T may be affected.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Admin Tool panel ADB21T          *
  *                      using CDI line command to show          *
  *                      column distribution information         *
  *                      ( statistics ) an sqlcode104            *
  *                      occurs if comma is used as decimal .    *
  ****************************************************************
  * RECOMMENDATION: INSTALL CORRECTIVE SERVICE FOR APAR/PTF      *
  ****************************************************************
  SQLCODE104 occurs when using CDI line command from panel ADB21T
  and COMMA is used as DECIMAL
  

Problem conclusion

• In system configuration where comma is defined
  as decimal and comma is intended as separator,
  it must be followed by a blank. ORDER BY clause
  violates this rule and causes the problem which
  is fixed here.
  

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

•    ADB21CPS ADB21T   ADB21TPS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R410 PSY UQ70910

     UP02/10/23 P F210

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.