PK10653: UPDATE LUMODES IN CDB RESULTS IN SQLCODE104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Update LUMODES in CDB results in SQLCODE104 because of extra
  comma. This happens when update selected on panel ADB2Z53.
  Example:
  Statement that is about to be executed (first 28 lines):
  UPDATE SYSIBM.LUMODES
    SET CONVLIMIT=50,          <-------- note the comma
    WHERE LUNAME='STM4DSN6'
      AND MODENAME='IBMDB2LM'
  

Local fix

• remove the comma before executing
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who use    *
  *                 "UPDATE LUMODES IN CDB", are affected.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Update LUMODES in CDB on panel  ADB2Z53 *
  *                      results in SQLCODE104 (because of extra *
  *                      comma in the UPDATE statement).         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The extra comma leads to illegal SQL syntax which results
  in SQLCODE -104.
  

Problem conclusion

• The extra comma has been removed and the reported problem
  has been fixed.
  

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:

  UK09037

Modules/Macros

•    ADB2Z53U
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK09037

     UP05/11/22 P F511

• R710 PSY UK09038

     UP05/11/22 P F511

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.