CA Datacom DB00501E RC 46(46) Database Open error

Products

• Datacom
• DATACOM - AD
• Datacom/DB

Issue/Introduction

When trying to run a DBUTLTY process, after having a problem, we receive a RC 46(46) on subsequent runs that were trying to correct the problem.

Cause

The RC 46(46) means that something has left the "file is open" indicator on in the CXX. This happens in one of two ways: either a job or another task actually has the database open, or a job that was running against that database has terminated abnormally.

Resolution

If you know that there is nothing currently using this database, and that it should be offline, you can run a CXX Reset to turn off the indicator.

First, run a full CXX report using
 REPORT AREA=CXX,DBID=###

Review the first page of the report to find 'UPDATE USERS' on the left side. If you know that nothing should have the database open, and the UPDATE USERS is other than zero (usually it is 1), then you can run the DBUTLTY job with this input:
 RESET AREA=CXX,DBID=###

Then, run the CXX report again and confirm that the UPDATE USERS is now zero.

You can now proceed with your processing.

Additional Information

As always, please contact CA Technologies support for CA Datacom if you have further questions.