index_L

 <  Day Day Up  >    

[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] [Y] [Z]

L-locks
labeled durations
labels
        columns
language interfaces modules
        linking
Language UDF
        text
LANGUAGE UDF characteristic
languages
       CODE/370
                stored procedures
       LE/370
                stored procedures
                stored proceures
       programming
                UDFs 2nd
large objects.
LARGE parameter
        table spaces 2nd 3rd
large partitioned table spaces 2nd 3rd
large table spaces
        LOBs
LAST keyword
        scrollable cursors
LAST_DAY function
latches
        locks, compared
LCASE function
LDS (linear data sets)
LE/370 language
        stored procedures 2nd
leaf pages 2nd
        indexes
        Type 2 indexes
LEAFDIST column
LEAFDISTLIMIT parameter
        REORG utility
LEAST function
least-recently-used (LRU) algorithm
LEFT function
LEFT OUTER JOIN outer join
left outer joins
        right outer joins, compared
LENGTH function
lengths
        data types 2nd
levels
       DRDA
                DUW
                remote request
                RUW
       indexes
                creating
       isolation
                SQL statemetns
libraries
       DBRM
                programs, precompiling
        DCLGEN
       standard
                maintenance
licking
        MODIFY RECOVERY utility
LIGHT parameter
LIKE clause
        table schemas
LIKE predicate
        comparisons
        host variables 2nd
lilstings
        RCT example 2nd
LIMIT parameter
        information-gathering commands
        UNLOAD utility
limited block fetches 2nd 3rd
limited block protocol
limited partition scans
limits
        physical storage 2nd 3rd
        structural 2nd 3rd 4th
linear data sets.
linear page sets
link-editing applications
        language interface modues
LINK_OPTS column
        SYSIBM.SYSPSMOPTS table
linking
        CICS
        programs
links
        DB2 Catalog 2nd 3rd
LIST keyword
        LISTDEF statemetn 2nd
list of objects statistics
       gathering
                RUNSTATS utility
LIST parameter
        buffer pool information
list prefetch
        disabling 2nd
list prefetches 2nd
list structures
LISTDEF control statement
        utilities
LISTDEF statement
        database object lists 2nd
                example 2nd
                expanding 2nd
                INCLUDE/EXCLUDE clauses 2nd
                indexes
                LIST keyword 2nd
                LOBs 2nd
                previewing
                referential integrity
                wildcards 2nd
        RUNSTATS utility
listings
        applications, running
        batch JCL for TSO/DB2 application
        CHECK DATA JCL
                LOB references
        CHECK INDEX JCL
        CHECK LOB JCL
        COBOL error-handling paragraph 2nd
        COBOL stored procedure shell 2nd
        COPYTOCOPY JCL
        cursor processing
        database object list example
        DB2 availability, checking
       DB2 PM accounting reports
                short 2nd
        DB2 PM audit summary report
        DB2 PM I/O activity summary report 2nd
        DB2 PM lock contention summary report
        DB2 PM statistics short report 2nd 3rd 4th
        DB2 PM Transit Time Summary
        DIAGNOSE JCL
        DISPLAY BUFFERPOOL command results 2nd
        DISPLAY GROUP command
        DISPLAY LOG command
        DL/I batch interface
        DSN FUNCTION TABLE, creating
        DSN STATEMENT TABLE, creating
        DSN1CHKR JCL
        DSN1COMP JCL
        DSN1COPY JCL
        DSN1COPY with OBIDXLAT option JCL
        DSN1LOGP JCL
        DSN1PRNT JCL
        DSN1SDMP JCL
        DSNJCNVB JCL
        DSNJLOGF
        DSNJU003 JCL
        DSNJU004 JCL
        DSNTEP2 JCL
        DSNTIAD JCL
        DSNTIAUL JCL
       environment commands
                issuing with DB2I
        EXECUTE IMMEDIATE statement
        fixed-list SELECT dynamic SQL
        full image copy JCL
        full recovery JCL
        incremental image copy JCL
        index copy JCL
        JDBC code fragment
       joins
                application 2nd
                SQL
       LOAD JCL
                nonrestartable 2nd
                restartable 2nd
       long accounting reports
                buffer pool information 2nd 3rd 4th
                CPU and Elapsed Time 2nd
                database code usage information
                highlights 2nd 3rd
                locking activity 2nd
                miscellaneous information 2nd 3rd
                package/DBRM information 2nd
                program status
                RID list processing
                SQL activity 2nd 3rd
        MERGECOPY JCL
        MODIFY RECOVERY
        MODIFY STATISTICS JCL
       non-SELECT dynamic SQL
                COBOL program
                parameter markers
        ODBC applications 2nd
        partial recovery JCL
        PLAN TABLE, creating 2nd
        program preparation batch procedure 2nd 3rd
       program preparation CLISTs
                bind 2nd
                precompile/compile/link 2nd
       QMF forms
                DBID/PSID/OBID queries
        QMF forms (SYSCOPY queries)
        QMF table listing query
        QUIESCE JCL
        REBUILD INDEX JCL
        RECOVER INDEXSPACE JCL
       REORG JCL
                nonrestartable
                restartable
        REPAIR DBD JCL
        REPAIR LOCATE JCL
        REPAIR SET JCL
        REPORT RECOVERY JCL
        REPORT TABLESPACESET JCL
        RUNSTATS INDEX JCL
        RUNSTATS TABLESPACE JCL
        SQLJ code fragment
        STOSPACE JCL
        UNLOAD JCL
        updates with cursors 2nd
        varying-list SELECT dynamic SQL
        varying-list SELECT dynamic SQL with minimal SQLDA
lists
       IN
                duplicates
                ordering
LIT parameter
        SSMs
LN function
LOAD control statements
        creating
load modules
LOAD utility 2nd
        appending/replacing data
        blocked input
        concurrency 2nd
        contingency options
        data conversion
        DECIMAL columns
        delimited input data sets 2nd
        editing data before loading
        floating point data
        index keys, sorting
        indexes, creating
        inline copies
        inline statistics 2nd
        input data sets, sequencing 2nd
        INSERT statements, compared
        INSERTs, compared
        locking 2nd
        LOG NO option
        mass deletes
        multi-table simple table space
        nonrestartable jobs 2nd
        nullable columns
        online loading
        parameters, coding
        partitions
        performance
        philosophies 2nd 3rd 4th
        referential constraints, forcing
        reorganizing
        rerunning/restarting 2nd 3rd 4th
                BUILD phase
                DISCARD phase
                INDEXVAL phase
                RELOAD phase
                REPORT phase
                SORT phase
                UTILINIT phase
                UTILTERM phase
        restarting jobs 2nd
        ROWID values
        security
        serializing jobs
        sort utility
        statistics, gathering
        table triggers
        work data sets 2nd 3rd 4th 5th
                buffering
        work data sets, separating
loading
        delimited input data sets 2nd
        utilities 2nd
loading tables
        indexes
LOADRLASTTIME column
        INDEXSPACESTATS table
        TABLESPACESTATS table
LOB columns
        pages 2nd
LOB data pages
LOB map pages
LOB table spaces
        data sets
        DSN1COPY utility
        DSN1PRNT utility
        encoding schemes
        names
        REORG phases
        VSAM data sets
LOBs 2nd
        accessing
        buffer pools
        database object lists 2nd
        defining 2nd
        expressions
        implementing
        large table spaces, creating
        locators 2nd
                application storage
                indicator variables
        locks 2nd 3rd
                duration
                hierarchy
                S-locks
                table spaces
                X-locks
        logging
        materialization
        navigational queries
        overhead, limiting
       references
                checking 2nd 3rd 4th
        ROWID columns 2nd
        sample applications
        tables
        tables, creating 2nd 3rd
                auxiliary tables
                columns, defining
                example 2nd
                LOB table spaces
                populating
                unique indexes
        user -defined distinct types
        VARCHAR/VARGRAPHIC columns, compared 2nd 3rd
        variable declarations 2nd
LOBs (large objects)
LOCATE function
location aliases
location identifiers
        packages
locations
LOCATIONS table
locators
        LOBs 2nd
                application storage
                indicator variables
lock avoidance
Lock Contention summary report
lock structures
LOCK TABLE command
        batch programs
LOCK TABLE statement 2nd
LOCK TABLE statements
        DSNTIAUL utility
locking
        batch programs
        CICS problems
        COPY utility 2nd
        COPYTOCOPY utility
        IRLM
        LOAD utility 2nd
       partitions
                table spaces
        QUIESCE utility
        REBUILD INDEX utility
        RECOVER utility
        REORG INDEX utility
        REORG TABLESPACE
        REPORT RECOVERY utility
       row
                table spaces
       row-level
                data sharing
        RUNSTATS utility
        STOSPACE utility
       structures
                specifying
        table spaces 2nd 3rd 4th
                disabling
                MAXIMUM
                switching
        timeouts, minimizing
        UNLOAD utility
locking activity (long accounting report) 2nd
locking report sets 2nd
LOCKMAX 0 parameter
        table spaces
LOCKMAX parameter
        table space locks
        table spaces
LOCKPART parameter
        table spaces
locks
        application program designs
        avoidance 2nd 3rd 4th
                data sharing
                occurences 2nd
        BIND package parameters
       BIND parameters
                pages/rows 2nd 3rd 4th
                table spaces
        BIND plan parameters
        CHECK INDEX utility
        CHECK LOB utility
        checking
        clustering
        contention messages
        data sharing
        deadlocks 2nd
        drains
        efficiency
        escalating 2nd 3rd
                DSNZPARM parameter
                LOCKMAX parameter
        escalation
        free space, increasing
        global 2nd
                structures
        hierarchical
        hierarchy
        holding across commits
        IRLM parameters
        L-locks
        latches, compared
        LOBs 2nd 3rd
                duration
                hierarchy
                S-locks
                table spaces
                X-locks
        managing 2nd 3rd
       monitoring
                statistics reports
        P-locks
       page
                row locks, compared 2nd
        pages 2nd 3rd
                compatibility
        partition independence 2nd
        promoting
        referential integrity
        REPAIR LOCATE utility
        rows 2nd
                compatibility
                page locks, compared 2nd
        rows, decreasing
        S-locks
        stable data
        suspending
        table spaces 2nd 3rd 4th 5th
                compatbility
        tables 2nd 3rd
        timeouts
       transaction
                claims/drains, compared
       tuning
                DSNZPARMs
        uncertain data
        X-locks
LOCKS clause
        DISPLAY DATABASE command
LOCKSIZE ANY parameter
LOCKSIZE parameter
        table spaces 2nd 3rd
LOCKSIZE ROW parameter
        table spaces
locs
        sizes
log data sets
        DSN1COPY utility
LOG function
LOG SUSPEND command
        Version 7 enhancements
LOG YES parameter
        REPAIR DBD utility
        REPAIR LOCATE utility
LOG10 function
LOGAPSTG parameter
logging
        LOBs
logic
       negation
                subqueries
        three-valued.
        triggers
                testing
        two-valued.
Logical page list (LPL) status
logical page lists.
logs
       active
                DSN1LOGP
                RECOVER utility
                size
       archive
                RECOVER utility
        archiving
        changed information, augmenting
       I/O
                tuning 2nd 3rd 4th
        LOAD utility
       managing
                statistics reports
        monitoring
        offloading 2nd
                performance
        output buffer size
        problem resolution
        reading, reducing
       suspending
                COPY utility
        synchronizing
       tuning
                DSNZPARMs 2nd
        volumes
                Version 8
long accounting reports
        buffer pool information 2nd 3rd 4th
        CPU and Elapsed Time 2nd 3rd
        database code usage information
        highlights 2nd 3rd
        locking activity 2nd
        miscellaneous information 2nd 3rd
        package/DBRM information 2nd
        program status
        RID list procesing
        SQL activity 2nd 3rd
Long Record Trace report
LONG VARCHAR columns
LONG VARCHAR parmeter
        stored procedures
LONG VARGRAPHIC parameter
        stored procedures
LONGLOG parameter
        online reorganizations
lookasides (index)
loops
       infinite
                preventing 2nd
LOWER function
LPL page recovery
LPL status (Logical page list)
LPLs
        viewing
LPLs (logical page lists)
LRU (least-recently-used) algorithm
LRU algorithm
        buffer pools
LSTATS parameter
        buffer pool inforamtion
LTRIM function
LULIST table
LUMODES table
LUNAME column
        RLSTs
LUNAMES table

 <  Day Day Up  >    


DB2 Developers Guide
DB2 Developers Guide (5th Edition)
ISBN: 0672326132
EAN: 2147483647
Year: 2004
Pages: 388

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net