< 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] Q.RESOURCE_TABLE table 2nd QBLOCK TYPE column PLAN TABLE Plan TABLE QBLOCKNO column DSN_FUNCTION_TABLE table JOIN TYPE PLAN TABLE QMF 2nd 3rd formatted reports , creating 2nd guide panels Form Home Proc Query Report sessions QMF (Query Management Facility) QMF Command Interface. QMF enhancement tools QMF forms DBID/PSID/OBID queries SYSCOPY queries QMF Governor 2nd 3rd QMF tools QMFCI (QMF Command Interface) QMs (queue managers) QRY tools 2nd 3rd qualified names UDFs QUALIFIER parameters BIND statements qualifying rows quality data data warehouses quality assurance CASE tools support QUARTER function quarter timestamp unit queries . AQR supported 2nd average package size (EDM pools) average plan size (EDM pools) column average per table concurrent packages concurrent plans DB2 Catalog 2nd DBID/PSID/OBID QMF forms distributed query blocks controlling hierarchies limiting 2nd 3rd optimization MQTs package authorization caching parallel 2nd parallelism performance factors 2nd 3rd plan authorization caching PLAN TABLE 2nd rewriting SYSCOPY QMF forms table average per database tweaking queries (DB2 Catalog) application efficiency 2nd 3rd authorization 2nd 3rd formatted reports 2nd historical 2nd navigational 2nd 3rd 4th 5th 6th 7th navigational. partition statistics 2nd performance monitoring reports physical analysis 2nd 3rd 4th 5th 6th CASE expression index disk storage index statistics physical characteristics reorganization frequency reorganization indicators SPACE values tablespace DASD tablespace statistics programmer aid 2nd 3rd 4th readability starting points Query Management Facility. QUERY NO column PLAN TABLE query optimization MQTs 2nd query parallelism access paths 2nd 3rd 4th 5th 6th CP I/O parallel joins 2nd 3rd parallel plans restrictions 2nd sequential plans Sysplex 2nd query tools 2nd 3rd 4th 5th QUERYNO column DSN STATEMENT TABLE DSN_FUNCTION_TABLE table Quest Central Quest Software queue managers. QUIESCE utility 2nd concurrency JCL locking partition levels phases recovery points running system databases table spaces 2nd 3rd TABLESPACESET parameter WRITE option |
< Day Day Up > |