HP 3000 Manuals

Row Level Locking: Technical Addendum for ALLBASE/SQL Release F

Index

A
    adding
       constraint to table   
    altering
       tables   
    ALTER TABLE   
       syntax   
    assigning pages
       to runtime control block buffer   
    automatic locking modes
       in CREATE TABLE   

B
    buffer
       data   
       log   
       runtime control block   

C
    changing
       a table's lock mode   
    check constraint
       in ALTER TABLE   
       in CREATE TABLE   
    column names
       in ALTER TABLE   
       in CREATE TABLE   
    columns
       adding to tables   
       maximum allowed in tables   
    concurrency
       and table size   
       in creating tables   
    CREATE TABLE
       syntax   
    creating
       tables   
    creating objects
       tables   
    CS isolation level
       explained   
    cursor stability (CS)
       explained   

D
    data buffer
       shared memory for   
    data types
       in CREATE TABLE   
       of column added to existing table   
    DBCore services
       control block buffer   
    DBEFileSet names
       in CREATE TABLE   
    deadlock
       avoidance of   
       definition   
       detection/resolution   
       example   
    default columns in tables
       defining   
    defining objects
       columns   
       default columns in tables   
       tables   
    dropping
       constraint   

E
    error code
       -4008   
    exclusive lock
       defined   

F
    FOREIGN KEY
       in CREATE TABLE   

G
    granting
       to PUBLIC   
    grants
       automatic   
       implicit (CREATE TABLE)   
    granularity
       of locking   

H
    hash
       in CREATE TABLE   

I
    implicit locking
       private   
       public   
       publicread   
    index
       allocating storage for   
    index locking
       explained   
    intention exclusive lock
       defined   
    intention share lock
       defined   
    IS lock
       explained   
    isolation level
       defined   
    IX lock
       explained   

L
    LANG = clause
       in ALTER TABLE   
       in CREATE TABLE   
    LANGUAGEID
       in SYSTEM.TABLE   
    locking
       automatic   
       deadlocks   
       exclusive mode   
       explicit   
       granularity   
       implicit   
       in table creation   
       isolation levels   
       levels of   
       mode   
       objects locked   
       page and table compared   
       PUBLIC   
       publicread   
       PUBLICREAD   
       release   
       released in deadlock   
       row and page compared   
       share   
       strategy in CREATE TABLE   
    locking mode
       associated authorities   
    LOCK TABLE
       to override automatic locking   
    lock types
       exclusive (X)   
       intention exclusive (IX)   
       intention share (IS)   
       share intention exclusive (SIX)   
       share (S)   
    lock waits
       and timeout value   
    log buffer
       shared memory for   

M
    maintenance
       changing a table's lock mode   
       tables   

N
    native language
       shown in SYSTEM.TABLE   
       tables in ALTER TABLE   
       tables in CREATE TABLE   
    NOT NULL
       in CREATE TABLE   
    null values
       and altering tables   

P
    page level locking
       explained   
    pages
       deadlocks   
    PRIMARY KEY
       in ALTER TABLE   
       in CREATE TABLE   
    private   
       locking   
    PRIVATE tables
       in CREATE TABLE   
       locking mode   
    PUBLIC
       grant to   
    PUBLICREAD tables
       in CREATE TABLE   
       locking mode   
    PUBLICROW tables
       in CREATE TABLE   
       locking mode   
    PUBLIC tables
       in CREATE TABLE   
       locking mode   

R
    RC isolation level
       explained   
    read committed (RC)
       explained   
    read uncommitted (RU)
       explained   
    referential constraint
       in ALTER TABLE   
       in CREATE TABLE   
    repeatable read (RR)
       explained   
    row level locking
       explained   
    RR isolation level
       explained   
    RU isolation level
       explained   
    runtime control blocks
       shared memory for   

S
    SearchCondition
       in CREATE TABLE   
    security
       specifying when creating a table   
    shared memory
       estimating requirements   
       requirements for buffers   
       runtime control block buffer   
    share intention exclusive lock
       defined   
    share lock
       defined   
    share mode locking
       explained   
    SIX lock
       explained   
    S lock
       explained   
    SQL statement
       ALTER TABLE   
       CREATE TABLE   
    SYSTEM
       table locking   
    SYSTEM.TABLE
       column definition and description   
       monitoring for table size   

T
    table
       adding constraint to   
       allocating storage for   
       changing lock mode   
       creating   
       defined   
       defining default columns in   
       dropping constraint from   
       implicit locking   
       implied security   
       locking   
       private   
       public   
       publicread   
    table level locking
       explained   
    table names
       in ALTER TABLE   
       in CREATE TABLE   
    tasks
       changing a table's lock mode   
       creating a table   
    timeout value
       and lock waits   
    transaction block buffer
       shared memory for   
    transactions
       priority   

U
    unique constraint
       in ALTER TABLE   
       in CREATE TABLE   
    user table locking
       explained   

X
    X (EXCLUSIVE) locks
       explained   

MPE/iX 5.0 Documentation