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

  1. Edit the BMCDB2 CLIST.
  2. 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)
  3. 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.

  4. Press END to exit.

    Important

    The Catalog Managerdata editing package ACTJTEQ is installed with the following values for two BIND PACKAGE options: an ISOLATION value of CS (cursor stability) and a CURRENTDATA value of YES. You can change these values by rebinding the data editing package with other values that are allowed by Db2. For BIND PACKAGE syntax and descriptions, see the IBM documentation.

  5. 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)


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*