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]
I-marks I/O application tuning 2nd 3rd internal tuning 2nd log tuning 2nd 3rd 4th paging tuning 2nd 3rd query I/O parallelism RAMAC tuning sort tuning 2nd tuning 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 I/O (input/output) I/O activity report sets 2nd 3rd I/O Activity Summary report 2nd I/O costs optimizer I/O parallelism I/O routines application development IBM IBM DB2 for OS/390 and z/OS Web site IBM Redbook Web site IBM SERVICE DATA column PLAN TABLE IBM SQL reserved words 2nd IBM System Journal (ital) IBM utility packages 2nd 3rd ICTYPE column SYSIBM.SYSCOPY table IDBACK parameter 2nd identical input parameters stored procedures UDFs identifiers collection packages DB2 objects location packages identity columns 2nd 3rd IDENTITY columns identity columns copying IDENTITY columns navigational queries identity columns problems 2nd sequence objects, compared 2nd values Version 7 enhancements 2nd identity protection (Internet) IDENTITY_VAL_LOCAL function IDFORE parameter 2nd IDs subsystem CICS utility names IDUG (International DB2 User Group ) IDUG Solutions Journal (ital) IDUG Web site IFCIDs traces IFI (Instrumentation Facility Interface) 2nd IFNULL function image copies compressing COPY utility consistent, recovering DB2 Catalog reorganization falling back to previous full. GDG relative generation numbers incremental logs, reading incremental. indexes MODIFY RECOVERY utility shipping offsite SHRLEVEL CHANGE tablespaces image copy data sets allocating specifying IMMEDWRITE parameter binding data sharing impedance mismatches implementing data warehouses 2nd LOBs online schema changes optimization hints RI security views stored procedures 2nd 3rd triggers 2nd Importer UDF audio image video ImportTime UDF audio image video IMS applications 2nd Attach Facility 2nd 3rd CICS, compared cursor closing points databases, accessing DDL deadlocks 2nd DL/I batch interface 2nd ESA quick reschedule Fast Path databases IRLMs, sharing online considerations 2nd PCBs, copying restarting RTTs SPAs SYSGEN PROCLIM paramter read-only transactions transaction modes WFI transactions testing pools threads 2nd TM regions two-phase commits 2nd 3rd IMS (Information Management System) IMS commands 2nd 3rd IMS databases accessing stored procedures IMS/TM online applications 2nd IMSI IN DATABASE clauses tables IN lists duplicates ordering IN parameter CREATE PROCEDURE statement IN predicate in-doubt threads in-house training (DB2) inactive DBATs 2nd inactive threads connection pools 2nd inbound authid translations INCLUDE clause LISTDEF statement 2nd INCLUDING COLUMN DEFAULTS parameter INCRCOPY parameter DSN1COMP utility incremental copies full image copies, balancing MERGECOPY utility incremental image copies JCL listing logs, reading index copy JCL listing index data pages 2nd Type 1 type 1 leaf 2nd 3rd type 1 non-leaf Type 2 2nd 3rd INDEX DB2 object index keys length 2nd sorting index lookasides index only access index space index-only access 2nd 3rd indexability predicates 2nd simple statements INDEXBP parameter indexed columns joins updating indexes 2nd access, disabling auxiliary tables avoiding b-trees buffer pools caching clustering 2nd customizing 2nd ignoring column cardinality 2nd column data type changes columns adding 2nd avoiding extra multiple considerations 2nd copying COPY utility creating 2nd 3rd 4th 5th customizing 2nd data monidification data sets size 2nd 3rd data sets, defining data synchronization COPY utility data warehouses database object lists databases DB2 Catalog rebuilding deferring creation disk storage monitoring DPSIs 2nd troubleshooting 2nd entries 2nd foreign keys free space 2nd image copies index data pages index key length 2nd index space index-only access 2nd indexed access 2nd 3rd 4th 5th 6th clustered index access direct index lookups index lookasides index scans index screening index-only access list prefetches 2nd matching index scans 2nd multi-indexes 2nd non-clustered index access non-matching index scans 2nd skip sequential prefetches large insertions large tables leaf pages levels reating LOAD utility loading tables lookasides MQTs multi-index access 2nd multiple multiple nulls names 2nd 3rd navigational queries non-partitioned non-partitioning 2nd nonleaf pages NPSI online schema changes clustering 2nd 3rd 4th columns, adding 2nd padded variable length Version 8 padded/non-padded pages 2nd partition levels checking partitioned 2nd starting/stopping partitioned table spaces partitioning 2nd 3rd 4th 5th 6th physical characteristics PLAN TABLE primary keys primary/secondary space allocations rebuilding recover pending flags recovery REORG INDEX utility locking REORG phases 2nd reorganizing REORG utility 2nd RIDs root pages RTS RUNSTATS, running scan queries scans avoiding matching 2nd non-matching 2nd screening secondary partitioned small tables statistics statistics query storage 2nd storing structure 2nd system reorganizing tables three-level pages two-level pages Type 1 pages Version 6 2nd type 1 leaf pages 2nd 3rd type 1 non-leaf pages Type 2 organizing pages 2nd 3rd storage 2nd 3rd Version 6 unclustered uniqueness validity VARCHAR columns variable columns 2nd variable index keys 2nd versions REBUILD INDEX utility workload analysis 2nd INDEXONLY column PLAN TABLE INDEXSPACESTATS table columns 2nd 3rd indicator variables LOB locators INDREFLIMIT parameter REORG utility industry periodicals 2nd 3rd 4th infinite loops preventing 2nd influencing optimizer 2nd DB2 Catalog statistics. optimization hints 2nd 3rd 4th 5th OPTIMIZE FOR n ROWS clause 2nd 3rd SQL statements, tweaking 2nd 3rd standard methods 2nd 3rd 4th 5th Informatica Information Builders Inc. Information Integrator Information Integrator for Content Information Management System. information-gathering commands 2nd active objects, viewing buffer pools, monitoring buffer pools, tuning centralized areas database information, viewing database usage grouping buffer pools information, limiting LIMIT parameter LIST/LSTATS parameters locking information, viewing logging, monitoring LPLs, viewing objects, monitoring 2nd 3rd 4th OVERVIEW parameter restricted objects stored procedures, monitoring UDF statistics, monitoring utilities, monitoring 2nd wildcards informational referential constraints checking Infospace Infotel Corporation INIT macro parameters RCT 2nd 3rd 4th DPMODI ERRDEST PCTEROP PLANI PLNPGMI PLNXTR1 PLNXTR2 PURGEC ROLBI SHDDEST SIGNID SNAP STANDBY STRTWT SUBID SUFFIX THRDMAX TOKENI TRACEID TWAITI TXIDSO Init_Text_Handle UDF text initializing host variables variables initiators inline copies COPYTOCOPY utility creating LOAD utility inline statistics gathering LOAD utility 2nd REORG utility 2nd RUNSTATS utility inline views. inner joins explicit INNER keyword joins inner tables INOUT parameter CREATE PROCEDURE statement input data set SPUFI 2nd input data sets DSNTEP2 utility sequencing 2nd input/output. insensitive scrollable cursors INSERT authority restricting INSERT function INSERT statements base table views columns, listing LOAD utility, compared multiple rows set-level processing inside-out subquery access INSTALL SYSADM group-level authorization INSTALL SYSOPR group-level authorization instances. instant copies/restore disaster recovery 2nd Instant Copy and Recover 2nd Instrumentation Facility Interface. 2nd INT function INT tools 2nd integer columns 2nd INTEGER data type promotability INTEGER function integration data warehouses, populating 2nd integrity check constraints 2nd 3rd advantages semantics table-level coding triggers, comapred data FOR UPDATE OF clause stored procedures declarative referential triggers edit procedures field procedures referential data warehouses triggers 2nd 3rd referential. SQL only applications triggers validation routines integrity tools 2nd Intelligent Enterprise (ital) intelligent miner for data intelligent miner for text intelligent miner scoring inter-system communications CF interfaces attachment data sharing DL/I batch 2nd internal DBA tools stored procedures internal I/O tuning 2nd International DB2 User Group. Internet accessing bookmarks cross-posting (newsgroups) DB2 data access Java Net.Data 2nd 3rd 4th network traffic software versions DB2 functions DB2 resources mailing lists 2nd Usenet newsgroups 2nd 3rd Web 2nd 3rd 4th 5th 6th emoticons FAQs flames information sources 2nd mailing lists 2nd archives 2nd DB2 resources 2nd digesting finding 2nd newsgroups, compared privacy mailing lists, digesting newsgroup tips newsgroups cross-posting mailing lists, compared tips newsgroups vs mailing lists privacy 2nd search engines spams Usenet newsgroups 2nd DB2 resources 2nd 3rd WWW 2nd 3rd DB2 resources 2nd 3rd 4th 5th 6th Internet enabling tools Internet FAQ Consortium Web site Internet Service Providers. Intersystem Resource Lock Manager. intranets IPLIST table 2nd IPNAMES table IRLM tuning 2nd 3rd IRLM (Intersystem Resource Lock Manager) IRLM address space tuning 2nd IRLM commands 2nd 3rd IRLM parameters locks IRLMRWT value (DSNZPARMs) IRLMs sharing IS NOT DISTINCT FROM comparison operator nulls IS NULL predicate ISO week timestamp unit ISO year timestamp unit ISOBID column INDEXSPACESTATS table isolation levels BIND statements dirty reads advantages 2nd implementing 2nd requirements individual SQL statements Java SQL statements UR 2nd 3rd ISOLATION parameter data sharing locks dirty reads 2nd 3rd advantages 2nd requirements page/row locks 2nd 3rd 4th ISPF panels TSO ISPF tables TSO 2nd ISPs (Internet Service Providers) ITRACE parameter IRLM address space
|
| < Day Day Up > |