What is causing CA Datacom/DB Version 15.1 INSTJCL job IVPNEW02 to terminate with -117 DB RETURN CODE = 01(175)?
___________SQL ERROR SUMMARY START___________
SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)
____________SQL ERROR SUMMARY END____________
IVPNEW02 executes program DBSQLPR which requires Datacom SQL. The error is caused by Datacom SQL not having been activated in the CA Datacom Multi-user (MUF) startup options.
To activate Datacom SQL, assure that these options are in the startup:
Then, recycle the MUF and rerun IVPNEW02.
You will see additional MUF messages such as this which indicates that SQL is now active:
DB00212I - CA Datacom SQL Version 15.1