Just updated system to DB2 V11 and run the CA Vision Results job. It fails with a :SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C9008A, TYPE OF RESOURCE 00000240, AND RESOURCE NAME DSN8EAE1

Document ID : KB000015280
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Updated to DB2 V11 and receive SQLCODE errors

Question:

Just updated system to DB2 V11 and run the CA Vision Results job. It fails with a :SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C9008A, TYPE OF RESOURCE 00000240, AND
RESOURCE NAME DSN8EAE1

Answer:

Now that you have upgraded your DB2 system you will need to copy the DSN8EAE1 module to the new DB2 dataset library that is used for the Vision Result processing.