L

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

LARGE clause 2nd
Large object (LOB)
Large objects
Large table spaces 2nd
Latency
Leaf pages
Left outer joins
LEFTOUTERJOIN keyword 2nd 3rd
License Center 2nd 3rd 4th 5th 6th 7th
Licensing
     DB2 installation 2nd 3rd
     License Center
     phone contact
LIKE predicate 2nd
Line continuation, CLP 2nd 3rd 4th
Linux server, connectivity to
     iSeries client 2nd 3rd 4th
     z/OS client 2nd 3rd 4th 5th 6th
Linux, UNIX, Windows (LUW) support 2nd
Linux/UNIX, installing DB
     manually 2nd
     overview
     required user IDs and groups 2nd
     response files
     with Setup Wizard 2nd
List applications command, troubleshooting locking problems 2nd
LIST DATABASE PARTITION GROUPS statement 2nd 3rd
list db directory command
list dcs directory command
LIST HISTORY command 2nd
list node directory command
list prefetch command
LIST TABLESPACE CONTAINERS FOR command 2nd 3rd
LIST TABLESPACES command
     changing container definitions 2nd 3rd
     listing table spaces 2nd 3rd
list utilities command 2nd
Listener processes 2nd
Listeners 2nd 3rd
Listing
    databases [See displaying]
    DB2 commands [See displaying]
    DCS directory contents [See displaying]
    directories [See displaying]
    environment variables [See displaying]
    installed products [See displaying]
    instances [See displaying]
    local database directory contents [See displaying]
    node directory contents [See displaying]
    partition groups [See displaying]
    registry variables [See displaying]
    SQL statements [See displaying]
    system db directory contents [See displaying]
    table spaces [See displaying]
LOAD authority 2nd
load command 2nd 3rd 4th 5th 6th 7th 8th 9th
Load copy
Load module
Load querying
load utility
    allow no access option [See import utility, INSERT statement]
    allow read access option [See import utility, INSERT statement]
    ANYORDER modifier [See import utility, INSERT statement]
    authority required [See import utility, INSERT statement]
    collecting statistics [See import utility, INSERT statement]
    copy yes/no options [See import utility, INSERT statement]
    CPU_PARALLELISM modifier [See import utility, INSERT statement]
    DATA BUFFER modifier [See import utility, INSERT statement]
    data validation [See import utility, INSERT statement]
    definition [See import utility, INSERT statement]
    DISK_PARALLELISM modifier [See import utility, INSERT statement]
    exception option [See import utility, INSERT statement]
    exception tables [See import utility, INSERT statement]
    FASTPARSE modifier [See import utility, INSERT statement]
    file type modifiers [See import utility, INSERT statement]
    indexing mode option [See import utility, INSERT statement]
    leaving free space [See import utility, INSERT statement]
    list utilities command [See import utility, INSERT statement]
    load command [See import utility, INSERT statement]
    load querying [See import utility, INSERT statement]
    loading from a client [See import utility, INSERT statement]
    loading from a cursor [See import utility, INSERT statement]
    loading large objects [See import utility, INSERT statement]
    lock with force option [See import utility, INSERT statement]
    locking considerations [See import utility, INSERT statement]
    messages option [See import utility, INSERT statement]
    modified by modifier [See import utility, INSERT statement]
    monitoring load operations [See import utility, INSERT statement]
    nonrecoverable option [See import utility, INSERT statement]
    overview [See import utility, INSERT statement]
    page overflow [See import utility, INSERT statement]
    performance [See import utility, INSERT statement]
    performance considerations [See import utility, INSERT statement]
    pointers [See import utility, INSERT statement]
    process description [See import utility, INSERT statement]
    rebuilding indexes [See import utility, INSERT statement]
    roll forward recovery [See import utility, INSERT statement]
    savecount option [See import utility, INSERT statement]
    saving rejected records [See import utility, INSERT statement]
    set integrity command [See import utility, INSERT statement]
    SORT BUFFER modifier [See import utility, INSERT statement]
    statistic profiles [See import utility, INSERT statement]
    statistics no option [See import utility, INSERT statement]
    statistics use profile option [See import utility, INSERT statement]
    table space states [See import utility, INSERT statement]
    table states [See import utility, INSERT statement]
    warningcount option [See import utility, INSERT statement]
    with the Control Center [See import utility, INSERT statement]
Loading
    databases [See data movement utilities]
     from a client 2nd 3rd
     from a cursor
     large objects 2nd 3rd
     table data, performance 2nd 3rd 4th
LOB (large object)
LOB locator
lobs from clause
lobsinfile modifier 2nd
Local clients
Local database directories 2nd
Local database directory
Local databases
Local groups 2nd
Locator [See LOB locator]
Lock attributes
     overview 2nd
     row-level lock modes 2nd 3rd 4th 5th 6th
     tablelevel lock modes 2nd 3rd 4th 5th
Lock deferral
Lock escalation 2nd 3rd 4th
LOCK TABLE statement
Lock waits 2nd
lock with force option 2nd
Locking
    avoiding [See concurrency, isolation levels]
    case study [See concurrency, isolation levels]
    configuring [See concurrency, isolation levels]
    considerations with load utility [See concurrency, isolation levels]
    deadlocks [See concurrency, isolation levels]
    definition [See concurrency, isolation levels]
    scenarios
        lost updates [See concurrency, isolation levels]
        nonrepeateable reads [See concurrency, isolation levels]
        phantom reads [See concurrency, isolation levels]
        transactions [See concurrency, isolation levels]
        uncommitted reads [See concurrency, isolation levels]
    troubleshooting
        Activity Monitor [See concurrency, isolation levels]
        deadlocks [See concurrency, isolation levels]
        Event Monitor [See concurrency, isolation levels]
        force application command [See concurrency, isolation levels]
        Health Center [See concurrency, isolation levels]
        list applications command [See concurrency, isolation levels]
        Snapshot Monitor [See concurrency, isolation levels]
        snapshot table functions [See concurrency, isolation levels]
LOCKLIST parameter 2nd 3rd
Lockout time
Locks
LOCKSIZE option 2nd
LOCKTIMEOUT parameter 2nd
Log disk full condition 2nd
Log files 2nd
Log full condition
Log space
LOGARCHMETH1 parameter 2nd 3rd
LOGARCHMETH2 parameter
LOGARCHOPT1 parameter
LOGARCHOPT2 parameter
LOGBUFSZ parameter
LOGFILSIZ parameter
Logging
     configuring
     default error level, setting
     error messages 2nd
     methods 2nd 3rd 4th 5th 6th 7th
Logical agents
Logical links 2nd
Logical operators
Logical partitions 2nd 3rd 4th 5th 6th
LOGPRIMARY parameter
Logs
     active
     administration notification
     archived
     circular
     database
     DB2 environment
     definition
     DPF 2nd
     primary
     recoverable
     secondary
    transaction
        active log directory [See recovery]
        active logs [See recovery]
        archival logging [See recovery]
        circular logging [See recovery]
        database configuration parameters [See recovery]
        handling [See recovery]
        infinite active logging [See recovery]
        log disk full condition [See recovery]
        log full condition [See recovery]
        log space [See recovery]
        logging methods [See recovery]
        offline archive logs [See recovery]
        online archive logs [See recovery]
        overview [See recovery]
        primary log files [See recovery]
        secondary log files [See recovery]
        size of log space [See recovery]
        states of logs [See recovery]
        user exit [See recovery]
LOGSECOND parameter
LOGTARGET option
LONG clause 2nd
long in lobts clause
Long strings
Long table spaces [See large table spaces]
LONG VARCHAR (long variable character) data type
LONG VARGRAPHIC data type
Long variable character (LONG VARCHAR) data type
Lost updates 2nd 3rd 4th 5th
Lotus brand 2nd
Lotus worksheet format 2nd
Lowercase 2nd 3rd
LUW (Linux, UNIX, Windows) support 2nd