PK15027: UTIL RUNSTATS COLUMN SYNTAX INVALID RESULTS IN RC=08 AND MESSAGE DSNU088I DSNUGPRZ - INVALID CHARACTER OPERAND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The U.R line command and the UTIL line command and the RUNSTATS
  option issued against an object which has column names which
  are quoted results in invalid RUNSTATS utility syntax. The
  JCL will fail RC=08 and the message 'DSNU088I    DSNUGPRZ -
  INVALID CHARACTER OPERAND'.
  

Local fix

• Correct the syntax for the COLGROUP by removing the quotes
  surrounding the column name list e.g.:
    COLGROUP(
  ""BJOB", "BPGM", "BDSN""
          )
  would become:
    COLGROUP(
   "BJOB", "BPGM", "BDSN"
          )
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who        *
  *                 use  RUNSTATS utility  with COLUMN or        *
  *                 COLGROUP option, are affected.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using U.R and UTIL line commands,  *
  *                      and  the  RUNSTATS  option  is  issued  *
  *                      against  an  object  which  has column  *
  *                      names  that  are  quoted,  results  in  *
  *                      invalid  RUNSTATS  utility syntax. The  *
  *                      JCL fails with RC=08.                   *
  *                      .*                                      *
  *                      When on panel ADB2USR specifying column *
  *                      names  for  Runstats,  if  a  lookup is *
  *                      performed, Admin Tool double-quotes the *
  *                      column  names.  Elsewhere in processing *
  *                      they  are double-quoted again, creating *
  *                      invalid  syntax  in  the JCL.  A column *
  *                      list  entered  without  lookup  is also *
  *                      quoted incorrectly by Admin Tool.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Solution: The column names / list of names is now only quoted
  once on a Lookup operation.  If entered without Lookup, Admin
  Tool  will  no longer quote the column name or list of names.
  The user will need to supply  the quotes if desired. The HELP
  panel is updated to reflect this.
  .*
  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:

Modules/Macros

•    ADBHUSR  ADB2U
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK09984

     UP05/12/24 P F512

• R710 PSY UK09985

     UP05/12/24 P F512

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.