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]
b-trees (indexes) backing up data COPY utility data sharing data warehouses system BACKUP SYSTEM utility 2nd 3rd 4th 5th table spaces XML administration support tables BACKUP SYSTEM utility 2nd 3rd concurrency phases backup utilities COPY 2nd 3rd CHANGELIMIT parameter 2nd 3rd concurrency 2nd data/index synchronization DFSMS disks dual image copies full image copies full image copy JCL image copies, compressing incremental image copy JCL incremental/full image copies, balancing index copy JCL indexes locking 2nd logs, suspending performance phases recovery points recovery time restarting RI- related objects, copying sequential prefetch SYSCOPY data set, allocating 2nd SYSCOPY data set, buffering SYSIBM.SYSCOPY table system page placement COPYTOCOPY 2nd concurrency inline copies JCL example locking phases running 2nd 3rd MERGECOPY 2nd concurrency full image copies incremental copies JCL phases SYSCOPY data set 2nd SYSUT1 data set 2nd 3rd QUIESCE 2nd concurrency JCL locking pahses partition levels recovery points running system databases table spaces 2nd 3rd TABLESPACESET parameter WRITE option REBUILD INDEX concurrency index versions JCL listing large indexes locking phases rerunning system indexes SYSUT1 data sets VSAM data sets work data sets REPAIR REPORT RECOVERY 2nd JCL listing locking backups disaster recovery base data types UDTs, compared base tables views columns , adding 2nd 3rd columns, deleting combined tables creating 2nd 3rd 4th 5th split tables 2nd Basic Cursor Table. batch applications IMS TSO 2nd 3rd 4th batch jobs dispatching priorities batch message processor applications IMS batch procedures program preparation 2nd batch processing operating environments batch programs clustered access COMMIT statements data customizations 2nd scheduling cursor repositioning deadlocks LOCK TABLE command lock timeouts locking parallel processing 2nd 3rd restarting 2nd 3rd 4th 5th units of work 2nd 3rd 4th Batch Terminal Simulator. BCT (Basic Cursor Table) plan messages BEFORE keyword scrollable cursors before triggers 2nd 3rd bends AEY9 avoiding BETWEEN predicate BEZ Systems Binary Large Objects. BIND command CACHESIZE parameter program preparation 2nd reactive governing BIND PACKAGE command program preparation BIND package parameters locks bind panels (DB2I) BIND parameters locks pages/rows 2nd 3rd 4th table spaces BIND PLAN command program preparation BIND plan parameters locks BIND statements ACTION parameter CACHESIZE parameter collections DBRMs, retaining default parameters dirty reads 2nd 3rd 4th benefits problems UR isolation levels 2nd dynamic reoptimization DYNAMICRULES parameter 2nd 3rd ENABLE/DISABLE parameters 2nd errors explicit consistency tokens IMMEDWRITE parameter initial administration isolation levels like programs, grouping lock avoidance mirror tables multiple qualified tables OPTHINT parameter packages 2nd packages, creating parallelism 2nd PATH parameter plans prepared statements production BINDs QUALIFIER parameter read stability reoptimization reoptimization, isolating repeatable reads 2nd 3rd page locking RETAIN parameter statistics (current) tabe space locking 2nd validation wildcard package lists BIND time monitoring BIND TIME column PLAN TABLE bind-time authorization checking BIND_OPTS column SYSIBM.SYSPSMOPTS table BINDAGENT authority BINDAGENT group -level authorization BINDCT plan messages binding applications DB2 Connect data sharing DB2 Connect utilities DB2I distributed environment options 2nd online TSO applications packages DB2I plans 2nd DB2I production plans program precompiling BitsPerSample UDF audio video black boxes application programs 2nd BLOB data type promotability BLOB function BLOBs (Binary Large Objects) block fetches continuous 2nd 3rd cursors ambiguous FOR READ ONLY/FOR FETCH ONLY clauses non-updateable read-only data currency 2nd 3rd limited 2nd 3rd block style coding SQL statements 2nd 3rd BM BM (Buffer Manager) BMC Instant Copy and Recover 2nd BMC Software BMC Software Web site bodies SQL stored procedures 2nd Book Manager Library Reader bookmarks Internet boundaries partitions table spaces BP0 monitoring optimizing BP32 BP32K allocating Brio Technology broken page bits repairing browsing cursor-free BSDS expanding BTS (Batch Terminal Simulator) Buffer Manager. buffer pools active converting allocating allocations BP0 optimizing BP0, monitoring BP32 BP32K BP32K, allocating data sharing data sharing group buffer pools tuning 2nd 3rd 4th 5th deferred write threshold defining distributed FIFO algorithm group duplexing 2nd 3rd 4th grouping hit ratios indexes LOBs long accounting reports 2nd 3rd 4th LRU algorithm monitoring multiple 2nd assignments memory processing requirements one large buffer pool 2nd page stealing algorithm parameters tuning reserving size tuning 2nd 3rd sort storage groups subsystem size table spaces 2nd sizes specifying thresholds throughput tuning 2nd 3rd 4th 5th 6th 7th 8th access, isolating allocation 2nd available pages example scenario 2nd multiple buffer pools 2nd one large buffer pool 2nd performance processing 2nd reserving stealing tables, isolating unavailable pages tuning parameters DWQT PGSTEAL VDWQT VPSEQT 2nd 3rd 4th 5th 6th VPSIZE VTYPE workloads buffering global data 2nd buffer pools group buffer pool duplexing 2nd updating/reading data 2nd non-DB2 data sets SYSCOPY data set work data sets LOAD utility REORG utility BUFFERPOOL parameter table spaces 2nd sizes specifying bufferpools sequential prefetch values sequential prefetch/detection values 2nd buffers maximizing message BUFND parameter DSN1COPY utility BUFNO option TEMPLATE statement BUFNO parameter MERGECOPY utility utilities BUILDNAME column SYSIBM.SYSPSMOPTS table BUILDOWNER column SYSIBM.SYSPSMOPTS table BUILDSCHEMA column SYSIBM.SYSPSMOPTS table built-in functions 2nd guidelines column function results, searching nulls synonyms, avoiding 2nd UPPER vs TRANSLATE functions MQSeries 2nd 3rd XML publishing 2nd built-in security groupings built-in stored procedures 2nd Bunker Hill business intelligence Version 7 enhancements 2nd Business Objects, Inc. BY DEFAULT parameter rows/columns bytecodes (Java) BytesPerSec UDF audio video
|
| < Day Day Up > |