A fix is available
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 number
PH35827
Reported component name
TDS FOR Z/OS
Reported component ID
569510100
Reported release
C01
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-03-30
Closed date
2021-04-08
Last modified date
2021-05-03
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
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.
[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C01"}]
Document Information
Modified date:
04 May 2021