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

Products

• Vision:Results
• Vision:Sixty

Issue/Introduction

Updated to DB2 V11 and receive SQLCODE errors

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

Environment

Release:
Component: V:RSLT

Resolution

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.