Why are CA Datacom/DB or CA Datacom/AD Version 15.1 IVP jobs failing with RC 8 and error:
SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)
Version 15.1
CA Datacom/DB
CA Datacom/AD
The Datacom SQL option has not been activated in the MUF startup.
The startup options to activate the SQL option are commented out ('*' in column 1) as follows:
*DATACOM SQL CA DATACOM/DB-SQL
*SQLDEFAULT 016,CASQLDEFAULT SQL DBID,ENT-NAME(SQL ONLY)
*SQLOPTION YES,017,DATACOM,120,NO SQL,TTM DBID,MODE,TIMEOUT,VIEW SECRTY
To activate the SQL option, un-comment the above statements to the MUF startup (remove the '*') and recycle the MUF.
When activated, the MUF startup will display this message:
DB00212I - CA Datacom SQL Version 15.1