Sysview table Load gets a S04E after CARS2603 maintenance

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Receive an S04E ABEND when running a load job for the SUBSYS_DDF_DETAIL table (or other SYSVIEW tables) after applying maintenance. The SMF Extract job completes successfully with new control cards, but the subsequent load fails. There is a discrepancy between the number of records extracted and the number of records the load job attempts to process.

Environment

z/os

DB2

Cause

This issue occurs when an invalid or incorrect input file is concatenated in the SYSULD DDNAME (or relevant input DD) of the load job. In the reported scenario, the extract job prepared #### records, but the load joblog indicated that #### records were being processed before the ABEND, suggesting that an extra or incorrect dataset was included in the input concatenation.

 

Resolution

To resolve this issue, verify and correct the input datasets being used for the load:

1. Review the SYSULD DDNAME (or the specific DD providing input to the load utility) in the load job JCL.
2. Check for any concatenated datasets and ensure that only the intended extract files are included.
3. Compare the record counts from the SMF Extract job output with the "NUMBER OF INPUT RECORDS PROCESSED" in the load joblog to identify any discrepancies.
4. Remove any invalid or duplicate datasets from the concatenation.
5. Re-run the load job with the corrected input file.