A fix is available
APAR status
Closed as new function.
Error description
The CQM@LDB2 DB2 offload job currently posts the following message and terminates with return code 08 when the VSAM backstore interval being offloaded does not contain any data to offload: CQM7002I STARTING INTERVAL NOT LOCATED IN INTERVAL DATASET OR ALL INTERVALS ARE EMPTY - NO DATA TO OFFLOAD This enhancement adds a new parameter for program CQM@WDB2 to allow customers to specify any valid user return code value (0 - 4095), when the empty backstore interval condition occurs. New syntax will be supported in the CQM@WDB2 program: NO_DATA_RC(8) The default value of '08' will ensure that the program behavior does not change by default.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Query Monitor. * **************************************************************** * PROBLEM DESCRIPTION: The CQM@LDB2 DB2 offload job currently * * posts the following message and * * terminates with return code 08 when * * the VSAM backstore interval being * * offloaded does not contain any data to * * offload: * * CQM7002I STARTING INTERVAL NOT * * LOCATED IN INTERVAL DATASET OR * * ALL INTERVALS ARE EMPTY - NO DATA TO * * OFFLOAD * * This enhancement adds a new parameter * * for program CQM@WDB2 to allow customers * * to specify any valid user return code * * value (0 - 4095), when the empty * * backstore interval condition occurs. * * New syntax will be supported in the * * CQM@WDB2 program: NO_DATA_RC(8) * * The default value of '08' will ensure * * that the program behavior does not * * change by default. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PM62893
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
310
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-04-19
Closed date
2012-11-02
Last modified date
2012-12-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PM62896 UK83203
Modules/Macros
CQM@ITXT CQM@LDB2 CQM@WDB2
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R310 PSY UK83203
UP12/11/09 P F211
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.
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSAURY","label":"Db2 Query Monitor for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 August 2024