CQMC2520W Incomplete results. Successful list. Failed list. Reason: details
Explanation
A data request was made to obtain data from multiple members of a data sharing group. The result set that was returned contained the requested data from the members in the successful list, but data could not be gathered from members in the failed list. The error from the first failing member is indicated at the end of the message.
User response
The most appropriate response depends on the reason shown in the message. For example, the most common error is that one of the requests ran out of memory, so the most common message might be:
CQMC2520W: INCOMPLETE RESULTS. SUCCESSFUL DB2S: DB2A, DB2B, DB2C, DB2D, DB2E. FAILED DB2S: DB2F. REASON: 44,595 records required 481,626,000 bytes, which exceeded available memory 445,694,232 bytes on the server
In this case, the possible responses might be to increase available memory to the CAE Server or to reduce the size of the request (by specifying some kind of filtering or by reducing the number of intervals requested).
Alternatively, if the reason indicates an ABEND, for example:
CQMC2520W: INCOMPLETE RESULTS. SUCCESSFUL DB2S: DB2A, DB2B, DB2C, DB2D, DB2E. FAILED DB2S: DB2A. REASON: Abend S0C4-00000011 during query for datasource 0 (Unknown code); access type 0 (Unknown Access Type); Effective User ID: userid. QM Subsystem name: qmssid ssid: DB2A.
Then you should attempt to reproduce the problem and send the SVC dump to IBM® Software Support.
If you receive other messages or reasons you cannot resolve, contact IBM Software Support and provide the CAE Server log and the JES output for the CAE Agent that is providing access to the first of the FAILED DB2s.