Why are CA Datacom/DB Version 15.1 IVP jobs IVPNEW02 and IVPNEW03 run for new Datacom MUF failing with error: SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)?

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

Why are CA Datacom/DB Version 15.1 IVP jobs IVPNEW02 and IVPNEW03 run for a new Datacom Multi-User MUF) failing with error:

SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)

Answer:

The Datacom SQL option has not been activated. The default MUF startup options found in the CABDSAMP member DBDATIN2 have the following statements commented out (with '*' in position 1): 

*DATACOM    SQL                 CA DATACOM/DB-SQL

*SQLOPTION  YES,017,DATACOM,120,NO  SQL,TTM DBID,MODE,TIMEOUT,              

*SQLOPTION_TTMID 017,117,217   TTM DBIDS FOR MUFPLEX (UP TO 7)

To activate the SQL option, uncomment the above statements to the MUF startup and recycle the MUF.

Once activated, the MUF Jes will display this message at startup:

DB00212I - CA Datacom SQL Version 15.1