What is causing DBSQLPR error: SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)?

Products

• Datacom
• DATACOM - AD

Issue/Introduction

What is causing any CA Datacom batch utility DBSQLPR job error SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)?

  ___________SQL ERROR SUMMARY START___________

  SQLCODE = -117, SQLSTATE=, DB RETURN CODE = 01(175)
  MESSAGE =
 ____________SQL ERROR SUMMARY END____________

 =================================================
 == DBSQLPR is completing with return code 0117 ==
 ==                                             ==
 ==         Statements Found:   00000           ==
 ==         Statement Errors:   00000           ==
 ==         Statement Warnings: 00000           ==
 =================================================

Environment

Release: DATABB00200-14-Datacom/AD
Component:

Resolution

The SQL option needs to be activated in the CA Datacom Multi-User (MUF).

The startup options are:

 DATACOM SQL 

 SQLDEFAULT 016,CASQLDEFAULT 

 SQLOPTION YES,017,DATACOM,120,NO 

... and also ... 

 VIRTUAL IXX017,32K 

 VIRTUAL TTM017,4M

Additional Information

Refer to the CA Datacom® Core - 15.1 documentation (or your current release documentation).