Area level ACCESS

Using CA Datacom/DB Utility (DBUTLTY) › Area Level DBUTLTY Control › Area level ACCESS

Area level ACCESS

Area ACCESS controls all access (User Requirements Table open) to a data area (and the table(s) the area contains) in a Multi-User Facility, with the exception of the RESTART process done during the Multi-User Facility enable.

ACCESS STATUS=WRITE: Allows all types of access.
ACCESS STATUS=OFF: Denies all types of access.
ACCESS STATUS=READ: Allows User Requirements Table opens, with UPDATE=NO specified or defaulted.
ACCESS STATUS=UTLTY: Allows all DBUTLTY functions and denies all OPENS that are not DBUTLTY, except that the DBUTLTY function DBTEST with PGM=DBTSTPR, as it executes as though it is not part of DBUTLTY.

Area level ACCESS is set by the DBUTLTY function ACCESS, controlled by users. The area level of ACCESS is usually done to stop, in an orderly fashion, access in to a Multi-User Facility area. It usually precedes a DBUTLTY function at the data area level that needs to execute in the Multi-User Facility.

A temporary, internal, parallel form of the ACCESS STATUS=UTLTY function is done by other CA Datacom/DB functions such as LOAD with MULTUSE=YES. The LOAD, in this case, validates that its requirements are met then sets the area in the protected status, thereby preventing other opens to any table in the area for the duration of the LOAD. The LOAD with MULTUSE=YES does not require the area level ACCESS.

Following is an example of an area ACCESS to reorganize an area in the Multi-User Facility with no loss of access to other areas in the Multi-User Facility. In the example, the utility functions BACKUP and LOAD each execute in the Multi-User Facility. The ACCESS function is not required, but if used it ensures correct execution of the utility set by ensuring that no other job, which could either update data that would be lost or cause the LOAD to fail with a return code 88, can open the base between the BACKUP and LOAD

Use ACCESS to stop new jobs and wait on current jobs:
```
ACCESS STATUS=UTLTY,DBID=1,AREA=DEM,USERS=WAIT
```
Use BACKUP to back up the DEM area:
```
BACKUP DBID=1,AREA=DEM,MULTUSE=YES,...
```

Use LOAD to load the reorganized data:

LOAD DBID=1,FORMAT=BACKUP,AREA=DEM,MULTUSE=YES,...

Use ACCESS to allow new user jobs:
```
ACCESS STATUS=WRITE,DBID=1,AREA=DEM
```

If there is an attempt to open (a user application open or a utility open) a table in an area that is contrary to a user-executed DBUTLTY ACCESS with the AREA keyword, return code 88(002) is generated. If there is an attempt to open a table in an area that is contrary to a DBUTLTY execution in the Multi-User Facility, return code 88(003) is generated. For example, an 88(003) would be received if a data area was being initialized using the MULTUSE=YES keyword, and there was an attempt by a user application or a utility to open a table in the area.