A fix is available
APAR status
Closed as program error.
Error description
Add parameters to filter the selected data to a specific DB2
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 Query Monitor for z/OS 3.3.0 * * users of component * * - CQM Data Offload and Batch Reporting * * - TCz * * - Documentation - Public use * * - CQM Data Collector * * - Help and Messaging * * - SQL Text * **************************************************************** * PROBLEM DESCRIPTION: 1. Introduce a new parameter in OFFLOAD * * that permits filtering to a specific * * Db2 subsystem. * * * * 2. Long SQL texts are truncated or can * * cause abends while viewing in * * exceptions and operational summaries. * * * * 3. Invalid record address in interval * * datasets. * * * * 4. Data loss or message CQM2604E if * * OFFLOAD started during splitting * * interval. * * * * 5. Default PRIQTY and SECQTY should be * * changed to -1 to allow Db2 to set the * * suitable values when creating new * * OFFLOAD tablespaces. * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** 1. A new parameter is introduced in OFFLOAD to enable the selection of data. 2. SQL texts longer than 2MB are truncated or produce abends while viewing in exceptions and operational summaries panels due to writing records in datasets in incorrect order. 3. Records longer than 2MB are written in parts in datasets but addresses of the parts were set incorrectly. 4. If OFFLOAD was started during interval switch, there can be data loss or message CQM2604E LOGIC ERROR VSAM VSAMRC = x'08 'VSAMRS = x'0400', because interval statistics is accumulated, calculated and recorded in file only at the moment of finishing interval switch. Also attempts to OFFLOAD current (active) interval caused only partial offloading of data due to the same reason as interval switch problem. 5. Default PRIQTY and SECQTY were changed to -1 to allow Db2 to set the suitable values for OFFLOAD new tablespace creation.
Problem conclusion
1. New FILTER_DB2_SUBSYSTEM parameter has been added to OFFLOAD process. See documentation about its usage. 2. Algorithm for saving data into interval files was changed to calculate record length correctly. 3. Algorithm for controlling sequence of record segments while writing data to interval files was fixed. 4. OFFLOAD logic has been changed to wait until interval switch is finished. Customer is informed about such wait via new message: CQM1047I WAITING FOR THE COMPLETION OF THE PROCESS OF INTERVALS SWITCHING FOR THE CQM SUBSYSTEM xxxx An attempt to offload the active interval will fail now, OFFLOAD terminates with RC = 4, interval files are not offloaded, and a new error message is displayed: CQM1048E CURRENT INTERVAL FILES ARE INCOMPLETE AND CANNOT BE OFFLOADED 5. Default PRIQTY and SECQTY are set to -1 to allow Db2 to set suitable values. Search Keywords: (PH17912) OFFLOAD CQM2604E ABEND 0C4 INTERVAL SWITCH FILTER_DB2_SUBSYSTEM CQM8026E CQM1048E CQM1047I CQM2627E CQM2628E PRIQTY SECQTY
Temporary fix
Comments
APAR Information
APAR number
PH17912
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
2019-10-09
Closed date
2020-09-03
Last modified date
2020-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71402
Modules/Macros
CQM#IVSM CQM#PARM CQM#SWTX CQM$$PRM CQM@LDB2 CQM@LIDA CQM@WDB2 CQMDDL CQMDDLST CQMMEXCX CQMTTXTX CQMXDLST
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI71402
UP20/09/09 P F009
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"3.3.0"}]
Document Information
Modified date:
05 October 2020