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]
OBID parameter tables OBID queries QMF forms OBIDs record translating specifying OBIDXLAT option (DSN1COPY utility) object migration tools object/relational database management system defined 2nd objects active viewing DB2 ALIAS COLUMN DATABASE defining 2nd hierarchy INDEX native data types 2nd security 2nd STOGROUP SYNONYM TABLE TABLESPACE VIEW dropping large. naming conventions non-partitioned VSAM data sets 2nd pages 2nd partitioned VSAM data sets 2nd physical program preparation 2nd restricted viewing RI- related copying sequence 2nd 3rd SEQUENCE sequence creating identity columns , compared 2nd SEQUENCE navigational queries sequence parameters performance stopped starting objects (DB2) identifiers ODBC application development 2nd 3rd 4th administration COMMIT/ROLLBACK cursors DRDA, compared embedded SQL parameter markers portability restrictions return codes sample code 2nd SQLError() function ODBC ( Open Database Connectivity) ODS 2nd ODS (Operational Data Store) OFF keyword OPTIONS control statement Offline Copy utility. offloading logs performance offloading logs OFFPOSLIMIT parameter REORG utility offsite copies SHRLEVEL REFERENCE clause OLAP 2nd OLAP (on-line analytical processing) OLAP (On-Line Analytical Processing) OLAP server old recovery information OLTP (on-line transaction processing) on-line analytical processing. On-Line Analytical Processing. on-line transaction processing. on-site library one-phase commit distribution two-phase, compared one-time processing EXECUTE IMMEDIATE statement online IMS/TM applications 2nd online applications cascading delete rule commits concurrency, increasing cursor repositioning 2nd data sorting direct row access 2nd empty tables joins limiting list prefetch, disabling modifications, saving overactive data 2nd pages retrieved sequential values timestamps transactions TSO binding design 2nd 3rd 4th 5th DSN command processor 2nd online DB2 performance monitors GUI workstations MainView overview VTAM 2nd online reorganizations 2nd disadvantages mapping tables 2nd parameters DEADLINE DELAY LONGLOG MAXRO 2nd online schema changes column data types 2nd 3rd 4th impact 2nd 3rd limitations exception states implementing indexes clustering 2nd columns, adding 2nd variable index keys 2nd pre-V8 table space partitioning 2nd 3rd 4th adding partitions 2nd boundaries rebalancing partitions 2nd rotating partitions 2nd V8 new features 2nd versioning 2nd deactivating versions new versions online utilities generating DB2I JCL generation panels 2nd 3rd 4th monitoring 2nd partition levels return codes UIDs work data sets 2nd 3rd open data sets tuning 2nd 3rd Open Database Connectivity. OPEN statement cursors opening cursors 2nd operating environments batch processing feasibility 2nd resource availability 2nd 3rd selecting operating systems explotation tuning CPUs 2nd 3rd 4th 5th I/O 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th memory 2nd memory. z/OS 2nd 3rd 4th 5th Operational Data Store. operational databases data warehouses, compared operational support 2nd operational support tools 2nd operational utilities Operational Utilities suite operators comparison UDTs comparison. UNION UNION ALL OPTHINT column PLAN TABLE OPTHINT parameter access paths optimization distributed 2nd 3rd optimization hints 2nd advantages defining 2nd implementing performance improvements OPTIMIZE FOR n ROWS clause distribution performance optimizer, influencing 2nd 3rd optimizer access path selection 2nd 3rd access path strategies indexed access 2nd 3rd 4th 5th 6th joins 2nd 3rd 4th 5th 6th 7th 8th 9th joins. query parallelism 2nd 3rd 4th 5th 6th scans 2nd 3rd sequential prefetch 2nd 3rd access path strategy compatibility 2nd access paths, selecting CPU costs DB2 Catalog statistics 2nd 3rd DB2 Family differences filter factors 2nd 3rd functionality 2nd hints 2nd 3rd I/O costs influencing 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 overview 2nd 3rd physical data independence 2nd 3rd predicate transitive closure 2nd SQL statements subqueries 2nd 3rd 4th correlated 2nd inside-out subquery access non-correlated outside-in-outside subquery access view materialization 2nd view merge transitivity 2nd optimizing BP0 options CASCADE referential constraints date and time FORCE MODE parameter NO ACTION referential constraints RESTRICT referential constraints SET NULL referential constraints OPTIONS control statement OFF keyword PREVIEW keyword ORDER BY clause columns DSNTIAUL utility GROUP BY, compared joins row sequencing rows top ten retrieval organizational issues education 2nd 3rd advanced topics external training in-house training industry periodicals 2nd 3rd 4th introductory courses mailing lists on-site library reference material environmental support operational support 2nd personnel issues political 2nd 3rd standards/procedures application development guide data administration 2nd database administration guide design review 2nd 3rd 4th migrations/turnovers naming conventions 2nd QMF guide roles/responsibilities 2nd 3rd security guide SQL performance guide system administration guide vendor tools guide organizationl issues tools required OS/390 tuning 2nd OUT parameter CREATE PROCEDURE statement outbound authid translations outer joins 2nd 3rd 4th explicit FULL OUTER JOIN left right outer joins, compared LEFT OUTER JOIN nulls 2nd predicate placement 2nd RIGHT OUTER JOIN outer tables OuterBay Technologies output data sets utilities outside-in-outside subquery acess overactive data online 2nd overhead LOBs limiting reducing traces accounting audit monitor performance statistics overloading functions OVERVIEW parameter DISPLAY command
|
| < Day Day Up > |