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
searchcancel
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
book
Article ID: 15280
calendar_today
Updated On: 02-14-2018
Products
Vision:ResultsVision: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.