CA Datacom IVP job BDIVP02 or AXIVP02 fails with "SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)". Why?

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

Question:

CA Datacom/DB IVP job BDIVP02 or CA Datacom/AD IVP job AXIVP02 fails with "SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)". Why?

Answer:

This IVP job exercises the installation of the CA Datacom SQL option.

Assure that the CA Datacom SQL component is installed and also that the Datacom Multi-User (MUF) startup options include:

   SQLDEFAULT 016,CASQLDEFAULT       SQL DBID,ENT-NAME(SQL ONLY)           
   SQLOPTION  YES,017,DATACOM,120,NO SQL,TTM DBID,MODE,TIMEOUT,VIEW SECRTY 

Additional Information:

If your CA Datacom/DB license does not include the SQL option or you are using CA Datacom/AD with a CA product which does not use the SQL component, then you do not need to run this IVP job and there is no further concern.