CA Datacom/DB or/AD Version 15.1 IVP jobs IVP jobs may get: SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)?
search cancel

CA Datacom/DB or/AD Version 15.1 IVP jobs IVP jobs may get: SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)?

book

Article ID: 12241

calendar_today

Updated On:

Products

Datacom/DB Datacom/AD

Issue/Introduction

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)

 

Environment

Version 15.1

CA Datacom/DB

CA Datacom/AD

Cause

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

Resolution

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