Specifying locking options for editing data
Catalog Manager
offers three locking options for editing table data: shared table lock, row lock, and no lock.
To set the editor locking options for all users, you must enable the locking options command. The command is passed as a parameter to the Catalog Managerproduct module ACTEMAIN from the BMCDB2 CLIST.
To enable the locking options command
- Edit the BMCDB2 CLIST.
Find the lines shown in the following figure.
WHEN(ACTEMAIN) DO /* CATALOG MANAGER
SET BMCFPCNT= 10100
IF (&ACCESS = INDIRECT) THEN +
SET CIACCESS = YES
SET APPLID = &ACTAPPL
SET PARM = &STR(S=&SSID,O=&ACTDOPT,D=&ASUDOPTD,+
M=BC,I=&CIACCESS,A=&ACMDOPT,+
DB2CAT=&DB2VCAT)
/* EDITOR LOCK OPTIONS (ELO) - ALLOWS USER TO IDENTIFY */
/* THE DEFAULT LOCKING OPTIONS FOR DATA EDITING. USER */
/* MAY CHOOSE ALL OR ANY COMBINATION OF THE THREE. */
/* T - TABLE LOCK, R - ROW LOCK, N - NO LOCKING */
SET PARM = &STR(&PARM, ELO=TRN)Enable the Catalog Managerlocking options command.The syntax for the locking options command is ELO=option.
As an example, the previous figure shows the locking option command ELO set to TRN. These options determine whether requests for edits from any user are allowed while a table is edited. For more information about the options for data editing, see the CATALOG MANAGER documentation.
Press END to exit.
If you plan to use Fast Path Navigation (see Fast-Path-Navigation), you must edit the AEXADMF1 and AEXADMF2 CLISTs and enable the Catalog Managerlocking options command as you did in Step 3 for the BMCDB2 CLIST.For example, if you set ELO to TRN, then add the following statement to the AEXADMF2 CLIST:
SET PARM = &STR(&PARM(ELO=TRN)
Related topic