Special considerations for CQMERROR DD

Review this information concerning the CQMERROR DD statement.

When you include the CQMERROR DD statement in your CQM@LDB2 offload job, the offload process writes the message SQL text not available to the CQMERROR file instead of writing the following messages to the offload job log:

CQM1153E RETURN CODE reason_code REASON CODE reason_code WAS ENCOUNTERED DURING TRANSLATION SOURCE CCSID ccsid TARGET CCSID ccsid INCORRECT DATA LOCATED IN DDNAME=CQMERROR

CQM2604E VSAM LOGIC ERROR VSAMRC=X'08' VSAMRS=X'002C' CQM#IVSM(***)

CQM2604E VSAM LOGIC ERROR VSAMRC=X'08' VSAMRS=X'0010' CQM#IVSM(nnnnn)

If Db2 Query Monitor encounters errors when unloading data from interval Performance History Files and the CQMERROR file is not empty, the return code 4 is set. If the problem is due to translation, the corresponding field is set to "N/A" in the output record and you must decide whether or not to load data (with these errors) to the Performance History Database .

Review the resulting data based on the CQMERROR file. Decide whether the data is acceptable for loading to your Performance History Database . If the data is acceptable, restart the offload job from the step for DSNUTILB. You can automatically load all records without any manual steps by locating the step for DSNUTILB and changing:

COND=(0,NE)

to:

COND=(4,GT)

If you change COND=(0,NE) to COND=(4,GT), the loaded data might contain unexpected results.

When an error is encountered and the CQMERROR DD statement is not specified in your CQM@LDB2 offload job, the offload process sets the RC=04 and issues the following message:

CQM1006E CQMERROR DD STATEMENT MISSING