A fix is available
APAR status
Closed as program error.
Error description
CQM1153E RETURN CODE 04 REASON CODE 07 WAS ENCOUNTERED DURING TRANSLATION SOURCE CCSID = xxxx TARGET CCSID = xxxx seen in CQM OFFLOAD job. A COMMIT in a COBOL batch program causes METR record produced with the PROGRAM field incorrectly encoded in EBCDIC instead of ASCII. This METR record cannot be then correctly processed by Offload resulting in a Return Code 0004 Reason code 0007 TRANSLATION ERROR.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Query Monitor for z/OS * * users of component: * * - CQM Data Collector * * - CQM Data Offload and Batch Reporting * * - ISPF Client * **************************************************************** * PROBLEM DESCRIPTION: "CQM1153E RETURN CODE 04 REASON * * CODE 07 WAS ENCOUNTERED DURING * * TRANSLATION" message during run of * * Query Monitor OFFLOAD job. * * "CQM153E - RETURN CODE 04 REASON * * CODE 07 WAS ENCOUNTERED DURING * * TRANSLATION" message in hostvars when * * display SQL text. * **************************************************************** * RECOMMENDATION: Apply the PTF. * * * **************************************************************** The COMMIT/ROLLBACK code attempted to detect PROGRAM name encoding by checking high order bit. This check may fail in the case when the first character of PROGRAM name is not alphanumeric and cause EBCDIC encoded PROGRAM name to be copied to the METR record instead of expected UTF-8 encoded. PROGRAM name conversion then failed with either Offload CQM1153E or ISPF CQM153E error message. Problem with displaying SQL text in hostvars had a similar cause.
Problem conclusion
Code was changed to use alternative source for the PROGRAM name that always encoded in the UTF-8. The display of SQL text for hostvars was also corrected. Search Keywords: CQM1153E CQM153E
Temporary fix
Comments
APAR Information
APAR number
PH33147
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
330
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-01-07
Closed date
2021-03-22
Last modified date
2021-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQM#GPRF CQM#IVSM CQM#PARM CQM#QAPI CQM#QAPX CQM#QSQL CQM$ACTV CQM$BUFP CQM$CALL CQM$CHLP CQM$CNCL CQM$DELY CQM$DSCV CQM$HSTV CQM$LOCK CQM$OBJS CQM$QRPT CQM$SM01 CQM@LIDA CQM@WDB2 CQMBLOB CQMC0278 CQMC0279 CQMC0280 CQMCAE CQMCAEPT CQMCAPI CQMCPXPT CQMCREOR CQMCSDDL CQMDDL CQMDDLST CQMEO CQMHBUFS CQMIADD CQMIDAA CQMIDAAL CQMIDAD1 CQMIDAM1 CQMIDAM2 CQMIDAM3 CQMIDEL CQMIENBL CQMJAR CQMLDTAS CQMMEACX CQMMEAPX CQMMEARX CQMMEASX CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX CQMMECRX CQMMECSX CQMMIDAA CQMPARSE CQMUPXPT CQMUTS1 CQMUTS2 CQMUTS3 CQMXDLST
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI74526
UP21/04/01 P F103
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":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.3.0"}]
Document Information
Modified date:
03 April 2021