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]
table altering tools 2nd 3rd table authority query TABLE class privileges TABLE DB2 object TABLE DCCSID column PLAN TABLE table editors tools 2nd TABLE ENCODE column PLAN TABLE table expressions advantages 2nd common. multiple table data retrieval performance, improving 2nd views, compared table functions 2nd TABLE MCCSID column PLAN TABLE table references unqualified DCLGEN statements TABLE SCCSID column PLAN TABLE table spaces backing up caching clustering index, ignoring compressing advantages disadvantages third-party solutions 2nd data pages 2nd data, erasing DB2 Catalog 2nd DB2 Directory 2nd DBD01 defining DSN1CHKR utility encoding schemes 2nd free space 2nd 3rd calculating growth rate formula insert activity space search algorithm large DSN1COPY utility LOBs LOB 2nd data sets DSN1COPY utility DSN1PRNT utility encoding schemes names REORG phases VSAMdata sets LOB locks locking 2nd locks 2nd 3rd 4th 5th 6th compatibility modified pages, tracking multi-table 2nd code/reference tables DBD growth multiple tables, defining 2nd referential integrity single tables, defining multi-table simple loading multiple recovering names non-segmented space search algorithm online activity page size 2nd parameters BUFFERPOOL 2nd 3rd 4th CCSID 2nd CLOSE 2nd 3rd COMPRESS 2nd 3rd 4th DSNZPARM 2nd DSSIZE ERASE FREEPAGE 2nd 3rd LARGE 2nd 3rd LOCKMAX LOCKMAX 0 LOCKPART LOCKSIZE 2nd 3rd LOCKSIZE ROW MAXROWS MAXROWS 1 MEMBER CLUSTER NUMPARTS PCTFREE 2nd 3rd PRIQTY 2nd 3rd 4th 5th PRIQTY. SECQTY 2nd 3rd 4th 5th SEGSIZE TRACKMOD USING 2nd 3rd paramters partition locking partitioned advantages 2nd 3rd clustering creating DASD volumes data set sizes 2nd disadvantages 2nd distributing indexes large 2nd 3rd maximum size multiple tables, compared 2nd 3rd 4th 5th partition key ranges partition key updates size SMS 2nd starting/stopping table-controlled 2nd three-partition example 2nd 3rd pending states correcting 2nd 3rd reasons for 2nd recovering REORG phases 2nd reorganizing regular 2nd six special 2nd RI related row maximum 2nd sample SCT01 segmented 2nd 3rd MQTs multiple tables, defining 2nd space search algorithm storin simple 2nd single space search algorithm 2nd SPT02 statistics storing 2nd 3rd primary storage 2nd 3rd 4th 5th secondary storage 2nd 3rd 4th 5th SYSCOPY SYSDBASE SYSDBAUT SYSDDF SYSGPAUT SYSGROUP SYSGRTNS SYSJAVA SYSLGRNX SYSOBJ SYSPKAGE SYSPLAN SYSSEQ2 SYSSTATS SYSSTR system recovering SYSUSER SYSUTILX SYSVIEWS types partitioned 2nd VSAM data sets closing 2nd 3rd TABLE TYPE column PLAN TABLE table UDFs cardinality, overriding table user -defined functions table-controlled partitioning 2nd tables auditable auditing auxiliary creating indexes names navigational queries average per database query base views, creating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th buffer pools isolating CDB 2nd CICS 2nd FCT PCT PPT RCT code multi-table table spaces column average per column labels columns 2nd abbreviation standards compressing data types 2nd data types, selecting 2nd 3rd date/time data date/time stamp 2nd decimal defaults 2nd defining homonyms identity 2nd 3rd 4th integer 2nd names nullable nulls 2nd 3rd 4th ROWID sequence objects 2nd 3rd 4th sequencing 2nd surrogate keys synonyms variable character 2nd 3rd 4th 5th 6th wasted space combined base table views denormalization comments converting to MQTs 2nd DB2 declaring DB2 Catalog 2nd 3rd 4th 5th IPLIST IPNAMES LOCATIONS LULIST LUMODES LUNAMES MODESELECT SYSAUXRELS SYSCHECKDEP SYSCHECKS SYSCHECKS2 SYSCOLAUTH 2nd 3rd SYSCOLDIST SYSCOLDIST_HIST SYSCOLDISTSTATS SYSCOLSTATS SYSCOLUMNS SYSCOLUMNS_HIST SYSCONSTDEP SYSCOPY SYSDATABASE SYSDATATYPES SYSDBAUTH SYSDBRM SYSDUMMY1 SYSFIELDS SYSFOREIGNKEYS SYSINDEXES SYSINDEXES_HIST SYSINDEXPART SYSINDEXPART_hIST SYSINDEXSTATS SYSINDEXSTATS_HIST SYSJARCLASS_SOURCE SYSJARCONTENTS SYSJARDATA SYSJAROBJECTS SYSKEYCOLUSE SYSKEYS SYSLINKS SYSLOBSTATS SYSLOBSTATS_HIST SYSPACKAGE SYSPACKAUTH SYSPACKDEP SYSPACKLIST SYSPACKSTMT SYSPARMS SYSPKSYSTEM SYSPLANDEP SYSPLSYSTEM SYSPROCEDURES SYSRELS SYSRESAUTH SYSROUTINEAUTH SYSROUTINES SYSROUTINES_OPTS SYSROUTINES_SRC SYSSEQUENCEAUTH SYSSEQUENCES SYSSEQUENCESDEP SYSSTMT SYSSTOGROUP SYSSTRINGS SYSSYNONYMS SYSTABAUTH SYSTABCONST SYSTABLEPART SYSTABLEPART_HIST SYSTABLES SYSTABLES_HIST SYSTABLESPACE SYSTABSTATS SYSTABSTATS_HIST SYSTRIGGERS SYSUSERAUTH SYSVIEWDEP SYSVIEWS SYSVLTREE SYSVOLUMES SYSVTREE USERNAMES DB2 Directory DBD01 SCT02 SPT01 SYSLGRNX SYSUTILX dependent referential constraints drops DSN FUNCTION TABLE 2nd columns creating RUNSTATS version 8 DSN STATEMENT TABLE 2nd columns 2nd 3rd columns;APPLNAME columns;COLLID columns;COST CATEGORY columns;EXPLAIN TIME columns; GROUP MEMBER columns;PROCMS columns;PROCSU columns;PROGNAME columns;QUERYNO columns;REASON columns;STMT ENCODE columns;STMT TYPE creating RUNSTATS version 8 DSN_FUNCTION_TABLE 2nd 3rd columns 2nd DTD repository 2nd dummy empty rows, adding emptying encoding schemes exception defining function IN DATABASE clause indexing INDEXSPACESTATS columns 2nd 3rd inner ISPF TSO 2nd join 4GL applications join limitations 2nd 3rd joining 2nd 3rd 4th 5th criteria INNER keyword JOIN keyword table joins three-table large indexing loading indexes LOB columns, creating 2nd 3rd auxiliary tables defining example 2nd LOB table spaces populating unique indexes LOBs locks 2nd 3rd logs, augmenting materialized query navigational queries materialized query. mirror binding denormalization package support MQTs multiple partitioned table spaces, compared 2nd 3rd 4th 5th names 2nd navigational queries normalized OBIDs, specifying outer parameters AUDIT ALL AUDIT CHANGES AUDIT NONE CCSID DATA CAPTURE DROP OBID parent referential constraints partition key ranges pivoting PLAN TABLE optimization hints PLAN TABLE. PLAN_TABLE columns 2nd pre-joined denormalization Q.RESOURCE_TABLE 2nd reference multi-table table spaces report denormalization rows 2nd abbreviation standards data types 2nd data types, slecting 2nd 3rd date/time data date/time stamp 2nd defaults 2nd duplicate keeping navigational queries nulls 2nd 3rd 4th primary keys ROWID data types sequence objects 2nd 3rd 4th sequencing 2nd surrogate keys wasted space RTS 2nd 3rd 4th INDEXSPACESTATS columns 2nd 3rd TABLESPACESTATS columns 2nd 3rd sample activity 2nd department 2nd employee 2nd employee assignment employee photo & resume 2nd project 2nd project activity 2nd storage group views 2nd 3rd schemas, duplicating security skeleton cursor. small indexing snapshot 2nd snapshots data warehouses, populating space column data type changes spaces adding partitions 2nd boundaries partitioning 2nd 3rd 4th rebalancing partitions 2nd rotating partitions 2nd speed hierarchies 2nd split base table views 2nd denormalization 2nd statement SYSCOLDIST 2nd SYSCOLDISTSTATS SYSCOLSTATS SYSCOLUMNS 2nd SYSIBM.SYSCOPY ICTYPE column SYSIBM.SYSDUMMY1 access SYSIBM.SYSPSM SQL stored procedures, creating SYSIBM.SYSPSMOPTS SQL stored procedures, creating 2nd SYSINDEXES 2nd SYSINDEXPART 2nd SYSINDEXSTATS SYSLOBSTATS SYSROUTINES 2nd SYSTABLEPART SYSTABLES 2nd SYSTABLESPACE 2nd SYSTABSTATS 2nd TABLESPACESTATS columns 2nd 3rd temporary created 2nd 3rd declared 2nd 3rd 4th 5th 6th 7th 8th 9th functions 2nd host variable lists names navigational queries non-relational data stored procedures 2nd triggers LOAD utility navigational queries 2nd XML administration support 2nd backing up DTD repository table 2nd XML usage table 2nd XML usage 2nd TABLESPACE DB2 object tablespace scans 2nd tablespaces DASD monitoring DB2 Catalog separating image copies information statistics partitioned data sharing group buffer pools physical characteristics physical statistics query reorganizing RTS RUNSTATS, running scan queries TABLESPACESET parameter QUIESCE utility TABLESPACESTATS table columns 2nd 3rd TABNO column PLAN TABLE TAN function TANH function tape options TEMPLATE statement TASKREQ ENTRY macro parameter TASKREQ POOL macro parameter tasks CICS Procedural tasks 2nd UDFs TCBLIMIT parameter DB2CONN parameter TCBs maximum TCP/IP distributed connections TCP/IP networks member routing technical environment CASE tools support technical issues Procedural DBA 2nd technical support teleprocessing environment tuning 2nd teleprocessing environments tuning TEMPLATE control statement utilities TEMPLATE statement data sets, allocating 2nd disk options 2nd examples 2nd names options 2nd BUFNO DATACLAS DISP DSN EXPDL GDGLIMIT MGMTCLAS MODELDCB RETPD STORCLAS UNIT VOLCNT VOLUMES symbolics 2nd tape options TEMPLATE statements database object lists templates 2nd disk options 2nd examples 2nd names options 2nd tape options testing 2nd UDFs temporary tables advantages created 2nd declared 2nd 3rd advantages 2nd scrollable cursors storage 2nd Version 7 enhancements 2nd functions 2nd host variable lists names navigational queries non-relational data stored procedures 2nd TERM command utilities, monitoring TERM UTILITY command 2nd Terminal Monitor Program. terminating DSN command sessions MODIFY STATISTICS utility UNLOAD utility utilities 2nd testing database object lists 2nd denormalization validity disaster recovery plan existence 2nd expression equality system CASE tools support templates 2nd trigger logic testing pools IMS third normal form third-party solutions compression 2nd third-party utilities third-party vendors THRDA COMD macro parameter THRDA parameter THRDM COMD macro parameter THRDM ENTRY macro parameter THRDM parameter THRDM POOL macro parameter THRDMAX RCT INIT macro parameter THRDS COMD macro parameter THRDS ENTRY macro parameter THRDS POOL macro parameter thread operation attributes DB2ENTRY parameter 2nd thread selection attributes DB2ENTRY parameter THREADLIMIT parameter CICS pool thread attributes CICS thread operation attributes threads CAF 2nd CICS 2nd common CICS distributed DB2 Connect 2nd distributed processing connection pools 2nd inactive DBATs 2nd entry CICS IMS 2nd in-doubt inactive connection pools 2nd pool CICS 2nd 3rd pooling DB2 Connect EE 2nd protected transactions types 2nd THREADWAIT parameter CICS pool thread attributes CICS thread operation attributes three-level indexes pages three-part names system-directed distribution 2nd three-partition table space example 2nd 3rd three- tier environments Net.Data support three-valued logic. thresholds buffer pools 2nd data sharing group buffer pools throughput 2nd 3rd availability buffer pool size contention hardware throughput chains Thumbnail UDF image TicksPerQNote UDF audio TicksPerSec UDF audio TIME data type 2nd 3rd promotability TIME durations TIME function Time-Sharing Option. time/date data tables time/date stamps tables 2nd timeout errors timeout messages timeouts lock minimizing locks TIMESTAMP column PLAN TABLE TIMESTAMP data type 2nd 3rd promotability TIMESTAMP durations TIMESTAMP function TIMESTAMP_FORMAT function timestamps interpreting online applications rounding/truncating timouts tuning DSNZPARMs 2nd TMP (Terminal Monitor Program) TNAME column PLAN TABLE TOKENE ENTRY macro parameter TOKENI RCT INIT macro parameter tokens explicit consistency BIND statements Tone Software Corp. tools add-on auditing 2nd 3rd Catalog query and analysis 2nd categories 2nd 3rd client/server compression 2nd DASD and space management data movement 2nd database analysis 2nd database modeling and design 2nd integrity 2nd Internet enabling miscellaneous object migration operational support 2nd PC-based performance enhancement performance monitors 2nd plan analysis 2nd programming and development QMF enhancement query 2nd 3rd repositories 2nd security 2nd table altering 2nd 3rd table editors 2nd utility enhancement analysis SQL statements CASE application development 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th DBA Version 7 enhancements debugging CICS EXPLAIN feature internal DBA stored procedures report writers 2nd capabilities required SQL Assist vendor CAF vendor guide vendors evaluating 2nd 3rd Top Ten retrieval 2nd TOTALENTRIES column INDEXSPACESTATS table TOTALROWS column TABLESPACESTATS table TRACE (/ before) command trace destinations specifying Trace Record Distribution report TRACEID RCT INIT macro parameter traces 2nd accounting 2nd 3rd 4th accounting trace reports audit 2nd 3rd 4th basic statistics, collecting DB2 PM reports, starting 2nd 3rd destinations 2nd global 2nd 3rd IFCIDs monitor 2nd 3rd 4th performance 2nd 3rd 4th starting statistics 2nd tuning DSNZPARMs tracking modified pages (table spaces) TRACKMOD parameter table spaces traffic network DB2 Internet applications training 4GL applications EXPLAIN feature Net.Data macro language transaction locks claims/drains, compared transaction recovery transactions CICS divertable grouping CICS monitoring online applications protected threads queues, tuning read-only IMS SYSGEN WFI TRANSID parameter CICS thread selection attributes transit time report sets 2nd 3rd Transit Time Summary report transition variables triggers 2nd 3rd TRANSLATE function UPPER function, compared translating authids 2nd consistent authids network specific authids password encryption trasit time report sets Treehouse Software trees syncpoint triggers after 2nd before 2nd 3rd benefits 2nd 3rd check constraints, compared 2nd client/server applications creating 2nd 3rd 4th 5th 6th activation events, selecting examples 2nd 3rd granularity logic SQL statements tables, defining transition variables 2nd WHEN clause data integrity data warehouses 2nd declarative referntial integrity firing 2nd 3rd granularity implementing 2nd limitations logic, testing multiple 2nd names 2nd navigational queries 2nd nesting 2nd non-DB2 resources, accessing packages 2nd performance Procedural DBA referntial integrity 2nd 3rd row-level simplicity statement-level stored procedures, compared storing tables LOAD utility transition variables VALUES statement troubleshooting data warehouses DPSIs 2nd performance 2nd 3rd 4th TRTCH option TEMPLATE statement TRUNC function TRUNC_TIMESTAMP function TRUNCATE function truncating timestamps TSLOCKMODE column PLAN TABLE TSO 2nd Attachment Facility batch applications 2nd 3rd 4th commits DB2-PM DB2I 2nd bind option DB2 Commands option DCLGEN option Defaults option Free Plan option menu precompile option Program Preparation option rebind option Run option SPUFI option 2nd 3rd 4th 5th Utilities option functionality/efficiency ISPF panels ISPF tables 2nd MVS performance groups online applications binding design 2nd 3rd 4th 5th DSN command processor 2nd parameters 2nd QMF 2nd 3rd Form panel Home panel Proc panel Query panel Report panel sessions resources, integrating TMP TSO (Time-Sharing Option) TSO commands tuning active users DSNZPARMs applications 2nd 3rd access paths 2nd 3rd 4th 5th nonuniform distribution statistics, deleting 2nd optimizer, influencing. referential integrity 2nd 3rd buffer pool parameters 2nd DWQT PGSTEAL VDWQT VPSEQT 2nd 3rd 4th 5th 6th VPSIZE VTYPE buffer pool size 2nd 3rd buffer pools 2nd 3rd 4th 5th access, isolating active buffer pools, converting allocation 2nd allocations available pages BP0 optimization BP0, monitoring BP32 BP32K BP32K, allocating example scenario 2nd multiple buffer pools 2nd one large buffer pool 2nd performance processing 2nd reserving reserving buffer pools sort buffer pools stealing tables, isolating thresholds 2nd unavailable pages CPUs 2nd 3rd 4th 5th data sharing group buffer pools 2nd 3rd 4th 5th castout process duplexing GBPCACHE parameter partitioned tablespaces size thresholds database design 2nd 3rd database designs DB2 Catalog 2nd 3rd 4th contention 2nd 3rd data set placement 2nd data sets indexes 2nd performance reorganizing RUNSTATS size SQL access, monitoring tablespaces, separating timeouts/deadlocks DSNZPARMs active users EDM pools locks logs 2nd timeouts 2nd traces dynamic SQL EDM pools DSNZPARMs hierarchy hiperpool parameters 2nd hiperpools 2nd 3rd I/O 2nd 3rd application 2nd 3rd costs, minimizing DB2 Catalog disk device retrieval costs internal 2nd log 2nd 3rd 4th page retrieval paging 2nd 3rd RAMAC sort 2nd write operations IRLM address space 2nd locks DSNZPARMs logs DSNZPARMs 2nd memory 2nd buffer pools 2nd DB2 code EDM pools 2nd 3rd 4th 5th IRLM 2nd 3rd memory requirements open data sets 2nd 3rd RID pools 2nd sort pools 2nd working storage z/OS 2nd operating systems OS/390 referential integrity 2nd 3rd 4th shared data subsystem teleprocessing environments 2nd 3rd timeouts DSNZPARMs 2nd traces DSNZPARMs transaction queues z/OS 2nd 3rd 4th 5th 6th turnovers procedures TWAIT COMD macro parameter TWAIT ENTRY macro parameter TWAIT POOL macro parameter TWAITI RCT INIT macro parameter tweaking SQL statements optimizer, influencing 2nd 3rd two-level indexes pages two-phase commit distribution actual commit 2nd multi-site updates one-phase, compared preparation phase syncpoint trees two-phase commits CICS 2nd IMS 2nd 3rd two-tier environments Net.Data support two-valued logic. TXID ENTRY macro parameter TXIDSO RCT INIT macro parameter Type 1 indexes pages Version 6 2nd type 1 leaf index data pages 2nd 3rd type 1 non-leaf index data pages Type 2 indexes organizing pages 2nd 3rd storage 2nd 3rd Version 6 type-2 connections types denormalization combined tables derivable data hierarchies 2nd 3rd 4th large page sizes mirror tables pre-joined tables redundant data repeating groups 2nd report tables split tables 2nd table spaces partitioned 2nd 3rd partitioned. segmented 2nd simple 2nd
|
| < Day Day Up > |