DB2 Developers Guide (5th Edition)
| < 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 > |