Index

A B C D E F G H I J K L M N O P Q R S T U V W X Z

accepted block cursor requests, monitor element (2201)

access plan graph node, definition (2972)

access plan graph, changing level of detail (2623)

access plan graph, changing the appearance of (2637)

access plan graph, displaying and using (2617)

access plan graph, getting more details about objects in a graph (2626)

access plan graph, list of operators used (3024)

access plan graph, printing from Command Center (2770)

access plan graph, printing from Visual Explain (2719)

access plan graph, producing (2595)

access plan graph, reading the symbols (2625)

access plan graph, viewing from Access Plan Graph window (2720)

access plan graph, viewing from Command Center (2771)

access plan graph, viewing from Explainable Statements window (2699)

access plan graph, viewing from Explained Statements History window (2707)

access plan, creating from Command Center (2758)

access plan, definition (2971)

access plan, improving (2638), (2639), (2640)

access plan, troubleshooting tip (2749)

accesses to overflowed records since connect, monitor element (2229)

acc_curs_blk element (2202)

active sorts, monitor element (2193)

active_sorts element (2194)

adsm_mgmtclass configuration parameter (2905)

adsm_nodename configuration parameter (2906)

adsm_owner configuration parameter (2907)

adsm_password configuration parameter (2908)

agent ID holding lock, monitor element (2105)

agent ID, monitor element (2253)

agent identification, monitor element (2483)

agentpri configuration parameter (2822)

agents assigned from pool, monitor element (2455)

agents created due to empty agent pool, monitor element (2457)

agents registered, monitor element (2249)

agents stolen, monitor element (2479)

agents waiting for a token, monitor element (2251)

agents waiting on locks, monitor element (2549)

agents_created_empty_pool element (2458)

agents_from_pool element (2456)

agents_locks_waiting element (2550)

agents_registered element (2250)

agents_registered_top element (2288)

agents_stolen element (2480)

agents_top element (2440)

agents_waiting_on_token element (2252)

agents_waiting_top element (2290)

agent_id element (2254)

agent_id_holding_lock element (2106)

agent_pid element (2484)

agent_stack_sz configuration parameter (2821)

agent_sys_cpu_time element (2354)

agent_usr_cpu_time element (2352)

alias, definition (2990)

aliases, altering comments (1599)

aliases, changing comments (1600)

aliases, creating (1602)

aliases, deleting (1605)

aliases, dropping (1604)

app_ctl_heap_sz database parameter (2909)

APPC, configuring (1735)

APPC, definition (2973)

APPC, properties (1736)

applheapsz configuration parameter (2910)

application agent priority, monitor element (2467)

application creator, monitor element (2167)

application ID holding lock, monitor element (2107)

application id, definition (2974)

application ID, monitor element (2263)

application idle time, monitor element (2471)

application name, definition (2975)

application name, monitor element (2261)

application priority type, monitor element (2469)

application status change time, monitor element (2259)

application status, monitor element (2255)

applications connected currently, monitor element (2065)

applications executing in the database manager currently, monitor element (2068)

applications, listing (1723)

appls_cur_cons (2066)

appls_in_db2 element (2069)

appl_con_time element (2071)

appl_id element (2264)

appl_idle_time element (2472)

appl_id_holding_lk element (2108)

appl_name element (2262)

appl_priority element (2468)

appl_priority_type element (2470)

appl_section_inserts element (2462)

appl_section_lookups element (2460)

appl_status element (2256)

aslheapsz configuration parameter (2823)

associated_agents_top element (2554)

audit buffer size configuration parameter (2881)

audit_buf_sz configuration parameter (2880)

authentication configuration parameter (2824)

authority_lvl element (2486)

authorization id, definition (2976)

authorization ID, monitor element (2267)

auth_id element (2268)

autorestart database configuration parameter (2911)

avg_appls configuration parameter (2912)

backbufsz configuration parameter (2825)

backup_pending configuration parameter (2954)

basic operators, changing color from Command Center (2765)

basic operators, changing color from Visual Explain (2714)

basic query, used in Visual Explain examples (2641)

bind options, choosing (2659)

bind options, getting information about (2636)

binds/precompiles attempted, monitor element (2243)

binds_precompiles element (2244)

bp_info element (2446)

buffer pool asynchronous data reads, monitor element (2297)

buffer pool asynchronous data writes, monitor element (2299)

buffer pool asynchronous index reads, monitor element (2431)

buffer pool asynchronous index writes, monitor element (2301)

buffer pool asynchronous read requests, monitor element (2307)

buffer pool asynchronous read time, monitor element (2303)

buffer pool asynchronous write time, monitor element (2305)

buffer pool data logical reads, monitor element (2113)

buffer pool data pages from extended storage, monitor element (2451)

buffer pool data pages to extended storage, monitor element (2447)

buffer pool data physical reads, monitor element (2115)

buffer pool data writes, monitor element (2117)

buffer pool index logical reads, monitor element (2119)

buffer pool index pages from extended storage, monitor element (2453)

buffer pool index pages to extended storage, monitor element (2449)

buffer pool index physical reads, monitor element (2121)

buffer pool index writes, monitor element (2123)

buffer pool information, monitor element (2445)

buffer pool log space cleaners triggered, monitor element (2309)

buffer pool threshold cleaners triggered, monitor element (2313)

buffer pool victim page cleaners triggered, monitor element (2311)

buffer pool, definition (2979)

buffer pools, altering characteristics of (1606)

buffer pools, altering characteristics of in a partitioned database environment (1609)

buffer pools, changing characteristics of (1607)

buffer pools, changing characteristics of in a partitioned database environment (1610)

buffer pools, creating (1612)

buffer pools, creating for a partitioned database (1614)

buffer pools, removing (1560)

buffpage configuration parameter (2913)

buff_free element (2520)

buff_free_bottom element (2524)

built-in functions, getting statistics (2630)

byte order of event data, monitor element (2369)

byte_order element (2370)

catalog cache heap full, monitor element (2429)

catalog cache inserts, monitor element (2425)

catalog cache lookups, monitor element (2423)

catalog cache overflows, monitor element (2427)

catalog network node name, monitor element (2489)

catalog node number, monitor element (2545)

catalogcache_sz configuration parameter (2914)

catalog_node element (2546)

catalog_node_name element (2490)

cat_cache_heap_full element (2430)

cat_cache_inserts element (2426)

cat_cache_lookups element (2424)

cat_cache_overflows element (2428)

CE_free element (2530)

CE_free_bottom element (2532)

character strings, finding from Visual Explain (2747)

chngpgs_thresh configuration parameter (2915)

client communication protocol, monitor element (2341)

client operating platform, monitor element (2339)

client process ID, monitor element (2337)

client product/version ID, monitor element (2271)

client_db_alias element (2274)

client_nname element (2270)

client_pid element (2338)

client_platform element (2340)

client_prdid element (2272)

client_protocol element (2342)

CMPEXP operator, definition (3025)

codepage configuration parameter (2955)

codepage_id element (2258)

codeset configuration parameter (2956)

collate_info configuration parameter (2957)

column distribution statistics, viewing from Command Center (2793)

column distribution statistics, viewing from Visual Explain (2743)

columns in SQL statements, getting statistics (2632)

command scripts, copying (2802)

command scripts, creating (2753), (2798)

command scripts, deleting (2803)

command scripts, editing (2801)

command scripts, running (2754), (2799)

command scripts, scheduling (2755), (2800)

commands, db2vexp (creating explain snapshots) (2598)

commands, db2vexp (displaying an access plan graph) (2619)

commands, EXPLAIN.DDL (2608)

commands, EXPLSNAP option on BIND (2616)

commands, LIST TABLES (2605)

commands, reorg (2665)

commands, reorgchk (2663)

commands, runstats WITH DISTRIBUTION (2695)

commands, SET CURRENT EXPLAIN SNAPSHOT (2612)

commands, VESAMPL.DDL (2602)

commit statements attempted, monitor element (2137)

committed private memory, monitor element (2415)

commit_sql_stmts element (2138)

communications, setting up (1725)

comm_bandwidth configuration parameter (2826)

comm_private_mem element (2416)

completion actions, defining for a job (2820)

component_id element (2498)

configuration NNAME of client, monitor element (2269)

configuration NNAME at monitoring (server) node, monitor element (2032)

configuration parameters, choosing (2658)

configuration parameters, definition (2981)

configuration parameters, getting information about (2635)

conn_elapse configuration parameter (2827)

connection entries currently free, monitor element (2529)

connection partition, definition (2983)

connection request completion timestamp, monitor element (2073)

connection request start timestamp, monitor element (2070)

connection status, monitor element (2539)

connections involved in deadlock, monitor element (2393)

connections, definition (2982)

connections_top element (2294)

connection_status element (2540)

connects since first database connect, monitor element (2062)

conn_complete_time element (2074)

conn_time (2406)

container, definition (2984)

containers, listing for a node (1942)

containers, modifying characteristics (1941)

contents pane toolbar (1592)

contents pane, description (1589)

contents pane, refreshing (1575)

Control Center toolbar (1593)

Control Center, opening new (1570)

Control Center, using (1547)

con_local_dbases (2061)

Coordinated Universal Time (2866)

coordinating node, monitor element (2551)

coordinator agent, monitor element (2557)

coord_agents_top element (2478)

coord_agent_pid element (2558)

coord_node element (2552)

copyprotect configuration parameter (2916)

corr_token element (2336)

cost, definition (2985)

cost, on operator details (2575)

count element (2400)

counter, data elements (2027)

country configuration parameter (2958)

country_code element (2344)

cpuspeed configuration parameter (2828)

creator element (2168)

current applications waiting on locks, monitor element (2092)

current communication heap size, monitor element (2203)

current number of tablequeue buffers overflowed, monitor element (2511)

curr_comm_heap_size element (2204)

cursor blocking, definition (2986)

cursor name, monitor element (2160)

cursor_name element (2161)

customizing the list of displayed columns (1552)

cyclical referential constraint, definition (2988)

data definition language (ddl) SQL statements, monitor element (2145)

data elements, overview (2026)

data types, length restrictions (1864)

data types, list of (1863)

data, prefetching (3056)

database alias used by application, monitor element (2273)

database authorities for new groups (1697)

database authorities for new users (2001)

database connection

applications connected currently, monitor element (2064)

applications executing in the database manager currently, monitor element (2067)

connection request completion timestamp, monitor element (2072)

database connection services directory, definition (2992)

database country code, monitor element (2343)

database disconnection time, monitor element (2377)

database files closed, monitor element (2129)

database location, monitor element (2493)

database manager type at monitored (server) node, monitor element (2036)

database manager, definition (2995)

database name (2996)

database name, monitor element (2048)

database object, definition (2997)

database partition, backing up (1629), (1679)

database partition, configuring (1677)

database partition, leaving in roll-forward pending state after restore (1659)

database partition, leaving in the roll-forward pending state after a roll-forward operation (1670)

database partition, modifying containers during restore (1655)

database partition, performing roll-forward recovery during restore (1657)

database partition, restarting (1678)

database partition, restoring (1651), (1680)

database partition, restoring selected table spaces (1653)

database partition, rolling forward (1668), (1681)

database partition, rolling forward selected table spaces (1672)

database partition, taking out of roll-forward pending state (1682)

database partitions, viewing from Visual Explain (2732)

database path, monitor element (2050)

database, adding (1616)

database, altering (1618)

database, backing up (1628)

database, backing up using a SmartGuide (1631)

database, configuring (1632)

database, configuring for performance using a SmartGuide (1647)

database, creating from backup image (1641)

database, creating from backup image, leaving in roll-forward pending state (1644)

database, creating from backup image, modifying containers (1642)

database, creating from backup image, performing roll-forward recovery (1643)

database, creating using a SmartGuide (1640)

database, definition (2989)

database, leaving in roll-forward pending state after restore (1658)

database, leaving in the roll-forward pending state after a roll-forward operation (1669)

database, modifying containers during restore (1654)

database, performing roll-forward recovery during restore (1656)

database, restoring (1650)

database, restoring backup image to new database (1662)

database, restoring backup image to new database, leaving database in roll-forward pending state (1665)

database, restoring backup image to new database, modifying containers (1663)

database, restoring backup image to new database, performing roll-forward recovery (1664)

database, restoring selected table spaces (1652)

database, restoring using a SmartGuide (1661)

database, rolling forward (1667)

database, rolling forward selected table spaces (1671)

databases, adding to the object tree (1549)

databases, authorities on (1625)

databases, connecting to (1634)

databases, dropping (1557)

databases, granting authorities to user groups (1622)

databases, granting authorities to users (1620)

databases, revoking authorities from user groups (1623)

databases, revoking authorities from users (1621)

database_consistent configuration parameter (2959)

database_level configuration parameter (2960)

DB2 commands, executing (2751)

DB2 startup preferences, specifying (1584)

DB2 tools, shutting down (1579)

db2start_time element (2042)

db2vexp command, creating explain snapshots (2597)

db2vexp command, displaying an access plan graph (2618)

db2_status (2412)

dbheap configuration parameter (2917)

db_conn_time element (2246)

db_heap_top element (2296)

db_location element (2494)

db_name element (2049)

db_path element (2051)

db_status element (2418)

DCSD, definition (2991)

ddl_sql_stmts element (2146)

deadlocks detected, monitor element (2085)

deadlocks element (2086)

default password, changing (1572)

default userid, changing (1571)

degree of parallelism, monitor element (2441)

degree_parallelism element (2442)

DELETE operator, definition (3026)

DELETE operator, description (2577)

delimited ASCII format (DEL), description (2998)

delimited identifier, definition (2999)

delimited identifiers, description (3049)

dependent table, definition (3000)

descendent table, definition (3001)

dftdbpath configuration parameter (2839)

dft_account_str configuration parameter (2829)

dft_client_adpt configuration parameter (2830)

dft_client_comm configuration parameter (2831)

dft_degree configuration parameter (2918)

dft_extent_sz configuration parameter (2919)

dft_loadrec_ses configuration parameter (2920)

dft_monswitches configuration parameter (2832)

dft_mon_bufpool configuration parameter (2836)

dft_mon_lock configuration parameter (2837)

dft_mon_sort configuration parameter (2838)

dft_mon_stmt configuration parameter (2834)

dft_mon_table configuration parameter (2835)

dft_mon_uow configuration parameter (2833)

dft_prefetch_sz configuration parameter (2921)

dft_queryopt configuration parameter (2922)

dft_sqlmathwarn configuration parameter (2923)

diaglevel configuration parameter (2840)

diagnostics log, for nodes (1749)

diagnostics, tracing DB2 information (1598)

diagpath configuration parameter (2841)

direct read requests, monitor element (2319)

direct read time, monitor element (2323)

direct reads from database, monitor element (2315)

direct write requests, monitor element (2321)

direct write time, monitor element (2325)

direct writes to database, monitor element (2317)

direct_reads element (2316)

direct_read_reqs element (2320)

direct_read_time element (2324)

direct_writes element (2318)

direct_write_reqs element (2322)

direct_write_time element (2326)

dir_cache configuration parameter (2842)

dir_obj_name configuration parameter (2902)

dir_path_name configuration parameter (2843)

dir_type configuration parameter (2844)

disconn_time element (2378)

discover configuration parameter (2845)

discover_comm configuration parameter (2846)

discover_db configuration parameter (2924)

discover_inst configuration parameter (2847)

distinct type, definition (3002)

dlchktime configuration parameter (2925)

dl_conns element (2394)

DMS table space, definition (2993)

dos_rqrioblk configuration parameter (2848)

drda correlation token, monitor element (2335)

DRDA, definition (3003)

drda_heap_sz configuration parameter (2849)

dynamic SQL statements attempted, monitor element (2133)

dynamic SQL statements, creating explain snapshots for (2610)

dynamic SQL, definition (3004)

dynamic_sql_stmts element (2134)

estore_seg_sz configuration parameter (2926)

event monitor name, monitor element (2373)

event start time, monitor element (2407)

event stop time, monitor element (2409)

event_monitor_name element (2374)

event_type element (2376)

exception tables, description (3005)

exclusive lock escalations, monitor element (2089)

execution elapsed time, monitor element (2499)

execution_id element (2334)

explain snapshot, definition (3006)

explain snapshots for dynamic SQL statements, creating (2609)

explain snapshots for static SQL statements, creating (2613)

explain snapshots, creating (2596)

explain snapshots, samples for Visual Explain (2599)

explain tables, creating (2603)

EXPLAIN.DDL file/command (2606)

explainable statement, definition (3007)

explainable statements, choosing (2622)

explainable statements, filtering (2698)

explainable statements, viewing (2700)

explained SQL statements, changing (2703)

explained SQL statements, choosing (2621)

explained SQL statements, filtering (2705)

explained SQL statements, removing (2706)

explained SQL statements, viewing (2701)

explained statement, definition (3008)

EXPLSNAP option (on BIND command) (2615)

extended operators, changing color from Command Center (2766)

extended operators, changing color from Visual Explain (2715)

failed statement operations, monitor element (2135)

failed_sql_stmts element (2136)

fcm buffers currently free, monitor element (2519)

fcm_num_anchors configuration parameter (2850)

fcm_num_buffers configuration parameter (2852)

fcm_num_connect configuration parameter (2853)

fcm_num_rqb database manager configuration parameter (2854)

FETCH operator, definition (3027)

FETCH operator, description (2578)

fetch_count element (2386)

file system, definition (3010)

files, EXPLAIN.DDL (2607)

fileserver configuration parameter (2855)

files_closed element (2130)

FILTER operator, definition (3028)

FILTER operator, description (2579)

filter, definition (3009)

filtering the list of displayed objects (1563)

finding information in a book (3081)

first database connect timestamp, monitor element (2245)

first_overflow_time element (2402)

folders, description (1590)

function statistics, viewing from Command Center (2780)

function statistics, viewing from Visual Explain (2729)

functions, getting statistics (2629)

functions, viewing from Command Center (2779)

functions, viewing from Visual Explain (2728)

gauge, data elements (2028)

GENROW function, definition (3029)

graph settings, changing (overview from Command Center) (2760)

graph settings, changing (overview using Visual Explain) (2709)

graph settings, changing from Command Center (2761)

graph settings, changing from Visual Explain (2710)

Groups, adding (1691)

groups, authorizations for (2978)

groups, changing database authorities (1684)

groups, changing index privileges (1687)

groups, changing schema privileges (1685)

groups, changing table privileges (1686)

groups, changing view privileges (1688)

groups, granting database authorities to new (1692)

groups, granting index privileges to new (1695)

groups, granting schema privileges to new (1693)

groups, granting table privileges to new (1694)

groups, granting view privileges to new (1696)

GRPBY operator, definition (3030)

GRPBY operator, description (2580)

help, getting from the Control Center (1568)

help, using DB2 (1546)

highest, data elements (2029)

host product/version ID, monitor element (2275)

host_prdid element (2276)

hover help, description (1591)

hover help, setting for administration tools (1576)

how to use the DB2 Universal Database help (1545)

HSJOIN operator, definition (3031)

HSJOIN operator, description (2581)

ID of code page used by application, monitor element (2257)

idle_agents element (2414)

index statistics, viewing from Command Center (2784)

index statistics, viewing from Visual Explain (2734)

indexes, altering comments (1702)

indexes, changing comments (1703)

indexes, clustering (2980)

indexes, CONTROL privilege (1701)

indexes, creating (1705), (2657)

indexes, deleting (1708)

indexes, dropping (1707)

indexes, getting statistics (2633)

indexes, granting privileges for groups (1712)

indexes, granting privileges for users (1710)

indexes, revoking privileges for groups (1713)

indexes, revoking privileges for users (1711)

indexes, running statistics (1924)

indexes, viewing from Command Center (2783)

indexes, viewing from Visual Explain (2733)

indexrec configuration parameter (2903)

indexsort configuration parameter (2927)

Information Center, using the (3080)

information, data elements (2030)

information, getting from the Control Center (1569)

info_type element (2366)

input database alias, monitor element (2046)

input_db_alias element (2047)

INSERT operator, definition (3032)

INSERT operator, description (2582)

instance activity, stopping (1722)

instance, adding (1714)

instance, changing (1716)

instance, configuring (1718)

instance, definition (3012)

instance, starting (1737)

instances, adding to the object tree (1550)

instances, attaching to (1636)

instances, removing (1556)

instances, stopping (1738)

integrated exchange format (IXF), description (3013)

internal automatic rebinds, monitor element (2147)

internal commits, monitor element (2149)

internal rollbacks due to deadlock, monitor element (2153)

internal rollbacks, monitor element (2151)

internal rows deleted, monitor element (2217)

internal rows inserted, monitor element (2327)

internal rows updated, monitor element (2219)

intra_parallel configuration parameter (2876)

int_auto_rebinds element (2148)

int_commits element (2150)

int_deadlock_rollbacks element (2154)

int_rollbacks element (2152)

int_rows_deleted element (2218)

int_rows_inserted element (2328)

int_rows_updated element (2220)

IPX/SPX, definition (3014)

IPX/SPX, configuring (1731)

IPX/SPX, properties (1732)

ipx_socket configuration parameter (2856)

isolation level, definition (3015)

IXAND operator, definition (3033)

IXSCAN operator, definition (3034)

IXSCAN operator, description (2583)

java_heap_sz database manager configuration parameter (2857)

jdk11_path database manager configuration parameter (2858)

jobs, deleting (2811)

jobs, disabling (2809)

jobs, enabling (2808)

jobs, rescheduling (2810)

jobs, running (2805)

jobs, scheduling recurring (2817)

jobs, scheduling single (2816)

jobs, scheduling to run twice a month (2818)

jobs, showing results of (2806)

jobs, using invalid dates when scheduling (2819)

keepdari configuration parameter (2859)

last backup timestamp, monitor element (2247)

last reset timestamp, monitor element (2044)

last_backup element (2248)

last_over_flow time (2404)

last_reset element (2045)

LIST TABLES command (2604)

lists, existing names missing (1596)

local connections executing in the database manager, monitor element (2058)

local connections, monitor element (2056)

local database directory, definition (3016)

local databases with current connects, monitor element (2060)

local_cons element (2057)

local_cons_in_exec (2059)

lock escalations, monitor element (2087)

lock mode, monitor element (2097)

lock object name, monitor element (2103)

lock object type waited on, monitor element (2101)

lock status, monitor element (2099)

lock wait start timestamp, monitor element (2111)

lock waits, monitor element (2078)

locklist configuration parameter (2928)

locks

current applications waiting on locks, monitor element (2091)

locks held, monitor element (2075)

total lock list memory in use, monitor element (2082)

total time unit of work waited on locks, monitor element (2094)

locks held, monitor element (2076)

locks_held element (2077)

locks_held_top element (2392)

locks_waiting (2093)

locktimeout configuration parameter (2929)

lock_escals element (2088)

lock_mode element (2098)

lock_object_name element (2104)

lock_object_type element (2102)

lock_status element (2100)

lock_timeouts element (2292)

lock_waits (2079)

lock_wait_start_time element (2112)

lock_wait_time element (2081)

loc_list_in_use (2084)

log being rolled forward, monitor element (2569)

log phase, monitor element (2571)

logbufsz configuration parameter (2930)

logfilsiz configuration parameter (2931)

loghead configuration parameter (2962)

logical volume, definition (3011)

logpath configuration parameter (2963)

logprimary configuration parameter (2932)

logretain configuration parameter (2933)

logs, pruning (2814)

logsecond configuration parameter (2934)

log_reads element (2330)

log_retain_status configuration parameter (2961)

log_space_used element (2233)

log_writes element (2332)

max_connretries database manager configuration parameter (2862)

max_coordagents database manager configuration parameter (2863)

max_querydegree configuration parameter (2868)

max_time_diff database manager configuration parameter (2865)

maxagents configuration parameter (2860)

maxappls configuration parameter (2935)

maxcagents configuration parameter (2861)

maxdari configuration parameter (2864)

maxfilop configuration parameter (2936)

maximum communication heap size, monitor element (2205)

maximum database heap allocated, monitor element (2295)

maximum number of agents registered, monitor element (2287)

maximum number of agents waiting, monitor element (2289)

maximum number of agents, monitor element (2439)

maximum number of associated agents, monitor element (2553)

maximum number of concurrent connections, monitor element (2293)

maximum number of coordinating agents, monitor element (2477)

maximum number of locks held, monitor element (2391)

maximum secondary log space used, monitor element (2281)

maximum total log space used, monitor element (2283)

maxlocks configuration parameter (2937)

maxtotfilop configuration parameter (2867)

max_comm_heap_size element (2206)

MA_free element (2526)

MA_free_bottom element (2528)

message anchor (2851)

message anchors currently free, monitor element (2525)

mincommit configuration parameter (2938)

minimum connection entries, monitor element (2531)

minimum fcm buffers free, monitor element (2523)

minimum message anchors, monitor element (2527)

minimum request blocks, monitor element (2535)

min_priv_mem configuration parameter (2869)

miscellaneous operators, changing color from Command Center (2768)

miscellaneous operators, changing color from Visual Explain (2717)

mon_heap_sz configuration parameter (2870)

MSJOIN operator, definition (3035)

MSJOIN operator, description (2584)

multipage_alloc configuration parameter (2964)

named pipe, configuring (1733)

named pipe, properties (1734)

names, missing from lists (1595)

names, not appearing in lists (1597)

NetBIOS, configuring (1727)

NetBIOS, definition (3017)

NetBIOS, properties (1728)

newlogpath configuration parameter (2939)

nextactive configuration parameter (2965)

NLJOIN operator, definition (3036)

NLJOIN operator, description (2585)

nname configuration parameter (2871)

node settings, changing from Command Center (2762)

node settings, changing from Visual Explain (2711)

nodegroup, altering (1740)

nodegroup, creating (1742)

nodes, diagnostics log (1748)

nodes, starting (1745)

nodes, stopping (1746)

nodes, tracing (1747)

nodetype configuration parameter (2901)

nondelimited ASCII format (ASC), description (3018)

notebook pages, Access plan (Command Center) (2759)

notebooks, Access Plan Graph Settings (2693)

notebooks, Add Group (1690)

notebooks, Add User (1994)

notebooks, Advanced Subscription Definition (1760)

notebooks, Alter Table (1822)

notebooks, Alter Trigger (1976)

notebooks, Authorities (database) (1624)

notebooks, Backup Database (1627)

notebooks, Backup Database Partition (1626)

notebooks, Backup Table Space (1943)

notebooks, Backup Table Space Partition (1944)

notebooks, Change Group (1683)

notebooks, Change User (1993)

notebooks, Command Center (2750)

notebooks, Configure Database (1633)

notebooks, Configure Instance (1719)

notebooks, Create Database from Backup (1645)

notebooks, Create Table (1854)

notebooks, Create Table SmartGuide (1866)

notebooks, Create Trigger (1980)

notebooks, Export (1872)

notebooks, Import (1894)

notebooks, Journal (2804)

notebooks, Load (1908)

notebooks, Pre-filter (1566)

notebooks, Privileges (index) (1709)

notebooks, Privileges (schema) (1816)

notebooks, Privileges (table) (1881)

notebooks, Privileges (view) (2011)

notebooks, Restore Database (1648)

notebooks, Restore Database Partition (1649)

notebooks, Restore Database to New (1666)

notebooks, Restore Table Space (1951)

notebooks, Restore Table Space Partition (1952)

notebooks, Roll-Forward Database (1673)

notebooks, Roll-Forward Database Partition (1674)

notebooks, Roll-Forward Table Space (1959)

notebooks, Roll-Forward Table Space Partition (1960)

notebooks, Subscription Timing (1774)

notebooks, Tools Settings (1585)

null indicator flags, description (3020)

null indicators, description (3019)

num_initagents database manager configuration parameter (2873)

num_poolagents database manager configuration parameter (2874)

number of agents working on a subsection, monitor element (2517)

number of agents, monitor element (2437)

number of available agents, monitor element (2463)

number of event monitor overflows, monitor element (2399)

number of idle agents, monitor element (2413)

number of lock timeouts, monitor element (2291)

number of log pages read, monitor element (2329)

number of log pages written, monitor element (2331)

number of nodes, monitor element (2537)

number of rollforward table spaces, monitor element (2573)

number of rows read from tablequeues, monitor element (2513)

number of rows written to tablequeues, monitor element (2515)

number of successful fetches, monitor element (2385)

number of table spaces, monitor element (2367)

number of tables with monitor output, monitor element (2207)

number_nodes element (2538)

numdb configuration parameter (2872)

numsegs configuration parameter (2966)

num_agents element (2438)

num_estore_segs configuration parameter (2940)

num_freqval configuration parameter (2941)

num_iocleaners configuration parameter (2942)

num_ioservers configuration parameter (2943)

num_poolagents element (2464)

num_quantiles configuration parameter (2944)

num_subagents element (2518)

num_tables element (2208)

num_tablespaces element (2368)

object tree toolbar (1594)

object tree, description (1588)

object tree, expanding and collapsing (1562)

objectname configuration parameter (2875)

objects, creating in the Control Center (1551)

objects, displaying in the Control Center (1554)

objects, finding in the contents pane (1567)

objects, list of icons (1587)

objects, selecting multiple (1689)

objects, working with in the Control Center (1574)

open local cursors with blocking, monitor element (2361)

open local cursors, monitor element (2359)

open remote cursors with blocking, monitor element (2197)

open remote cursors, monitor element (2195)

open_loc_curs element (2360)

open_loc_curs_blk element (2362)

open_rem_curs element (2196)

open_rem_curs_blk element (2198)

operand settings, changing from Command Center (2764)

operand settings, changing from Visual Explain (2713)

operand, definition (3021)

operation element (2159)

operator details, viewing from Command Center (2782)

operator details, viewing from Visual Explain (2731)

operator settings, changing from Command Center (2763)

operator settings, changing from Visual Explain (2712)

operator, definition (3022)

operators, getting details of (2634)

operators, list of (3023)

optimization parameters, viewing from Command Center (2772)

optimization parameters, viewing from Visual Explain (2721)

optimized text, viewing from Command Center (2773)

optimized text, viewing from Visual Explain (2722)

optimizer, definition (3047)

ordinary identifier, definition (3050)

ordinary identifiers, description (3048)

outbound application ID, monitor element (2277)

outbound sequence number, monitor element (2279)

outbound_appl_id element (2278)

outbound_sequence_no element (2280)

overflow_accesses (2230)

package cache inserts, monitor element (2421)

package cache lookups, monitor element (2419)

package name, monitor element (2169)

package, definition (3051)

package_name element (2170)

page fetch pairs statistics, viewing from Command Center (2786)

page fetch pairs statistics, viewing from Visual Explain (2736)

parameters, definition (3052)

parent table, definition (3053)

partitioning key, definition (3054)

pckcachesz configuration parameter (2945)

PIPE operator, definition (3037)

piped sorts accepted, monitor element (2185)

piped sorts requested, monitor element (2183)

piped_sorts_accepted element (2186)

piped_sorts_requested element (2184)

pkg_cache_inserts element (2422)

pkg_cache_lookups (2420)

pool_async_data_reads element (2298)

pool_async_data_read_reqs element (2308)

pool_async_data_writes element (2300)

pool_async_index_reads element (2432)

pool_async_index_writes element (2302)

pool_async_read_time element (2304)

pool_async_write_time element (2306)

pool_data_from_estore element (2452)

pool_data_l_reads element (2114)

pool_data_p_reads element (2116)

pool_data_to_estore element (2448)

pool_data_writes element (2118)

pool_drty_pg_steal_clns (2312)

pool_drty_pg_thrsh_clns element (2314)

pool_index_from_estore element (2454)

pool_index_l_reads element (2120)

pool_index_p_reads element (2122)

pool_index_to_estore element (2450)

pool_index_writes element (2124)

pool_lsn_gap_clns element (2310)

pool_read_time element (2126)

pool_write_time element (2128)

post threshold sorts, monitor element (2181)

post_threshold_sorts element (2182)

pre-filtering tables and indexes before display (1565)

predicate, definition (3055)

prefetch_wait_time element (2556)

previous transaction, monitor element (2389)

previous unit of work completion timestamp, monitor element (2234)

prev_stop_time element (2390)

prev_uow_stop_time element (2235)

priv_mem_thresh configuration parameter (2877)

product identification, monitor element (2497)

product name, monitor element (2495)

product_name element (2496)

properties, on operator details (2576)

protocol, definition (3057)

queries, designing (2666)

query 1 of Visual Explain examples, following along (2642)

query 1 of Visual Explain examples, running a query with no indexes and no statistics (2646), (2647)

query 2 of Visual Explain examples, collecting current statistics for tables and indexes (2648), (2649)

query 2 of Visual Explain examples, following along (2643)

query 3 of Visual Explain examples, creating indexes on columns used to join tables in a query (2650), (2651)

query 3 of Visual Explain examples, following along (2644)

query 4 of Visual Explain examples, creating additional indexes on table columns (2652), (2653)

query 4 of Visual Explain examples, following along (2645)

query cost estimate, monitor element (2465)

query optimization class, definition (3058)

query rows estimate, monitor element (2443)

query_card_estimate element (2444)

query_cost_estimate element (2466)

query_heap_sz configuration parameter (2878)

RB_free element (2534)

RB_free_bottom element (2536)

recovery history, restoring (2812)

rec_his_retentn configuration parameter (2946)

referenced column statistics, viewing from Command Center (2791)

referenced column statistics, viewing from Visual Explain (2741)

referenced columns, viewing from Command Center (2790)

referenced columns, viewing from Visual Explain (2740)

rejected block cursor requests, monitor element (2199)

rej_curs_blk element (2200)

release configuration parameter (2904)

remote connections executing in the database manager, monitor element (2054)

remote connections to database manager, monitor element (2052)

rem_cons_in element (2053)

rem_cons_in_exec (2055)

reorg command (2664)

reorganizing table data (2660)

reorganizing, definition (3059)

reorgchk command (2662)

replication source, adding a (1778)

replication source, changing a (1780)

replication source, confirming removal (1781)

replication sources, changing (1794)

replication sources, defining a join (1798)

replication sources, defining custom (1796)

replication sources, defining default (1800)

replication sources, deleting (1803)

replication sources, dropping (1804)

replication sources, quick definition (1801)

replication sources, removing (1802)

replication sources, running (1805)

replication sources, setting defaults for defining (1577)

replication subscriptions, activating (1750)

replication subscriptions, changing (1752)

replication subscriptions, cloning (1754)

replication subscriptions, creating (1757)

replication subscriptions, deactivating (1751)

replication subscriptions, deferring (1793)

replication subscriptions, defining (1756)

replication subscriptions, defining, adding run-time processing statements (1772)

replication subscriptions, defining, changing columns (1767)

replication subscriptions, defining, creating columns (1763)

replication subscriptions, defining, data blocking (1777)

replication subscriptions, defining, read-only, replica, or row replica target tables (1761)

replication subscriptions, defining, replica to source frequency (1776)

replication subscriptions, defining, setting up sources and targets (1759)

replication subscriptions, defining, showing keys (1765)

replication subscriptions, defining, source to target frequency (1775)

replication subscriptions, defining, SQL run-time statements (1770)

replication subscriptions, defining, subset of rows (1769)

replication subscriptions, defining, target columns (1762)

replication subscriptions, deleting (1789)

replication subscriptions, dropping (1790)

replication subscriptions, removing (1788)

replication subscriptions, running (1791)

replication subscriptions, setting defaults for defining (1578)

replication, overview (1783)

request blocks currently free, monitor element (2533)

reset_time element (2398)

restbufsz configuration parameter (2879)

restore_pending configuration parameter (2967)

resync_interval configuration parameter (2882)

RETURN operator, definition (3038)

rf_log_num element (2570)

rf_num_tspaces element (2574)

rf_status element (2572)

rf_timestamp element (2434)

rf_type element (2568)

RIDSCN operator, definition (3039)

RIDSCN operator, description (2586)

roll-forward pending, definition (3062)

roll-forward, definition (3061)

rollback statements attempted, monitor element (2139)

rollback_sql_stmts (2140)

rolled back application, monitor element (2475)

rolled_back_appl_id element (2476)

rollforward tablespace, monitor element (2435)

rollforward type, monitor element (2567)

rollfwd_pending configuration parameter (2968)

route_obj_name configuration parameter (2883)

row blocking, see cursor blocking (2987)

row predicates, examples, filter rows (1787)

rows deleted, monitor element (2209)

rows inserted, monitor element (2211)

rows read from table since connect, monitor element (2227)

rows selected, monitor element (2215)

rows updated, monitor element (2213)

rows written in table since connect, monitor element (2225)

rows_deleted element (2210)

rows_inserted element (2212)

rows_read element (2228)

rows_selected element (2216)

rows_updated element (2214)

rows_written element (2226)

rqrioblk configuration parameter (2884)

runstats WITH DISTRIBUTION command (2694)

runstats, using (2655)

schema, definition (3063)

schemas, ALTERIN privilege (1700)

schemas, altering comments (1807)

schemas, changing comments (1808)

schemas, CREATEIN privilege (1698)

schemas, creating (1810)

schemas, DROPIN privilege (1699)

schemas, dropping (1558)

schemas, granting privileges to user groups (1814)

schemas, granting privileges to users (1812)

schemas, privileges on (1817)

schemas, revoking privileges from user groups (1815)

schemas, revoking privileges from users (1813)

script execution, saving the results of (2757)

script options, changing (2756)

scripts, showing contents of (2807)

secondary connections, monitor element (2547)

secondary logs allocated currently, monitor element (2285)

section inserts, monitor element (2461)

section lookups, monitor element (2459)

section number, monitor element (2171)

section_number element (2172)

sec_logs_allocated element (2286)

sec_log_used_top element (2282)

select SQL statements executed, monitor element (2141)

selectivity of predicates (3064)

select_sql_stmts element (2142)

seqdetect configuration parameter (2947)

sequence number holding lock, monitor element (2109)

sequence number, monitor element (2265)

sequence_no element (2266)

sequence_no_holding_lk element (2110)

server instance name, monitor element (2034)

server operating system, monitor element (2491)

server product/version ID, monitor element (2038)

server version, monitor element (2521)

server_db2_type element (2037)

server_instance_name element (2035)

server_nname element (2033)

server_platform element (2492)

server_prdid element (2039)

server_version element (2522)

service level, monitor element (2473)

service name, definition (3065)

service_level element (2474)

SET CURRENT EXPLAIN SNAPSHOT command (2611)

setup communications (1726)

sheapthres configuration parameter (2885)

size element (2364)

size of monitor data record, monitor element (2363)

SmartGuide, Backup Database (1630)

SmartGuide, Create Database (1639)

SmartGuide, create table space (1950)

SmartGuide, Performance Configuration (1646)

SmartGuide, Restore Database (1660)

snapshots, samples for Visual Explain (2600)

softmax configuration parameter (2948)

SORT operator, definition (3040)

SORT operator, description (2587)

sort overflows, monitor element (2191)

sortheap configuration parameter (2949)

sorting the list of displayed objects (1580)

sort_heap_allocated element (2180)

sort_overflows element (2192)

specifying file options (1874)

spm_log_file_sz configuration parameter (2888)

spm_max_resync configuration parameter (2887)

spm_name configuration parameter (2886)

SQL communications area (SQLCA), monitor element (2387)

SQL expressions, examples, computed columns clause (1784)

SQL expressions, examples, WHERE clause (1785)

SQL requests since last commit, monitor element (2487)

SQL statement subsection, definition (3066)

SQL statement, dynamically explaining (from Access Plan Graph window) from Visual Explain (2718)

SQL statement, dynamically explaining (from Explain SQL Statement window) (2696)

SQL statement, dynamically explaining (from Explainable Statements window) (2697)

SQL statement, dynamically explaining (from Explained Statements History window) (2704)

SQL statement, dynamically explaining (how to) (2620)

SQL statement, dynamically explaining from Command Center (2769)

SQL statement, viewing optimized text from Command Center (2774)

SQL statement, viewing optimized text from Visual Explain (2723)

SQL statements, analyzing using Visual Explain (2593)

SQL statements, executing (2752)

SQL statements, summary of guidelines for tuning SQL statements (2654)

SQL text, viewing from Access Plan Graph window (2724)

SQL text, viewing from Command Center (2775)

SQL text, viewing from Explainable Statements window (2702)

SQL text, viewing from Explained Statements History window (2708)

sqlca element (2388)

sql_reqs_since_commit element (2488)

ss_exec_time element (2500)

ss_logon configuration parameter (2889)

ss_node_number element (2502)

ss_number element (2562)

ss_status element (2504)

ss_sys_cpu_time element (2566)

ss_usr_cpu_time element (2564)

star joins (3067)

start database manager timestamp, monitor element (2043)

start_stop_time database manager configuration parameter (2890)

start_time element (2408)

statement length, monitor element (2173)

statement node, monitor element (2559)

statement operation start timestamp, monitor element (2162)

statement operation stop timestamp, monitor element (2164)

statement operation, monitor element (2157)

statement sorts, monitor element (2177)

statement termination character, setting for Command Center (1582)

statement termination character, setting for Script Center (1583)

statement text, monitor element (2175)

statement type, monitor element (2155)

static SQL statements attempted, monitor element (2131)

static SQL statements, creating explain snapshots for (2614)

static SQL, definition (3068)

static_sql_stmts (2132)

statistics, column distribution (viewing from Command Center) (2794)

statistics, column distribution (viewing from Visual Explain<) (2744)

statistics, for tables, indexes, table functions (2627)

statistics, function (viewing from Command Center) (2781)

statistics, function (viewing from Visual Explain<) (2730)

statistics, generating using runstats (2656)

statistics, indexes (viewing from Command Center) (2785)

statistics, indexes (viewing from Visual Explain<) (2735)

statistics, page fetch pairs (viewing from Command Center) (2787)

statistics, page fetch pairs (viewing from Visual Explain<) (2737)

statistics, referenced column (viewing from Command Center) (2792)

statistics, referenced column (viewing from Visual Explain<) (2742)

statistics, table (viewing from Command Center) (2789)

statistics, table (viewing from Visual Explain<) (2739)

statistics, table function (viewing from Command Center) (2796)

statistics, table function (viewing from Visual Explain<) (2746)

statistics, table spaces (viewing from Command Center) (2778)

statistics, table spaces (viewing from Visual Explain<) (2727)

status element (2242)

status of database, monitor element (2417)

status of DB2 instance, monitor element (2411)

status_change_time element (2260)

stat_heap_sz configuration parameter (2950)

stmtheap configuration parameter (2951)

stmt_length element (2174)

stmt_node_number element (2560)

stmt_operations element (2158)

stmt_sorts element (2178)

stmt_start element (2163)

stmt_stop element (2165)

stmt_text element (2176)

stmt_type element (2156)

stmt_usr_cpu_time element (2356), (2358)

stop_time element (2166), (2410)

stored procedure, definition (3069)

subsection node number, monitor element (2501)

subsection number, monitor element (2561)

subsection status, monitor element (2503)

svcename configuration parameter (2891)

sysadm_group configuration parameter (2892)

sysctrl_group configuration parameter (2893)

sysmaint_group configuration parameter (2894)

system CPU time used by agent, monitor element (2353)

system CPU time used by statement, monitor element (2357)

system CPU time used by subsection, monitor element (2565)

system CPU time, monitor element (2381)

system database directory, definition (3071)

system, changing (1820)

system, definition (3070)

system-managed table space, definition (3072)

systems, adding (1818)

systems, adding to the object tree (1548)

systems, attaching to (1635)

systems, changing (1720)

systems, removing (1555)

system_cpu_time element (2382)

table data, reorganizing (2661)

table design, tuning (2667)

table file ID of lock, monitor element (2223)

table function statistics, viewing from Command Center (2795)

table function statistics, viewing from Visual Explain (2745)

table name, monitor element (2347)

table partition, definition (3073)

table partitions, loading data into (1934)

table schema name, monitor element (2349)

table space name, monitor element (2345)

table space partition, altering (1966)

table space partition, altering characteristics (1938)

table space partition, backing up (1946), (1967)

table space partition, changing characteristics (1939)

table space partition, definition (3075)

table space partition, leaving in the roll-forward pending state after a roll-forward operation (1964)

table space partition, modifying containers during restore (1956)

table space partition, performing roll-forward recovery during restore (1958)

table space partition, restoring (1954), (1968)

table space partition, rolling forward (1962), (1969)

table space partition, taking out of roll-forward pending state (1970)

table space statistics, viewing from Command Center (2777)

table space statistics, viewing from Visual Explain (2726)

table space, backing up (1945)

table space, definition (3074)

table space, DMS (2994)

table space, leaving in the roll-forward pending state after a roll-forward operation (1963)

table space, modifying containers during restore (1955)

table space, performing roll-forward recovery during restore (1957)

table space, restoring (1953)

table space, rolling forward (1961)

table spaces, altering characteristics (1935)

table spaces, changing characteristics (1936)

table spaces, creating (1947)

table spaces, creating (defining) using a SmartGuide (1949)

table spaces, getting statistics (2628)

table spaces, removing (1559)

table spaces, viewing from Command Center (2776)

table spaces, viewing from Visual Explain (2725)

table spaces, viewing information about (2813)

table statistics, viewing from Command Center (2788)

table statistics, viewing from Visual Explain (2738)

table type, monitor element (2221)

table, ALTER privilege (1891)

tables REFERENCES privilege (1893)

tables, altering check constraints (1843)

tables, altering column (1827)

tables, altering column lists (1831)

tables, altering foreign keys (1839)

tables, altering new columns (1830)

tables, altering partitioning key (1835)

tables, altering primary key (1833)

tables, altering properties (1823)

tables, altering, adding check constraints (1841)

tables, altering, adding columns (1825)

tables, altering, adding foreign keys (1837)

tables, basic copy, description (1852)

tables, changing check constraints (1844)

tables, changing column (1828)

tables, changing column lists (1832)

tables, changing foreign keys (1840)

tables, changing length of VARCHAR column (1829)

tables, changing partitioning key (1836)

tables, changing primary key (1834)

tables, changing properties (1824)

tables, changing, adding check constraints (1842)

tables, changing, adding columns (1826)

tables, changing, adding foreign keys (1838)

tables, column default values (1865)

tables, constraint checking, turning off (1926)

tables, constraint checking, turning on and checking (1927)

tables, constraint checking, turning on without checking (1928)

tables, constraint checking, when to set (1930)

tables, CONTROL privilege (1890)

tables, copying (basic) (1850)

tables, creating (defining) (1853)

tables, creating (defining) using a SmartGuide (1867)

tables, creating (defining), adding check constraints (1862)

tables, creating (defining), adding columns (1856)

tables, creating (defining), adding foreign keys (1861)

tables, creating (defining), adding predefined columns (1857)

tables, creating (defining), changing column lists (1858)

tables, creating (defining), defining partitioning key (1860)

tables, creating (defining), defining primary key (1859)

tables, creating (defining), defining properties (1855)

tables, creating (importing data into) (1902)

tables, creating (importing data into), retrieving large objects (1904)

tables, creating (importing data into), specifying file options (1903)

tables, creating (importing data into), specifying table space options (1906)

tables, creating (importing data into), specifying target table and columns (1905)

tables, creating views on (2007)

tables, DELETE privilege (1889)

tables, deleting (1869)

tables, dropping (1868)

tables, exporting to files (1870), (1873)

tables, exporting to files, specifying column names (1879)

tables, exporting to files, storing large objects (1877)

tables, granting privileges for groups (1884)

tables, granting privileges for users (1882)

tables, importing data into (1895)

tables, importing data into, mapping column locations (1900)

tables, importing data into, mapping column names (1901)

tables, importing data into, mapping column positions (1899)

tables, importing data into, mapping columns one to one (default) (1898)

tables, importing data into, retrieving large objects (1897)

tables, importing data into, specifying file options (1896)

tables, INDEX privilege (1892)

tables, INSERT privilege (1887)

tables, loading data into (1907)

tables, loading data into, collecting statistics (1914)

tables, loading data into, delimited ASCII format (DEL) (1911)

tables, loading data into, integrated exchange format (IXF) (1912)

tables, loading data into, nondelimited ASCII format (ASC) (1910)

tables, loading data into, restarting a load (1917)

tables, loading data into, saving changes (1915)

tables, loading data into, specifying conditions for rows (1913)

tables, loading data into, specifying location and file type (1909)

tables, loading data into, specifying other options (1916)

tables, loading data into, terminating a load (1918)

tables, locking (1846)

tables, quiescing (1845)

tables, renaming (1919)

tables, reorganizing (1921)

tables, reorganizing, description (3060)

tables, revoking privileges for groups (1885)

tables, revoking privileges for users (1883)

tables, running statistics (1923)

tables, SELECT privilege (1886)

tables, unlocking (1848)

tables, unquiescing (1847)

tables, UPDATE privilege (1888)

tables, viewing contents (1931)

tablespace_name element (2346)

table_event_time element (2384)

table_file_id element (2224)

table_name element (2348)

table_schema element (2350)

table_type element (2222)

TBSCAN operator, definition (3041)

TBSCAN operator, description (2588)

TCP/IP, definition (3076)

TCP/IP, configuring (1729)

TCP/IP, properties (1730)

TEMP operator, definition (3042)

TEMP operator, description (2589)

temporary table (3077)

territory configuration parameter (2969)

time of database connection, monitor element (2405)

time of first event overflow, monitor element (2401)

time of last event overflow, monitor element (2403)

time of log record, monitor element (2433)

time of monitor reset, monitor element (2397)

time of table event, monitor element (2383)

time of table space event, monitor element (2395)

time waited for prefetch, monitor element (2555)

time waited on locks, monitor element (2080)

time zone displacement, monitor element (2481)

timestamp, data elements (2031)

timestamp, monitor element (2040)

time_stamp element (2041)

time_zone_disp element (2482)

tm_database configuration parameter (2895)

total buffer pool physical read time, monitor element (2125)

total buffer pool physical write time, monitor element (2127)

total fcm buffers received, monitor element (2543)

total fcm buffers sent, monitor element (2541)

total lock list memory in use, monitor element (2083)

total number of tablequeue buffers overflowed, monitor element (2509)

total sort heap allocated , monitor element (2179)

total sort time, monitor element (2189)

total sorts, monitor element (2187)

total time unit of work waited on locks, monitor element (2095)

total_buffers_rcvd element (2544)

total_buffers_sent element (2542)

total_cons element (2063)

total_sec_cons element (2548)

total_sorts element (2188)

total_sort_time element (2190)

tot_log_used_top element (2284)

tpname configuration parameter (2897)

tp_mon_name configuration parameter (2896)

TQUEUE operator, definition (3043)

TQUEUE operator, description (2590)

tq_cur_send_spills element (2512)

tq_node_waited_for element (2506)

tq_rows_read element (2514)

tq_rows_written element (2516)

tq_tot_send_spills element (2510)

tq_wait_for_any element (2508)

triggers, altering comments (1977)

triggers, copying triggered action (1985)

triggers, creating (1979)

triggers, creating, specifying associated table (1982)

triggers, creating, specifying conditions for execution (1983)

triggers, creating, specifying name and schema (1981)

triggers, creating, specifying triggered action (1984)

triggers, definition (3078)

triggers, deleting (1987)

triggers, dropping (1986)

triggers, viewing definition (1978)

troubleshooting tip, catching inefficient access plans (2748)

trust_allclnts configuration parameter (2898)

trust_clntauth configuration parameter (2899)

ts_event_time element (2396)

ts_name element (2436)

type of event monitor data, monitor element (2375)

type of snapshot monitor data, monitor element (2365)

udf_mem_sz configuration parameter (2900)

uid_sql_stmts element (2144)

UNION operator, definition (3044)

UNIQUE operator, definition (3045)

UNIQUE operator, description (2592)

unit of work completion status, monitor element (2240)

Unit of Work log space used, monitor element (2231)

unit of work start timestamp, monitor element (2236)

unit of work stop timestamp, monitor element (2238)

uow_comp_status element (2241)

uow_lock_wait_time element (2096)

uow_log_space_used element (2232)

uow_start_time element (2237)

uow_stop_time element (2239)

UPDATE operator, definition (3046)

UPDATE operator, description (2591)

update operators, changing color from Command Center (2767)

update operators, changing color from Visual Explain (2716)

update/insert/delete SQL statements executed, monitor element (2143)

user authorization level, monitor element (2485)

user CPU time used by agent, monitor element (2351)

user CPU time used by statement, monitor element (2355)

user CPU time used by subsection, monitor element (2563)

user CPU time, monitor element (2379)

user ids, setting (1637)

user login ID, monitor element (2333)

user-defined functions, getting statistics (2631)

userexit configuration parameter (2952)

users, adding (1995)

users, authorizations for (2977)

users, changing database authorities (1988)

users, changing index privileges (1991)

users, changing schema privileges (1989)

users, changing table privileges (1990)

users, changing view privileges (1992)

users, granting database authorities to new (1996)

users, granting index privileges to new (1999)

users, granting schema privileges to new (1997)

users, granting table privileges to new (1998)

users, granting view privileges to new (2000)

user_cpu_time element (2380)

user_exit_status configuration parameter (2970)

util_heap_sz configuration parameter (2953)

version element (2372)

version of monitor data, monitor element (2371)

VESAMPL.DDL command (2601)

views, altering comments (2002)

views, CONTROL privilege (2019)

views, creating (2006)

views, creating, example SQL (2008)

views, DELETE privilege (2018)

views, deleting (2009)

views, description (2022)

views, dropping (2010)

views, exporting to files (1871), (1875)

views, exporting to files, specifying column names (1880)

views, exporting to files, storing large objects (1878)

views, granting privileges for groups (2014)

views, granting privileges for users (2012)

views, INSERT privilege (2016)

views, related, description (2023)

views, revoking privileges for groups (2015)

views, revoking privileges for users (2013)

views, showing related (2020)

views, specifying file options (1876)

views, UPDATE privilege (2017)

views, viewing contents (2024)

views, viewing SQL (2003)

Visual Explain, learning about (2594)

waited for node on a tablequeue, monitor element (2505)

waiting for any node to send on a tablequeue, monitor element (2507)

WHERE clauses, examples, filter rows (1786)

windows, Access Plan Graph (2671)

windows, Add Database (1617)

windows, Add Instance (1715)

windows, Add or Change DMS Container (1972)

windows, Add or Change SMS Container (1971)

windows, Add SQL (1773)

windows, Add System (1819)

windows, Alter (index) (1704)

windows, Alter Alias (1601)

windows, Alter Buffer Pool (1608), (1611)

windows, Alter Database (1619)

windows, Alter Nodegroup (1741)

windows, Alter Schema (1809)

windows, Alter Table Space (1937)

windows, Alter Table Space Partition (1940)

windows, Alter View (2004)

windows, Change Column (1768)

windows, Change Explained Statement (2673)

windows, Change Instance (1717)

windows, Change Replication Source (1795)

windows, Change Subscription (1753)

windows, Change System (1721), (1821)

windows, Clone (replication subscription) (1755)

windows, Column Distribution Statistics (2689)

windows, Confirm Stop (1739)

windows, Confirmation (1561)

windows, Connect/Attach (1638)

windows, Copy (1851)

windows, Create Alias (1603)

windows, Create Buffer Pool (1613), (1615)

windows, Create Column (1764)

windows, Create Index (1706)

windows, Create Nodegroup (1743)

windows, Create Schema (1811)

windows, Create Table Space (1948)

windows, Create View (2005)

windows, Customize columns (1553)

windows, Database Connection Partitions (1675)

windows, Database Partitions (1676)

windows, Database Partitions -- OPERATOR (2691)

windows, Database selection (1975)

windows, Define as Replication Source (1797)

windows, Define Join (1799)

windows, Define Subscription (1758), (1779)

windows, Explain SQL Statement (2668)

windows, Explainable Statements (2669)

windows, Explained Statements History (2670)

windows, File Browser (1973)

windows, Filter (1564)

windows, Filter Explainable Statements (2675)

windows, Filter Explained Statements (2676)

windows, Find (2674)

windows, Function Statistics (2682)

windows, Functions (2681)

windows, Index Statistics (2684)

windows, Indexes (2690)

windows, Legend (1586)

windows, List Applications (1724)

windows, Nodes (1744)

windows, Operator Details (2683)

windows, Optimization Parameters (2678)

windows, Page Fetch Pairs Statistics (2685)

windows, Path Browser (1974)

windows, Quiesce (1849)

windows, Referenced Column Statistics (2688)

windows, Referenced Columns (2687)

windows, Remove Confirmation (1782)

windows, Rename Table (1920)

windows, Reorganize (1922)

windows, Run Now or Save SQL (1792), (1806)

windows, Run Statistics (1925)

windows, Sample Contents (table) (1932)

windows, sample contents (view) (2025)

windows, Schedule (2815)

windows, Script Center (2797)

windows, Select Printer (2677)

windows, Set Constraints (1929)

windows, Set/Reset Default userid (1573)

windows, Show Keys (1766)

windows, show Related Views (2021)

windows, Sort (1581)

windows, SQL (1771)

windows, SQL Text (2672)

windows, Table Function Statistics (2692)

windows, Table Partitions (1933)

windows, Table Space Partitions (1965)

windows, Table Space Statistics (2680)

windows, Table Spaces (2679)

windows, Table Statistics (2686)

work sheet format (WSF), definition (3079)

x_lock_escals element (2090)

zoom slider, for magnifying access graph plans (2624)

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]