Previous Topic: ETJOF999E Error ReceivedNext Topic: CAEU9126E dsGroup(ssid) Not Found in dsConf(DEFAULT)


ETJBP056W Unable to Open SELECT Data Set

Symptom:

Message ETJBP056W occurs while paging through a large results set during a DBA for DB2 Command Manager SUBMIT execution. This message indicates that an error occurred while attempting to retrieve information from the work file containing the results set. This error can occur if you submit a request in the DBA for DB2 Command Manager and then you begin working in any other area of CA Chorus. This error can result in the work data set holding the result set being deleted.

Solution:

Resolve this issue by completing one the following options:

Note: The ISQL Value Pack Component in the ISPF interface contains a batch function that is designed for the large result sets. For more information about this function, see the CA Database Management Solutions for DB2 for z/OS Value Pack Reference Guide.

Important! Do not initiate additional requests in CA Chorus until you review the large result set.