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 (2918)

accepted block cursor requests, monitor element (4763)

access plan graph node, definition (5091)

access plan graph, changing level of detail (3487)

access plan graph, changing the appearance of (3501)

access plan graph, creating (3461)

access plan graph, displaying and using (3483)

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

access plan graph, list of operators used (5106)

access plan graph, printing from Command Center (3673)

access plan graph, printing from Visual Explain (3553)

access plan graph, reading the symbols (3489)

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

access plan, creating from Command Center (3641)

access plan, definition (5090)

access plan, improving (3502), (3503), (3508)

access plan, troubleshooting tip (3593)

access plan, viewing form the Command Center (3638)

accesses to overflowed records, monitor element (4745)

acc_curs_blk element (4764)

active sorts, monitor element (4518)

active_sorts element (4519)

adding object lists to Utility Procedures (3380)

adding objects to Object Lists (3379)

adding performance variables to a graph (3431)

adding performance variables to a monitor (3414)

adding sources to a process (3778)

adding tables, views, and files to a process (3759)

adding targets to a process (3781)

agent ID holding lock, monitor element (4703)

Agent sites notebook (3724), (3737)

agentpri configuration parameter (4150)

agents assigned from pool, monitor element (4482)

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

agents registered, monitor element (4472)

agents waiting for a token, monitor element (4474)

agents_created_empty_pool element (4485)

agents_from_pool element (4483)

agents_registered element (4473)

agents_registered_top element (4477)

agents_stolen element (4489)

agents_top element (4873)

agents_waiting_on_token element (4475)

agents_waiting_top element (4479)

agent_id element (4375)

agent_id_holding_lock element (4704)

agent_pid element (4451)

agent_stack_sz configuration parameter (4112)

agent_sys_cpu_time element (4879)

agent_usr_cpu_time element (4877)

alarm thresholds (3436)

alarms, Alert Center (3449)

alert center preferences (3452)

alert center properties (2632)

Alert Center, overview (3447)

alert center, viewing nodes (3457)

alerts, definition (5058)

alerts, suspending (3455)

alias, definition (4992)

aliases, altering comments (2708)

aliases, changing comments (2709)

aliases, creating (2711)

aliases, deleting (2714)

aliases, dropping (2713)

altering indexes (DB2 for OS/390 V5) (3326)

altering table spaces (DB2 for OS/390 V5) (3330)

altering table spaces (DB2 for OS/390 V6) (3334)

altering tables (DB2 for OS/390 V5) (3348)

altering tables (DB2 for OS/390 V6) (3350)

ANOVA transformer (3839), (3845)

APPC, configuring (2982)

APPC, definition (4985)

APPC, properties (2983)

applheapsz configuration parameter (4107)

application agent priority, monitor element (4416)

application creator, monitor element (4810)

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

application ID holding lock, monitor element (4705)

application id, definition (5059)

application ID, monitor element (4386)

application idle time, monitor element (4448)

application name, definition (5060)

application name, monitor element (4384)

application priority type, monitor element (4418)

application status change time, monitor element (4380)

application status, monitor element (4376)

application version, changing level (3929)

application version, creating (3925)

application version, description (5038)

application version, editing (3927)

application versions, deleting (3941)

application versions, viewing details (3942)

application with oldest transaction, monitor element (4382)

applications connected currently, monitor element (4467)

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

applications, DB2 Connect (2959)

applications, forcing gateway (2978)

applications, forcing local (2973)

applications, listing gateway (2977)

applications, listing local (2971)

applications, local (2958)

appls_cur_cons (4468)

appls_in_db2 element (4471)

appl_con_time element (4427)

appl_id element (4387)

appl_idle_time element (4449)

appl_id_holding_lk element (4706)

appl_id_oldest_xact element (4383)

appl_name element (4385)

appl_priority element (4417)

appl_priority_type element (4419)

appl_section_inserts element (4637)

appl_section_lookups element (4635)

appl_status element (4377)

app_ctl_heap_sz database parameter (4101)

archive logging (2686)

aslheapsz configuration parameter (4119)

associated_agents_top element (4491)

audit_buf_sz configuration parameter (4126)

authentication configuration parameter (4318)

authentication credentials, description (5039)

authentications, creating (3943)

authentications, deleting (3945)

authentications, editing (3946)

authentications, viewing details (3948)

authority

configuration parameters (4314)

authority_lvl element (4421)

authorization id, definition (5061)

authorization ID, monitor element (4390)

auth_id element (4391)

autorestart database configuration parameter (4185)

avg_appls configuration parameter (4147)

backbufsz configuration parameter (4095)

backup image for restore database (2694)

backup_pending configuration parameter (4231)

base aggregate replication step, defining (3882)

basic operators, changing color from Command Center (3668)

basic query, used in Visual Explain examples (3513)

batch steps, changing properties (3931)

batch, description (5040)

batch, promoting to production (3938)

batch, testing for group (3937)

batches, copying (3951)

batches, creating (3953)

batches, deleting (3955)

batches, editing (3956)

batches, viewing (3958)

batches, viewing details (3960)

bind options, choosing (3527)

bind options, getting information about (3500)

binds/precompiles attempted, monitor element (4797)

binds_precompiles element (4798)

Books tab (4028)

bp_info element (4593)

bp_name element (4595)

buffer pool asynchronous data reads, monitor element (4572)

buffer pool asynchronous data writes, monitor element (4574)

buffer pool asynchronous index reads, monitor element (4578)

buffer pool asynchronous index writes, monitor element (4576)

buffer pool asynchronous read requests, monitor element (4584)

buffer pool asynchronous read time, monitor element (4580)

buffer pool asynchronous write time, monitor element (4582)

buffer pool data logical reads, monitor element (4554)

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

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

buffer pool data physical reads, monitor element (4556)

buffer pool data writes, monitor element (4558)

buffer pool index logical reads, monitor element (4560)

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

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

buffer pool index physical reads, monitor element (4562)

buffer pool index writes, monitor element (4564)

buffer pool information, monitor element (4592)

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

buffer pool threshold cleaners triggered, monitor element (4590)

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

buffer pool, definition (4988)

buffer pools, altering characteristics of (2717)

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

buffer pools, changing characteristics of (2718)

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

buffer pools, creating (2715)

buffer pools, creating for a partitioned database (2720)

buffer pools, removing (2614)

bufferpool name, monitor element (4594)

buffpage configuration parameter (4090)

buff_free element (4531)

buff_free_bottom element (4533)

built-in functions, getting statistics (3494)

byte order of event data, monitor element (4910)

byte_order element (4911)

Calc with calc rules (ESSCALC2) (3878)

Calculate Statistics transformer (3851)

Calculate statistics transformer (3852)

Calculate subtotal transformer (3846)

Calculate subtotals transformer (3847)

capacity management configuration parameters (4087)

cascade relationships, creating for a process or step (3823)

catalog cache heap full, monitor element (4624)

catalog cache inserts, monitor element (4620)

catalog cache lookups, monitor element (4618)

catalog cache overflows, monitor element (4622)

catalog node network name, monitor element (4366)

catalog node number, monitor element (4370)

catalogcache_sz configuration parameter (4092)

Cataloged Database, description (2919)

catalog_noauth configuration parameter (4319)

catalog_node element (4371)

catalog_node_name element (4367)

cat_cache_heap_full element (4625)

cat_cache_inserts element (4621)

cat_cache_lookups element (4619)

cat_cache_overflows element (4623)

CE_free element (4539)

CE_free_bottom element (4541)

change aggregate replication step, defining (3883)

changing a source (3763)

changing a target (3765)

changing Data Warehouse Center password (3742)

changing Data Warehouse Center user IDs (3741)

changing initialization settings (3807)

changing warehouse control database (3745)

character strings, finding from Visual Explain (3547)

Chi-Square transformer (3848), (3849)

chngpgs_thresh configuration parameter (4135)

circular logging (2684)

Clean Data transformer (3862)

cleanup batch, description (5041)

client communication protocol, monitor element (4412)

client operating platform, monitor element (4410)

client process ID, monitor element (4408)

client product/version ID, monitor element (4394)

client_db_alias element (4397)

client_nname element (4393)

client_pid element (4409)

client_platform element (4411)

client_prdid element (4395)

client_protocol element (4413)

CMPEXP operator, definition (2891)

codepage configuration parameter (4213)

codepage_id element (4379)

codeset configuration parameter (4212)

collate_info configuration parameter (4214)

column distribution statistics, viewing from Command Center (3695)

column distribution statistics, viewing from Visual Explain (3587)

columns in SQL statements, getting statistics (3496)

command center, selecting a database (3639)

command script results, saving (3636)

command script results, viewing (3634)

command scripts, copying (3660)

command scripts, creating (3620), (3651)

command scripts, deleting (3662)

command scripts, editing (3658)

command scripts, running (3623), (3629), (3653)

command scripts, scheduling (3631), (3655)

commands, EXPLAIN.DDL (3474)

commands, EXPLSNAP option on BIND (3482)

commands, LIST TABLES (3471)

commands, reorg (3533)

commands, reorgchk (3531)

commands, runstats WITH DISTRIBUTION (3521)

commands, SET CURRENT EXPLAIN SNAPSHOT (3478)

commands, VESAMPL.DDL (3468)

commit statements attempted, monitor element (4775)

committed private memory, monitor element (4492)

commit_sql_stmts element (4776)

communication error time, monitor element (4972)

communication errors, monitor element (4970)

communications, setting up (2980)

comm_bandwidth configuration parameter (4304)

comm_private_mem element (4493)

complete recovery (roll forward) (2697)

completion actions, defining for a job (3713)

component_id element (4349)

configuration

parameter summary, database (4085)

parameter summary, database manager (4083)

configuration NNAME of client, monitor element (4392)

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

configuration parameter

agent communication memory (4115)

agent private memory (4102)

application communication memory (4116)

application shared memory (4099)

applications and agents (4145)

communication protocol setup (4246)

communications (4245)

compiler settings (4238)

Database Application Remote Interface (DARI) (4159)

database attributes (4207)

database management (4203)

database manager instance memory (4123)

database shared memory (4088)

database status (4230)

database system monitor (4293)

DB2 Data Links Manager (4216)

DB2 Discovery (4261)

diagnostic information (4288)

distributed services (4254)

distributed unit of work (4196)

I/O and storage (4133)

instance administration (4313)

instance management (4287)

locks (4128)

log activity (4175)

log files (4166)

logging (4164)

parallel operations (4269)

partitioned database (4270)

query enabler (4205)

recovery (4165), (4181)

stored procedure (4158)

system management (4302)

Tivoli Storage Manager (4183)

configuration parameters, choosing (3526)

configuration parameters, definition (5062)

configuration parameters, getting information about (3499)

configuration parameters; capacity management (4086)

configuring database for performance using a wizard (2762), (2799)

connection entries currently free, monitor element (4538)

connection partition, definition (4989)

connection request completion timestamp, monitor element (4431)

connection request start timestamp, monitor element (4426)

connection status, monitor element (4548)

connection switches, monitor element (4502)

connections involved in deadlock, monitor element (4683)

connections, definition (5063)

connections_top element (4429)

connection_status element (4549)

connects since database activation, monitor element (4464)

conn_complete_time element (4432)

conn_elapse configuration parameter (4273)

conn_time (4361)

container, definition (5093)

containers, listing for a node (3219)

containers, modifying characteristics (3218)

contents pane toolbar (2670)

contents pane, description (2674)

contents pane, refreshing (2641)

Control Center toolbar (2671)

Control Center, opening new (2639)

Control Center, using (2596)

con_elapsed_time element (4969)

con_local_dbases (4463)

con_response_time element (4967)

coordinate systems, defining (2857)

Coordinated Universal Time (4281)

coordinating node, monitor element (4424)

coordinator agent, monitor element (4452)

coord_agents_top element (4487)

coord_agent_pid element (4453)

coord_node element (4425)

Copy file using FTP (VWPRCPY) (3874)

copying a source table (3904)

copying a step (3837)

copying a target table (3906)

copyprotect configuration parameter (4215)

Correlation transformer (3853), (3854)

corr_token element (4407)

cost, definition (5094)

cost, on operator details (3594)

count element (4905)

counter, data elements (4325)

counters, definition (5064)

country configuration parameter (4211)

country_code element (4415)

cpuspeed configuration parameter (4305)

creating a shortcut to a step (3757)

Creating and changing data set templates (3377)

Creating and changing data set templates defaults (3367), (3382)

Creating and changing object lists (3375)

Creating and changing utility procedures (3376)

creating Data Set Templates (3378), (3381)

creating databases (DB2 for OS/390 V5) (3286)

creating DB users (DB2 for OS/390 V5) (3290)

creating DB users (DB2 for OS/390 V6) (3292)

creating distinct types (DB2 for OS/390 V6) (3324)

creating indexes (DB2 for OS/390 V5) (3328)

creating indexes (DB2 for OS/390 V6) (3336)

creating schemas (DB2 for OS/390 V6) (3340)

creating storage groups (DB2 for OS/390 V5) (3342)

creating storage groups (DB2 for OS/390 V6) (3344)

creating synonyms (DB2 for OS/390) (3346)

creating table spaces (DB2 for OS/390 V5) (3332)

creating table spaces (DB2 for OS/390 V6) (3338)

creating tables (DB2 for OS/390 V5) (3352)

creating tables (DB2 for OS/390 V6) (3354), (3365)

creating triggers (DB2 for OS/390 V6) (3356)

creating, server options (3085)

creator element (4811)

current agents waiting on locks, monitor element (4696)

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

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

cursor blocking, definition (5095)

cursor name, monitor element (4808)

cursor_name element (4809)

customizing the list of displayed columns (2606)

cyclical referential constraint, definition (4990)

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

data element, definition (5069)

data elements, overview (4324)

Data Export with ODBC to File (VWPEXPT2) (3877)

Data Links access token expiry interval configuration parameter (4219)

Data Links number of copies configuration parameter (4221)

Data Links time after drop configuration parameter (4223)

Data Links token algorithm configuration parameter (4225)

Data Links token in upper case configuration parameter (4227)

data set allocation, examples (DB2 for OS/390) (3368)

data sets, deleting (DB2 for OS/390) (3288)

data sets, renaming (DB2 for OS/390 V6) (3374)

data source, accessing (2872)

data source, adding to federated system (2873)

data types, length restrictions (2876)

data types, list of (2875)

Data Warehouse Center passwords, changing (3744)

Data Warehouse Center Program properties notebook (3773)

Data Warehouse Center trace, running (3747)

Data Warehouse Center user IDs, changing (3743)

Data Warehouse Center, connecting (3748)

Data Warehouse Center, getting started (3715)

Data Warehouse Center, logging on (3717)

Data Warehouse Center, opening (3718)

data, prefetching (2916)

database

configuration parameter summary (4084)

database activation timestamp, monitor element (4358)

database alias at the gateway, monitor element (4924)

database alias used by application, monitor element (4396)

database authorities for new groups (2809)

database authorities for new users (2835)

database connection

applications connected currently, monitor element (4466)

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

connection request completion timestamp, monitor element (4430)

database connection services directory, definition (4994)

database country code, monitor element (4414)

database deactivation timestamp, monitor element (4362)

database files closed, monitor element (4570)

database location, monitor element (4368)

database manager

configuration parameter summary (4082)

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

database manager, definition (5006)

database managment, configuration parameters (4204)

database name (2915)

database name, monitor element (4354)

database object hierarchy, definition (5067)

database object, definition (5007)

database object, performance monitor definition (5066)

database partition, backing up (2745), (2805)

database partition, configuring (2797)

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

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

database partition, modifying containers during restore (2772)

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

database partition, restarting (2804)

database partition, restoring (2768), (2806)

database partition, restoring selected table spaces (2770)

database partition, rolling forward (2784), (2807)

database partition, rolling forward selected table spaces (2788)

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

database partitions, viewing from Visual Explain (3569)

database path, monitor element (4356)

database system monitor

configuration parameters (4294)

database system monitor, definition (5068)

database, adding (2736)

database, altering (2738)

database, backing up (2744)

database, backing up using a wizard (2746)

database, configuring (2748)

database, configuring for performance using a wizard (2761), (2798)

database, creating from backup image (2757)

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

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

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

database, creating using a wizard (2755)

database, definition (4991)

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

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

database, modifying containers during restore (2771)

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

database, restarting a database (2789)

database, restoring (2767)

database, restoring backup image to new database (2779)

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

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

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

database, restoring selected table spaces (2769)

database, restoring using a wizard (2777)

database, rolling forward (2783)

database, rolling forward selected table spaces (2787)

database,generating DDL statements (2624)

databases, adding to the object tree (2598)

databases, authorities on (2725), (2726)

databases, connecting to (2750)

databases, creating (DB2 for OS/390 V5) (3287)

databases, dropping (2611)

databases, forcing local applications (2974)

databases, generating DDL (DB2 for OS/390 V5) (3296)

databases, generating DDL (DB2 for OS/390 V6) (3299)

databases, granting authorities to user groups (2742)

databases, granting authorities to users (2740)

databases, listing local applications (2972)

databases, revoking authorities from user groups (2743)

databases, revoking authorities from users (2741)

databases, spatially enabling (2855)

database_consistent configuration parameter (4232)

database_level configuration parameter (4209)

datalinks configuration parameter (4228)

DB users, creating (DB2 for OS/390 V5) (3291)

DB users, creating (DB2 for OS/390 V6) (3293)

DB2 commands, executing (3617), (3626)

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

DB2 Data Links Manager (4217)

DB2 Relational Connect

changing the number of concurrent non-DB2 data sources (4052)

changing the enforcement policy (4047)

changing the license type policy (4050)

viewing non-DB2 data source statistics (4078)

DB2 startup preferences, specifying (2656)

DB2 tools, shutting down (2651)

DB2 Universal Database for OS/390 utility identifier, changing (2636)

DB2 Universal Database for OS/390 utility identifier, defining (2635)

db2start_time element (4330)

db2_all (2699)

db2_status (4351)

dbheap configuration parameter (4091)

DBSpace, updating statistics (2865)

db_conn_time element (4359)

db_heap_top element (4639)

db_location element (4369)

db_name element (4355)

db_path element (4357)

db_status element (4365)

DCS application status, monitor element (4944)

DCS database name, monitor element (4920)

DCSD, definition (4993)

dcs_appl_status element (4945)

dcs_db_name element (4921)

ddl_sql_stmts element (4784)

deadlock detector, definition (5072)

deadlock, definition (5070)

deadlocked connection, definition (5071)

deadlocks detected, monitor element (4663)

deadlocks element (4664)

Default calc (ESSCALC1) (3884)

default performance monitors (5073)

defining a subject area (3722)

degree of parallelism, monitor element (4874)

degree_parallelism element (4875)

DELETE operator, definition (2892)

DELETE operator, description (3596)

deleting data sets (DB2 for OS/390) (3289)

deleting performance variables from a graph (3432)

delimited ASCII format (DEL), description (4995)

delimited identifier, definition (5074)

delimited identifiers (name), description (2921)

dependent table, definition (5008)

descendent table, definition (5009)

details, performance monitor (3424)

dftdbpath configuration parameter (4320)

dft_account_str configuration parameter (4309)

dft_client_adpt configuration parameter (4260)

dft_client_comm configuration parameter (4259)

dft_degree configuration parameter (4240)

dft_extent_sz configuration parameter (4142)

dft_loadrec_ses configuration parameter (4187)

dft_monswitches configuration parameter (4295)

dft_mon_bufpool configuration parameter (4299)

dft_mon_lock configuration parameter (4300)

dft_mon_sort configuration parameter (4301)

dft_mon_stmt configuration parameter (4297)

dft_mon_table configuration parameter (4298)

dft_mon_uow configuration parameter (4296)

dft_prefetch_sz configuration parameter (4140)

dft_queryopt configuration parameter (4241)

dft_refresh_age configuration parameter (4242)

dft_sqlmathwarn configuration parameter (4239)

diaglevel configuration parameter (4290)

diagnostics log, for nodes (3015)

diagnostics, tracing DB2 information (2638)

diagpath configuration parameter (4291)

direct read requests, monitor element (4610)

direct read time, monitor element (4614)

direct reads from database, monitor element (4606)

direct write requests, monitor element (4612)

direct write time, monitor element (4616)

direct writes to database, monitor element (4608)

direct_reads element (4607)

direct_read_reqs element (4611)

direct_read_time element (4615)

direct_writes element (4609)

direct_write_reqs element (4613)

direct_write_time element (4617)

dir_cache configuration parameter (4125)

dir_obj_name configuration parameter (4257)

dir_path_name configuration parameter (4256)

dir_type configuration parameter (4255)

disconn_time element (4363)

discover configuration parameter (4263)

discover server instance configuration parameter (4268)

discovery mode configuration parameter (4264)

discover_comm configuration parameter (4265)

discover_db configuration parameter (4262)

discover_inst configuration parameter (4267)

displaying objects (3822)

displaying related objects (3817)

distinct type, definition (4996)

distinct types, creating (DB2 for OS/390 V6) (3325)

distinct types, generating DDL (DB2 for OS/390 V6) (3317)

Distributed Computing Environment (DCE)

configuration parameters (4253)

dlchktime configuration parameter (4130)

dl_conns element (4684)

dl_expint configuration parameter (4218)

dl_num_copies configuration parameter (4220)

dl_time_drop configuration parameter (4222)

dl_token configuration parameter (4224)

dl_upper configuration parameter (4226)

DMS table space, definition (5097)

dos_rqrioblk configuration parameter (4121)

downloading books (4030)

drda correlation token, monitor element (4406)

DRDA, definition (4997)

drda_heap_sz configuration parameter (4110)

dynamic SQL statements attempted, monitor element (4771)

dynamic SQL statements, creating explain snapshots for (3476)

dynamic SQL, definition (5099)

dynamic_sql_stmts element (4772)

dyn_query_mgmt configuration parameter (4206)

EISCAN operator, definition (2893)

elapsed statement execution time, monitor element (4868)

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

enable Data Links support configuration parameter (4229)

enable intra-partition parallelism configuration parameter (4286)

enabled satellite, description (5042)

Enforcement Policy, changing (4043), (4045)

error handling

configuration parameters (4289)

estimating space requirements for tables and indexes (2616)

estore_seg_sz configuration parameter (4143)

Event Analyzer, definition (5075)

event monitor name, monitor element (4914)

Event Monitor, definition (5076)

event start time, monitor element (4818)

event stop time, monitor element (4816)

event time, monitor element (4918)

event_monitor_name element (4915)

event_time element (4919)

exception tables, description (5010)

exclusive lock escalations, monitor element (4667)

execution_id element (4405)

explain snapshot, definition (5100)

explain snapshots for dynamic SQL statements, creating (3475)

explain snapshots for static SQL statements, creating (3479)

explain snapshots, creating (3464)

explain snapshots, samples for Visual Explain (3465)

explain tables, creating (3469)

EXPLAIN.DDL file/command (3472)

explainable SQL statements, viewing (3539)

explainable statement, definition (5101)

explainable statements, choosing (3486)

explainable statements, filtering (3537)

explained SQL statements, changing (3545)

explained SQL statements, choosing (3485)

explained SQL statements, filtering (3548)

explained SQL statements, removing (3550)

explained statement, definition (5102)

EXPLSNAP option (on BIND command) (3481)

exporting data (3869)

extended operators, changing color from Command Center (3669)

extent (2704)

failed statement operations, monitor element (4773)

failed_sql_stmts element (4774)

fcm buffers currently free, monitor element (4530)

fcm_num_anchors configuration parameter (4274)

fcm_num_buffers configuration parameter (4276)

fcm_num_connect configuration parameter (4277)

fcm_num_rqb database manager configuration parameter (4278)

federated configuration parameter (4312)

federated database system support configuration parameter (4311)

federated database system, creating (2874)

federated database system, description (5011)

federated database, description (5012)

FETCH operator, definition (2894)

FETCH operator, description (3597)

fetch_count element (4827)

file system, definition (5013)

files, adding to process (3761)

files, EXPLAIN.DDL (3473)

fileserver configuration parameter (4250)

files_closed element (4571)

FILTER operator, definition (2895)

FILTER operator, description (3598)

filtering the list of displayed objects (2619)

first active log file (loghead) parameter (4174)

first_overflow_time element (4907)

fix batch, description (5043)

fix batches, assigning to satellite (3949)

fix batches, viewing which satellites are using (3961)

folders, description (2675)

fonts, changing (2634)

forcing gateway applications (2979)

forcing local applications (2975)

Free text data load (3885)

function statistics, viewing from Command Center (3682)

function statistics, viewing from Visual Explain (3564)

functions, getting statistics (3493)

functions, viewing from Command Center (3681)

functions, viewing from Visual Explain (3562)

gateway applications, listing (2976)

gauge, data elements (4326)

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

generalized replication subscriptions, viewing details (3985)

Generate Key Table transformer (3863)

Generate key table transformer (3864)

Generate Period Table (3861)

Generate Period Table transformer (3860)

generating data definition language, databases (DB2 for OS/390 V5) (3295)

generating data definition language, databases (DB2 for OS/390 V6) (3298)

generating data definition language, distinct types (DB2 for OS/390 V6) (3316)

generating data definition language, schemas (DB2 for OS/390 V6) (3313)

generating data definition language, stored procedures (DB2 for OS/390 V6) (3322)

generating data definition language, table spaces (DB2 for OS/390 V5) (3301)

generating data definition language, table spaces (DB2 for OS/390 V6) (3304)

generating data definition language, tables (DB2 for OS/390 V5) (3307)

generating data definition language, tables (DB2 for OS/390 V6) (3310)

generating data definition language, user defined functions (DB2 for OS/390 V6) (3319)

generating DDL for databases (DB2 for OS/390 V5) (3294)

generating DDL for databases (DB2 for OS/390 V6) (3297)

generating DDL for distinct types (DB2 for OS/390 V6) (3315)

generating DDL for schemas (DB2 for OS/390 V6) (3312)

generating DDL for stored procedures (DB2 for OS/390 V6) (3321)

generating DDL for table spaces (DB2 for OS/390 V5) (3300)

generating DDL for table spaces (DB2 for OS/390 V6) (3303)

generating DDL for tables (DB2 for OS/390 V5) (3306)

generating DDL for tables (DB2 for OS/390 V6) (3309)

generating DDL for user defined functions (DB2 for OS/390 V6) (3318)

GENROW function, definition (2896)

geocoder, running for spatial data (2859)

getting started with the Data Warehouse Center (3714)

graph settings, changing from Command Center (3664)

graph, edit performance monitor (3427)

graph, performance monitor details (3443)

graph, performance variables (3444)

group, copying (3962)

group, creating (3921)

group, description (5044)

groups, adding (2827)

groups, authorizations for (4987)

groups, changing database authorities (2816)

groups, changing index privileges (2819)

groups, changing schema privileges (2817)

groups, changing table privileges (2818)

groups, changing table space privileges (2820)

groups, changing view privileges (2821)

groups, deleting (3964)

groups, deploying new (3920)

groups, editing (3965)

groups, granting database authorities to new (2828)

groups, granting index privileges to new (2831)

groups, granting schema privileges to new (2829)

groups, granting table privileges to new (2830)

groups, granting view privileges to new (2832)

groups, renaming (3967)

groups, to receive notification messages (3771)

groups, viewing details (3969)

groups, viewing logs (3970)

GRPBY operator, definition (2897)

GRPBY operator, description (3599)

gw_comm_errors element (4971)

gw_comm_error_time element (4973)

gw_connections_top element (4929)

gw_cons_wait_client element (4937)

gw_cons_wait_host element (4935)

gw_con_time element (4927)

gw_cur_cons element (4933)

gw_db_alias element (4925)

gw_exec_time element (4939)

gw_total_cons element (4931)

hash join overflows, monitor element (4526)

hash join small overflows, monitor element (4528)

hash join threshold, monitor element (4522)

hash_join_overflows element (4527)

hash_join_small_overflows element (4529)

help, getting from the Control Center (2629)

help, how to use (2595)

highest, data elements (4327)

host coded character set ID, monitor element (4946)

host database name, monitor element (4922)

host product/version ID, monitor element (4398)

host response time, monitor element (4964)

host_ccsid element (4947)

host_db_name element (4923)

host_prdid element (4399)

host_response_time element (4965)

hover help, description (2676)

hover help, setting for administration tools (2642)

HSJOIN operator, definition (2898)

HSJOIN operator, description (3600)

I/O

configuration parameters (4134)

IBM-supplied performance variables, definition (5077)

icons, Control Center (4080)

icons, node states (5078)

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

idle_agents element (4481)

importing spatial data (2861)

inactive_gw_agents element (4501)

inbound communication address, monitor element (4952)

inbound number of bytes received, monitor element (4954)

inbound number of bytes sent, monitor element (4960)

inbound_bytes_received element (4955)

inbound_bytes_sent element (4961)

inbound_comm_address element (4953)

index statistics, viewing from Command Center (3686)

index statistics, viewing from Visual Explain (3573)

indexes, altering (DB2 for OS/390 V5) (3327)

indexes, altering comments (2926)

indexes, changing comments (2927)

indexes, clustering (5092)

indexes, CONTROL privilege (2813)

indexes, creating (2929), (3525)

indexes, creating (DB2 for OS/390 V5) (3329)

indexes, creating (DB2 for OS/390 V6) (3337)

indexes, creating for VSE & VM (2931)

indexes, creating spatial (2863)

indexes, creating using wizard (2933)

indexes, deleting (2950)

indexes, dropping (2949)

indexes, getting statistics (3497)

indexes, granting privileges for groups (2953)

indexes, granting privileges for users (2951)

indexes, reorganizing for VSE & VM (2955)

indexes, revoking privileges for groups (2954)

indexes, revoking privileges for users (2952)

indexes, running statistics (3192)

indexes, viewing from Command Center (3685)

indexes, viewing from Visual Explain (3571)

indexrec configuration parameter (4186)

indexsort configuration parameter (4138)

infopops, description (2677)

infopops, setting for administration tools (2643)

infopops, turning on (2644)

information, data elements (4328)

information, getting from the Control Center (2630)

information, linking to documentation on a local web server (4036)

information, putting DB2 Universal Database documentation on a local Web server (4037)

initdari_jvm configuration parameter (4162)

initialization settings, changing (3808)

input database alias, monitor element (4898)

input_db_alias element (4899)

INSERT operator, definition (2899)

INSERT operator, description (3601)

instance, adding (2960)

instance, changing (2962)

instance, configuring (2964)

instance, definition (5015)

instance, starting (2994)

instances, adding to the object tree (2599)

instances, attaching to (2752)

instances, removing (2610)

instances, stopping (2992)

integrated exchange format (IXF), description (4998)

internal automatic rebinds, monitor element (4785)

internal commits, monitor element (4787)

internal rollbacks due to deadlock, monitor element (4791)

internal rollbacks, monitor element (4789)

internal rows deleted, monitor element (4747)

internal rows inserted, monitor element (4751)

internal rows updated, monitor element (4749)

intra_parallel configuration parameter (4285)

int_auto_rebinds element (4786)

int_commits element (4788)

int_deadlock_rollbacks element (4792)

int_rollbacks element (4790)

int_rows_deleted element (4748)

int_rows_inserted element (4752)

int_rows_updated element (4750)

Invert Data transformer (3866), (3867)

IPX/SPX, configuring (2984)

IPX/SPX, definition (4999)

IPX/SPX, properties (2985)

ipx_socket configuration parameter (4252)

isolation level, definition (5016)

IXAND operator, definition (2900)

IXSCAN operator, definition (2901)

IXSCAN operator, description (3602)

java_heap_sz database manager configuration parameter (4127)

jdk11_path database manager configuration parameter (4310)

jobs, deleting (3705)

jobs, disabling (3703)

jobs, enabling (3702)

jobs, rescheduling (3704)

jobs, running (3699)

jobs, scheduling recurring (3710)

jobs, scheduling single (3709)

jobs, scheduling to run twice a month (3711)

jobs, showing results of (3700)

jobs, using invalid dates when scheduling (3712)

join relationships, establishing in a warehouse schema (3813)

join relationships, removing in warehouse schema (3814)

keepdari configuration parameter (4160)

last backup timestamp, monitor element (4372)

last reset timestamp, monitor element (4896)

last_backup element (4373)

last_over_flow time (4909)

last_reset element (4897)

legend, Control Center (4079)

level of protection for your data (2683)

level of recovery (2692), (2701)

level, description (5045)

levels, viewing (4023)

License Center

DB2 Relational Connect

changing the license type policy (4051)

changing the number of concurrent non-DB2 data sources (4053)

viewing non-DB2 data source statistics (4077)

License Center, adding a license (4040)

License Center, Changing the number of licensed processors (4056)

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

License Center, License page (4044), (4046), (4049), (4057), (4059) , (4067), (4069), (4071)

License Center, Statistics page (4074), (4076)

License Center, User page (4042), (4055), (4061), (4063), (4065)

License, adding (4039)

License, changing type policy (4048)

License, removing (4058)

License, viewing concurrent user policy information (4068)

License, viewing information (4070)

License, viewing measured usage license information (4072)

License, viewing processor status (4066)

limiting the number of objects displayed in the Control Center. (2621)

LIST TABLES command (3470)

lists, existing names missing (2668)

Load data from a file without load rules (3880)

Load data from a flat file into DB2 UDB for AS/400, append (3890)

Load data from a flat file into Db2 UDB for AS/400, insert (3893), (3897)

Load data from file with load rules (3879)

Load data from SQL server with load rules (3886)

loading data (3870)

Loading data into tables for a DB2 for OS/390 table space (3900)

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

local connections, monitor element (4458)

local database directory, definition (5017)

local databases with current connects, monitor element (4462)

local_cons element (4459)

local_cons_in_exec (4461)

Locating an object (2626)

Locating an object (Data Warehouse Center) (3754)

locating objects (3821)

locating related objects (3820)

lock escalation, monitor element (4685)

lock mode requested, monitor element (4687)

lock mode, monitor element (4669)

lock node, monitor element (4677)

lock object name, monitor element (4675)

lock object type waited on, monitor element (4673)

lock status, monitor element (4671)

lock wait start timestamp, monitor element (4701)

lock waits, monitor element (4689)

locklist configuration parameter (4097)

locks

configuration parameter (4129)

current agents waiting on locks, monitor element (4695)

locks held, monitor element (4657)

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

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

locks held, monitor element (4658)

locks_held element (4659)

locks_held_top element (4682)

locks_waiting (4697)

locktimeout configuration parameter (4132)

lock_escalation element (4686)

lock_escals element (4666)

lock_mode element (4670)

lock_mode_requested element (4688)

lock_node element (4678)

lock_object_name element (4676)

lock_object_type element (4674)

lock_status element (4672)

lock_timeouts element (4680)

lock_waits (4690)

lock_wait_start_time element (4702)

lock_wait_time element (4692)

loc_list_in_use (4662)

log being rolled forward, monitor element (4721)

log entries for steps, viewing (3738)

log phase, monitor element (4723)

logbufsz configuration parameter (4093)

logfilsiz configuration parameter (4168)

logging on to the Data Warehouse Center (3716)

logging types (2689), (2691)

logging, archive (2687)

logging, circular (2685)

loghead configuration parameter (4173)

logical volume, definition (5014)

logpath configuration parameter (4172)

logprimary configuration parameter (4169)

logretain configuration parameter (4179)

logs

configuration parameters affecting log activity (4176)

configuration parameters affecting log files (4167)

logs entries for steps, viewing details (3755)

logs, deleting (3971)

logs, pruning (3708)

logs, viewing details (3972)

logs, viewing details of log entry (3973)

logsecond configuration parameter (4170)

log_reads element (4647)

log_retain_status configuration parameter (4234)

log_space_used element (4652)

log_writes element (4649)

maxagents configuration parameter (4151)

maxappls configuration parameter (4146)

maxcagents configuration parameter (4152)

maxdari configuration parameter (4161)

maxfilop configuration parameter (4148)

maximum agent overflows, monitor element (4498)

maximum database heap allocated, monitor element (4638)

maximum number of agents registered, monitor element (4476)

maximum number of agents waiting, monitor element (4478)

maximum number of associated agents, monitor element (4490)

maximum number of concurrent connections, monitor element (4428), (4928)

maximum number of coordinating agents, monitor element (4486)

maximum number of locks held, monitor element (4681)

maximum number of tablequeue buffers overflows, monitor element (4856)

maximum package cache size, monitor element (4632)

maximum query degree of parallelism configuration parameter (4284)

maximum secondary log space used, monitor element (4640)

maximum total log space used, monitor element (4642)

maxlocks configuration parameter (4131)

maxtotfilop configuration parameter (4149)

max_agent_overflows element (4499)

max_connretries database manager configuration parameter (4279)

max_coordagents database manager configuration parameter (4153)

max_logicagents configuration parameter (4154)

max_querydegree configuration parameter (4283)

max_time_diff database manager configuration parameter (4280)

MA_free element (4535)

MA_free_bottom element (4537)

memory

agent communication memory (4117)

agent private memory (4103)

application communication memory (4118)

application shared memory (4100)

database manager instance (4122)

database shared memory (4089)

message anchor (4275)

message anchors currently free, monitor element (4534)

mincommit configuration parameter (4177)

minimum connection entries, monitor element (4540)

minimum fcm buffers free, monitor element (4532)

minimum message anchors, monitor element (4536)

minimum request blocks, monitor element (4544)

min_priv_mem configuration parameter (4113)

miscellaneous operators, changing color from Command Center (3671)

monitoring run-time activities (3734)

mon_heap_sz configuration parameter (4124)

most recent connection elapsed time, monitor element (4968)

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

most recent statement elapsed time, monitor element (4820)

most recent unit of work elapsed time monitor element (4439)

moving a process (3800)

moving a step (3835)

moving a target table (3902), (3908)

Moving Average transformer (3855), (3856), (3857), (3865)

moving data (3733)

MSJOIN operator, definition (2902)

MSJOIN operator, description (3603)

multipage_alloc configuration parameter (4237)

multiple databases, testing and configuring (2659)

multisite update (2700)

multisite update, configuring using wizard (2966)

multisite update, testing (2969)

named pipe, configuring (2986)

named pipe, properties (2987)

names, missing from lists (2667)

names, not appearing in lists (2669)

national language characters, ASCII values for Alt-Gr key combinations (2660)

NetBIOS, configuring (2988)

NetBIOS, definition (5000)

NetBIOS, properties (2989)

new data source, accessing (2871)

newlogpath configuration parameter (4171)

nicknames, changing options (2999), (3002)

nicknames, creating (2870), (2995), (2998), (3001), (3003)

nicknames, description (5018)

nicknames, options (2997), (3000)

NLJOIN operator, definition (2903)

NLJOIN operator, description (3604)

nname configuration parameter (4247)

node number, monitor element (4422)

node settings, changing from Command Center (3665)

node states (5079)

node, viewing in the alert center (3456)

nodegroup, altering (3006)

nodegroup, creating (3008)

nodes, diagnostics log (3014)

nodes, invoking actions when status changes (2633)

nodes, starting (3011)

nodes, stopping (3012)

nodes, tracing (3013)

nodetype configuration parameter (4308)

node_number element (4423)

non-DB2 data source statistics, viewing (4075)

nondelimited ASCII format (ASC), description (5001)

notebooks, Access Plan Graph Settings (3458)

notebooks, Add Group (2815)

notebooks, Add User (2837)

notebooks, Advanced Subscription Definition (3020)

notebooks, Alter Table (3101)

notebooks, Alter Trigger (3248)

notebooks, Applications (2957)

notebooks, Authorities (database) (2727)

notebooks, Backup Database (2729)

notebooks, Backup Database Partition (2728)

notebooks, Backup Table Space (3206)

notebooks, Backup Table Space Partition (3207)

notebooks, Change Batch Steps (3932)

notebooks, Change Group (2814)

notebooks, Change Level (3930)

notebooks, Change Monitor (3383), (3392)

notebooks, Change Replication Parameters (3977)

notebooks, Change User (2836)

notebooks, Command Center (3613), (3619), (3621), (3624), (3628) , (3630), (3632), (3635), (3637), (3642) , (3645)

notebooks, Command Center Options (3643), (3646)

notebooks, Configure Database (2749)

notebooks, Configure Instance (2965)

notebooks, Create Database from Backup (2730)

notebooks, Create Monitor (3384), (3396)

notebooks, Create Satellite (3924)

notebooks, Create Table (3134)

notebooks, Create Trigger (3257)

notebooks, Data Warehouse Center Properties (3719)

notebooks, Edit Batch (3957)

notebooks, Edit Satellite (3994)

notebooks, Export (3149)

notebooks, Export Warehouse Schema (3753)

notebooks, Filter (2622)

notebooks, Import (3103)

notebooks, Information Center (4025)

notebooks, Journal (3615)

notebooks, License Center (4038)

notebooks, Load (3175)

notebooks, Load Table Partition (3176)

notebooks, Locate (2627)

notebooks, Privileges (index) (2925)

notebooks, Privileges (schema) (3074)

notebooks, Privileges (table) (3102)

notebooks, Privileges (view) (3267)

notebooks, Restore Database (2731)

notebooks, Restore Database Partition (2732)

notebooks, Restore Database to New (2733)

notebooks, Restore Table Space (3208)

notebooks, Restore Table Space Partition (3209)

notebooks, Roll-Forward Database (2734)

notebooks, Roll-Forward Database Partition (2735)

notebooks, Roll-Forward Table Space (3210)

notebooks, Roll-Forward Table Space Partition (3211)

notebooks, Schedule (3731)

notebooks, Show Monitor (3386)

notebooks, Show Related (2650)

notebooks, Subscription Timing (3021)

notebooks, Tools Settings (2661)

notebooks, View Batch (3959)

notebooks, View Level (4024)

notebooks, Warehouse Group (3721)

notebooks, Warehouse Schema Properties (3829)

notebooks, Warehouse Target (3725)

notebooks, Warehouse User (3720)

notification messages, changing (3749)

notification messages, creating for a process or step (3811)

notifylevel configuration parameter (4292)

null indicator flags, description (5020)

null indicators, description (5019)

number of agents created, monitor element (4872)

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

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

number of associated agents, monitor element (4496)

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

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

number of database backups configuration parameter (4189)

number of event monitor overflows, monitor element (4904)

number of idle agents, monitor element (4480)

number of lock escalations, monitor element (4665)

number of lock timeouts, monitor element (4679)

number of log pages read, monitor element (4646)

number of log pages written, monitor element (4648)

number of nodes in partition, monitor element (4902)

number of nodes, monitor element (4546)

number of open cursors, monitor element (4942)

number of rollforward table spaces, monitor element (4725)

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

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

number of SQL statements attempted, monitor element (4940)

number of successful fetches, monitor element (4826)

number_nodes element (4547)

numdb configuration parameter (4306)

numsegs configuration parameter (4141)

num_agents element (4871)

num_assoc_agents element (4497)

num_compilation element (4863)

num_db_backups configuration parameter (4188)

num_estore_segs configuration parameter (4144)

num_executions element (4861)

num_freqvalues configuration parameter (4243)

num_gw_conn_switches element (4503)

num_initagents database manager configuration parameter (4156)

num_initdaris configuration parameter (4163)

num_iocleaners configuration parameter (4136)

num_ioservers configuration parameter (4137)

num_nodes_in_db2_instance element (4903)

num_poolagents database manager configuration parameter (4155)

num_quantiles configuration parameter (4244)

num_subagents element (4843)

object tree toolbar (2672)

object tree, description (2673)

object tree, expanding and collapsing (2618)

objectname configuration parameter (4251)

objects, creating in the Control Center (2605)

objects, displaying in the Control Center (2608)

objects, finding in the contents pane (2623)

objects, finding in the Information Center (4035)

objects, list of icons (4081)

objects, related (3818)

objects, selecting multiple (2822)

objects, working with in the Control Center (2640)

obsolete batch, description (5046)

open local cursors with blocking, monitor element (4767)

open local cursors, monitor element (4765)

open remote cursors with blocking, monitor element (4759)

open remote cursors, monitor element (4757)

open_cursors element (4943)

open_loc_curs element (4766)

open_loc_curs_blk element (4768)

open_rem_curs element (4758)

open_rem_curs_blk element (4760)

operand settings, changing from Command Center (3667)

operand, definition (5103)

operation element (4803)

operator details, viewing from Command Center (3684)

operator details, viewing from Visual Explain (3567)

operator settings, changing from Command Center (3666)

operator, definition (5104)

operators, getting details of (3498)

operators, list of (5105)

optimization parameters, viewing from Command Center (3674)

optimization parameters, viewing from Visual Explain (3555)

optimized text, viewing from Command Center (3675)

optimizer, definition (5107)

options, page setup (3775), (3803)

ordinary identifier, definition (5081)

ordinary identifiers (name), description (2920)

outbound application ID, monitor element (4400)

outbound communication address, monitor element (4950)

outbound communication protocol, monitor element (4948)

outbound number of bytes received, monitor element (4958)

outbound number of bytes sent, monitor element (4956)

outbound sequence number, monitor element (4402)

outbound_appl_id element (4401)

outbound_bytes_received element (4959)

outbound_bytes_sent element (4957)

outbound_comm_address element (4951)

outbound_comm_protocol element (4949)

outbound_sequence_no element (4403)

overflow, definition (5080)

overflow_accesses (4746)

overhead, calculating (2706)

oversized documents, page setup (3776), (3804)

package cache inserts, monitor element (4628)

package cache lookups, monitor element (4626)

package cache overflows, monitor element (4630)

package name, monitor element (4804)

package, definition (5108)

package_name element (4805)

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

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

page reorganizations, monitor element (4755)

page setup options (3774), (3802)

page_reorgs element (4756)

parallel operations

configuration parameters (4272)

parallel prefetching (2703)

parameterized script, description (5047)

parameters, definition (5021)

parent table, definition (5022)

partial record, monitor element (4916)

partial_record element (4917)

partitioned database

configuration parameters (4271)

partitioning key, definition (5023)

pckcachesz configuration parameter (4098)

performance monitor, adding performance variables (3413), (3430)

performance monitor, changing a monitor (3391)

performance monitor, changing the default monitor (3389)

performance monitor, copying a monitor (3393)

performance monitor, creating a monitor (3395)

Performance Monitor, definition (5082)

performance monitor, details graph (3441)

performance monitor, editing graph (3426)

performance monitor, introduction (3388)

performance monitor, listing monitored objects (3410)

performance monitor, making changes to an active monitor (3397)

performance monitor, Monitoring Performance (3387)

performance monitor, removing monitors (3398)

performance monitor, removing performance variables (3417)

performance monitor, renaming a monitor (3400)

performance monitor, saving a monitor (3402)

performance monitor, starting a monitor (3404)

performance monitor, stopping monitors (3406)

performance monitor, summaries (3445)

performance monitor, thresholds (3433)

performance monitor, viewing a list of monitors (3408)

performance monitor, viewing details collected (3422)

performance monitor, viewing performance variables (3420)

performance snapshot, definition (5085)

performance statistics for steps, viewing (3832)

performance variable thresholds (3434)

performance variable, definition (5083)

performance variables, accessing the IBM-supplied (4984)

performance variables, adding to a monitor (3412)

performance variables, adding to graph (3428)

performance variables, categories of (5084)

performance variables, deleting from graph (3429)

performance variables, details graph (3442)

performance variables, exceeding thresholds (3451)

performance variables, graphing (3425)

performance variables, introduction (4983)

performance variables, reference information (4982)

performance variables, removing from a monitor (3416)

performance variables, viewing collected (3421)

performance variables, viewing for a monitor (3419)

performance, configuring database parameters (2763), (2800)

performance, improving for a database with different workloads (2765), (2802)

performance, troubleshooting after running Configure Performance wizard (2793)

PIPE operator, definition (2904)

piped sorts accepted, monitor element (4510)

piped sorts requested, monitor element (4508)

piped_sorts_accepted element (4511)

piped_sorts_requested element (4509)

Pivot Data transformer (3868)

pkg_cache_inserts element (4629)

pkg_cache_lookups (4627)

pkg_cache_num_overflow element (4631)

pkg_cache_size_top element (4633)

point-in-time replication step, defining (3895)

pool_async_data_reads element (4573)

pool_async_data_read_reqs element (4585)

pool_async_data_writes element (4575)

pool_async_index_reads element (4579)

pool_async_index_writes element (4577)

pool_async_read_time element (4581)

pool_async_write_time element (4583)

pool_data_from_estore element (4603)

pool_data_l_reads element (4555)

pool_data_p_reads element (4557)

pool_data_to_estore element (4599)

pool_data_writes element (4559)

pool_drty_pg_steal_clns (4589)

pool_drty_pg_thrsh_clns element (4591)

pool_index_from_estore element (4605)

pool_index_l_reads element (4561)

pool_index_p_reads element (4563)

pool_index_to_estore element (4601)

pool_index_writes element (4565)

pool_lsn_gap_clns element (4587)

pool_read_time element (4567)

pool_write_time element (4569)

Population types (3901)

post threshold sorts, monitor element (4506)

post_threshold_hash_joins element (4523)

post_threshold_sorts element (4507)

predicate, definition (5109)

prefetch (2705)

prefetch_wait_time element (4597)

prep_time_best element (4867)

prep_time_worst element (4865)

previous transaction stop time, monitor element (4446)

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

prev_stop_time element (4447)

prev_uow_stop_time element (4434)

printing books (4029)

priv_mem_thresh configuration parameter (4114)

process or thread id, monitor element (4450)

process, adding source (3780)

process, adding target (3783)

process, moving (3801)

process, removing a source (3788)

process, removing a target (3791)

product identification, monitor element (4348)

product name, monitor element (4346)

production batch, description (5048)

production satellite, description (5049)

production satellite, staging a rollout (3939)

product_name element (4347)

promoting a step (3784)

properties, on operator details (3595)

protocol, definition (5002)

queries, designing (3534)

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

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

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

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

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

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

query 4 of Visual Explain examples, creating additional indexes on table columns (3507), (3512)

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

query cost estimate, monitor element (4832)

query number of rows estimate, monitor element (4830)

query optimization class, definition (5110)

query_card_estimate element (4831)

query_cost_estimate element (4833)

query_heap_sz configuration parameter (4109)

RB_free element (4543)

RB_free_bottom element (4545)

recovery

configuration parameters (4182)

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

recovery history, restoring (3706)

recovery, level (2702)

rec_his_retentn configuration parameter (4190)

Reference tab (4027)

referenced column statistics, viewing from Command Center (3693)

referenced column statistics, viewing from Visual Explain (3584)

referenced columns, viewing from Command Center (3692)

referenced columns, viewing from Visual Explain (3582)

Registered User, adding (4041)

Regression transformer (3858)

Regresssion transformer (3859)

rejected block cursor requests, monitor element (4761)

rej_curs_blk element (4762)

related objects, showing (3819)

relationships, see cascade relationships (3824)

release configuration parameter (4208)

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

remote connections to database manager, monitor element (4454)

removing a source from a process (3786)

removing a target from a process (3789)

removing performance variables from a monitor (3418)

rem_cons_in element (4455)

rem_cons_in_exec (4457)

REORG (Visual Warehouse 5.2 version) (3843)

reorg command (3532)

Reorganizing a DB2 for OS/390 table space (3899), (3918)

reorganizing data (3871)

reorganizing table data (3528)

reorganizing, definition (5024)

reorgchk command (3530)

replication parameters, changing (3976)

replication source, adding a (3049)

replication source, changing a (3051)

replication source, confirming removal (3052)

replication sources, changing (3061)

replication sources, defining a join (3065)

replication sources, defining custom (3063)

replication sources, defining default (3067)

replication sources, deleting (3070)

replication sources, dropping (3071)

replication sources, promoting (3981)

replication sources, quick definition (3068)

replication sources, removing (3069)

replication sources, running (3072)

replication sources, setting defaults for defining (2645)

replication subscriptions, activating (3023)

replication subscriptions, changing (3025)

replication subscriptions, cloning (3027)

replication subscriptions, creating (3030)

replication subscriptions, deactivating (3024)

replication subscriptions, deferring (3060)

replication subscriptions, defining (3029)

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

replication subscriptions, defining, changing columns (3039)

replication subscriptions, defining, creating columns (3035)

replication subscriptions, defining, data blocking (3048)

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

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

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

replication subscriptions, defining, showing keys (3037)

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

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

replication subscriptions, defining, subset of rows (3041)

replication subscriptions, defining, target columns (3034)

replication subscriptions, deleting (3055)

replication subscriptions, dropping (3056)

replication subscriptions, generalizing (3979)

replication subscriptions, promoting (3983)

replication subscriptions, removing (3054)

replication subscriptions, running (3057)

replication subscriptions, setting defaults for defining (2646)

replication, overview (3022)

request blocks currently free, monitor element (4542)

resetting counters (5065)

restbufsz configuration parameter (4096)

restore database, level of recovery (2693)

restore database, roll forward (2698)

restore, backup image (2695)

restore_pending configuration parameter (4236)

resync_interval configuration parameter (4198)

RETURN operator, definition (2905)

rf_log_num element (4722)

rf_num_tspaces element (4726)

rf_status element (4724)

rf_timestamp element (4716)

rf_type element (4720)

RIDSCN operator, definition (2906)

RIDSCN operator, description (3605)

roll forward (complete recovery) (2696)

roll-forward pending, definition (5027)

roll-forward, definition (5026)

rollback statements attempted, monitor element (4777)

rollback_sql_stmts (4778)

rolled back agent, monitor element (4711)

rolled back application, monitor element (4709)

rolled back sequence number, monitor element (4713)

rolled_back_agent_id element (4712)

rolled_back_appl_id element (4710)

rolled_back_sequence_no element (4714)

rollforward timestamp, monitor element (4715)

rollforward type, monitor element (4719)

rollfwd_pending configuration parameter (4233)

route_obj_name configuration parameter (4258)

row blocking, see cursor blocking (5096)

row predicates, examples, filter rows (3017)

rows deleted, monitor element (4733)

rows inserted, monitor element (4735)

rows read, monitor element (4743)

rows selected, monitor element (4739)

rows updated, monitor element (4737)

rows written, monitor element (4741)

rows_deleted element (4734)

rows_inserted element (4736)

rows_read element (4744)

rows_selected element (4740)

rows_updated element (4738)

rows_written element (4742)

rqrioblk configuration parameter (4120)

RQUERY operator, definition (2907)

Run FTP Command File (VWPFTP) (3875)

running statistics (3872)

RUNSTATS (Visual Warehouse 5.2 version) (3850)

runstats WITH DISTRIBUTION command (3520)

runstats, using (3523)

Sample Programs tab (4032)

samples, performance monitor (3423)

Satellite Administration Center, using (3919)

satellite control server, description (5051)

satellite, creating (3923)

satellite, description (5050)

satellite, fixing (3940)

satellites, configuring as production satellite (3986)

satellites, configuring as test satellite (3987)

satellites, copying (3988)

satellites, deleting (3990)

satellites, disabling (3991)

satellites, disabling all in a group (3992)

satellites, editing (3993)

satellites, enabling (3995)

satellites, enabling all in a group (3996)

satellites, promoting (3997)

satellites, setting execution starting point (3999)

satellites, viewing details (4001)

saving files using the Control Center file extension (2631)

schedule patterns or instances, creating for a process or step (3812)

scheduling a step (3792)

scheduling, overview (3730)

schema, definition (2917)

schemas, ALTERIN privilege (2812)

schemas, altering comments (3075)

schemas, changing comments (3076)

schemas, CREATEIN privilege (2810)

schemas, creating (3078)

schemas, creating (DB2 for OS/390 V6) (3341)

schemas, DROPIN privilege (2811)

schemas, dropping (2612)

schemas, generating DDL (DB2 for OS/390 V6) (3314)

schemas, granting privileges to user groups (3082)

schemas, granting privileges to users (3080)

schemas, privileges on (2886)

schemas, revoking privileges from user groups (3083)

schemas, revoking privileges from users (3081)

script for a threshold (3438)

script options, changing (3644)

script, adding to batch (3935)

script, importing to a batch (3933)

scripts, copying (4002)

scripts, deleting (4003)

scripts, editing (4004)

scripts, renaming (4006)

scripts, selecting (4008)

scripts, showing contents of (3701)

scripts, viewing details (4010)

search discovery communications protocols configuration parameter (4266)

secondary connections, monitor element (4494)

secondary logs allocated currently, monitor element (4644)

section inserts, monitor element (4636)

section lookups, monitor element (4634)

section number, monitor element (4806)

section_number element (4807)

sec_logs_allocated element (4645)

sec_log_used_top element (4641)

select a script for a threshold (3440)

select SQL statements executed, monitor element (4779)

selecting a source for a step (3794)

selecting a target for a step (3796)

selecting, server options (3086)

selectivity of predicates (5111)

select_sql_stmts element (4780)

seqdetect configuration parameter (4139)

sequence number holding lock, monitor element (4707)

sequence number, monitor element (4388)

sequence_no element (4389)

sequence_no_holding_lk element (4708)

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

server instance name, monitor element (4334)

server operating system, monitor element (4344)

server options, viewing (3087)

server product/version ID, monitor element (4338)

server version, monitor element (4340)

servers, adding options (3090)

servers, altering server options (3092)

servers, creating (2868), (3084), (3088)

servers, DB2 Server for VSE & VM, adding to the object tree (2602)

servers, dropping an option (3094)

server_db2_type element (4337)

server_instance_name element (4335)

server_nname element (4333)

server_platform element (4345)

server_prdid element (4339)

server_version element (4341)

service level, monitor element (4342)

service name, definition (5029)

service_level element (4343)

SET CURRENT EXPLAIN SNAPSHOT command (3477)

setup batch, description (5053)

setup communications (2981)

sheapthres configuration parameter (4105)

show related, objects (2662)

showing command or showing SQL (2647)

showing related objects (3816)

snapshot time, monitor element (4900)

snapshots, samples for Visual Explain (3466)

softmax configuration parameter (4178)

SORT operator, definition (2908)

SORT operator, description (3606)

sort overflows, monitor element (4516)

sortheap configuration parameter (4104)

sorting the list of displayed objects (2652)

sort_heap_allocated element (4505)

sort_overflows element (4517)

source table, copying (3905)

source, adding to a process (3779)

source, changing (3764)

source, removing from process (3787)

space management (2680)

spatial analysis (2864)

spatial data, importing (2860)

spatial indexes, creating (2862)

spatial layers, creating (2858)

spatial reference systems, creating (2856)

Specifying a Data Warehouse Center agent to access user objects (3740)

specifying file options (3151)

spm_log_file_sz configuration parameter (4201)

spm_log_path configuration parameter (4199)

spm_max_resync configuration parameter (4202)

spm_name configuration parameter (4200)

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

SQL dynamic statement text, monitor element (4822)

SQL expressions, examples, computed columns clause (3018)

SQL expressions, examples, WHERE clause (3019)

SQL requests since last commit, monitor element (4793)

SQL statement subsection, definition (5087)

SQL statement, dynamically explaining (3519)

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

SQL statement, dynamically explaining from Command Center (3672)

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

SQL statement, viewing text (3541)

SQL statements in Index wizard workload, viewing (2947)

SQL statements, adding to Index wizard workload (2939)

SQL statements, analyzing using Visual Explain (3459)

SQL statements, changing on Index wizard workload (2941)

SQL statements, executing (3618), (3627)

SQL statements, importing (2943)

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

SQL step (3888)

SQL text, viewing from Command Center (3677)

SQL text, viewing from Visual Explain (3542)

SQL, editing (Data Warehouse Center) (3751)

sqlca element (4829)

sql_reqs_since_commit element (4794)

sql_stmts element (4941)

ss_exec_time element (4841)

ss_logon configuration parameter (4321)

ss_node_number element (4837)

ss_number element (4835)

ss_status element (4839)

ss_sys_cpu_time element (4891)

ss_usr_cpu_time element (4889)

staging table replication step, defining (3896)

star joins (5112)

start database manager timestamp, monitor element (4331)

start_stop_time database manager configuration parameter (4282)

start_time element (4819)

statement best preparation time, monitor element (4866)

statement compilations, monitor element (4862)

statement executions, monitor element (4860)

statement node, monitor element (4795)

statement operation start timestamp, monitor element (4812)

statement operation stop timestamp, monitor element (4814)

statement operation, monitor element (4801)

statement sorts, monitor element (4824)

statement termination character, setting for Command Center (2654)

statement termination character, setting for Script Center (2655)

statement type, monitor element (4799)

statement worst preparation time, monitor element (4864)

statement, definition (5088)

static SQL statements attempted, monitor element (4769)

static SQL statements, creating explain snapshots for (3480)

static SQL, definition (5113)

static_sql_stmts (4770)

statistics for steps, viewing (3830)

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

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

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

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

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

statistics, generating using runstats (3524)

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

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

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

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

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

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

statistics, running (3873)

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

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

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

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

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

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

statistics, updating DBSpaces (2866)

Statistics, viewing (4073)

status element (4443)

status of database, monitor element (4364)

status of DB2 instance, monitor element (4350)

status_change_time element (4381)

stat_heap_sz configuration parameter (4108)

step, copying (3838)

step, creating a shortcut (3758)

step, moving (3836)

step, promoting (3785)

step, scheduling (3793)

step, selecting a source (3795)

step, selecting a target (3797)

step, testing (3799)

steps (new), running (3809)

steps, cancelling (3806), (3834), (3915)

steps, purging from Work in Progress window (3913)

steps, rerunning (3916)

steps, running from Work in Progress window (3914)

steps, viewing the current status (3917)

stmtheap configuration parameter (4106)

stmt_elapsed_time element (4821)

stmt_node_number element (4796)

stmt_operations element (4802)

stmt_sorts element (4825)

stmt_start element (4813)

stmt_stop element (4815)

stmt_sys_cpu_time element (4883)

stmt_text element (4823)

stmt_type element (4800)

stmt_usr_cpu_time element (4881)

stolen agents, monitor element (4488)

stop performance monitoring, from alert center (3453)

stop_time element (4817)

storage groups, creating (DB2 for OS/390 V5) (3343)

storage groups, creating (DB2 for OS/390 V6) (3345)

stored procedure, definition (5003)

stored procedures

configuration parameters (4157)

stored procedures, generating DDL (DB2 for OS/390 V6) (3323)

subject area, defining (3723)

Submit MVS JCL jobstream (VWPMVS) (3876)

subscription definitions, changing (3974)

subsection execution elapsed time, monitor element (4840)

subsection node number, monitor element (4836)

subsection number, monitor element (4834)

subsection status, monitor element (4838)

success code sets, creating (4011)

success code sets, deleting (4013)

success code sets, editing (4014)

success code sets, viewing details (4016)

summary information, performance monitor (3446)

suspending alerts (3454)

svcename configuration parameter (4248)

switches, for the monitor (5086)

synchronization, description (5052)

synonyms, creating (DB2 for OS/390) (3347)

sysadm_group configuration parameter (4315)

sysctrl_group configuration parameter (4316)

sysmaint_group configuration parameter (4317)

system catalog tables (2681)

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

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

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

system CPU time, monitor element (4886)

system database directory, definition (5031)

system management

configuration parameters (4303)

system, changing (3098)

system, definition (5030)

system-managed table space, definition (5114)

systems, adding (3096)

systems, adding to the object tree (2597)

systems, attaching to (2751)

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

systems, DB2 Universal Database for OS/390, adding to the object tree (2600)

systems, removing (2609)

system_cpu_time element (4887)

table data, reorganizing (3529)

table design, tuning (3535)

table file ID, monitor element (4753)

table function statistics, viewing from Command Center (3697)

table function statistics, viewing from Visual Explain (3590)

table name, monitor element (4729)

table partition, definition (5032)

table partitions, loading data into (3205)

table schema name, monitor element (4731)

table space name, monitor element (4693)

table space partition, altering (3243)

table space partition, altering characteristics (3215)

table space partition, backing up (3221), (3244)

table space partition, changing characteristics (3216)

table space partition, definition (5033)

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

table space partition, modifying containers during restore (3231)

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

table space partition, restoring (3229), (3245)

table space partition, rolling forward (3235), (3246)

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

table space statistics, viewing from Command Center (3679)

table space statistics, viewing from Visual Explain (3559)

table space, backing up (3220)

table space, definition (5115)

table space, DMS (5098)

table space, granting privileges for users (3238)

table space, granting the USE privilege (2823), (2833), (2851)

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

table space, modifying containers during restore (3230)

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

table space, restoring (3228)

table space, revoking USE privilege (2825), (2853)

table space, rolling forward (3234)

table spaces, altering (DB2 for OS/390 V5) (3331)

table spaces, altering (DB2 for OS/390 V6) (3335)

table spaces, altering characteristics (3212)

table spaces, changing characteristics (3213)

table spaces, creating (3222)

table spaces, creating (DB2 for OS/390 V5) (3333)

table spaces, creating (DB2 for OS/390 V6) (3339)

table spaces, creating (DB2 for OS/390) (3369), (3370)

table spaces, creating (defining) using wizard (3224)

table spaces, generating DDL (DB2 for OS/390 V5) (3302)

table spaces, generating DDL (DB2 for OS/390 V6) (3305)

table spaces, getting statistics (3492)

table spaces, granting privileges for groups (3240)

table spaces, removing (2613)

table spaces, renaming (3226)

table spaces, revoking privileges for groups (3241)

table spaces, revoking privileges for users (3239)

table spaces, viewing from Command Center (3678)

table spaces, viewing from Visual Explain (3557)

table spaces, viewing information about (3707)

table statistics, viewing from Command Center (3690)

table statistics, viewing from Visual Explain (3579)

table type, monitor element (4727)

table, ALTER privilege (2883)

tables REFERENCES privilege (2885)

tables, adding to process (3760)

tables, altering (DB2 for OS/390 V5) (3349)

tables, altering (DB2 for OS/390 V6) (3351)

tables, altering check constraints (3124)

tables, altering column (3108)

tables, altering column categories (3112)

tables, altering foreign keys (3120)

tables, altering new columns (3111)

tables, altering partitioning key (3116)

tables, altering primary key (3114)

tables, altering properties (3104)

tables, altering, adding check constraints (3122)

tables, altering, adding columns (3106)

tables, altering, adding foreign keys (3118)

tables, autojoininig in a warehouse schema (3825)

tables, basic copy, description (3202)

tables, changing check constraints (3125)

tables, changing column (3109)

tables, changing column categories (3113)

tables, changing foreign keys (3121)

tables, changing length of VARCHAR column (3110)

tables, changing partitioning key (3117)

tables, changing primary key (3115)

tables, changing properties (3105)

tables, changing, adding check constraints (3123)

tables, changing, adding columns (3107)

tables, changing, adding foreign keys (3119)

tables, column default values (2877)

tables, constraint checking, turning off (3194)

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

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

tables, constraint checking, when to set (3201)

tables, CONTROL privilege (2882)

tables, copying (basic) (3131)

tables, creating (DB2 for OS/390 V5) (3353)

tables, creating (DB2 for OS/390 V6) (3355), (3366)

tables, creating (defining) (3133)

tables, creating (defining) using wizard (3143)

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

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

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

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

tables, creating (defining), changing column categories (3138)

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

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

tables, creating (defining), defining properties (3135)

tables, creating (importing data into) (3169)

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

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

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

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

tables, creating views on (3273)

tables, DELETE privilege (2881)

tables, deleting (3146)

tables, dropping (3145)

tables, exporting to files (3147), (3150)

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

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

tables, filtering (3004)

tables, generating DDL (DB2 for OS/390 V5) (3308)

tables, generating DDL (DB2 for OS/390 V6) (3311)

tables, granting privileges for groups (3160)

tables, granting privileges for users (3158)

tables, importing data into (3162)

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

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

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

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

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

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

tables, INDEX privilege (2884)

tables, INSERT privilege (2879)

tables, loading data into (3174)

tables, loading data into, collecting statistics (3182)

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

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

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

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

tables, loading data into, saving changes (3183)

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

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

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

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

tables, locking (3127)

tables, quiescing (3126)

tables, renaming (3187)

tables, reorganizing (3189)

tables, reorganizing, description (5025)

tables, revoking privileges for groups (3161)

tables, revoking privileges for users (3159)

tables, running statistics (3191)

tables, SELECT privilege (2878)

tables, selecting or creating for warehouse schema (3767)

tables, unlocking (3129)

tables, unquiescing (3128)

tables, UPDATE privilege (2880)

tables, updating table statistics (3197)

tables, viewing contents (3199)

tablespace being rolled forward, monitor element (4717)

tablespace_name element (4694)

table_file_id element (4754)

table_name element (4730)

table_schema element (4732)

table_type element (4728)

target table, copying (3907)

target table, moving (3903), (3909)

target, adding to a process (3782)

target, changing (3766)

target, removing from process (3790)

targets, creating (4017)

targets, deleting (4019)

targets, editing (4020)

targets, viewing details (4022)

Tasks tab (4026)

TBSCAN operator, definition (2909)

TBSCAN operator, description (3607)

TCP/IP, configuring (2990)

TCP/IP, definition (5004)

TCP/IP, properties (2991)

TEMP operator, definition (2910)

TEMP operator, description (3608)

temporary table (5034)

territory configuration parameter (4210)

test batch, description (5054)

test satellite, description (5055)

testing a step (3798)

testing multiple databases (2657)

testing, multisite update (2968)

threshold, select a script (3439)

thresholds, performance monitor (3435)

time of database connection, monitor element (4360)

time of first event overflow, monitor element (4906)

time of last event overflow, monitor element (4908)

time waited for prefetch, monitor element (4596)

time waited on locks, monitor element (4691)

time zone displacement, monitor element (4352)

timeron (2924)

timestamp, data elements (4329)

time_stamp element (4901)

time_zone_disp element (4353)

Tivoli Storage Manager (ADSM)

configuration parameters (4184)

tm_database configuration parameter (4197)

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

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

total fcm buffers received, monitor element (4552)

total fcm buffers sent, monitor element (4550)

total hash joins, monitor element (4520)

total hash loops, monitor element (4524)

total inactive DRDA agents, monitor element (4500)

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

total log available, monitor element (4655)

total log space used, monitor element (4653)

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

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

total sort heap allocated , monitor element (4504)

total sort time, monitor element (4514)

total sorts, monitor element (4512)

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

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

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

total_buffers_rcvd element (4553)

total_buffers_sent element (4551)

total_cons element (4465)

total_exec_time element (4869)

total_hash_joins element (4521)

total_hash_loops element (4525)

total_log_available element (4656)

total_log_used element (4654)

total_sec_cons element (4495)

total_sorts element (4513)

total_sort_time element (4515)

tot_log_used_top element (4643)

tot_s_cpu_time element (4893)

tot_u_cpu_time element (4895)

TP monitor client accounting string, monitor element (4980)

TP monitor client application name, monitor element (4978)

TP monitor client user ID, monitor element (4974)

TP monitor client workstation name, monitor element (4976)

tpmon_acc_str element (4981)

tpmon_client_app element (4979)

tpmon_client_userid element (4975)

tpmon_client_wkstn element (4977)

tpname configuration parameter (4249)

tp_mon_name configuration parameter (4307)

TQUEUE operator, definition (2911)

TQUEUE operator, description (3609)

tq_cur_send_spills element (4851)

tq_id_waiting_on element (4859)

tq_max_send_spills element (4857)

tq_node_waited_for element (4847)

tq_rows_read element (4853)

tq_rows_written element (4855)

tq_tot_send_spills element (4849)

tq_wait_for_any element (4845)

transaction ID, monitor element (4962)

transaction manager (TM) database, description (2922)

transaction processing (TP) monitor, description (2923)

transaction, definition (5089)

transfer rates, calculating (2707)

transforming data (3732)

triggers, altering comments (3249)

triggers, copying triggered action (3255)

triggers, creating (3256)

triggers, creating (DB2 for OS/390 V6) (3357)

triggers, creating, specifying associated table (3252)

triggers, creating, specifying conditions for execution (3253)

triggers, creating, specifying name and schema (3251)

triggers, creating, specifying triggered action (3254)

triggers, definition (5035)

triggers, deleting (3259)

triggers, dropping (3258)

triggers, viewing definition (3250)

Troubleshooting tab (4031)

troubleshooting tip, catching inefficient access plans (3592)

troubleshooting, performance after running Configure Performance wizard (2792)

trust_allclnts configuration parameter (4322)

trust_clntauth configuration parameter (4323)

tsm_mgmtclass configuration parameter (4192)

tsm_nodename configuration parameter (4194)

tsm_owner configuration parameter (4195)

tsm_password configuration parameter (4193)

ts_name element (4718)

types of logging (2688), (2690)

udf_mem_sz configuration parameter (4111)

uid_sql_stmts element (4782)

unassigned batch, description (5056)

UNION operator, definition (2912)

UNIQUE operator, definition (2913)

UNIQUE operator, description (3610)

unit of work completion status, monitor element (4441)

unit of work log space used, monitor element (4650)

unit of work start timestamp, monitor element (4435)

unit of work status, monitor element (4444)

unit of work stop timestamp, monitor element (4437)

uow_comp_status element (4442)

uow_elapsed_time element (4440)

uow_lock_wait_time element (4700)

uow_log_space_used element (4651)

uow_start_time element (4436)

uow_status element (4445)

uow_stop_time element (4438)

update batch, description (5057)

Update DB2 for OS/390 table space statistics (3892)

UPDATE operator, definition (2914)

UPDATE operator, description (3611)

update operators, changing color from Command Center (3670)

Update outline from file (3887)

Update outline from SQL table (3881)

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

updating multiple databases (2658)

USE privilege, granting (2824), (2834), (2852)

USE privilege, revoking (2826), (2854)

user authorization level, monitor element (4420)

User based policy (4064)

user copy replication step, defining (3889)

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

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

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

user CPU time, monitor element (4884)

user defined functions, generating DDL (DB2 for OS/390 V6) (3320)

user ids, setting (2753)

user login ID, monitor element (4404)

user mapping, description (5036)

user mappings, adding (3260)

user mappings, altering (3264)

user mappings, creating (2869), (3262)

user options, viewing (3261)

User Program Group notebook (3728)

user tables (2679), (2682)

User, removing (4060), (4062)

user-defined functions, getting statistics (3495)

user-defined tables (2678)

User-Program notebook (3729)

userexit configuration parameter (4180)

users, adding (2844)

users, authorizations for (4986)

users, changing database authorities (2838)

users, changing index privileges (2841), (2842)

users, changing schema privileges (2839)

users, changing table privileges (2840)

users, changing view privileges (2843)

users, granting database authorities to new (2845)

users, granting index privileges to new (2848), (2849)

users, granting schema privileges to new (2846)

users, granting table privileges to new (2847)

users, granting view privileges to new (2850)

users, to receive notification messages (3770)

user_cpu_time element (4885)

user_exit_status configuration parameter (4235)

Using concurrent copy on object lists (3360)

using Concurrent Copy on Utility Procedures (3359)

Using copy on object lists (3361)

using Copy on Utility Procedures (3358), (3373)

Using quiesce on object lists (3362)

using Quiesce on Object Lists (3372)

using Quiesce on Utility Procedures (3363), (3364), (3371)

utility identifier template, DB2 Universal Database for OS/390 (2637)

util_heap_sz configuration parameter (4094)

version element (4913)

version of monitor data, monitor element (4912)

VESAMPL.DDL command (3467)

views, adding to process (3762)

views, altering comments (3268)

views, CONTROL privilege (2890)

views, creating (3272)

views, creating, example SQL (3266)

views, DELETE privilege (2889)

views, deleting (3274)

views, description (3282)

views, dropping (3275)

views, exporting to files (3148), (3152)

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

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

views, granting privileges for groups (3278)

views, granting privileges for users (3276)

views, INSERT privilege (2887)

views, related, description (3283)

views, revoking privileges for groups (3279)

views, revoking privileges for users (3277)

views, specifying file options (3153)

views, UPDATE privilege (2888)

views, viewing contents (3280)

views, viewing SQL (3269)

Visual Explain, about (5116)

Visual Explain, learning about (3460)

Visual Explain, windows (3463)

VM, DB2 Server for VSE & VM, adding to the object tree (2604)

VSE, DB2 Server for VSE & VM, adding to the object tree (2603)

VWPEXPT1 (Visual Warehouse 5.2 version) (3841)

VWPLDPR (Visual Warehouse 5.2 version) (3844)

VWPLOADI (Visual Warehouse 5.2 version) (3842)

VWPLOADI for DB2 UDB for AS/400 (3891)

VWPLOADR (Visual Warehouse 5.2 version) (3840)

VWPLOADR for DB2 UDB for AS/400 (3894), (3898)

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

waited on node on a tablequeue, monitor element (4858)

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

warehouse control database, copying (3746)

warehouse schema models, generating and storing (3726)

warehouse schema, autojoining tables (3826)

warehouse schema, creating (3828)

warehouse schemas, exporting (3752)

warehouse schemas, updating (3815), (3827)

warehouse source tables, defining (3910)

warehouse source views, defining (3912)

warehouse target tables, defining (3911)

warehouse users or groups, to receive notification messages (3769)

warning thresholds (3437)

warnings, Alert Center (3450)

Web tab (4034)

WHERE clauses, examples, filter rows (3016)

window, Create Batch (3954)

window, Edit Group (3966)

window, Run New Step (3810)

windows, Access Plan Graph (3551)

windows, Add (3415)

windows, Add Database (2737)

windows, Add Instance (2961)

windows, Add or Change DMS Container (2666)

windows, Add or Change SMS Container (2665)

windows, Add Scripts (3936)

windows, add server options (3091)

windows, Add SQL (3045)

windows, Add SQL Statement (2940)

windows, Add System (3097)

windows, Alert Center (3448)

windows, Alter (index) (2928)

windows, Alter Alias (2710)

windows, Alter Buffer Pool (2719), (2724)

windows, Alter Database (2739)

windows, Alter Nodegroup (3007)

windows, Alter Schema (3077)

windows, alter server options (3093)

windows, Alter Table Space (3214)

windows, Alter Table Space Partition (3217)

windows, Alter View (3270)

windows, altering a user mapping (3265)

windows, Change Column (3040)

windows, Change Default Monitor (3390)

windows, Change Explained Statement (3544)

windows, Change Instance (2963)

windows, Change Replication Source (3062)

windows, Change SQL Statement (2942)

windows, Change Subscription (3026)

windows, Change Subscription Definition (3975)

windows, Change System (3099), (3100)

windows, Clone (replication subscription) (3028)

windows, Column Distribution Statistics (3586)

windows, Confirm Stop (2993)

windows, Confirmation (2615)

windows, Connect/Attach (2754)

windows, Copy (3132)

windows, Copy Batch (3952)

windows, Copy Group (3963)

windows, Copy Monitor (3394)

windows, Copy Satellite (3989)

windows, Copy Saved Script (3661)

windows, Create Alias (2712)

windows, Create Application Version (3926)

windows, Create Authentication (3944)

windows, Create Buffer Pool (2716), (2721)

windows, Create Column (3036)

windows, Create Group (3922)

windows, Create Index (2930)

windows, Create Index (on DB2 Server for VSE & VM) (2932)

windows, Create Nodegroup (3009)

windows, Create Schema (3079)

windows, Create Success Code (4012)

windows, Create Table Space (3223)

windows, Create Target (4018)

windows, create user mappings (3263)

windows, Create View (3271)

windows, Create Workload (2936)

windows, creating nicknames (2996)

windows, Customize Columns (2607)

windows, Database Connection Partitions (2795)

windows, Database Partitions (2796)

windows, Database Partitions -- OPERATOR (3568)

windows, Database selection (2791)

windows, Define as Replication Source (3064)

windows, Define Join (3066)

windows, Define Subscription (3031), (3050)

windows, drop server options (3095)

windows, Edit Application Version (3928)

windows, Edit Authentication (3947)

windows, Edit Command Script (3659)

windows, Edit Message (3750)

windows, Edit Script (4005)

windows, Edit Success Code (4015)

windows, Edit Target (4021)

windows, Edit Workload (2938)

windows, Estimate Size (2617)

windows, Explain SQL Statement (3518)

windows, Explainable Statements (3536)

windows, Explained Statements History (3543)

windows, File Browser (2663)

windows, Filter (2620)

windows, Filter Explainable Statements (3538)

windows, Filter Explained Statements (3549)

windows, filtering tables for nicknames (3005)

windows, Find (3546)

windows, Fix Satellite (3950)

windows, Function Statistics (3563)

windows, Functions (3561)

windows, Generalize Replication Subscription (3980)

windows, Generate DDL statements (2625)

windows, Import Script (3934), (4009)

windows, Import SQL Statements (2944)

windows, Index Statistics (3572)

windows, Indexes (3570)

windows, List Monitor (3385)

windows, List Monitored Objects (3411)

windows, List Monitors (3399), (3407), (3409)

windows, Locate Result (2628)

windows, Log (3739)

windows, Log details (3756)

windows, New Command Script (3652)

windows, Nodes (3010)

windows, Open/Import (3625), (3648)

windows, Operator Details (3566)

windows, Optimization Parameters (3554)

windows, Page Fetch Pairs Statistics (3575)

windows, Page Setup (3777), (3805)

windows, Path Browser (2664)

windows, Promote Replication Subscription (3984)

windows, Promote Satellite (3998)

windows, Promote Source (3982)

windows, Quiesce (3130)

windows, Referenced Column Statistics (3583)

windows, Referenced Columns (3581)

windows, Remove Confirmation (3053)

windows, Rename Group (3968)

windows, Rename Monitor (3401)

windows, Rename Script (4007)

windows, Rename Table (3188)

windows, Rename Table Space (3227)

windows, Reorganize (3190)

windows, Reorganize Index (on DB2 Server for VSE & VM) (2956)

windows, Restart Database (2790)

windows, Run Now (3654)

windows, Run Now or Save SQL (3059), (3073)

windows, Run SQL files (3058)

windows, Run Statistics (3193)

windows, Sample Contents (table) (3200)

windows, Sample Contents (view) (3281)

windows, Save As (3622), (3649)

windows, Save As Monitor (3403)

windows, Save Script (3647)

windows, Schedule (3616), (3633), (3657)

windows, Script Center (3614), (3650), (3656)

windows, Script Center Script (3663)

windows, Select Database (3640)

windows, Select Printer (3552)

windows, Select Tables (3768)

windows, Select Users (3772)

windows, servers (3089)

windows, Set Execution Starting Point (4000)

windows, Set Integrity (3203)

windows, Show Command (2648)

windows, Show Keys (3038)

windows, Show SQL (2649)

windows, Sort (2653)

windows, SQL (3043)

windows, SQL Statement (2948)

windows, SQL Text (3540)

windows, Start Monitor (3405)

windows, Statistics (3833)

windows, Statistics Details (3831)

windows, Table Function Statistics (3589)

windows, Table Partitions (3204)

windows, Table Space Partitions (3242)

windows, Table Space Statistics (3558)

windows, Table Spaces (3556)

windows, Table Statistics (3578)

windows, Test Multisite Update (2970)

windows, Update Table Statistics (DB2 Server for VSE & VM) (3198)

windows, Visual Explain (3462)

windows, Warehouse Schema Modeler (3727)

windows, Work in Progress (3736)

windows, Workload Details (2946)

windows, wrapper (3285)

wizards, Backup Database (2747)

wizards, Configure Multisite Update (2967)

wizards, Configure Performance (2764), (2766), (2794), (2801), (2803)

wizards, Create Database (2756)

wizards, Create Index (2934)

wizards, Create Table (3144)

wizards, Create Table Space (3225)

wizards, Restore Database (2778)

work in progress, see monitoring run-time activities (3735)

work sheet format (WSF), definition (5005)

workloads, creating (2935)

workloads, editing (2937)

workloads, viewing (2945)

World Wide Web (4033)

wrapper, description (5037)

wrappers, creating (2867), (3284)

xid (4963)

x_lock_escals element (4668)

zoom slider, for magnifying access plan graphs (3488)