PH35827: DRL3035E No table name is found in QUERY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DRL3035E No table name is found in QUERY when installing
  certain components.
  KPMZ 1 Address Space Statistics
  MVS 2 Address Space and Job Statistics
  DSET 1 Data Set Activity
       2 VSAM Activity
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Z Performance and Capacity Analytics     *
  *                 customers                                    *
  *                 a) Running with Db2 option decimal=comma.    *
  *                 or                                           *
  *                 b) Installing Capacity Planning for z/OS.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: a) Message DSNT408I SQLCODE = -104,     *
  *                      ERROR: ILLEGAL SYMBOL with RC=08 when   *
  *                      installing the zERT component with the  *
  *                      Db2 specification of decimal=comma.     *
  *                      The same error running the sample job   *
  *                      DRLJCP09.                               *
  *                      b) RC=04 when installing the Capacity   *
  *                      Planning for z/OS component with        *
  *                      message                                 *
  *                      DRL3003W The length of the table name   *
  *                      exceeds 254 characters.                 *
  *                      c) Possible RC=08 when installing       *
  *                      components KPMZ, MVS, DSET or           *
  *                      Distributed with messages:              *
  *                      DRL3035E No table name is found in      *
  *                      QUERY DRLQxxxx.                         *
  *                      DRL3016E Error defining REPORT xxxxxxxx *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTFs.                     *
  ****************************************************************
  a) SQL sample did not have a space before a numeric value
  following a comma, which is a requirement of systems running
  with Db2 decimal=comma
  b & c) The install process was calculating the length of a Db2
  table name incorrectly.
  

Problem conclusion

• a) The object has been changed to add a space
  between the comma and the following numeric value to meet
  the requirements when Db2 is started with decimal=comma.
  b & c) The install process has been updated to correctly
  calculate the length of the Db2 table name.
  

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:

  UI74842 UI74843

Modules/Macros

• DRLERDEF DRLJCP09 DRLTZERT
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• RC01 PSY UI74842

     UP21/04/10 P F104

• RCA8 PSY UI74843

     UP21/04/10 P F104

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.