What is causing CA Datacom/DB Version 15.1 INSTJCL job IVPNEW02 to terminate with -117 DB RETURN CODE = 01(175)?

Document ID : KB000012165
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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)  

MESSAGE =                                          

____________SQL ERROR SUMMARY END____________      

 

Answer:

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:

DATACOM SQL                     

SQLDEFAULT 016,CASQLDEFAULT      

SQLOPTION YES,017,DATACOM,120,NO

 

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