DBAUTH control statement

The DBAUTH control statement specifies whether IMS Index Builder issues the IMS DBRC authorization request for the prime database and the indexes to prevent transactions and programs from updating the database.

The following tables summarize the access intent that is requested through IMS DBRC authorization. EX indicates exclusive access, and RD indicates read access.

Table 1. Access intent for prime database and indexes (non-HALDB)
PROC control statement	Prime database	HIDAM primary index	Secondary index
BLD_SECONDARY	RD (see Note)	N/A	EX
BLD_PRIMARY	RD	EX	N/A
BLD_ALL	RD	EX	EX
Note: If DFSURWF1 or HPSRSIDX is used as the input, no request is issued for the prime database.

Table 2. Access intent for prime database and indexes (HALDB)
PROC control statement	Prime HALDB partition	PSINDEX partition
BLD_SECONDARY	RD (see Notes)	EX
BLD_PRIMARY	EX	N/A
BLD_ILDS	EX	N/A
BLD_ALL	EX	EX
Notes: If HPSRWFP is used as the input, no request is issued for the prime HALDB partitions. If the RECOVERY NEEDED flag of the primary index or ILDS is turned on, exclusive access (EX) is requested.

DBAUTH: Specifies that this is a DBAUTH statement.
YES: IMS Index Builder issues the DBRC authorization request.
RECOV: IMS Index Builder issues the CHANGE.DBDS RECOV command to turn on the RECOVERY NEEDED flag to prevent access from other IMS subsystems throughout the entire process.
The DBRC authorization for the resource is released when the IMS cleanup processing ends for the IMS region. Message DFS627I indicates the end of this processing. Without the RECOV option, other IMS subsystems might access the resource after the DBRC authorization is released until the DBRC NOTIFY commands are issued. The RECOV option prevents any access during this period by turning on the RECOVERY NEEDED flag.
Restriction: IMS Index Builder does not issue the CHANGE.DBDS RECOV command for PSINDEX partitions whose PARTITION INIT NEEDED flag is set to YES.
NO: IMS Index Builder does not issue the DBRC authorization request.

If the DBAUTH statement is not specified, YES is the default.

If DBRC=N is specified on the INPUT control statement, no DBRC authorization request is issued even if DBAUTH YES is specified.

Note: The longest possible time that IMS Index Builder can wait for a response from DBRC is 30 minutes.

Tip: You can override the default value in the runtime parameters module. See the explanation of the IIURDFLT DBAUTH entry in Defining runtime parameters.