Successful DBOC CLOSE actually doesn’t close a database

book

Article ID: 211670

calendar_today

Updated On:

Products

CA Datacom/DB CA Datacom

Issue/Introduction

A DBOC CLOSE is successfully issued on a CICS URT. A DBOC INQ confirms that it is closed but a console (or DBUTLTY) ACCESS command shows that the CICS region has still the database open:


DB01311I - ACCESS OFF,nnn                         
DB00607I - BASE nnn ACCESS OFF ACTIVE JOB(S) CICSxxx

Environment

Release : 15.1

Component : CA DATACOM/DB

Resolution

In this case, CICS SQL plans with PLNCLOSE=R keep the database open even if the standard CICS URT is closed. See PLNCLOSE topics on "CA Datacom/DB SQL Preprocessor Options"

Additional Information

Additional documentation about this topic:

After DBOC CLOSE, why would the database be open in CICS?

From the Dynamic System Tables (DST), how to tell what URTs have a Datacom database open?

How does ACCESS OFF work with USERS=WAIT and USERS=FAIL?

How to avoid the creation of SQL dynamically generated URTs?