Index

Numerics
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

Numerics

1ST_CONN, description (4243)

accepted block cursor requests, monitor element (4078)

access plan graph node, definition (4338)

access plan graph, changing level of detail (2979)

access plan graph, changing the appearance of (2993)

access plan graph, creating (2953)

access plan graph, displaying and using (2975)

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

access plan graph, list of operators used (4353)

access plan graph, printing from Command Center (3156)

access plan graph, printing from Visual Explain (3045)

access plan graph, reading the symbols (2981)

access plan graph, viewing form the Command Center (3104)

access plan, creating from Command Center (3127)

access plan, definition (4337)

access plan, improving (2994), (2995), (3000)

access plan, troubleshooting tip (3085)

access plan, viewing form the Command Center (3197)

accesses to overflowed records, monitor element (4056)

acc_curs_blk element (4079)

active sorts, monitor element (3849)

active_sorts element (3850)

adding performance variables to a graph (2923)

adding performance variables to a monitor (2906)

adsm_mgmtclass configuration parameter (3454)

adsm_nodename configuration parameter (3456)

adsm_owner configuration parameter (3457)

adsm_password configuration parameter (3455)

ADSTAR Distributed Storage Manager (ADSM)

configuration parameters (3446)

agent ID holding lock, monitor element (4012)

agentpri configuration parameter (3413)

agents assigned from pool, monitor element (3819)

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

agents registered, monitor element (3809)

agents waiting for a token, monitor element (3811)

agents_created_empty_pool element (3822)

agents_from_pool element (3820)

agents_registered element (3810)

agents_registered_top element (3814)

agents_stolen element (3826)

agents_top element (4172)

agents_waiting_on_token element (3812)

agents_waiting_top element (3816)

agent_id element (3638)

agent_id_holding_lock element (4013)

agent_pid element (3708)

agent_stack_sz configuration parameter (3375)

agent_sys_cpu_time element (4178)

agent_usr_cpu_time element (4176)

alarm thresholds (2928)

alarms, Alert Center (2941)

alert center preferences (2944)

alert center properties (2236)

Alert Center, overview (2939)

alert center, viewing nodes (2949)

alerts, definition (4305)

alerts, suspending (2947)

alias, definition (4229)

aliases, altering comments (2302)

aliases, changing comments (2303)

aliases, creating (2305)

aliases, DB2 for OS/390 tasks for (2819)

aliases, deleting (2308)

aliases, dropping (2307)

APPC, configuring (2483)

APPC, definition (4222)

APPC, properties (2484)

applheapsz configuration parameter (3370)

application agent priority, monitor element (3677)

application creator, monitor element (4125)

application handle (agent ID), monitor element (3637)

application ID holding lock, monitor element (4014)

application id, definition (4306)

application ID, monitor element (3647)

application idle time, monitor element (3705)

application name, definition (4307)

application name, monitor element (3645)

application priority type, monitor element (3679)

application status change time, monitor element (3643)

application status, monitor element (3639)

application version, changing level (3208)

application version, creating (3204)

application version, description (4285)

application version, editing (3206)

application versions, deleting (3220)

application versions, viewing details (3221)

application with oldest transaction, monitor element (3785)

applications connected currently, monitor element (3804)

applications executing in the database currently, monitor element (3807)

applications, DB2 Connect (2864)

applications, forcing gateway (2902)

applications, forcing local (2897)

applications, listing (2479)

applications, listing gateway (2901)

applications, listing local (2895)

applications, local (2863)

appls_cur_cons (3805)

appls_in_db2 element (3808)

applying a filter to the list (3307)

appl_con_time element (3688)

appl_id element (3648)

appl_idle_time element (3706)

appl_id_holding_lk element (4015)

appl_id_oldest_xact element (3786)

appl_name element (3646)

appl_priority element (3678)

appl_priority_type element (3680)

appl_section_inserts element (3956)

appl_section_lookups element (3954)

appl_status element (3640)

app_ctl_heap_sz database parameter (3364)

aslheapsz configuration parameter (3382)

associated_agents_top element (3828)

audit_buf_sz configuration parameter (3389)

authentication configuration parameter (3577)

authentication credentials, description (4286)

authentications, creating (3222)

authentications, deleting (3224)

authentications, editing (3225)

authentications, viewing details (3227)

authority

configuration parameters (3573)

authority_lvl element (3682)

authorization id, definition (4308)

authorization ID, monitor element (3651)

auth_id element (3652)

autorestart database configuration parameter (3447)

avg_appls configuration parameter (3410)

backbufsz configuration parameter (3358)

backup_pending configuration parameter (3491)

basic operators, changing color from Command Center (3151)

basic query, used in Visual Explain examples (3005)

batch steps, changing properties (3210)

batch, description (4287)

batch, promoting to production (3217)

batch, testing for group (3216)

batches, copying (3230)

batches, creating (3232)

batches, deleting (3234)

batches, editing (3235)

batches, viewing (3237)

batches, viewing details (3239)

bind options, choosing (3019)

bind options, getting information about (2992)

binds/precompiles attempted, monitor element (4112)

binds_precompiles element (4113)

Books tab (3313)

bp_info element (3914)

buffer pool asynchronous data reads, monitor element (3893)

buffer pool asynchronous data writes, monitor element (3895)

buffer pool asynchronous index reads, monitor element (3899)

buffer pool asynchronous index writes, monitor element (3897)

buffer pool asynchronous read requests, monitor element (3905)

buffer pool asynchronous read time, monitor element (3901)

buffer pool asynchronous write time, monitor element (3903)

buffer pool data logical reads, monitor element (3875)

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

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

buffer pool data physical reads, monitor element (3877)

buffer pool data writes, monitor element (3879)

buffer pool index logical reads, monitor element (3881)

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

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

buffer pool index physical reads, monitor element (3883)

buffer pool index writes, monitor element (3885)

buffer pool information, monitor element (3913)

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

buffer pool threshold cleaners triggered, monitor element (3911)

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

buffer pool, definition (4225)

buffer pools, altering characteristics of (2311)

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

buffer pools, changing characteristics of (2312)

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

buffer pools, creating (2309)

buffer pools, creating for a partitioned database (2314)

buffer pools, DB2 for OS/390 tasks for (2821)

buffer pools, removing (2219)

buffpage configuration parameter (3353)

buff_free element (3852)

buff_free_bottom element (3854)

built-in functions, getting statistics (2986)

byte order of event data, monitor element (4213)

byte_order element (4214)

capacity management configuration parameters (3350)

catalog cache heap full, monitor element (3943)

catalog cache inserts, monitor element (3939)

catalog cache lookups, monitor element (3937)

catalog cache overflows, monitor element (3941)

catalog node network name, monitor element (3623)

catalog node number, monitor element (3627)

catalog tables, DB2 for OS/390 tasks for (2823)

catalogcache_sz configuration parameter (3355)

Cataloged Database, description (4244)

catalog_noauth configuration parameter (3578)

catalog_node element (3628)

catalog_node_name element (3624)

categories of information (3304)

cat_cache_heap_full element (3944)

cat_cache_inserts element (3940)

cat_cache_lookups element (3938)

cat_cache_overflows element (3942)

CE_free element (3860)

CE_free_bottom element (3862)

character strings, finding from Visual Explain (3039)

chngpgs_thresh configuration parameter (3398)

cleanup batch, description (4288)

client communication protocol, monitor element (3673)

client operating platform, monitor element (3671)

client process ID, monitor element (3669)

client product/version ID, monitor element (3655)

client_db_alias element (3658)

client_nname element (3654)

client_pid element (3670)

client_platform element (3672)

client_prdid element (3656)

client_protocol element (3674)

CMPEXP operator, definition (2279), (4354)

codepage configuration parameter (3473)

codepage_id element (3642)

codeset configuration parameter (3472)

collate_info configuration parameter (3474)

collections, DB2 for OS/390 tasks for (2825)

column distribution statistics, viewing from Command Center (3178)

column distribution statistics, viewing from Visual Explain (3079)

columns in SQL statements, getting statistics (2988)

command scripts, copying (3143)

command scripts, creating (3112), (3134)

command scripts, deleting (3145)

command scripts, editing (3141)

command scripts, running (3115), (3136)

command scripts, scheduling (3118), (3138)

commands, EXPLAIN.DDL (2966)

commands, EXPLSNAP option on BIND (2974)

commands, LIST TABLES (2963)

commands, reorg (3025)

commands, reorgchk (3023)

commands, runstats WITH DISTRIBUTION (3013)

commands, SET CURRENT EXPLAIN SNAPSHOT (2970)

commands, VESAMPL.DDL (2960)

commit statements attempted, monitor element (4090)

committed private memory, monitor element (3831)

commit_sql_stmts element (4091)

common tasks, DB2 for OS/390 (2817)

communication error time, monitor element (3763)

communication errors, monitor element (3761)

communications, setting up (2481)

comm_bandwidth configuration parameter (3563)

comm_private_mem element (3832)

completion actions, defining for a job (3196)

component_id element (3608)

configuration

parameter summary, database (3348)

parameter summary, database manager (3346)

configuration NNAME of client, monitor element (3653)

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

configuration parameter

ADSTAR Distributed Storage Manager (3445)

agent communication memory (3378)

agent private memory (3365)

application communication memory (3379)

application shared memory (3362)

applications and agents (3408)

communication protocol setup (3505)

communications (3504)

compiler settings (3498)

Database Application Remote Interface (DARI) (3421)

database attributes (3467)

database management (3465)

database manager instance memory (3386)

database shared memory (3351)

database status (3490)

database system monitor (3552)

DataLinks (3476)

DB2 Discovery (3520)

diagnostic information (3547)

distributed services (3513)

distributed unit of work (3458)

I/O and storage (3396)

instance administration (3572)

instance management (3546)

locks (3391)

log activity (3437)

log files (3428)

logging (3426)

parallel operations (3528)

partitioned database (3529)

recovery (3427), (3443)

stored procedure (3420)

system management (3561)

configuration parameters, choosing (3018)

configuration parameters, definition (4309)

configuration parameters, getting information about (2991)

configuration parameters; capacity management (3349)

connection entries currently free, monitor element (3859)

connection partition, definition (4226)

connection request completion timestamp, monitor element (3690)

connection request start timestamp, monitor element (3687)

connection status, monitor element (3869)

connection switches, monitor element (3789)

connections involved in deadlock, monitor element (3996)

connections, definition (4310)

connections_top element (3693)

connection_status element (3870)

connects since first database connect, monitor element (3801)

conn_complete_time element (3691)

conn_elapse configuration parameter (3532)

conn_time (3618)

container, definition (4340)

containers, listing for a node (2747)

containers, modifying characteristics (2746)

contents pane toolbar (2271)

contents pane, description (2275)

contents pane, refreshing (2241)

Control Center toolbar (2272)

Control Center, opening new (2239)

Control Center, using (2201)

con_elapsed_time element (3760)

con_local_dbases (3800)

con_response_time element (3758)

Coordinated Universal Time (3540)

coordinating node, monitor element (3685)

coordinator agent, monitor element (3829)

coord_agents_top element (3824)

coord_agent_pid element (3830)

coord_node element (3686)

copyprotect configuration parameter (3475)

corr_token element (3668)

cost, definition (4341)

cost, on operator details (3086)

count element (4059)

counter, data elements (3584)

counters, definition (4311)

country configuration parameter (3471)

country_code element (3676)

cpuspeed configuration parameter (3564)

creating, server options (2585)

creator element (4126)

current agents waiting on locks, monitor element (4005)

current number of connections for DB2 Connect, monitor element (3715)

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

cursor blocking, definition (4342)

cursor name, monitor element (4123)

cursor_name element (4124)

customized Control Center (2826)

customizing the list of displayed columns (2211)

cyclical referential constraint, definition (4227)

data definition language (DDL) SQL statements, monitor element (4098)

data element, definition (4316)

data elements, overview (3583)

Data Links access token expiry interval configuration parameter (3479)

Data Links number of copies configuration parameter (3481)

Data Links time after drop configuration parameter (3483)

Data Links token algorithm configuration parameter (3485)

Data Links token in upper case configuration parameter (3487)

data source, accessing (2428)

data source, adding to federated system (2429)

data types, length restrictions (2601), (2604), (2607), (2610), (2613)

data types, list of (2600), (2603), (2606), (2609), (2612)

data, prefetching (4266)

database

configuration parameter summary (3347)

database activation timestamp, monitor element (3615)

database alias at the gateway, monitor element (3635)

database alias used by application, monitor element (3657)

database authorities for new groups (2390)

database authorities for new users (2409)

database connection

applications connected currently, monitor element (3803)

applications executing in the database currently, monitor element (3806)

connection request completion timestamp, monitor element (3689)

database connection services directory, definition (4231)

database country code, monitor element (3675)

database deactivation timestamp, monitor element (3619)

database files closed, monitor element (3891)

database location, monitor element (3625)

database manager

configuration parameter summary (3345)

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

database manager, definition (4245)

database managment, configuration parameters (3466)

database name (4246)

database name, monitor element (3611)

database object hierarchy, definition (4314)

database object, definition (4247)

database object, performance monitor definition (4313)

database partition, backing up (2343), (2386)

database partition, configuring (2384)

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

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

database partition, modifying containers during restore (2363)

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

database partition, restarting (2385)

database partition, restoring (2359), (2387)

database partition, restoring selected table spaces (2361)

database partition, rolling forward (2374), (2388)

database partition, rolling forward selected table spaces (2378)

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

database partitions, viewing from Visual Explain (3061)

database path, monitor element (3613)

database system monitor

configuration parameters (3553)

database system monitor, definition (4315)

database, adding (2334)

database, altering (2336)

database, backing up (2342)

database, backing up using a SmartGuide (2344)

database, configuring (2345)

database, configuring for performance using a SmartGuide (2357)

database, creating from backup image (2353)

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

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

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

database, creating using a SmartGuide (2352)

database, definition (4228)

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

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

database, modifying containers during restore (2362)

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

database, restarting a database (2379)

database, restoring (2358)

database, restoring backup image to new database (2369)

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

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

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

database, restoring selected table spaces (2360)

database, restoring using a SmartGuide (2368)

database, rolling forward (2373)

database, rolling forward selected table spaces (2377)

databases, adding to the object tree (2203)

databases, authorities on (2319), (2320)

databases, connecting to (2347)

databases, DB2 for OS/390, tasks for (2828)

databases, dropping (2216)

databases, forcing local applications (2898)

databases, granting authorities to user groups (2340)

databases, granting authorities to users (2338)

databases, listing local applications (2896)

databases, revoking authorities from user groups (2341)

databases, revoking authorities from users (2339)

database_consistent configuration parameter (3492)

database_level configuration parameter (3469)

DataLinks (3477)

datalinks configuration parameter (3488)

DB users, DB2 for OS/390 tasks for (2831)

DB2 commands, executing (3109)

DB2 Connect gateway first connect initiated, monitor element (3709)

DB2 for OS/390 aliases, tasks (2818)

DB2 for OS/390 buffer pools, tasks (2820)

DB2 for OS/390 catalog tables, tasks (2822)

DB2 for OS/390 collections, tasks (2824)

DB2 for OS/390 databases, tasks (2827)

DB2 for OS/390 indexes, tasks (2834)

DB2 for OS/390 locations, tasks (2838)

DB2 for OS/390 packages, tasks (2840)

DB2 for OS/390 plans, tasks (2842)

DB2 for OS/390 schemas, tasks (2844)

DB2 for OS/390 storage groups, tasks (2846)

DB2 for OS/390 stored procedures, tasks (2848)

DB2 for OS/390 subsystems, tasks (2850)

DB2 for OS/390 synonyms, tasks (2852)

DB2 for OS/390 table spaces, tasks (2836)

DB2 for OS/390 tables, tasks (2854)

DB2 for OS/390 triggers, tasks (2856)

DB2 for OS/390 user-defined functions, tasks (2858)

DB2 for OS/390 users, tasks (2829)

DB2 for OS/390 views, tasks (2860)

DB2 for OS/390, getting started in the Control Center (2816)

DB2 startup preferences, specifying (2256)

DB2 tools, shutting down (2251)

db2start_time element (3589)

db2_status (3610)

dbheap configuration parameter (3354)

db_conn_time element (3616)

db_heap_top element (3958)

db_location element (3626)

db_name element (3612)

db_path element (3614)

db_status element (3622)

DCS application status, monitor element (3727)

DCS database name, monitor element (3631)

DCSD, definition (4230)

dcs_appl_status element (3728)

dcs_db_name element (3632)

ddl_sql_stmts element (4099)

deadlock detector, definition (4319)

deadlock, definition (4317)

deadlocked connection, definition (4318)

deadlocks detected, monitor element (3978)

deadlocks element (3979)

default password, changing (2208)

default performance monitors (4320)

default userid, changing (2207)

degree of parallelism, monitor element (4173)

degree_parallelism element (4174)

DELETE operator, definition (2280), (4355)

DELETE operator, description (3088)

deleting performance variables from a graph (2924)

delimited ASCII format (DEL), description (4232)

delimited identifier, definition (4321)

delimited identifiers, description (4262)

dependent table, definition (4248)

descendent table, definition (4249)

details, performance monitor (2916)

dftdbpath configuration parameter (3579)

dft_account_str configuration parameter (3568)

dft_client_adpt configuration parameter (3519)

dft_client_comm configuration parameter (3518)

dft_degree configuration parameter (3500)

dft_extent_sz configuration parameter (3405)

dft_loadrec_ses configuration parameter (3449)

dft_monswitches configuration parameter (3554)

dft_mon_bufpool configuration parameter (3558)

dft_mon_lock configuration parameter (3559)

dft_mon_sort configuration parameter (3560)

dft_mon_stmt configuration parameter (3556)

dft_mon_table configuration parameter (3557)

dft_mon_uow configuration parameter (3555)

dft_prefetch_sz configuration parameter (3403)

dft_queryopt configuration parameter (3501)

dft_sqlmathwarn configuration parameter (3499)

diaglevel configuration parameter (3549)

diagnostics log, for nodes (2513)

diagnostics, tracing DB2 information (2238)

diagpath configuration parameter (3550)

direct read requests, monitor element (3929)

direct read time, monitor element (3933)

direct reads from database, monitor element (3925)

direct write requests, monitor element (3931)

direct write time, monitor element (3935)

direct writes to database, monitor element (3927)

direct_reads element (3926)

direct_read_reqs element (3930)

direct_read_time element (3934)

direct_writes element (3928)

direct_write_reqs element (3932)

direct_write_time element (3936)

dir_cache configuration parameter (3388)

dir_obj_name configuration parameter (3516)

dir_path_name configuration parameter (3515)

dir_type configuration parameter (3514)

disconn_time element (3620)

discover configuration parameter (3522)

discover server instance configuration parameter (3527)

discovery mode configuration parameter (3523)

discover_comm configuration parameter (3524)

discover_db configuration parameter (3521)

discover_inst configuration parameter (3526)

distinct type, definition (4233)

distinct types, DB2 for OS/390 Version 6, tasks (2832)

Distributed Computing Environment (DCE)

configuration parameters (3512)

dlchktime configuration parameter (3393)

dl_conns element (3997)

dl_expint configuration parameter (3478)

dl_num_copies configuration parameter (3480)

dl_time_drop configuration parameter (3482)

dl_token configuration parameter (3484)

dl_upper configuration parameter (3486)

DMS table space, definition (4344)

dos_rqrioblk configuration parameter (3384)

downloading books (3315)

drda correlation token, monitor element (3667)

DRDA, definition (4234)

drda_heap_sz configuration parameter (3373)

dynamic SQL statements attempted, monitor element (4086)

dynamic SQL statements, creating explain snapshots for (2968)

dynamic SQL, definition (4346)

dynamic_sql_stmts element (4087)

elapsed statement execution time, monitor element (3777)

elapsed time spent on DB2 Connect gateway processing, monitor element (3721)

enable Data Links support configuration parameter (3489)

enable intra-partition parallelism configuration parameter (3545)

enabled satellite, description (4289)

Enforcement Policy, changing (3328)

error handling

configuration parameters (3548)

estimating space requirements for tables and indexes (2221)

estore_seg_sz configuration parameter (3406)

Event Analyzer, definition (4322)

event monitor name, monitor element (4217)

Event Monitor, definition (4323)

event start time, monitor element (4133)

event stop time, monitor element (4131)

event_monitor_name element (4218)

exception tables, description (4250)

exclusive lock escalations, monitor element (3982)

execution elapsed time, monitor element (4153)

execution_id element (3666)

explain snapshot, definition (4347)

explain snapshots for dynamic SQL statements, creating (2967)

explain snapshots for static SQL statements, creating (2971)

explain snapshots, creating (2956)

explain snapshots, samples for Visual Explain (2957)

explain tables, creating (2961)

EXPLAIN.DDL file/command (2964)

explainable SQL statements, viewing (3031)

explainable statement, definition (4348)

explainable statements, choosing (2978)

explainable statements, filtering (3029)

explained SQL statements, changing (3037)

explained SQL statements, choosing (2977)

explained SQL statements, filtering (3040)

explained SQL statements, removing (3042)

explained statement, definition (4349)

EXPLSNAP option (on BIND command) (2973)

extended operators, changing color from Command Center (3152)

failed statement operations, monitor element (4088)

failed_sql_stmts element (4089)

fcm buffers currently free, monitor element (3851)

fcm_num_anchors configuration parameter (3533)

fcm_num_buffers configuration parameter (3535)

fcm_num_connect configuration parameter (3536)

fcm_num_rqb database manager configuration parameter (3537)

federated configuration parameter (3571)

federated database system support configuration parameter (3570)

federated database system, creating (2430)

federated database system, description (4251)

federated database, description (4252)

FETCH operator, definition (2281), (4356)

FETCH operator, description (3089)

fetch_count element (4140)

file system, definition (4253)

files, EXPLAIN.DDL (2965)

fileserver configuration parameter (3509)

files_closed element (3892)

FILTER operator, definition (2282), (4357)

FILTER operator, description (3090)

filter, notebook (2263)

filtering an object (2226)

filtering the items in the list (3308)

filtering the list of displayed objects (2224)

finding an item in the list (3306)

first active log file (loghead) parameter (3436)

first_overflow_time element (4061)

fix batch, description (4290)

fix batches, assigning to satellite (3228)

fix batches, viewing which satellites are using (3240)

folders, description (2276)

forcing gateway applications (2903)

forcing local applications (2899)

function statistics, viewing from Command Center (3165)

function statistics, viewing from Visual Explain (3056)

functions, getting statistics (2985)

functions, viewing from Command Center (3164)

functions, viewing from Visual Explain (3054)

gateway applications, listing (2900)

gauge, data elements (3585)

generalized replication subscriptions, deleting all for application version (3257)

generalized replication subscriptions, viewing details (3264)

generating DDL for database objects (2229)

GENROW function, definition (2283), (4358)

graph settings, changing from Command Center (3147)

graph, edit performance monitor (2919)

graph, performance monitor details (2935)

graph, performance variables (2936)

group, copying (3241)

group, creating (3200)

group, description (4291)

groups, adding (2403)

groups, authorizations for (4224)

groups, changing database authorities (2397)

groups, changing index privileges (2400)

groups, changing schema privileges (2398)

groups, changing table privileges (2399)

groups, changing view privileges (2401)

groups, deleting (3243)

groups, deploying new (3199)

groups, editing (3244)

groups, granting database authorities to new (2404)

groups, granting index privileges to new (2407)

groups, granting schema privileges to new (2405)

groups, granting table privileges to new (2406)

groups, granting view privileges to new (2408)

groups, renaming (3246)

groups, viewing details (3248)

groups, viewing logs (3249)

GRPBY operator, definition (2284), (4359)

GRPBY operator, description (3091)

gw_comm_errors element (3762)

gw_comm_error_time element (3764)

gw_connections_top element (3712)

gw_cons_wait_client element (3720)

gw_cons_wait_host element (3718)

gw_con_time element (3710)

gw_cur_cons element (3716)

gw_db_alias element (3636)

gw_exec_time element (3722)

gw_total_cons element (3714)

hash join overflows, monitor element (4207)

hash join small overflows, monitor element (4209)

hash join threshold, monitor element (4203)

hash_join_overflows element (4208)

hash_join_small_overflows element (4210)

help, getting from the Control Center (2234)

help, how to use (2200)

highest, data elements (3586)

host coded character set ID, monitor element (3729)

host database name, monitor element (3633)

host product/version ID, monitor element (3659)

host response time, monitor element (3755)

host_ccsid element (3730)

host_db_name element (3634)

host_prdid element (3660)

host_response_time element (3756)

hover help, description (2277)

hover help, setting for administration tools (2242)

HSJOIN operator, definition (2285), (4360)

HSJOIN operator, description (3092)

I/O

configuration parameters (3397)

IBM-supplied performance variables, definition (4324)

icons, Control Center (3343)

icons, node states (4325)

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

idle_agents element (3818)

inactive_gw_agents element (3788)

inbound communication address, monitor element (3735)

inbound number of bytes received, monitor element (3737)

inbound number of bytes sent, monitor element (3743)

inbound_bytes_received element (3738)

inbound_bytes_sent element (3744)

inbound_comm_address element (3736)

index statistics, viewing from Command Center (3169)

index statistics, viewing from Visual Explain (3065)

indexes, altering comments (2433)

indexes, changing comments (2434)

indexes, clustering (4339)

indexes, CONTROL privilege (2394)

indexes, creating (2436), (3017)

indexes, creating using a SmartGuide (2438)

indexes, DB2 for OS/390, tasks for (2835)

indexes, deleting (2456)

indexes, dropping (2455)

indexes, getting statistics (2989)

indexes, granting privileges for groups (2459)

indexes, granting privileges for users (2457)

indexes, revoking privileges for groups (2460)

indexes, revoking privileges for users (2458)

indexes, running statistics (2721)

indexes, viewing from Command Center (3168)

indexes, viewing from Visual Explain (3063)

indexrec configuration parameter (3448)

indexsort configuration parameter (3401)

infopops, description (2278)

infopops, setting for administration tools (2243)

infopops, turning on (2244)

information, data elements (3587)

information, getting from the Control Center (2235)

initdari_jvm configuration parameter (3424)

input database alias, monitor element (4197)

input_db_alias element (4198)

INSERT operator, definition (2286), (4361)

INSERT operator, description (3093)

instance activity, stopping (2478)

instance, adding (2462)

instance, changing (2464)

instance, configuring (2466)

instance, definition (4255)

instance, starting (2495)

instances, adding to the object tree (2204)

instances, attaching to (2349)

instances, removing (2215)

instances, stopping (2493)

integrated exchange format (IXF), description (4235)

internal automatic rebinds, monitor element (4100)

internal commits, monitor element (4102)

internal rollbacks due to deadlock, monitor element (4106)

internal rollbacks, monitor element (4104)

internal rows deleted, monitor element (4064)

internal rows inserted, monitor element (4068)

internal rows updated, monitor element (4066)

intra_parallel configuration parameter (3544)

int_auto_rebinds element (4101)

int_commits element (4103)

int_deadlock_rollbacks element (4107)

int_rollbacks element (4105)

int_rows_deleted element (4065)

int_rows_inserted element (4069)

int_rows_updated element (4067)

IPX/SPX, configuring (2485)

IPX/SPX, definition (4236)

IPX/SPX, properties (2486)

ipx_socket configuration parameter (3511)

isolation level, definition (4256)

IXAND operator, definition (2287), (4362)

IXSCAN operator, definition (2288), (4363)

IXSCAN operator, description (3094)

java_heap_sz database manager configuration parameter (3390)

jdk11_path database manager configuration parameter (3569)

jobs, deleting (3188)

jobs, disabling (3186)

jobs, enabling (3185)

jobs, rescheduling (3187)

jobs, running (3182)

jobs, scheduling recurring (3193)

jobs, scheduling single (3192)

jobs, scheduling to run twice a month (3194)

jobs, showing results of (3183)

jobs, using invalid dates when scheduling (3195)

keepdari configuration parameter (3422)

last backup timestamp, monitor element (3629)

last reset timestamp, monitor element (4195)

last_backup element (3630)

last_over_flow time (4063)

last_reset element (4196)

legend, Control Center (3342)

level, description (4292)

levels, viewing (3302)

License Center, Changing the Number of Concurrent Users (3332)

License Center, License page (3325), (3329), (3331), (3335), (3339)

License Center, Statistics page (3341)

License Center, User page (3327), (3333), (3337)

License, adding (3324)

License, changing type policy (3330)

License, removing (3334)

License, viewing information (3338)

LIST TABLES command (2962)

lists, existing names missing (2269)

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

local connections, monitor element (3795)

local database directory, definition (4257)

local databases with current connects, monitor element (3799)

local_cons element (3796)

local_cons_in_exec (3798)

locate, notebook (2261)

Locating an object (2231)

locations, DB2 for OS/390, tasks for (2839)

lock escalations, monitor element (4018)

lock mode requested, monitor element (4020)

lock mode, monitor element (3984)

lock object name, monitor element (3990)

lock object type waited on, monitor element (3988)

lock status, monitor element (3986)

lock wait start timestamp, monitor element (4010)

lock waits, monitor element (3998)

locklist configuration parameter (3360)

locks

configuration parameter (3392)

current agents waiting on locks, monitor element (4004)

locks held, monitor element (3972)

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

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

locks held, monitor element (3973)

locks_held element (3974)

locks_held_top element (3995)

locks_waiting (4006)

locktimeout configuration parameter (3395)

lock_escalation element (4019)

lock_escals element (3981)

lock_mode element (3985)

lock_mode_requested element (4021)

lock_object_name element (3991)

lock_object_type element (3989)

lock_status element (3987)

lock_timeouts element (3993)

lock_waits (3999)

lock_wait_start_time element (4011)

lock_wait_time element (4001)

loc_list_in_use (3977)

log being rolled forward, monitor element (4032)

log phase, monitor element (4034)

logbufsz configuration parameter (3356)

logfilsiz configuration parameter (3430)

loghead configuration parameter (3435)

logical volume, definition (4254)

logpath configuration parameter (3434)

logprimary configuration parameter (3431)

logretain configuration parameter (3441)

logs

configuration parameters affecting log activity (3438)

configuration parameters affecting log files (3429)

logs, deleting (3250)

logs, pruning (3191)

logs, viewing details (3251)

logs, viewing details of log entry (3252)

logsecond configuration parameter (3432)

log_reads element (3966)

log_retain_status configuration parameter (3494)

log_space_used element (3971)

log_writes element (3968)

maxagents configuration parameter (3415)

maxappls configuration parameter (3409)

maxcagents configuration parameter (3414)

maxdari configuration parameter (3423)

maxfilop configuration parameter (3411)

maximum database heap allocated, monitor element (3957)

maximum number of agents registered, monitor element (3813)

maximum number of agents waiting, monitor element (3815)

maximum number of associated agents, monitor element (3827)

maximum number of concurrent connections, monitor element (3692), (3711)

maximum number of coordinating agents, monitor element (3823)

maximum number of locks held, monitor element (3994)

maximum package cache size, monitor element (3951)

maximum query degree of parallelism configuration parameter (3543)

maximum secondary log space used, monitor element (3959)

maximum total log space used, monitor element (3961)

maxlocks configuration parameter (3394)

maxtotfilop configuration parameter (3412)

max_connretries database manager configuration parameter (3538)

max_coordagents database manager configuration parameter (3416)

max_querydegree configuration parameter (3542)

max_time_diff database manager configuration parameter (3539)

MA_free element (3856)

MA_free_bottom element (3858)

memory

agent communication memory (3380)

agent private memory (3366)

application communication memory (3381)

application shared memory (3363)

database manager instance (3385)

database shared memory (3352)

message anchor (3534)

message anchors currently free, monitor element (3855)

mincommit configuration parameter (3439)

minimum connection entries, monitor element (3861)

minimum fcm buffers free, monitor element (3853)

minimum message anchors, monitor element (3857)

minimum request blocks, monitor element (3865)

min_priv_mem configuration parameter (3376)

miscellaneous operators, changing color from Command Center (3154)

mon_heap_sz configuration parameter (3387)

most recent connection elapsed time, monitor element (3759)

most recent response time for connect, monitor element (3757)

most recent statement elapsed time, monitor element (3765)

most recent unit of work elapsed time, monitor element (3775)

MSJOIN operator, definition (2289), (4364)

MSJOIN operator, description (3095)

multipage_alloc configuration parameter (3497)

multiple databases, testing and configuring (2259)

multisite update, configuring using a SmartGuide (2468)

multisite update, testing (2470)

named pipe, configuring (2487)

named pipe, properties (2488)

names, missing from lists (2268)

names, not appearing in lists (2270)

NetBIOS, configuring (2489)

NetBIOS, definition (4237)

NetBIOS, properties (2490)

new data source, accessing (2427)

newlogpath configuration parameter (3433)

nicknames, changing options (2500)

nicknames, creating (2426), (2496), (2499), (2501)

nicknames, description (4258)

nicknames, options (2498)

NLJOIN operator, definition (2290), (4365)

NLJOIN operator, description (3096)

nname configuration parameter (3506)

node number, monitor element (3683)

node settings, changing from Command Center (3148)

node states (4326)

node, viewing in the alert center (2948)

nodegroup, altering (2504)

nodegroup, creating (2506)

nodes, diagnostics log (2512)

nodes, invoking actions when status changes (2237)

nodes, starting (2509)

nodes, stopping (2510)

nodes, tracing (2511)

nodetype configuration parameter (3567)

node_number element (3684)

nondelimited ASCII format (ASC), description (4238)

notebooks, Access Plan Graph Settings (2950)

notebooks, Add Group (2396)

notebooks, Add User (2411)

notebooks, Advanced Subscription Definition (2518)

notebooks, Alter Table (2631)

notebooks, Alter Trigger (2769)

notebooks, Applications (2862)

notebooks, Authorities (database) (2321)

notebooks, Backup Database (2323)

notebooks, Backup Database Partition (2322)

notebooks, Backup Table Space (2733)

notebooks, Backup Table Space Partition (2734)

notebooks, Change Batch Steps (3211)

notebooks, Change Group (2395)

notebooks, Change Level (3209)

notebooks, Change Monitor (2874)

notebooks, Change Monitor notebook (2865)

notebooks, Change Replication Parameters (3256)

notebooks, Change User (2410)

notebooks, Command Center (3105), (3111), (3113), (3116), (3119) , (3122), (3125), (3128)

notebooks, Command Center Options (3123), (3129)

notebooks, Configure Database (2346)

notebooks, Configure Instance (2467)

notebooks, Create Database from Backup (2326)

notebooks, Create Monitor (2878)

notebooks, Create Monitor notebook (2866)

notebooks, Create Satellite (3203)

notebooks, Create Table (2665)

notebooks, Create Table SmartGuide (2632)

notebooks, Create Trigger (2778)

notebooks, Edit Batch (3236)

notebooks, Edit Satellite (3273)

notebooks, Export (2679)

notebooks, Filter (2227)

notebooks, Import (2634)

notebooks, Journal (3107)

notebooks, License Center (3323)

notebooks, Load (2705)

notebooks, Locate (2232)

notebooks, Privileges (index) (2431)

notebooks, Privileges (schema) (2574)

notebooks, Privileges (table) (2633)

notebooks, Privileges (view) (2795)

notebooks, Restore Database (2328)

notebooks, Restore Database Partition (2329)

notebooks, Restore Database to New (2331)

notebooks, Restore Table Space (2735)

notebooks, Restore Table Space Partition (2736)

notebooks, Roll-Forward Database (2332)

notebooks, Roll-Forward Database Partition (2333)

notebooks, Roll-Forward Table Space (2737)

notebooks, Roll-Forward Table Space Partition (2738)

notebooks, Show Monitor (2880)

notebooks, Show Monitor notebook (2868)

notebooks, Show Related (2250)

notebooks, Subscription Timing (2519)

notebooks, Tools Settings (2260)

notebooks, View Batch (3238)

notebooks, View Level (3303)

notifylevel configuration parameter (3551)

null indicator flags, description (4260)

null indicators, description (4259)

number of agents created, monitor element (4171)

number of agents working on a statement, monitor element (4169)

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

number of connections waiting for the client to send request, monitor element (3719)

number of connections waiting for the host to reply, monitor element (3717)

number of database backups configuration parameter (3451)

number of event monitor overflows, monitor element (4058)

number of idle agents, monitor element (3817)

number of lock escalations, monitor element (3980)

number of lock timeouts, monitor element (3992)

number of log pages read, monitor element (3965)

number of log pages written, monitor element (3967)

number of nodes in partition, monitor element (3779)

number of nodes, monitor element (3867)

number of open cursors, monitor element (3725)

number of rollforward table spaces, monitor element (4036)

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

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

number of SQL statements attempted, monitor element (3723)

number of successful fetches, monitor element (4139)

number_nodes element (3868)

numdb configuration parameter (3565)

numsegs configuration parameter (3404)

num_agents element (4170)

num_compilation element (3770)

num_db_backups configuration parameter (3450)

num_estore_segs configuration parameter (3407)

num_executions element (3768)

num_freqval configuration parameter (3502)

num_gw_conn_switches element (3790)

num_initagents database manager configuration parameter (3418)

num_initdaris configuration parameter (3425)

num_iocleaners configuration parameter (3399)

num_ioservers configuration parameter (3400)

num_nodes_in_db2_instance element (3780)

num_poolagents database manager configuration parameter (3417)

num_quantiles configuration parameter (3503)

num_subagents element (4156)

object tree toolbar (2273)

object tree, description (2274)

object tree, expanding and collapsing (2223)

objectname configuration parameter (3510)

objects, creating in the Control Center (2210)

objects, displaying in the Control Center (2213)

objects, finding in the contents pane (2228)

objects, list of icons (3344)

objects, selecting multiple (2402)

objects, working with in the Control Center (2240)

obsolete batch, description (4293)

open local cursors with blocking, monitor element (4082)

open local cursors, monitor element (4080)

open remote cursors with blocking, monitor element (4074)

open remote cursors, monitor element (4072)

open_cursors element (3726)

open_loc_curs element (4081)

open_loc_curs_blk element (4083)

open_rem_curs element (4073)

open_rem_curs_blk element (4075)

operand settings, changing from Command Center (3150)

operand, definition (4350)

operation element (4118)

operator details, viewing from Command Center (3167)

operator details, viewing from Visual Explain (3059)

operator settings, changing from Command Center (3149)

operator, definition (4351)

operators, getting details of (2990)

operators, list of (4352)

optimization algorithm parameters, setting for Index SmartGuide (2449)

optimization parameters, viewing from Command Center (3157)

optimization parameters, viewing from Visual Explain (3047)

optimized text, viewing from Command Center (3158)

optimizer, definition (4376)

ordinary identifier, definition (4328)

ordinary identifiers, description (4261)

outbound application ID, monitor element (3661)

outbound communication address, monitor element (3733)

outbound communication protocol, monitor element (3731)

outbound number of bytes received, monitor element (3741)

outbound number of bytes sent, monitor element (3739)

outbound sequence number, monitor element (3663)

outbound_appl_id element (3662)

outbound_bytes_received element (3742)

outbound_bytes_sent element (3740)

outbound_comm_address element (3734)

outbound_comm_protocol element (3732)

outbound_sequence_no element (3664)

overflow, definition (4327)

overflow_accesses (4057)

package cache inserts, monitor element (3947)

package cache lookups, monitor element (3945)

package cache overflows, monitor element (3949)

package name, monitor element (4119)

package, definition (4377)

packages, DB2 for OS/390, tasks for (2841)

package_name element (4120)

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

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

page reorganizations, monitor element (4211)

page_reorgs element (4212)

parallel operations

configuration parameters (3531)

parameterized script, description (4294)

parameters, definition (4263)

parent table, definition (4264)

partitioned database

configuration parameters (3530)

partitioning key, definition (4265)

pckcachesz configuration parameter (3361)

performance monitor, adding performance variables (2905), (2922)

Performance Monitor, changing a monitor (2873)

Performance Monitor, changing the default monitor (2871)

Performance Monitor, copying a monitor (2875)

Performance Monitor, creating a monitor (2877)

Performance Monitor, definition (4329)

performance monitor, details graph (2933)

performance monitor, editing graph (2918)

Performance Monitor, introduction (2870)

Performance Monitor, listing monitored objects (2893)

Performance Monitor, making changes to an active monitor (2879)

Performance Monitor, Monitoring Performance (2869)

Performance Monitor, removing monitors (2881)

performance monitor, removing performance variables (2909)

Performance Monitor, renaming a monitor (2883)

Performance Monitor, saving a monitor (2885)

Performance Monitor, starting a monitor (2887)

Performance Monitor, stopping monitors (2889)

performance monitor, summaries (2937)

performance monitor, thresholds (2925)

Performance Monitor, viewing a list of monitors (2891)

performance monitor, viewing details collected (2914)

performance monitor, viewing performance variables (2912)

performance snapshot, definition (4332)

performance variable thresholds (2926)

performance variable, definition (4330)

performance variables, accessing the IBM-supplied (4221)

performance variables, adding to a monitor (2904)

performance variables, adding to graph (2920)

performance variables, categories of (4331)

performance variables, deleting from graph (2921)

performance variables, details graph (2934)

performance variables, exceeding thresholds (2943)

performance variables, graphing (2917)

performance variables, introduction (4220)

performance variables, reference information (4219)

performance variables, removing from a monitor (2908)

performance variables, viewing collected (2913)

performance variables, viewing for a monitor (2911)

PIPE operator, definition (2291), (4366)

piped sorts accepted, monitor element (3841)

piped sorts requested, monitor element (3839)

piped_sorts_accepted element (3842)

piped_sorts_requested element (3840)

pkg_cache_inserts element (3948)

pkg_cache_lookups (3946)

pkg_cache_num_overflow element (3950)

pkg_cache_size_top element (3952)

plans, DB2 for OS/390, tasks for (2843)

pool_async_data_reads element (3894)

pool_async_data_read_reqs element (3906)

pool_async_data_writes element (3896)

pool_async_index_reads element (3900)

pool_async_index_writes element (3898)

pool_async_read_time element (3902)

pool_async_write_time element (3904)

pool_data_from_estore element (3922)

pool_data_l_reads element (3876)

pool_data_p_reads element (3878)

pool_data_to_estore element (3918)

pool_data_writes element (3880)

pool_drty_pg_steal_clns (3910)

pool_drty_pg_thrsh_clns element (3912)

pool_index_from_estore element (3924)

pool_index_l_reads element (3882)

pool_index_p_reads element (3884)

pool_index_to_estore element (3920)

pool_index_writes element (3886)

pool_lsn_gap_clns element (3908)

pool_read_time element (3888)

pool_write_time element (3890)

post threshold sorts, monitor element (3837)

post_threshold_hash_joins element (4204)

post_threshold_sorts element (3838)

predicate, definition (4378)

prefetch_wait_time element (3916)

prep_time_best element (3774)

prep_time_worst element (3772)

previous transaction stop time, monitor element (3703)

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

prev_stop_time element (3704)

prev_uow_stop_time element (3695)

printing books (3314)

priv_mem_thresh configuration parameter (3377)

process or thread id, monitor element (3707)

product identification, monitor element (3607)

product name, monitor element (3605)

production batch, description (4295)

production satellite, description (4296)

production satellite, staging a rollout (3218)

product_name element (3606)

properties, on operator details (3087)

protocol, definition (4239)

queries, designing (3026)

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

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

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

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

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

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

query 4 of Visual Explain examples, creating additional indexes on table columns (2999), (3004)

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

query cost estimate, monitor element (4145)

query number of rows estimate, monitor element (4143)

query optimization class, definition (4379)

query_card_estimate element (4144)

query_cost_estimate element (4146)

query_heap_sz configuration parameter (3372)

RB_free element (3864)

RB_free_bottom element (3866)

recovery

configuration parameters (3444)

recovery history retention period (rec_his_retentn) configuration parameter (3453)

recovery history, restoring (3189)

rec_his_retentn configuration parameter (3452)

Reference tab (3312)

referenced column statistics, viewing from Command Center (3176)

referenced column statistics, viewing from Visual Explain (3076)

referenced columns, viewing from Command Center (3175)

referenced columns, viewing from Visual Explain (3074)

Registered User, adding (3326)

rejected block cursor requests, monitor element (4076)

rej_curs_blk element (4077)

release configuration parameter (3468)

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

remote connections to database manager, monitor element (3791)

removing performance variables from a monitor (2910)

rem_cons_in element (3792)

rem_cons_in_exec (3794)

reorg command (3024)

reorganizing table data (3020)

reorganizing, definition (4267)

reorgchk command (3022)

replication parameters, changing (3255)

replication source, adding a (2547)

replication source, changing a (2549)

replication source, confirming removal (2550)

replication sources, changing (2559)

replication sources, defining a join (2563)

replication sources, defining custom (2561)

replication sources, defining default (2565)

replication sources, deleting (2568)

replication sources, dropping (2569)

replication sources, promoting (3260)

replication sources, quick definition (2566)

replication sources, removing (2567)

replication sources, running (2570)

replication sources, setting defaults for defining (2245)

replication subscriptions, activating (2521)

replication subscriptions, changing (2523)

replication subscriptions, cloning (2525)

replication subscriptions, creating (2528)

replication subscriptions, deactivating (2522)

replication subscriptions, deferring (2558)

replication subscriptions, defining (2527)

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

replication subscriptions, defining, changing columns (2537)

replication subscriptions, defining, creating columns (2533)

replication subscriptions, defining, data blocking (2546)

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

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

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

replication subscriptions, defining, showing keys (2535)

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

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

replication subscriptions, defining, subset of rows (2539)

replication subscriptions, defining, target columns (2532)

replication subscriptions, deleting (2553)

replication subscriptions, dropping (2554)

replication subscriptions, generalizing (3258)

replication subscriptions, promoting (3262)

replication subscriptions, removing (2552)

replication subscriptions, running (2555)

replication subscriptions, setting defaults for defining (2246)

replication, overview (2520)

request blocks currently free, monitor element (3863)

resetting counters (4312)

restbufsz configuration parameter (3359)

restore_pending configuration parameter (3496)

resync_interval configuration parameter (3460)

RETURN operator, definition (2292), (4367)

rf_log_num element (4033)

rf_num_tspaces element (4037)

rf_status element (4035)

rf_timestamp element (4027)

rf_type element (4031)

RIDSCN operator, definition (2293), (4368)

RIDSCN operator, description (3097)

roll-forward pending, definition (4270)

roll-forward, definition (4269)

rollback statements attempted, monitor element (4092)

rollback_sql_stmts (4093)

rolled back application, monitor element (4024)

rolled back sequence number, monitor element (4022)

rolled_back_appl_id element (4025)

rolled_back_sequence_no element (4023)

rollforward timestamp, monitor element (4026)

rollforward type, monitor element (4030)

rollfwd_pending configuration parameter (3493)

route_obj_name configuration parameter (3517)

row blocking, see cursor blocking (4343)

row predicates, examples, filter rows (2515)

rows deleted, monitor element (4044)

rows inserted, monitor element (4046)

rows read, monitor element (4054)

rows selected, monitor element (4050)

rows updated, monitor element (4048)

rows written, monitor element (4052)

rows_deleted element (4045)

rows_inserted element (4047)

rows_read element (4055)

rows_selected element (4051)

rows_updated element (4049)

rows_written element (4053)

rqrioblk configuration parameter (3383)

runstats WITH DISTRIBUTION command (3012)

runstats, using (3015)

Sample Programs tab (3317)

samples, performance monitor (2915)

Satellite Administration Center, using (3198)

satellite control server, description (4298)

satellite, creating (3202)

satellite, description (4297)

satellite, fixing (3219)

satellites, configuring as production satellite (3265)

satellites, configuring as test satellite (3266)

satellites, copying (3267)

satellites, deleting (3269)

satellites, disabling (3270)

satellites, disabling all in a group (3271)

satellites, editing (3272)

satellites, enabling (3274)

satellites, enabling all in a group (3275)

satellites, promoting (3276)

satellites, setting execution starting point (3278)

satellites, viewing details (3280)

schema, definition (4271)

schemas, ALTERIN privilege (2393)

schemas, altering comments (2575)

schemas, changing comments (2576)

schemas, CREATEIN privilege (2391)

schemas, creating (2578)

schemas, DB2 for OS/390, tasks for (2845)

schemas, DROPIN privilege (2392)

schemas, dropping (2217)

schemas, granting privileges to user groups (2582)

schemas, granting privileges to users (2580)

schemas, privileges on (2572), (2573)

schemas, revoking privileges from user groups (2583)

schemas, revoking privileges from users (2581)

script execution, saving the results of (3124)

script for a threshold (2930)

script options, changing (3121)

script, adding to batch (3214)

script, importing to a batch (3212)

scripts, copying (3281)

scripts, deleting (3282)

scripts, editing (3283)

scripts, renaming (3285)

scripts, selecting (3287)

scripts, showing contents of (3184)

scripts, viewing details (3289)

search discovery communications protocols configuration parameter (3525)

searching for text within the list (3305)

secondary connections, monitor element (3833)

secondary logs allocated currently, monitor element (3963)

section inserts, monitor element (3955)

section lookups, monitor element (3953)

section number, monitor element (4121)

section_number element (4122)

sec_logs_allocated element (3964)

sec_log_used_top element (3960)

select a script for a threshold (2932)

select SQL statements executed, monitor element (4094)

selecting, server options (2586)

selectivity of predicates (4380)

select_sql_stmts element (4095)

seqdetect configuration parameter (3402)

sequence number holding lock, monitor element (4016)

sequence number, monitor element (3649)

sequence_no element (3650)

sequence_no_holding_lk element (4017)

server (in a federated system), description (4272)

server instance name, monitor element (3593)

server operating system, monitor element (3603)

server product/version ID, monitor element (3597)

server version, monitor element (3599)

servers, adding options (2589)

servers, altering server options (2591)

servers, creating (2424), (2584), (2587)

servers, dropping an option (2593)

server_db2_type element (3596)

server_instance_name element (3594)

server_nname element (3592)

server_platform element (3604)

server_prdid element (3598)

server_version element (3600)

service level, monitor element (3601)

service name, definition (4273)

service_level element (3602)

SET CURRENT EXPLAIN SNAPSHOT command (2969)

setup batch, description (4300)

setup communications (2482)

sheapthres configuration parameter (3368)

show related, objects (2262)

showing all the items in the list (3309)

showing command or showing SQL (2247)

SmartGuide, Backup Database (2324)

SmartGuide, Configure Multisite Update (2461)

SmartGuide, Create Database (2325)

SmartGuide, Create Table Space (2739)

SmartGuide, Index (2432)

SmartGuide, Performance Configuration (2327)

SmartGuide, Restore Database (2330)

snapshot time, monitor element (4199)

snapshots, samples for Visual Explain (2958)

softmax configuration parameter (3440)

SORT operator, definition (2294), (4369)

SORT operator, description (3098)

sort overflows, monitor element (3847)

sortheap configuration parameter (3367)

sorting the list of displayed objects (2252)

sort_heap_allocated element (3836)

sort_overflows element (3848)

specifying file options (2681)

spm_log_file_sz configuration parameter (3463)

spm_log_path configuration parameter (3461)

spm_max_resync configuration parameter (3464)

spm_name configuration parameter (3462)

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

SQL dynamic statement text, monitor element (4135)

SQL expressions, examples, computed columns clause (2516)

SQL expressions, examples, WHERE clause (2517)

SQL requests since last commit, monitor element (4108)

SQL statement subsection, definition (4334)

SQL statement, dynamically explaining (3011)

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

SQL statement, dynamically explaining from Command Center (3155)

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

SQL statement, viewing text (3033)

SQL statements in Index SmartGuide workload, viewing (2453)

SQL statements, adding to Index SmartGuide workload (2443)

SQL statements, analyzing using Visual Explain (2951)

SQL statements, changing on Index SmartGuide workload (2445)

SQL statements, executing (3110)

SQL statements, importing (2447)

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

SQL text, viewing from Command Center (3160)

SQL text, viewing from Visual Explain (3034)

sqlca element (4142)

sql_reqs_since_commit element (4109)

sql_stmts element (3724)

ss_exec_time element (4154)

ss_logon configuration parameter (3580)

ss_node_number element (4150)

ss_number element (4148)

ss_status element (4152)

ss_sys_cpu_time element (4190)

ss_usr_cpu_time element (4188)

star joins (4381)

start database manager timestamp, monitor element (3590)

start_stop_time database manager configuration parameter (3541)

start_time element (4134)

statement best preparation time, monitor element (3773)

statement compilations, monitor element (3769)

statement executions, monitor element (3767)

statement node, monitor element (4110)

statement operation start timestamp, monitor element (4127)

statement operation stop timestamp, monitor element (4129)

statement operation, monitor element (4116)

statement sorts, monitor element (4137)

statement termination character, setting for Command Center (2254)

statement termination character, setting for Script Center (2255)

statement type, monitor element (4114)

statement worst preparation time, monitor element (3771)

statement, definition (4335)

static SQL statements attempted, monitor element (4084)

static SQL statements, creating explain snapshots for (2972)

static SQL, definition (4382)

static_sql_stmts (4085)

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

statistics, column distribution (viewing from Visual Explain) (3080)

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

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

statistics, function (viewing from Visual Explain) (3057)

statistics, generating using runstats (3016)

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

statistics, indexes (viewing from Visual Explain) (3066)

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

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

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

statistics, referenced column (viewing from Visual Explain) (3077)

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

statistics, table (viewing from Visual Explain) (3072)

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

statistics, table function (viewing from Visual Explain) (3083)

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

statistics, table spaces (viewing from Visual Explain) (3052)

Statistics, viewing (3340)

status element (3702)

status of database, monitor element (3621)

status of DB2 instance, monitor element (3609)

status_change_time element (3644)

stat_heap_sz configuration parameter (3371)

stmtheap configuration parameter (3369)

stmt_elapsed_time element (3766)

stmt_node_number element (4111)

stmt_operations element (4117)

stmt_sorts element (4138)

stmt_start element (4128)

stmt_stop element (4130)

stmt_sys_cpu_time element (4182)

stmt_text element (4136)

stmt_type element (4115)

stmt_usr_cpu_time element (4180)

stolen agents, monitor element (3825)

stop performance monitoring, from alert center (2945)

stop_time element (4132)

storage groups, DB2 for OS/390, tasks for (2847)

stored procedure, definition (4240)

stored procedures

configuration parameters (3419)

stored procedures, DB2 for OS/390, tasks for (2849)

subscription definitions, changing (3253)

subsection node number, monitor element (4149)

subsection number, monitor element (4147)

subsection status, monitor element (4151)

subsystems, DB2 for OS/390, tasks for (2851)

success code sets, creating (3290)

success code sets, deleting (3292)

success code sets, editing (3293)

success code sets, viewing details (3295)

summary information, performance monitor (2938)

suspending alerts (2946)

svcename configuration parameter (3507)

switches, for the monitor (4333)

synchronization, description (4299)

synonyms, DB2 for OS/390, tasks for (2853)

sysadm_group configuration parameter (3574)

sysctrl_group configuration parameter (3575)

sysmaint_group configuration parameter (3576)

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

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

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

system CPU time, monitor element (4185)

system database directory, definition (4275)

system management

configuration parameters (3562)

system, changing (2597)

system, definition (4274)

system-managed table space, definition (4383)

systems, adding (2595)

systems, adding to the object tree (2202)

systems, attaching to (2348)

systems, changing (2476)

systems, DB2 for OS/390, adding to the object tree (2206)

systems, DB2 UDB for OS/390, adding to the object tree (2205)

systems, removing (2214)

system_cpu_time element (4186)

table data, reorganizing (3021)

table design, tuning (3027)

table file ID, monitor element (4070)

table function statistics, viewing from Command Center (3180)

table function statistics, viewing from Visual Explain (3082)

table name, monitor element (4040)

table partition, definition (4276)

table partitions, loading data into (2732)

table schema name, monitor element (4042)

table space name, monitor element (4002)

table space partition, altering (2764)

table space partition, altering characteristics (2743)

table space partition, backing up (2749), (2765)

table space partition, changing characteristics (2744)

table space partition, definition (4277)

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

table space partition, modifying containers during restore (2756)

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

table space partition, restoring (2754), (2766)

table space partition, rolling forward (2760), (2767)

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

table space statistics, viewing from Command Center (3162)

table space statistics, viewing from Visual Explain (3051)

table space, backing up (2748)

table space, definition (4384)

table space, DMS (4345)

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

table space, modifying containers during restore (2755)

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

table space, restoring (2753)

table space, rolling forward (2759)

table spaces, altering characteristics (2740)

table spaces, changing characteristics (2741)

table spaces, creating (2750)

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

table spaces, DB2 for OS/390, tasks for (2837)

table spaces, getting statistics (2984)

table spaces, removing (2218)

table spaces, viewing from Command Center (3161)

table spaces, viewing from Visual Explain (3049)

table spaces, viewing information about (3190)

table statistics, viewing from Command Center (3173)

table statistics, viewing from Visual Explain (3071)

table type, monitor element (4038)

table, ALTER privilege (2620), (2628)

tables REFERENCES privilege (2622), (2630)

tables, altering check constraints (2655)

tables, altering column (2639)

tables, altering column lists (2643)

tables, altering foreign keys (2651)

tables, altering new columns (2642)

tables, altering partitioning key (2647)

tables, altering primary key (2645)

tables, altering properties (2635)

tables, altering, adding check constraints (2653)

tables, altering, adding columns (2637)

tables, altering, adding foreign keys (2649)

tables, basic copy, description (2729)

tables, changing check constraints (2656)

tables, changing column (2640)

tables, changing column lists (2644)

tables, changing foreign keys (2652)

tables, changing length of VARCHAR column (2641)

tables, changing partitioning key (2648)

tables, changing primary key (2646)

tables, changing properties (2636)

tables, changing, adding check constraints (2654)

tables, changing, adding columns (2638)

tables, changing, adding foreign keys (2650)

tables, column default values (2602), (2605), (2608), (2611), (2614)

tables, constraint checking, turning off (2723)

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

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

tables, constraint checking, when to set (2728)

tables, CONTROL privilege (2619), (2627)

tables, copying (basic) (2662)

tables, creating (defining) (2664)

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

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

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

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

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

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

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

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

tables, creating (defining), defining properties (2666)

tables, creating (importing data into) (2699)

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

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

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

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

tables, creating views on (2801)

tables, DB2 for OS/390, tasks for (2855)

tables, DELETE privilege (2618), (2626)

tables, deleting (2676)

tables, dropping (2675)

tables, exporting to files (2677), (2680)

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

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

tables, filtering (2502)

tables, granting privileges for groups (2690)

tables, granting privileges for users (2688)

tables, importing data into (2692)

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

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

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

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

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

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

tables, INDEX privilege (2621), (2629)

tables, INSERT privilege (2616), (2624)

tables, loading data into (2704)

tables, loading data into, collecting statistics (2711)

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

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

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

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

tables, loading data into, saving changes (2712)

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

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

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

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

tables, locking (2658)

tables, quiescing (2657)

tables, renaming (2716)

tables, reorganizing (2718)

tables, reorganizing, description (4268)

tables, revoking privileges for groups (2691)

tables, revoking privileges for users (2689)

tables, running statistics (2720)

tables, SELECT privilege (2615), (2623)

tables, unlocking (2660)

tables, unquiescing (2659)

tables, UPDATE privilege (2617), (2625)

tables, viewing contents (2726)

tablespace being rolled forward, monitor element (4028)

tablespace_name element (4003)

table_file_id element (4071)

table_name element (4041)

table_schema element (4043)

table_type element (4039)

targets, creating (3296)

targets, deleting (3298)

targets, editing (3299)

targets, viewing details (3301)

Tasks tab (3311)

TBSCAN operator, definition (2295), (4370)

TBSCAN operator, description (3099)

TCP/IP, configuring (2491)

TCP/IP, definition (4241)

TCP/IP, properties (2492)

TEMP operator, definition (2296), (4371)

TEMP operator, description (3100)

temporary table (4278)

territory configuration parameter (3470)

test batch, description (4301)

test satellite, description (4302)

testing multiple databases (2257)

testing, multisite update (2469)

threshold, select a script (2931)

thresholds, performance monitor (2927)

time of database connection, monitor element (3617)

time of first event overflow, monitor element (4060)

time of last event overflow, monitor element (4062)

time waited for prefetch, monitor element (3915)

time waited on locks, monitor element (4000)

timeron (2301), (4279)

timestamp, data elements (3588)

time_stamp element (4200)

tm_database configuration parameter (3459)

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

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

total fcm buffers received, monitor element (3873)

total fcm buffers sent, monitor element (3871)

total hash joins, monitor element (4201)

total hash loops, monitor element (4205)

total inactive DRDA agents, monitor element (3787)

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

total log available, monitor element (3783)

total log space used, monitor element (3781)

total number of attempted connections for DB2 Connect, monitor element (3713)

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

total sort heap allocated , monitor element (3835)

total sort time, monitor element (3845)

total sorts, monitor element (3843)

total system CPU for a statement, monitor element (4191)

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

total user CPU for a statement, monitor element (4193)

total_buffers_rcvd element (3874)

total_buffers_sent element (3872)

total_cons element (3802)

total_execution_time element (3778)

total_hash_joins element (4202)

total_hash_loops element (4206)

total_log_available element (3784)

total_log_used element (3782)

total_sec_cons element (3834)

total_sorts element (3844)

total_sort_time element (3846)

tot_log_used_top element (3962)

tot_s_cpu_time element (4192)

tot_u_cpu_time element (4194)

TP monitor client accounting string, monitor element (3753)

TP monitor client application name, monitor element (3751)

TP monitor client user ID, monitor element (3747)

TP monitor client workstation name, monitor element (3749)

tpmon_acc_str element (3754)

tpmon_client_app element (3752)

tpmon_client_userid element (3748)

tpmon_client_wkstn element (3750)

tpname configuration parameter (3508)

tp_mon_name configuration parameter (3566)

TQUEUE operator, definition (2297), (4372)

TQUEUE operator, description (3101)

tq_cur_send_spills element (4164)

tq_node_waited_for element (4160)

tq_rows_read element (4166)

tq_rows_written element (4168)

tq_tot_send_spills element (4162)

tq_wait_for_any element (4158)

transaction ID, monitor element (3745)

transaction manager (TM) database, description (4281)

transaction processor (TP) monitor, description (4282)

transaction processor (TP) monitor, TCP/IP protocol, non-universal databases (except OS/390 V5), configuring (2475)

transaction processor (TP), monitor, configuring (2472)

transaction, definition (4336)

triggers, altering comments (2770)

triggers, copying triggered action (2776)

triggers, creating (2777)

triggers, creating, specifying associated table (2773)

triggers, creating, specifying conditions for execution (2774)

triggers, creating, specifying name and schema (2772)

triggers, creating, specifying triggered action (2775)

triggers, DB2 for OS/390, tasks for (2857)

triggers, definition (4280)

triggers, deleting (2780)

triggers, dropping (2779)

triggers, viewing definition (2771)

Troubleshooting tab (3316)

troubleshooting tip, catching inefficient access plans (3084)

troubleshooting tips (3322)

trust_allclnts configuration parameter (3581)

trust_clntauth configuration parameter (3582)

ts_name element (4029)

udf_mem_sz configuration parameter (3374)

uid_sql_stmts element (4097)

unassigned batch, description (4303)

UNION operator, definition (2298), (4373)

UNIQUE operator, definition (2299), (4374)

UNIQUE operator, description (3102)

unit of work completion status, monitor element (3700)

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

unit of work start timestamp, monitor element (3696)

unit of work stop timestamp, monitor element (3698)

uow_comp_status element (3701)

uow_elapsed_time element (3776)

uow_lock_wait_time element (4009)

uow_log_space_used element (3970)

uow_start_time element (3697)

uow_stop_time element (3699)

update batch, description (4304)

UPDATE operator, definition (2300), (4375)

UPDATE operator, description (3103)

update operators, changing color from Command Center (3153)

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

updating multiple databases (2258)

URL, selecting (3321)

user authorization level, monitor element (3681)

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

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

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

user CPU time, monitor element (4183)

user ids, setting (2350)

user login ID, monitor element (3665)

user mapping, description (4283)

user mappings, adding (2781)

user mappings, altering (2784)

user mappings, creating (2425), (2782)

User, removing (3336)

user-defined functions, DB2 for OS/390, tasks for (2859)

user-defined functions, getting statistics (2987)

user-defined types, DB2 for OS/390 Version 6, tasks (2833)

userexit configuration parameter (3442)

users, adding (2417)

users, authorizations for (4223)

users, changing database authorities (2412)

users, changing index privileges (2415)

users, changing schema privileges (2413)

users, changing table privileges (2414)

users, changing view privileges (2416)

users, DB2 for OS/390 tasks for (2830)

users, granting database authorities to new (2418)

users, granting index privileges to new (2421)

users, granting schema privileges to new (2419)

users, granting table privileges to new (2420)

users, granting view privileges to new (2422)

user_cpu_time element (4184)

user_exit_status configuration parameter (3495)

util_heap_sz configuration parameter (3357)

version element (4216)

version of monitor data, monitor element (4215)

VESAMPL.DDL command (2959)

viewing an item of information (3310)

views, altering comments (2796)

views, CONTROL privilege (2790), (2794)

views, creating (2800)

views, creating, example SQL (2786)

views, DB2 for OS/390, tasks for (2861)

views, DELETE privilege (2789), (2793)

views, deleting (2802)

views, description (2812)

views, dropping (2803)

views, exporting to files (2678), (2682)

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

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

views, granting privileges for groups (2806)

views, granting privileges for users (2804)

views, INSERT privilege (2787), (2791)

views, related, description (2813)

views, revoking privileges for groups (2807)

views, revoking privileges for users (2805)

views, showing related (2808)

views, specifying file options (2683)

views, UPDATE privilege (2788), (2792)

views, viewing contents (2810)

views, viewing SQL (2797)

Visual Explain, about (4385)

Visual Explain, learning about (2952)

Visual Explain, windows (2955)

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

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

warning thresholds (2929)

warnings, Alert Center (2942)

web server, selecting (3320)

Web tab (3319)

WHERE clauses, examples, filter rows (2514)

window, Create Batch (3233)

window, Edit Group (3245)

windows, Access Plan Graph (3043)

windows, Add (2907)

windows, Add Database (2335)

windows, Add Instance (2463)

windows, Add or Change DMS Container (2267)

windows, Add or Change SMS Container (2266)

windows, Add Scripts (3215)

windows, add server options (2590)

windows, Add SQL (2543)

windows, Add SQL Statement (2444)

windows, Add System (2596)

windows, Advanced Limits (2450)

windows, Alert Center (2940)

windows, Alter (index) (2435)

windows, Alter Alias (2304)

windows, Alter Buffer Pool (2313), (2318)

windows, Alter Database (2337)

windows, Alter Nodegroup (2505)

windows, Alter Schema (2577)

windows, alter server options (2592)

windows, Alter Table Space (2742)

windows, Alter Table Space Partition (2745)

windows, Alter View (2798)

windows, Change Column (2538)

windows, Change Default Monitor (2872)

windows, Change Explained Statement (3036)

windows, Change Instance (2465)

windows, Change Replication Source (2560)

windows, Change SQL Statement (2446)

windows, Change Subscription (2524)

windows, Change Subscription Definition (3254)

windows, Change System (2477), (2598), (2599)

windows, Clone (replication subscription) (2526)

windows, Column Distribution Statistics (3078)

windows, Confirm Stop (2494)

windows, Confirmation (2220)

windows, Connect/Attach (2351)

windows, Copy (2663)

windows, Copy Batch (3231)

windows, Copy Group (3242)

windows, Copy Monitor (2876)

windows, Copy Satellite (3268)

windows, Copy Saved Script (3144)

windows, Create Alias (2306)

windows, Create Application Version (3205)

windows, Create Authentication (3223)

windows, Create Buffer Pool (2310), (2315)

windows, Create Column (2534)

windows, Create Group (3201)

windows, Create Index (2437)

windows, Create Nodegroup (2507)

windows, Create Schema (2579)

windows, Create Success Code (3291)

windows, Create Table Space (2751)

windows, Create Target (3297)

windows, create user mappings (2783)

windows, Create View (2799)

windows, Create Workload (2440)

windows, creating nicknames (2497)

windows, Customize columns (2212)

windows, Database Connection Partitions (2382)

windows, Database Partitions (2383)

windows, Database Partitions -- OPERATOR (3060)

windows, Database selection (2381)

windows, Define as Replication Source (2562)

windows, Define Join (2564)

windows, Define Subscription (2529), (2548)

windows, drop server options (2594)

windows, Edit Application Version (3207)

windows, Edit Authentication (3226)

windows, Edit Command Script (3142)

windows, Edit Script (3284)

windows, Edit Success Code (3294)

windows, Edit Target (3300)

windows, Edit Workload (2442)

windows, Estimate Size (2222)

windows, Explain SQL Statement (3010)

windows, Explainable Statements (3028)

windows, Explained Statements History (3035)

windows, File Browser (2264)

windows, Filter (2225)

windows, Filter Explainable Statements (3030)

windows, Filter Explained Statements (3041)

windows, filtering tables for nicknames (2503)

windows, Find (3038)

windows, Fix Satellite (3229)

windows, Function Statistics (3055)

windows, Functions (3053)

windows, Generalize Replication Subscription (3259)

windows, Generate DDL (2230)

windows, Import Script (3213), (3288)

windows, Import SQL Statements (2448)

windows, Index Statistics (3064)

windows, Indexes (3062)

windows, List Applications (2480)

windows, List Monitor (2867)

windows, List Monitored Objects (2894)

windows, List Monitors (2882), (2890), (2892)

windows, Locate Result (2233)

windows, New Command Script (3135)

windows, Nodes (2508)

windows, Open/Import (3117), (3131)

windows, Operator Details (3058)

windows, Optimization Parameters (3046)

windows, Page Fetch Pairs Statistics (3067)

windows, Path Browser (2265)

windows, Promote Replication Subscription (3263)

windows, Promote Satellite (3277)

windows, Promote Source (3261)

windows, Quiesce (2661)

windows, Referenced Column Statistics (3075)

windows, Referenced Columns (3073)

windows, Remove Confirmation (2551)

windows, Rename Group (3247)

windows, Rename Monitor (2884)

windows, Rename Script (3286)

windows, Rename Table (2717)

windows, Reorganize (2719)

windows, Restart Database (2380)

windows, Run Now (3137)

windows, Run Now or Save SQL (2557), (2571)

windows, Run SQL files (2556)

windows, Run Statistics (2722)

windows, Sample Contents (table) (2727)

windows, Sample Contents (view) (2811)

windows, Save As (3114), (3126), (3132)

windows, Save As Monitor (2886)

windows, Save Script (3130)

windows, Schedule (3108), (3120), (3140)

windows, Script Center (3106), (3133), (3139)

windows, Script Center Script (3146)

windows, Select Printer (3044)

windows, servers (2588)

windows, Set Constraints (2730)

windows, Set Execution Starting Point (3279)

windows, Set/Reset Default userid (2209)

windows, Show Command (2248)

windows, Show Keys (2536)

windows, Show Related Views (2809)

windows, Show SQL (2249)

windows, Sort (2253)

windows, SQL (2541)

windows, SQL Statement (2454)

windows, SQL Text (3032)

windows, Start Monitor (2888)

windows, Table Function Statistics (3081)

windows, Table Partitions (2731)

windows, Table Space Partitions (2763)

windows, Table Space Statistics (3050)

windows, Table Spaces (3048)

windows, Table Statistics (3070)

windows, Test Multisite Update (2471)

windows, Visual Explain (2954)

windows, Workload Details (2452)

windows, wrapper (2815)

windows,altering a user mapping (2785)

without transaction processor (TP) monitor, with SNA protocol, and or TCP/IP protocol, configuring (2474)

without transaction processor (TP) monitor, with TCP/IP protocol, universal and OS/390 V5 databases, configuring (2473)

work sheet format (WSF), definition (4242)

workloads, creating (2439)

workloads, editing (2441)

workloads, viewing (2451)

World Wide Web (3318)

wrapper, description (4284)

wrappers, creating (2423), (2814)

xid (3746)

x_lock_escals element (3983)

zoom slider, for magnifying access plan graphs (2980)