Administration Guide

Index

Special Characters
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

Special Characters

$RAHBUFDIR (8583)

$RAHBUFNAME (8584)

$RAHCHECKBUF (8585)

$RAHENV (8594)

access control (5919)

authentication (5920)

concurrency, overview (6762)

database manager (6046)

database objects (6043)

using locks (6791)

view to table (6070)

XA interface considerations (6507)

access path

lock attributes, factors affecting (6850)

access path selection (6880)

access plan

cost estimate (7231)

created by compiler (7045)

db2expln (7213)

graphical representation (7221)

objects (7222)

operators (7224)

using explain facility (7216)

Visual Explain (7252)

ACTIVATE DATABASE command (7361)

activating a database (6922)

active logs

definition (6166)

definition of (6172)

versus archive logs (6173)

adding a scope (5756)

adding constraint (5762)

adding DB2 for OS/390 subsystems (5877)

adding node to system

restrictions on database operations (7420)

when redistributing nodegroup (7456)

adding space to a table space (5899)

adding table check constraint (5775)

adding unique constraint (5763)

Administering Satellites Guide and Reference (7904)

administration client (5858)

Administration Guide (7884)

Administration Server (5874)

administration tools

Command Center (5881)

overview (5857)

Script Center (5883)

administration using GUI tools (5856)

Administrative API Reference (7885)

adsm_mgmtclass configuration parameter (7687)

adsm_nodename configuration parameter (7689)

adsm_owner configuration parameter (7690)

adsm_password configuration parameter (7688)

ADSTAR Distributed Storage Manager (ADSM)

backup restrictions (6438)

client set up (on Intel) (6427)

client set up (UNIX-based platforms) (6421)

configuration parameters (7677)

environment variables (on Intel) (6428)

environment variables (UNIX-based platforms) (6422)

managing backups and log archives (6439)

setting password (on Intel) (6434)

setting password (UNIX-based platforms) (6426)

system options file (on Intel) (6432)

timeout problem resolution (6437)

use with BACKUP command (6419)

use with RESTORE command (6420)

user options file (on Intel) (6433)

using (6435)

ADVISE_INDEX table (8481)

ADVISE_INDEX table definition (8490)

ADVISE_WORKLOAD table (8482)

ADVISE_WORKLOAD table definition (8491)

advisor

index (7255)

agent (7369)

agent pool (7373)

agent pool size (num_poolagents) database manager parameter (7627)

agent process

application heap size (applheapsz) parameter (7558)

application support layer heap size (aslheapsz) parameter (7570)

maximum number of agents (maxagents) parameter (7617)

maximum number of concurrent agents (maxcagents) parameter (7615)

priority of agents (agentpri) parameter (7613)

agentpri configuration parameter (7614)

agents

application control heap size, maximum (7540)

connection entries, number (7803)

governor changes priority of (7403)

initial number of agents in pool (num_initagents) database manager parameter (7633)

maximum number of coordinating (7620)

max_coordagents database manager parameter (7621)

pool size, controlling (7628)

agent_stack_sz configuration parameter (7563)

impact on memory (7286)

aggregating function (5624)

alias

authority (5660)

naming rules (7993)

using (5658)

alias (DB2 for MVS/ESA) (5661)

alias, creating (5655)

allow reverse scans (7075), (7087)

ALTER COLUMN (5758)

ALTER NICKNAME statement, example of (5840)

ALTER privilege, definition (6020)

ALTER SERVER statement, example of (5836)

ALTER TABLE statement

adding check constraint example (5777)

adding columns example (5750)

adding keys example (5772)

adding unique constraint example (5765)

dropping check constraint example (5790)

dropping keys example (5787)

dropping unique constraint example (5782)

tips for adding constraints (5773)

ALTER TABLESPACE statement

example of (5737), (6946)

altering a column (5753)

altering a nickname (5838)

altering a server (5834)

altering a structured type (5800)

altering a table (5745)

altering constraint (5760)

altering nodegroup (5726)

altering table space (5734)

altering view (5822)

APPC, CPI-C and SNA Sense Codes (7887)

applheapsz configuration parameter (7557)

impact on memory (7279)

Application Building Guide (7886)

application control heap

application control heap size (app_ctl_heap_sz) database parameter (7538)

application control heap size (app_ctl_heap_sz) databaseparameter (7539)

application design

acquiring locks (6793)

collating sequences, guidelines (8560)

deadlock, avoiding (6845)

lock compatibility, ensuring (6829)

lock escalation (6836)

locking considerations (6866)

locks, converting of (6834)

locks, factors affecting (6848)

overriding locks (6858)

Application Development Guide (7888)

application program (6237)

control heap, setting (7543)

database partition server failure detection (6268)

governor forces (7402)

maximum number of coordinating agents at node (7625)

transaction recovery on the failed database partition server (6255)

transaction recovery when the database partition server is active (6248)

transaction recovery, overview (6238)

app_ctl_heap_sz configuration parameter

impact on memory (7278)

app_ctl_heap_sz database parameter (7541)

archive log files

for OS/2 (8424)

for UNIX-based systems (8429)

archive logs

definition (6167)

ROLLFORWARD command support (6168), (6170)

versus active logs (6174)

where stored (6175)

aslheapsz configuration parameter (7572)

impact on memory (7287)

ATTACH command

overview of (5404)

specifying Distributed Computing Environment (DCE) information (8291)

attribute

definition of (5147)

attributes (5173)

audit activities (6099)

audit facility

actions (6105)

asynchronous record writing (6111)

audit events table (6120)

authorities/privileges (6104)

behavior (6107)

checking events table (6121)

CONTEXT events table (6126)

controlling activities (6128)

error handling (6109)

ERRORTYPE parameter (6112)

events (6106)

examples (6129)

messages (6117)

OBJMAINT events table (6122)

parameter descriptions (6116)

record layouts (6119)

SECMAINT events table (6123)

synchronous record writing (6110)

syntax (6114)

SYSADMIN events table (6124)

tips and techniques (6127)

usage scenarios (6113)

VALIDATE events table (6125)

AUDIT_BUF_SZ (6108)

audit_buf_sz configuration parameter (7580)

authentication (5917)

DCE security services (5950)

definition of (5921)

Distributed Computing Environment (DCE) directory services (8276)

distributed transaction processing considerations (6496)

federated database processing (5959)

partitioned database considerations (5949)

remote client (5948)

authentication configuration parameter (7873)

authentication type (5918)

CLIENT (5926)

DCE (5944)

DCE_SERVER_ENCRYPT (5946)

DCS (5940)

DCS_ENCRYPT (5942)

SERVER (5922)

SERVER_ENCRYPT (5924)

authority (5989)

configuration parameters (7869)

database administration (DBADM) (5997), (6014)

levels of (5982)

removing DBADM from SYSADM (5993)

removing DBADM from SYSCTRL (5995)

required for BACKUP command (6284)

required for REORG utility (7348)

required for RESTORE command (6316)

required for ROLLFORWARD command (6358)

system control (SYSCTRL) (5994)

system maintenance (SYSMAINT) (5996)

tasks and required authorities (6077)

authorization (5981) See also authority

choosing for database access (5266)

definition (5980)

system administration (SYSADM) (5990)

trusted client (5937)

authorization names

create view for privileges information (6098)

retrieving for privileges information (6084)

retrieving names with DBADM authority (6087)

retrieving names with table access authority (6090)

retrieving privileges granted to (6093)

automatic restart (6230)

AUTORESTART (6144)

autorestart database configuration parameter (6487), (7679)

DB2 transaction manager considerations (6474)

XA interface considerations (6513)

avg_appls configuration parameter (7609)

affect on query optimization (6935)

backbufsz configuration parameter (7529)

backing up database

fixed-disk media (6307)

backup (6274) See also BACKUP command

buffer for (6293)

container names (6303)

frequency (6180)

images (6301)

invoking (6290)

offline (6182)

online (6181)

planning (6281)

planning your strategy (6282)

quiesce (6285)

storage considerations (6187)

user exit program (6194)

BACKUP command

access errors, error handling (6299)

authority required (6283)

buffer (6294)

concurrency control (6297)

considerations for (6276)

database alias restriction (6291)

DB2 Data Links Manager considerations (6389)

disk output created (6305)

overview of (6275)

system crash (6295), (6337)

tape output created (6306)

use with ADSTAR Distributed Storage Manager (6418)

Backup Database SmartGuide (5860)

BACKUP DATABASE utility

considerations for user exit program (8463)

default backup buffer size (backbufsz) parameter (7528)

error handling for user exits (8471)

user exit program for OS/2 (8418)

backup domain controller

configuring DB2 to use (8598)

backups

active (6378)

expired (6380)

inactive (6379)

log chain (6384)

log sequence (6382)

backup_pending configuration parameter (7732)

benchmark program

creating (7488)

sample report (7493)

SQL statements (7486)

step summary (7494)

benchmarking

db2batch tool (7489)

overview of (7483)

preparations for (7485)

testing methods (7484)

testing process (7492)

bidirectional CCSID support (8535)

CCSID table (8536)

DB2 Connect implementation (8538)

DB2 UDB implementation (8537)

BIND command

OWNER option (6059)

BIND privilege

definition of (6039)

BINDADD privilege, definition (6007)

binding

changing configuration parameters (7509)

command line processor (5521)

database utilities (5522)

default for DEGREE option (6929)

isolation level, specifying (6787)

rebinding invalid packages (6055)

BLOB (5295) See also large objects

block fetch (6890) See also row blocking

block-structured devices (5540)

broadcast inner-table joins (7159)

broadcast outer table joins (7151)

buffer pool

binding database applications (7519)

choosing number of (7302)

consideration for outer versus inner table determination (7131)

database managed storage (DMS) (7356)

larger page size and storage requirements (5375)

mapping table space to (5374)

memory required (7300)

multiple (7298)

overview of (7292)

performance considerations (7520)

sizing using buffpage configuration parameter (7517)

storage considerations (7521)

buffpage configuration parameter (7518)

affect on query optimization (6932)

impact on memory (7271)

managing multiple buffer pools (7299)

caching of database (6921)

call level interface

binding to a database (5526)

calling format for user exits

for OS/2 (8451)

for UNIX-based systems (8453)

candidate keys

identifying (5202)

capacity management configuration parameters (7514)

Cartesian products (7139)

star schema (7140)

CASCADE delete rule

overview of (5251)

cascading assignment (6593)

case sensitive names, federated database (7999)

CATALOG DATABASE

example of (5529)

CATALOG GLOBAL DATABASE command

specifying Distributed Computing Environment (DCE) information (8289)

catalog node (6209)

connection for data redistribution (7467)

description (5416)

importance for recovery (6210)

catalog views (5333), (8338) See also system catalog, system catalog

BUFFERPOOLNODES (8343)

BUFFERPOOLS (8344)

CASTFUNCTIONS (8345)

CHECKS (8346)

COLAUTH (8347)

COLCHECKS (8348)

COLDIST (7011), (8349)

COLOPTIONS (8350)

COLUMNS (7007), (8351)

CONSTDEP (8352)

DATATYPES (8353)

DBAUTH (8354)

EVENTMONITORS (8355)

EVENTS (8356)

FUNCDEP (8358)

FUNCMAPOPTIONS (8359)

FUNCMAPPARMOPTIONS (8360)

FUNCMAPPINGS (8361)

FUNCPARMS (8362)

FUNCTIONS (8363)

functions (7037)

INDEXAUTH (8365)

INDEXCOLUSE (8366)

INDEXDEP (8367)

INDEXES (7009), (8368)

INDEXOPTIONS (8369)

KEYCOLUSE (8370)

NAMEMAPPINGS (8371)

NODEGROUPDEF (8372)

NODEGROUPS (8373)

overview (8335)

PACKAGEAUTH (8374)

PACKAGEDEP (8375)

PACKAGES (8376)

PARTITIONMAPS (8377)

PASSTHRUAUTH (8378)

PROCEDURES (8379)

PROCOPTIONS (8380)

PROCPARMOPTIONS (8381)

PROCPARMS (8382)

read-only (8340)

REFERENCES (8383)

REVTYPEMAPPINGS (8384)

SCHEMAAUTH (8385)

SCHEMATA (8386)

SERVEROPTIONS (8387)

SERVERS (8388)

STATEMENTS (8389)

SYSDUMMY1 (8341)

SYSSTAT.COLDIST (7012), (8406)

SYSSTAT.COLUMNS (7008), (8409)

SYSSTAT.FUNCTIONS (7038), (8410)

SYSSTAT.INDEXES (7010), (8411)

SYSSTAT.TABLES (7006), (8412)

TABAUTH (8390)

TABCONST (8391)

TABLES (7005), (8392)

TABLESPACES (8393)

TABOPTIONS (8394)

TBSPACEAUTH (8395)

TRIGDEP (8396)

TRIGGERS (8397)

TYPEMAPPINGS (8398)

updatable (8339)

update-capable (7028)

USEROPTIONS (8399)

VIEWDEP (8400)

VIEWS (8401)

WRAPOPTIONS (8402)

WRAPPERS (8403)

catalog views (structured types)

ATTRIBUTES (8342)

FULLHIERARCHIES (8357)

HIERARCHIES (8364)

catalogcache_sz configuration parameter (7524)

cataloging database (5527)

catalog_noauth configuration parameter (7874)

CDS (8229)

cell directory service (CDS) (8230)

changing database configuration (5719)

changing environment variables (5714)

changing node configuration file (5717)

changing partitioning key (5792)

changing passwords (7983)

changing registry variables (5715)

changing table attributes (5797)

character comparison, overview (8547)

character conversion

performance considerations (6910)

character serial devices (5539)

character sets

extended UNIX code (EUC) (8532)

checking available space (DMS) (5898)

chngpgs_thresh configuration parameter (7595)

managing the buffer pool (7293)

CLI Guide and Reference (7889)

client

backing up database, restriction (6339)

Client Configuration Assistant (5889)

CLIENT level security (5928)

client support

client I/O block size (rqrioblk) parameter (7573)

TCP/IP service name (svcename) parameter (7753)

transaction program name (tpname) parameter (7755)

CLIENT, authentication type (5927)

clients

trusted (5930), (5935)

untrusted (5931), (5939)

CLOB (5296) See also large objects

cluster configuration (6587)

cluster management (6591)

Cluster Manager (6646)

cluster monitoring for HACMP ES (6661)

clustered index

cluster ratio statistic (7097)

CL_SCHED sample table (8322)

code page

DB2CODEPAGE environment variable (8517)

guidelines for selecting (6912)

how determined (8516)

locales

deriving in applications (8526)

how DB2 derives locales (8527)

RESTORE command (6325)

supported Windows 95 code pages (8518)

supported Windows NT code pages (8519)

code page support

character conversion (6911)

code point (8543)

code point, definition of (8539)

codepage configuration parameter (7712)

codeset configuration parameter (7710)

collate_info configuration parameter (7714)

collating sequence

case independent comparisons (8549)

code point (8542)

collating_sequence option (8563)

EBCDIC and ASCII sort order example (8551)

federated database concerns (8562)

general concerns (8559)

identity sequence (8544)

multi-byte characters (8546)

overview of (8541)

samples of (8558)

sort order example (8550)

specifying (8552)

use in character comparisons (8548)

collating sequence performance ramifications, federated systems (7178)

collating_sequence server option (6960)

collocated join (7150)

collocation

data redistribution preservation of (7441)

replicated summary tables (5326), (7146)

column

adding (5748)

altering (5752)

attribute (5148)

defining (5166), (5555)

estimating row size (5289)

naming rules (7989)

column options

numeric string (7181)

varchar_no_trailing_blanks (7183)

column UDF (5623)

Command Center (5880)

command line processor

binding to a database (5523)

Command Reference (7890)

commands

db2evmon (7392)

commit

errors during two-phase (6477)

number of commits to group (mincommit) (7666)

two-phase (6476)

communication

connection retries, number (7817)

FCM daemon to agent, request blocks (7810)

node, connection elapse time (7782)

node, message buffers (7798)

communication protocol

VI Architecture (8611)

communications bandwidth configuration parameter (6942)

comm_bandwidth configuration parameter (7855)

comm_rate server option (6962), (6964)

compensation (7177)

compiler

overview of (7042)

overview of federated database phases (7044)

overview of pushdown analysis (7043)

overview of query rewrite (7052)

overview of remote SQL generation (7049)

composite key

definition of (5200), (5226)

composite tables

composite inner (7144)

composite outer (7143)

compound SQL

overview of (6908)

performance considerations (6909)

concurrency

controlling using locks (6792)

overview of (6760)

concurrency and granularity

effect of locks on (6826)

concurrency control

BACKUP command (6298)

maximum number of active applications (maxappls) parameter (7607)

maximum number of concurrently active databases (numdb) parameter (7858)

concurrent access mode (6558)

configuration (7497) See also benchmarking

changing database manager parameters (7502)

changing database parameters (7508)

database manager parameters (7499)

database parameters (7507)

parameter details, overview of (7512)

parameter summary, database (7511)

parameter summary, database manager (7504)

parameters, overview of (7495)

tuning parameters (7496)

configuration file

governor example (7409)

configuration file, governor (7406)

configuration parameter

ADSTAR Distributed Storage Manager (7676)

affecting optimizer (6931)

agent communication memory (7566)

agent private memory (7545)

application communication memory (7567)

application shared memory (7536)

applications and agents (7606)

AUTORESTART (6145), (6231)

capacity management (7513)

communication protocol setup (7750)

communications (7749)

compiler settings (7743)

Database Application Remote Interface (DARI) (7638)

database attributes (7701)

database management (7699)

database manager instance memory (7577)

database shared memory (7515)

database status (7730)

database system monitor (7844)

DB2 Data Links Manager (7716)

DB2 Discovery (7768)

diagnostic information (7839)

Distributed Computing Environment (DCE) (8284)

distributed services (7761)

distributed unit of work (7691)

I/O and storage (7593)

instance administration (7868)

instance management (7838)

locks (7584)

log activity (7664)

log files (7649)

logging (7647)

migration of (7935)

parallel operations (7776)

partitioned database (5421), (7777)

recovery (7648), (7674)

stored procedure (7637)

system management (7853)

configuration parameters

database logging (6344)

configuration, adding servers when system is running (7425)

configuration, adding servers when system is stopped (7429)

configuration, changing the size of a (7419)

configuration, dropping server with DB2STOP CMD/API (7434)

Configure Multisite Update SmartGuide (5867)

CONNECT privilege, definition (6006)

CONNECT statement

specifying Distributed Computing Environment (DCE) information (8290)

connect time reduction (7378)

connection

elapse time (7785)

number of retries (7816)

connection elapse time (conn_elapse) database manager configuration parameter (7780)

connection entry (7805)

connection pooling, MTS (6547)

Connectivity Supplement (7894)

conn_elapse configuration parameter (7783)

constraint

adding (5761)

changing (5759)

defining unique (5568)

dropping (5778)

Explain tables (8473)

constraint name

defining foreign keys (5586)

defining table check constraints (5597)

constraints

types of (5216)

container names (6304)

containers

adding (to DMS table space) (5735)

DMS table space design (5367)

logical file system (5353)

logical volume device (5369)

overview of (5330)

SMS table space (5349)

SMS table space design (5351)

suggestions for parallel I/O (7324)

Control Center

displaying systems (5873)

Event Analyzer (7386)

Performance Monitor (7384)

Snapshot Monitor (7385)

Control Center as a Java Applet (5905)

CONTROL privilege

definition of (6019)

implicit issuance (6058)

package privileges (6038)

controlling the rah command (8593)

conversion

of locks, rules for (6833)

cooked devices (5542)

Coordinated Universal Time (7825)

coordinator agent (7370)

maximum number at node (7626)

coordinator database partition, considerations for dropping (7436)

copyprotect configuration parameter (7715)

country configuration parameter (7708)

CPU speed configuration parameter

affect on query optimization (6939)

cpuspeed configuration parameter (7856)

cpu_ratio server option (6966)

crash recovery (6227)

offline table space (6139)

overview of (6138)

point of consistency (6142)

RESTART DATABASE (6143)

triggering (6258)

CREATE ALIAS statement

example of (5659)

using (5657)

CREATE DATABASE API

SQLEDBDESC structure (8556)

CREATE DATABASE command

example of (5495)

Create Database SmartGuide (5861)

create HACMP ES container examples (6599)

CREATE INDEX statement

example of (5695)

online reorganization (5686), (5699)

unique index (5697)

Create Table SmartGuide (5862)

Create Table space SmartGuide (5863)

CREATE TABLE statement

defining check constraints (5598)

defining referential constraints (5580)

example of (5561)

using multiple table spaces (5608)

CREATE TABLESPACE statement

example of (5534)

CREATE TRIGGER statement

example of (5616)

CREATE VIEW statement

changing column names (5648)

example of (5645)

CREATETAB privilege, definition of (6008)

CREATE_NOT_FENCED privilege, definition (6010)

creating (5154) See also defining

creating a function mapping (5627)

creating a function template (5630)

creating a nickname (5671)

creating a server (5668)

creating a type mapping (5641)

creating a wrapper (5665)

creating alias (5656)

creating an index specification (5679)

creating index (5677)

creating schema (5547)

creating table (5552)

creating table in multiple table spaces (5606)

creating table space (5531)

creating trigger (5613)

creating typed table (5600)

creating typed view (5651)

creating user-defined distinct type (5636)

creating user-defined function (5618)

creating user-defined structured type (5638)

creating user-defined type (5632)

creating view (5642)

CURRENT DEGREE special register (6927)

CURRENT SCHEMA (5551)

CURRENT SCHEMA special register (5410)

cursor

close using WITH RELEASE clause (6864)

read only, uncommitted read (6783)

updatable, uncommitted read (6784)

cursor stability

overview of (6775)

customized Control Center (5872)

damaged table spaces (6199)

DARI (6915) See also stored procedures

data

caching when database is started (6920)

changing distribution (5731)

connection entries for agents to pass, number (7804)

data integrity

concurrency, overview (6761)

protecting using locks (6795)

unique index (5680)

Data Links access token expiry interval configuration parameter (7719)

Data Links number of copies configuration parameter (7721)

Data Links time after drop configuration parameter (7723)

Data Links token algorithm configuration parameter (7725)

Data Links token in upper case configuration parameter (7727)

Data Movement Utilities Guide and Reference (7891)

data security

controlling database access (5907)

importance of (5908)

securing system catalog (6095)

data sources

CPU speed and performance (7197)

I/O speed and performance (7198)

data structure

SQLEDBDESC (8555)

data transfer

overview of (6133)

data type

column definition (5167), (5556)

multi-byte character set (5559)

database (6214)

activate (7364)

agents (7368)

altering nodegroup (5727)

auto restart enable (autorestart) parameter (7678)

backup (6273)

backup pending indicator (backup_pending) parameter (7731)

catalog node, media failure considerations (6215)

cataloging (5528)

changing (5722)

changing distribution of data (5730)

code page for database (codepage) parameter (7711)

codeset for database (codeset) parameter (7709)

collating information (collate_info) parameter (7713)

configuration parameter summary (7510)

configuration parameters (7505)

connection considerations (6499)

considerations before changing (5702)

considerations for creating (5422)

country code for database (country) parameter (7707)

crash recovery (6260)

creating (5494)

creating across all nodes (5419)

data caching when database is started (6919)

database is consistent (database_consistent) parameter (7733)

database partition synchronization, recovery considerations (6225)

deactivate (7365)

deciding what data to record (5145), (5152)

defining tables (5153)

designing (5144)

determining list of data nodes (6280)

dropping (5724)

enabling data partitioning (5414)

estimating size (5285)

federated database design considerations (5390)

implementing design (5391)

inconsistent after restart (6261)

maximum file open per application (maxfilop) parameter (7610)

maximum number of concurrently active databases (numdb) parameter (7857)

migration (7929)

naming rules (7980)

normalizing tables (5207)

number of containers (numsegs) parameter (7601)

object naming rules (7977)

other design considerations (5261)

package dependencies (5853)

parameter file SQLDBCON (7506)

physical design (5267)

recovering failed database partition server (6266)

recovery log (5517)

release level (release) parameter (7702)

resource manager in TP Monitor environment (6494)

restore (6311)

roll-forward changes (6342)

storage for an application (7266)

subdirectory created (5268)

territory for database (territory) parameter (7705)

transaction recovery on the failed database partition server (6253)

transaction recovery when the database partition server is active (6246)

transaction recovery, overview (6234)

uniquely identifying entities (5204)

updating multiple databases (6457)

user exit enable (userexit) parameter (7672)

user exit status indicator (user_exit_status) parameter (7739)

using multiple databases in a single transaction (6454)

database access

affect of optimization class (6868)

choosing authorizations (5265)

controlling (5906)

overview of (7068), (7072)

privileges through package with SQL (6063)

database administrator (DBADM) authority

privileges (5998)

retrieving names with (6086)

database alias (7976)

for BACKUP command (6292)

naming rules (7979)

RESTORE command (6319)

Database Application Remote Interface (DARI) (6916) See also stored procedures

initial number of fenced DARI processes in pool (num_initdaris) parameter (7645)

initialize DARI process with JVM (initdari_jvm) parameter (7643)

keep DARI process indicator (keepdari) parameter (7639)

maximum number of DARI processes (maxdari) parameter (7641)

database configuration

app_ctl_heap_sz parameter (7542)

changing (5718)

created file (5491)

database creation, specifying collating sequence (8553)

Database Descriptor Block (SQLEDBDESC), specifying collating sequences (8557)

database files

index data (5360)

log files (5273)

notes of caution (5284)

SMS table space (5357)

SQLINSLK (5275)

table data (5359)

database locator objects

creating (8237)

example (8238)

database logs (6162)

configuration parameters (6345)

database managed storage (5362) See also DMS table space

database management, configuration parameters (7700)

database manager (6235)

access control (6045)

binding utilities (5520)

configuration parameter summary (7503)

configuration parameters (7500)

default database path (dftdbpath) parameter (7875)

governor affect on performance (7416)

index (5690)

machine node type (nodetype) parameter (7861)

naming rules (7978)

parameter file db2systm (7501)

recovering failed database partition server (6267)

start timeout (7829)

starting and stopping (5393)

stop timeout (7830)

transaction failure, reducing impact (6220)

transaction recovery on the failed database partition server (6254)

transaction recovery when the database partition server is active (6247)

transaction recovery, overview (6236)

using memory (7263)

database manager configuration

conn_elapse parameter (7784)

fcm_num_anchors parameter (7789)

fcm_num_buffers parameter (7794)

fcm_num_connect parameter (7802)

fcm_num_rqb parameter (7809)

java_heap_sz parameter (7583)

max_connretries parameter (7818)

max_coordagents parameter (7623)

max_time_diff parameter (7822)

num_initagents parameter (7635)

num_poolagents parameter (7631)

start_stop_time parameter (7832)

database monitor

using (7382)

database objects

access control (6044)

creating (8235)

example (8236)

naming rules (7986), (8533)

database partition, adding to a system with no databases (7423)

database partition, adding when system is running (7424)

database partition, considerations for dropping a server (7435)

database partition, dropping with DB2STOP CMD/API (7433)

database partitions, adding to a system (7422)

database partitions, adding when system is stopped (7428)

database restore

overview of (6147)

database roll-forward recovery

overview (6150)

database seed (6331)

database startup cost (7363)

database system monitor

configuration parameters (7845)

fcm_num_rqb database manager parameter, tuning (7812)

databases

non-recoverable (6161)

recoverable (6160)

database_consistent configuration parameter (7734)

database_level configuration parameter (7704)

datalinks configuration parameter (7728)

Datalink_Reconcile_Not_Possible state (6395)

DataPropagator Relational (DPROPR)

overview (6134)

date

definition of (8566)

formats (8573)

date strings

definition of (8570)

datetime values

overview of (8565)

string representations (8569)

DAU (DB_Authentication) (8243)

DB2

starting on Windows NT (5400)

DB2 Administration Server

update configuration (5485)

update instance lists (5483)

using CCA and Control Center (5482)

DB2 Administration Server (DAS) (5462)

communications (5467)

configuration (5464), (5465)

configuring (5456)

Control Center communications (5466)

creating (5453)

enabling discovery of (5478)

environment (5476)

internode administrative communications (5468)

internode administrative communications in partitioned database system (UNIX) (5470)

internode administrative communications in partitioned database system (Windows NT) (5472)

listing (5455)

overview (5452)

ownership rules (5450)

registry variable considerations (5475)

registry variables (5477)

removing (5459)

security (5474)

security considerations (5457)

service ports (5469)

setting up with partitioned database system (5460)

example (5463)

starting and stopping (5454)

UNIX EEE servers (5471)

updating (5458)

Windows NT EEE servers (5473)

DB2 Connect (6132) See also data transfer

connect time reduction (7379)

DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (7911)

DB2 Connect Enterprise Edition for UNIX Quick Beginnings (7912)

DB2 Connect Personal Edition Quick Beginnings (7892)

DB2 Connect User's Guide (7893)

DB2 Data Links Manager (7717)

backup utility considerations (6388)

crash recovery (6385)

Datalink_Reconcile_Not_Possible state (6394)

Datalink_Reconcile_Pending state (6396)

detection of situations requiring reconciliations (6416)

garbage collection (6381)

indoubt transactions (6387)

interactions with recovery (6412)

point-in-time roll-forward example (6410)

reconciliation procedure (6417)

reconciling (6415)

removing table from Datalink_Reconcile_Not_Possible state (6414)

restore utility considerations (6390)

restoring databases (6400), (6405)

restoring databases from an offline backup without rolling forward (6398)

restoring table spaces (6401), (6406)

rollforward utility considerations (6391)

rolling forward databases to a point in time (6407)

rolling forward databases to end of logs (6402)

rolling forward table spaces to a point in time (6408)

rolling forward table spaces to end of logs (6403)

two-phase commit (6386)

DB2 Data Links Manager for AIX Quick Beginnings (7913)

DB2 Data Links Manager for Windows NT Quick Beginnings (7914)

DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (7909)

DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (7910)

DB2 failover examples (6566)

DB2 for Windows NT Performance Counters (8603)

DB2 library

books (7883)

Information Center (7921)

language identifier for books (7918)

late-breaking information (7919)

online help (7882)

ordering printed books (7926)

printing PostScript books (7925)

searching online information (7924)

setting up document server (7922)

SmartGuides (7881)

structure of (7880)

viewing online information (7920)

DB2 Personal Edition Quick Beginnings (7905)

DB2 Query Patroller Administration Guide (7915)

DB2 Query Patroller Installation Guide (7916)

DB2 Query Patroller User's Guide (7917)

DB2 shared nothing model (6559)

DB2 Syncpoint Manager

recovery of indoubt transactions (6492)

when required (6461)

DB2 Syncpoint Manager (SPM) (6490)

DB2 transaction manager

database configuration considerations (6466)

DB2ACCOUNT (8003)

DB2ADMINSERVER (8193)

db2adutl utility (6440)

DELETE command (6443)

EXTRACT command (6442)

QUERY command (6441)

db2adutl utility examples (6444)

DB2ATLD_PORTS (8119)

DB2ATLD_PWFILE (8121)

db2audit (6115)

db2audit.log (6103)

db2batch benchmarking tool (7490)

DB2BIDI (8005)

DB2BPVARS (8145)

DB2BQTIME (8109)

DB2BQTRY (8111)

DB2CHECKCLIENTINTERVAL (8059)

DB2CHGPWD_EEE (8123)

DB2CHKPTR (8151), (8153)

DB2CLIENTADPT (8103)

DB2CLIENTCOMM (8105)

DB2CLIINIPATH (8195)

DB2CODEPAGE (8007)

DB2COMM (8061)

DB2CONNECT_IN_APP_PROCESS (8045)

DB2COUNTRY (8009)

DB2DBDFT (8011)

DB2DBMSADDR (8013)

DB2DEFPREP (8197)

DB2DIRPATHNAME (8101)

DB2DISCOVERYTIME (8015)

DB2DMNBCKCTLR (8017), (8201)

db2dmnbckctlr

using (8599)

db2empfa (7326)

DB2ENVLIST (8047)

db2exfmt tool (7235), (8515)

db2expln (8494) See also explain tool

db2gov command (7398)

db2govlg command (7414)

db2icrt command (5432)

DB2INCLUDE (8019)

DB2INSTANCE (8049)

DB2INSTANCE environment variable

defining default instance (5403)

DB2INSTDEF (8021)

DB2INSTOWNER (8023)

DB2INSTPROF (8051)

DB2IQTIME (8113)

DB2LDAP_SEARCH_SCOPE (8209)

DB2LIBPATH (8053)

DB2LOADREC (6362), (8211)

DB2LOCK_TO_RB (8213)

db2look tool

overview of (7041)

DB2MEMDISCLAIM (8155)

DB2MEMMAXFREE (8157)

DB2MSCS utility

DB2MSCS.CFG parameters (6681)

overview (6679)

setting up a single-partition database system (6683)

setting up partitioned database system (6687)

setting up two single-partition database systems for mutual takeover (6685)

DB2NBADAPTERS (8065)

DB2NBBRECVNCBS (8073)

DB2NBCHECKUPTIME (8067)

DB2NBDISCOVERRCVBUFS (8027)

DB2NBINTRLISTENS (8069)

DB2NBRECVBUFFSIZE (8071)

DB2NBRESOURCES (8075)

DB2NBSENDNCBS (8077)

DB2NBSESSIONS (8079)

DB2NBXTRANCBS (8081)

DB2NETREQ (8083)

DB2NODE (8055), (8127)

DB2NODE environment variable

exported when adding server (7427)

db2nodes.cfg file (5489)

adding database partitions when redistributing data (7458)

dropping database partitions when redistributing data (7459)

db2nodes.cfg, having the database manager update (7430)

db2nodes.cfg, updating manually (7432)

DB2NOEXITLIST (8215)

DB2NTMEMSIZE (8165)

DB2NTNOCACHE (8149), (8167)

DB2NTPRICLASS (8169)

DB2NTREMOTEPREG (8217)

DB2NTWORKSET (8171)

DB2OPTIONS (8029), (8115)

DB2PATH (8057)

DB2PORTRANGE (8129)

DB2PRIORITIES (8175)

DB2RETRY (8085)

DB2RETRYTIME (8087)

DB2RHIST.ASC database file (5282)

DB2RHIST.BAK database file (5283)

DB2ROUTE (8107)

DB2ROUTINE_DEBUG (8219)

DB2RQTIME (8117)

DB2SERVICETPINSTANCE (8089)

db2set command (5440), (5445)

DB2SLOGON (8031)

DB2SORCVBUF (8221)

DB2SORT (8223)

DB2SOSNDBUF (8091)

db2start command (5397)

db2stop command (5396)

DB2SYSPLEX_SERVER (8093)

DB2SYSTEM (8225)

DB2TIMEOUT (8033)

DB2TRACEFLUSH (8039)

DB2TRACENAME (8035)

DB2TRACEON (8037)

DB2TRCSYSERR (8041)

db2uexit

user exit programs for OS/2 (8438)

user exit programs for UNIX-based systems (8443)

DB2UPMPR (8227)

DB2YIELD (8043)

db2_all (8576), (8579)

DB2_AVOID_PREFETCH (8141)

DB2_BINSORT (8143)

db2_call_stack (8581)

DB2_CORRELATED_PREDICATES (8131)

DB2_DJ_COMM (8199)

DB2_FALLBACK (8203)

DB2_FORCE_FCM_BP (8125)

DB2_FORCE_NLS_CACHE (8063)

DB2_FORCE_TRUNCATION (8205)

DB2_GRP_LOOKUP (8207)

DB2_HASH_JOIN (8133)

db2_kill (8580)

DB2_LIC_STAT_SIZE (8025)

DB2_LIKE_VARCHAR (8135)

DB2_MMAP_READ (8159)

DB2_MMAP_WRITE (8161)

DB2_NEW_CORR_SQ_FF (8137)

DB2_NO_PKG_LOCK (8163)

DB2_OVERRIDE_BPF (8173)

db2_override_bpf (7301)

DB2_PRED_FACTORIZE (8139)

DB2_RR_TO_RS (8177)

DB2_SORT_AFTER_TQ (8179)

DB2_VI_DEVICE (8099)

DB2_VI_ENABLE (8095)

DB2_VI_VIPL (8097)

DBCLOB (5297) See also large objects

dbexpln tool

data from compiler (7050)

dbheap configuration parameter (7523)

impact on memory (7273)

dbname server option (6968)

DB_Authentication (DAU) (8242)

DB_Comment (DCO) (8248)

DB_Communication_Protocol (DCP) (8251)

DB_Database_Locator_Name (DLN) (8257)

DB_Database_Protocol (DDP) (8254)

DB_Native_Database_Name (DNN) (8260)

DB_Object_Type (DOT) (8263)

DB_Principal (DPR) (8245)

DB_Product_Name (DPN) (8266)

DB_Product_Release (DRL) (8269)

DB_Target_Database_Info (DTI) (8272)

DCE network database

connecting (8293), (8294)

creating (8292)

DCE, authentication type (5945)

DCE_SERVER_ENCRYPT, authentication type (5947)

DCO (DB_Comment) (8249)

DCP (DB_Communication_Protocol) (8252)

DCS

authentication type (5941)

federated database processing (5962)

DCS_ENCRYPT, authentication type (5943)

DDP (DB_Database_Protocol) (8255)

DEACTIVATE DATABASE command (7362)

deadlocks

checking for (7588)

configuration parameter (7589)

detecting (6843)

overview of (6844)

DECLARE CURSOR WITH HOLD statement (6886)

decorrelation of a query (7064)

default attribute specification (5560)

default value

alternative to null value (5190)

column definition (5189)

defining referential constraint (5574)

defining table check constraint (5594)

defining unique constraint (5565)

DEGREE bind option (6928)

DELETE privilege, definition (6023)

DELETE rules

types of (5247)

DELETE statement

referential integrity implications for (5246)

deleting rows from typed tables (5804)

DEPARTMENT sample table (8323)

dependent row

definition of (5234)

dependent table

definition of (5232)

dereference operator (5603)

design of database

altering (5703)

design, implementing (5392)

DETACH command

overview of (5405)

determining problems with rah (8597)

dftdbpath configuration parameter (7876)

dft_account_str configuration parameter (7863)

dft_client_adpt configuration parameter (7767)

dft_client_comm configuration parameter (7766)

dft_degree configuration parameter (6925), (6933), (7745)

dft_extent_sz configuration parameter (7603)

dft_loadrec_ses configuration parameter (7682)

dft_monswitches configuration parameter (7846)

dft_mon_bufpool configuration parameter (7850)

dft_mon_lock configuration parameter (7851)

dft_mon_sort configuration parameter (7852)

dft_mon_stmt configuration parameter (7848)

dft_mon_table configuration parameter (7849)

dft_mon_uow configuration parameter (7847)

dft_prefetch_sz configuration parameter (7600)

dft_queryopt configuration parameter (6934), (7746)

dft_sqlmathwarn configuration parameter (7744)

diaglevel configuration parameter (7841)

diagpath configuration parameter (7842)

directed inner-table and outer-table joins (7156)

directed inner-table join (7162)

directed outer-table joins (7154)

directories

local database directory (5506)

node directory (5510)

system database directory (5508)

directory cache

effect of cataloging databases (5530)

directory objects

creating (8234)

object classes attributes (8241)

directory under which Java Development Kit 1.1 is installed (jkd11_path) database manager parameter (7864)

dir_cache configuration parameter (7579)

dir_obj_name configuration parameter (7764)

dir_path_name configuration parameter (7763)

dir_type configuration parameter (7762)

disaster recovery

considerations (6206)

discover configuration parameter (7770)

discover server instance configuration parameter (7775)

Discovery

configuration (5487)

hiding server instances (5480)

setting parameters (5481)

discovery mode configuration parameter (7771)

discover_comm configuration parameter (7772)

discover_db configuration parameter (7769)

discover_inst configuration parameter (7774)

disk-mirroring (6219)

Distributed Computing Environment (DCE)

ATTACH command (8288), (8296)

authentication (5952)

CATALOG GLOBAL DATABASE command (8286)

CDS (8228)

configuration parameters (7760)

configuration parameters and registry variables (8283)

CONNECT statement (8287), (8297)

directory services restrictions (8301)

directory services tasks (8299)

GDS (8233)

how directories are searched (8295)

overview of directory services (5512)

restrictions (5956)

security services (5951)

setup DB2 client instance (5955)

setup DB2 server (5954)

setup DB2 user (5953)

temporarily overriding DCE directory information (8298)

using directory services (8300)

distributed transaction processing (8303) See also X/Open transactional manager interface (XA)

dlchktime configuration parameter (7587)

DLFM_BACKUP_DIR_NAME (8181)

DLFM_ENABLE_STPROC (8183)

DLFM_GC_MODE (8185)

DLFM_INSTALL_PATH (8187)

DLFM_LOG_LEVEL (8189)

DLFM_PORT (8191)

DLN (DB_Database_Locator_Name) (8258)

dl_expint configuration parameter (7718)

dl_num_copies configuration parameter (7720)

dl_time_drop configuration parameter (7722)

dl_token configuration parameter (7724)

dl_upper configuration parameter (7726)

DMS table space

adding containers (5371)

advantages (5388)

allocating space (5368)

caching of (7357)

choosing extent size (5381)

creating (5537)

increasing storage (5370)

overview of (5364)

performance considerations (7355)

size (5366)

types of (5365)

DNN (DB_Native_Database_Name) (8261)

dos_rqrioblk configuration parameter (7575)

DOT (DB_Object_Type) (8264)

double byte character set user

data type (5558)

DPN (DB_Product_Name) (8267)

DPR (DB_Principal) (8246)

DPROPR (6135) See also DataPropagator Relational (DPROPR)

drda_heap_sz configuration parameter (7561)

impact on memory (7284)

DRL (DB_Product_Release) (8270)

drop a temporary table space (5741)

DROP DATABASE command

example of (5725)

DROP INDEX statement; example of (5845)

DROP NICKNAME statement, example of (5841)

DROP SERVER statement, example of (5837)

DROP TABLE statement

example of (5811)

DROP TABLESPACE statement; example of (5740)

DROP VIEW statement; example of (5824)

dropped table

recovery (6365)

dropping a nickname (5839)

dropping a server (5835)

dropping a summary table (5829)

dropping a wrapper (5833)

dropping constraint (5779)

dropping database (5723)

dropping index (5842)

dropping node from system

when redistributing nodegroup (7457)

dropping schema (5743)

dropping table (5808)

dropping table check constraint (5788)

dropping trigger (5812)

dropping unique constraint (5780)

dropping user table space (5738)

dropping user-defined function (5814)

dropping user-defined type (5816)

dropping view (5823)

DSMI_CONFIG (6424), (6430)

DSMI_DIR (6423), (6429)

DSMI_LOG (6425), (6431)

DTI (DB_Target_Database_Info) (8273)

dynamic SQL

distribution statistics (7020)

evaluating optimization class (6876)

EXECUTE privilege for database access (6066)

explain facility (7239), (7244)

setting optimization class (6873)

dynexpln (8495) See also explain tool

eliminating duplicate entries from machine list (8592)

EMPLOYEE sample table (8324)

EMP_ACT sample table (8325)

EMP_PHOTO sample table (8326)

EMP_RESUME sample table (8327)

enable Data Links support configuration parameter (7729)

enable intra-partition parallelism configuration parameter (7837)

enhanced scalability (6570) See also HACMP ES

entity

definition of (5146)

values (5205)

environment variables (5438), (8001)

changing (5712)

DB2LOADREC (6363)

DB2NODE, exported when adding server (7426)

setting on OS/2 (5446)

setting on UNIX (5449)

setting on Windows 3.x (5451)

setting on Windows 95 (5448)

setting on Windows NT (5447)

Eprimary node (6624)

erasing the sample database (8321)

error handling

access errors, BACKUP command (6300)

access errors, RESTORE command (6324)

configuration parameters (7840)

indoubt transaction in TP Monitor environment (6503)

indoubt transactions (6483)

log full (6347)

system crash during BACKUP (6296), (6338)

two-phase commit (6482)

user exit program (8466)

user exit program for OS/2 (8469)

XA interface (6526)

estimating size (5897)

estore_seg_sz configuration parameter (7604)

impact on memory (7275)

event definition example for HACMP ES (6642)

Event Management (6644)

event monitoring (6632)

event snapshots (7391)

exclusive mode

reasons for using (6863)

EXECUTE privilege

database access with dynamic SQL (6067)

database access with static SQL (6065)

definition of (6040)

EXPLAIN (7240)

explain

FOR SNAPSHOT (7245)

Visual (7212), (7251)

WITH SNAPSHOT (7246)

explain tool (8492)

aggregation (8510)

command options (8498), (8500)

data streams (8506)

description of output (8501)

examples of db2expln and dynexpln output (8513)

insert, update, and delete (8507)

joins (8505)

miscellaneous statements (8512)

overview of (8493)

parallel processing (8511)

row identifier (RID) preparation (8508)

running (8496)

syntax (8497), (8499)

table access (8502)

temporary tables (8504)

explain facility (7051) See also dbexpln tool

analysis (7218)

capturing information (7214), (7237)

choosing a tool (7209)

concepts (7219)

data from compiler (7048)

data organization (7226)

decision-making (7248)

explain instance (7228)

graphical representation (7220)

instance information (7229)

keywords (7232)

objects (7223)

obtaining data (7236)

operators (7225)

overview of (7208)

snapshot information (7233)

statement information (7230)

table information (7234)

using (7215)

explain instance (7227)

explain snapshot (7243)

explain table format tool (8514)

explain tables

accessing (7210)

EXPLAIN_ARGUMENT table (8474)

EXPLAIN_ARGUMENT table definition (8483)

EXPLAIN_INSTANCE table (8475)

EXPLAIN_INSTANCE table definition (8484)

EXPLAIN_OBJECT table (8476)

EXPLAIN_OBJECT table definition (8485)

EXPLAIN_OPERATOR table (8477)

EXPLAIN_OPERATOR table definition (8486)

EXPLAIN_PREDICATE table (8478)

EXPLAIN_PREDICATE table definition (8487)

EXPLAIN_STATEMENT table (8479)

EXPLAIN_STATEMENT table definition (8488)

EXPLAIN_STREAM table (8480)

EXPLAIN_STREAM table definition (8489)

explicit schema use (5408)

extended storage cache (7394)

Extended UNIX Code (EUC)

extended UNIX code (EUC)

character sets (8531)

code page support (6913)

extent size

choosing (7310)

choosing the value (5380)

definition of (5331)

SMS table space design (5352)

failover examples (6562)

failover support (6553), (6569) See also High Availability Cluster Multi-Processing configurations, High Availability Cluster Multi-Processing configurations

fast communication manager (FCM)

FCM Connection Entries (fcm_num_connect) parameter (7800)

fcm_num_buffers database manager parameter (7793)

message anchors, number, specifying (7790)

message buffers, number, specifying (7796)

number of FCM message anchors fcm_num_anchors database manager parameter (7787)

Number of FCM Request Blocks (fcm_num_rqb) parameter (7807)

FCM buffers (fcm_num_buffers) database manager configuration parameter (7792)

FCM communications (5493)

FCM connection entries (fcm_num_connect) database manager parameter (7799)

FCM tuning (7291)

fcm_num_anchors configuration parameter (7788)

fcm_num_buffers configuration parameter (7795)

fcm_num_connect configuration parameter (7801)

fcm_num_rqb database manager configuration parameter (7808)

federated configuration parameter (7867)

federated database

APPC setting (5976)

authentication details (5958)

authentication example (5978)

authentication overview (5915)

authorization overview (5916)

case-sensitive names (7998)

collating sequences, guidelines (8561)

compiler phases (7169)

DCS setting (5961)

function mapping, creating (5626)

function template, creating (5629)

index specification, creating (5676)

nickname, creating (5669)

nickname, identifying (5674)

nickname, working with (5673)

object names (7996)

passing IDs and passwords to data sources (5964)

pushdown analysis (7172)

referencing nicknames (5672)

remote SQL generation (7191)

server options, security (5970)

server, creating (5666)

type mapping, creating (5639)

user mapping, creating (5967)

wrapper, creating (5663)

federated database system support configuration parameter (7866)

FETCH FIRST clause (6885)

files (5271)

fileserver configuration parameter (7757)

filter (5871)

finding errors

data redistribution log file (7478)

first active log file (loghead) parameter (7663)

fold_id server option (6970)

fold_pw server option (6972)

FOR FETCH ONLY clause (6883), (6904)

FOR READ ONLY clause (6882), (6903)

FOR UPDATE clause (6881), (6905)

foreign key

adding (5769)

composite (5585)

constraint name (5584)

DROP FOREIGN KEY clause, ALTER TABLE statement (5785)

IMPORT utility, referential integrity implications for (5592)

LOAD utility, referential integrity implications for (5591)

privileges required for dropping (5786)

rules for foreign key definitions (5583)

update, referential integrity implications for (5258)

FOREIGN KEY clause

referential constraints (5581)

rules for foreign key definitions (5582)

frequent value statistics

equality predicates (7025)

number to collect (7021)

overview of (7018)

rules for updating (7033)

function mapping, creating (5628)

function template, creating (5631)

garbage collection (6377)

gateway connections (5878)

GDS (8231)

generate DDL (5870)

generation, remote SQL

overview (7190)

global directory service (GDS) (8232)

global level profile registry (5442)

global optimization

analyzing (7206)

explain tool cost information (7207)

nickname characteristics, affecting (7200)

server characteristics, affecting (7194)

Glossary (7895)

governor

configuration file (7405)

configuration file example (7408)

daemon (7400)

database manager performance (7415)

db2gov (7399)

db2govlg (7413)

error handling (7404)

log file (7411)

obtains statistics (7401)

purpose (7395)

querying log file (7412)

rules (7407)

starting (7396)

stopping (7397)

GRANT statement

implicit issuance (6056)

security (8281)

use of (6048)

GRANT statement; example of (6049)

granting authorities and privileges (5893)

HACMP (6552), (6568) See also High Availability Cluster Multi-Processing configurations, High Availability Cluster Multi-Processing configurations

HACMP ES (6567)

blank NFS server worksheet (6672)

blank volume and filesystems worksheet (6670)

cascading assignment (6592)

cluster configuration (6586)

cluster management (6590)

Cluster Manager (6645)

cluster monitoring (6660)

configuration examples (6625)

configuring (6600)

create container examples (6598)

enhanced scalability (6571)

Eprimary (6623)

event definition example (6641)

Event Management (6643)

event monitoring (6631)

failover (6584)

heartbeats (6577)

hot standby takeover (6607)

installation (6662)

keepalive packets (6579)

messages (6576)

migration (6665)

mutual takeover (6605)

new install (6664)

NFS server node (6611), (6621)

NFS server takeover example (6615)

NFS server worksheet (6671)

node availability (6581)

node_down event (6582)

non-disruptive maintenance (6629)

other scripts (6659)

process summary (6649)

rc.db2pe (6602)

rc.db2pe script (6613)

recovery program file (6647)

recovery scripts (6657)

rotating assignment (6594)

rules file (6635)

rules file restriction (6639)

rules.hacmprd file (6637)

script file installation (6653)

script files (6651)

shutdown (6655)

SP frame (6588)

SP switch alias address (6619)

SP switch considerations (6617)

startup recommendations (6627)

START_STOP_TIME (6603)

switch alias address (6609)

unique names (6596)

user-defined event (6633)

user-defined events (6585)

volume and filesystems worksheet (6669)

worksheets (6667)

HACMP ES configuration examples (6626)

HACMP ES rules file (6575)

hardware disk arrays (6217)

hash join

overview of (7126)

heartbeats (6578)

heuristic operations

guidelines (6485), (6504)

recovering indoubt transactions (6484)

hierarchy table (5605)

High Availability Cluster Multi-Processing configurations (6551)

hot standby mode (6561)

modes of failover support (6555)

mutual takeover mode (6565)

overview (6554)

hot standby mode (6556)

hot standby takeover HACMP ES example (6608)

I/O

configuration parameters (7594)

enabling parallel I/O (7322)

prefetch parallel (7319)

IBM eNetwork Directory

extending the directory schema (8630)

object classes and attributes (8632)

IBMCATGROUP nodegroup (5497)

IBMDEFAULTGROUP nodegroup (5499)

IBMTEMPGROUP nodegroup (5498)

identifying nicknames (5675)

identity sequence (8545)

idle agent (7372)

images

backup (6302)

implicit schema use (5409)

IMPLICIT_SCHEMA authority (5549)

IMPLICIT_SCHEMA privilege, definition of (6011)

IMPORT utility

binding to a database (5524)

LOAD (5590)

referential integrity implications for (5593)

IN (Intent None) mode (6813)

inactive DRDA agent (7377)

incompatibilities

COLNAMES (planned) (7943)

Column Data Type to BIGINT (7951)

column mismatch (7952)

creating databases (7967), (7975)

description (7937)

FK_COLNAMES (planned) (7942)

foreign key column names (7946)

PK_COLNAMES (planned) (7941)

planned (7939)

primary key column names (7945)

read-only views (planned) (7940)

SYSCAT.CHECKS Column TEXT (7950)

SYSCAT.INDEXES Column COLNAMES (7949)

SYSCAT.STATEMENTS column TEXT (7948)

SYSCAT.VIEWS column TEXT (7947)

Version 5 (7973)

Version 6 (7944)

incompatibilities for Version 5

external table functions (7974)

incompatibilities for Version 6

character name sizes (7959)

current explain mode (7969)

datalink columns (7964)

dependency codes (7954)

event monitor output stream format (7963)

FOR UPDATE syntax (7958)

Java programming (7957)

OBJCAT views (7953)

obsolete configuration keywords (7962)

obsolete database configuration parameters (7972)

PC/IXF format changes (7960)

RUMBA (7971)

SELECT privilege on hierarchy (7968)

SQLNAME in a non-doubled SQLVAR (7961)

SYSFUN string function signatures (7965)

SYSIBM base catalogs (7955)

SYSTABLE column change (7966)

USING and SORT BUFFER (7970)

VARCHAR data type (7956)

index

administering (6955)

changing (5843)

clustering (6958)

consideration for outer versus inner table determination (7132)

CREATE INDEX statement (5693)

CREATE UNIQUE INDEX statement (5696)

creating (5678)

definition of (5681)

definition of index ANDing (7095)

definition of index ORing (7094)

disadvantages of indexing (6949)

DROP INDEX statement (5844)

estimating size (5300)

guidelines for indexing (6952)

how used (5692)

index advisor (6950)

index re-creation time (indexrec) parameter (7680)

index-only access (8503)

index-only access (7092)

indexing versus no indexing (6948)

lock mode (6856)

look-up, affect on locks (6851)

management, overview of (6947)

multiple (7093)

naming rules (7990)

nickname performance considerations (7203)

non-unique (5694)

nonprimary (5850)

optimizing number (5684)

prefetch (7308)

primary (5572)

primary versus user-defined (5683)

privileges (6042)

reorganizing (7343), (7350)

scan (7078) See also index scan

structure (7077)

temporary space (5301)

unique (5698)

unique on primary key (5194)

unique on unique key (5195)

index advisor (6951), (7254)

index clustering

cluster factor statistic (7001)

cluster ratio statistic (7000)

index creation (6956)

index key, definition (5685)

index page prefetch (7307)

INDEX privilege, definition (6025)

index reorganization (6954)

index scan

clustered index (7096)

ordering data (7091)

overview of (7074)

predicate (7085)

predicate terminology (7102)

previous leaf pointers (7081)

search process (7079)

to delimit a range (7083)

use of (7080)

WHERE clause, use of (7086)

Index SmartGuide (5864)

indexes

online reorganization (5688), (5701)

indexrec configuration parameter (7681)

indexsort configuration parameter (7598)

indoubt transactions

definition of (6479)

recovering (6481), (6489), (8312)

recovery when not using DB2 Syncpoint Manager (6493)

recovery when using DB2 Syncpoint Manager (6491)

resynchronizing (6488)

initdari_jvm configuration parameter (7644)

initial number of agents in pool (num_initagents) database manager parameter (7632)

inner-table and outer-table joins, method (7157)

inner-table join, method (7160), (7163)

INSERT privilege, definition (6026)

INSERT statement

referential integrity implications for (5244)

Installation and Configuration Supplement (7896)

installation tasks for HACMP ES (6663)

installing the sample database (8318)

instance (5875)

adding a partition server (5709)

default (5428)

definition (5423)

directory (5426)

dropping a partition server (5710)

owner (5430)

removing (5711)

setting the current (5434)

instance level profile registry (5441)

instance owner (5431)

instance parallelism support (6924)

instance profile registry (5444)

instance user

setting the environment (5429)

instances

altering (5705)

auto-starting (5435)

creating (5427)

disadvantages (5425)

listing (5433), (5706)

listing database partition servers (5707)

overview of (5401)

reasons for using (5424)

running multiple (5436)

starting (5398)

stopping (5399)

time difference among nodes, maximum (7824)

updating (5708)

intra-partition parallelism (7323)

enabling (5411)

intra_parallel configuration parameter (6923), (7836)

IN_TRAY sample table (8328)

io_ratio server option (6974)

ipx_socket configuration parameter (7759)

IS (Intent Share) mode (6814)

isolation level

choosing (6785)

cursor stability (6778)

description of (6763)

read stability (6774)

repeatable read (6768)

specifying, overview (6786)

uncommitted read (6779)

issuing commands to multiple database partition servers (8575)

IX (Intent Exclusive) mode (6817)

java applet (5904)

java_heap_sz database manager configuration parameter (7582)

jdk11_path database manager configuration parameter (7865)

join

Cartesian products (7138)

composite tables (7142)

definition of (7117)

eliminating redundancy (7058)

enumeration algorithm (7137)

hash join (7125)

merge join (7123)

nested loop join (7122)

optimizer search strategies (7135)

outer versus inner table determination (7127)

overview of (7120)

shared aggregation (7059)

subquery transformation by optimizer (7057)

tables (7118)

join path

definition of (5206)

join strategies (7147)

broadcast inner-table (7161)

broadcast outer table (7152)

collocated (7149)

directed inner-table (7164)

directed inner-table and outer-table (7158)

directed outer-table (7155)

in a partitioned database (7148)

keepalive packets (6580)

keepdari configuration parameter (7640)

keeping related data together (6196)

key (5196) See also primary key

composite (5225)

definition of (5197), (5224)

foreign (5223)

primary (5192)

unique (5193)

Large Object (LOB)

column considerations (5562)

large objects

allocation objects (5299)

column definition (5168)

data objects (5298)

DMS storage (7360)

estimating size (5293)

LDAP (5514), (5903), (8613)

License Center (5887)

license information

altering (5704)

license management (5437)

Lightweight Directory Access Protocol (5902)

lightweight directory access protocol (5513), (8612)

attaching remotely (8618)

cataloging a node entry (8615)

configure host databases (8622)

deregistering databases (8619)

deregistering servers (8616)

disable (8625)

enable (8624)

extending directory schema (8628)

IBM eNetwork Directory (8629)

multiple user security (8627)

object classes and attributes (8631)

refreshing entries (8620)

registering databases (8617)

searching (8621)

security (8626)

setting registry variables (8623)

updating protocol information (8614)

LIST INDOUBT TRANSACTIONS command

use in performing heuristic actions (6486), (6505)

LIST NODES CMD

backing up database, determining list of data nodes (6278)

LIST NODES command, using when backing up database (6277)

LOAD utility

overview (6130)

LOB (5294) See also large objects

local database directory

overview of (5507)

locales

deriving in application programs (8528)

how DB2 derives (8529)

Locate (5879)

LOCK TABLE statement

in minimizing escalations (6839)

use to override locks (6857)

locking

maximum percent of lock list before escalation (maxlocks) parameter (7590)

maximum storage for lock lists (locklist) parameter (7532)

time interval for checking deadlock (dlchktime) parameter (7586)

locklist configuration parameter (7533)

affect on query optimization (6937)

impact on memory (7272)

locks

acquiring (6794)

attributes of (6796)

attributes, types of processing (6849)

avoiding global deadlocks (6842)

compatibility of, ensuring (6828)

configuration parameter (7585)

conversion of (6832)

creating, using cursor stability (6777)

creating, using repeatable read (6767)

deadlock, using FOR UPDATE OF (6846)

duration attribute (6798)

escalation and actions to take (6838)

escalation of (6835)

exclusive (X) mode (6808)

exclusive mode, reasons for using (6862)

factors affecting (6847)

improving concurrency (6837)

intent exclusive (IX) mode (6805)

intent none (IN) mode (6802)

intent share (IS) mode (6803)

locktimeout configuration parameter (6841)

mode attribute (6799)

modes for index scan (6855)

modes for table scan (6853)

object attribute (6797)

overview of (6790)

read stability (6773)

reducing waits for (6840)

share (S) mode (6804)

share mode, reasons for using (6860)

share with intent exclusive (SIX) mode (6806)

state (mode), types of (6801)

superxclusive (Z) mode (6809)

update (U) mode (6807)

locktimeout configuration parameter (7592)

log

audit (6101)

log files

governor log file (7410)

written for data redistribution (7477)

log sequence (6383)

logbufsz configuration parameter (6350), (7526)

logfilsiz configuration parameter (6349), (7652)

logging

raw devices (5544)

logging facility (6163) See also logs

loghead configuration parameter (7662)

logical file system

limits (5354)

logpath configuration parameter (7660)

logprimary configuration parameter (6346), (7654)

logretain configuration parameter (6353), (7671)

logs

active (6164)

archived (6165)

change database log path (newlogpath) parameter (7657)

configuration parameters affecting log activity (7665)

configuration parameters affecting log files (7650)

estimating size (5302)

first active log file (loghead) parameter (7661)

identifying (6368)

location (6369)

location of log files (logpath) parameter (7659)

log buffer size (logbufsz) parameter (7525)

log retain enable (logretain) parameter (7670)

log retain status indicator (log_retain_status) parameter (7737)

losing (6373)

managing (6367)

number of primary log files (logprimary) parameter (7653)

number of secondary log files (logsecond) parameter (7655)

offline archived logs (6171)

online archived logs (6169)

recovery range and soft checkpoint interval (softmax) parameter (7668)

size of log files (logfilsiz) parameter (7651)

storage required (6191)

use of timestamp (6370)

userexit program (6192)

logsecond configuration parameter (6348), (7656)

log_retain_status configuration parameter (7738)

long field data

alternatives to (5292)

DMS storage (7359)

estimating size (5291)

losing logs (6372)

managing DB2 for OS/390 objects (5876)

managing remote databases (5890)

managing storage (5896)

managing users (5892)

many-to-many relationships (5161)

many-to-one relationships (5159)

maxagents (7374)

maxagents configuration parameter (7618)

effect on memory (7270)

maxappls configuration parameter (7608)

DB2 transaction manager considerations (6473)

effect on memory (7269)

XA interface considerations (6512)

maxcagents configuration parameter (7616)

maxdari configuration parameter (7642)

maxfilop configuration parameter (7611)

maximum Java interpreter heap size (java_heap_sz) database manager parameter (7581)

maximum number of coordinating agents (max_coordagents) database manager parameter (7619)

maximum query degree of parallelism configuration parameter (6941), (7835)

maximum time difference among nodes (max_time_diff) database manager parameter (7819)

maxlocks configuration parameter (7591)

affect on query optimization (6938)

maxtotfilop configuration parameter (7612)

max_connretries database manager configuration parameter (7815)

max_coordagents database manager configuration parameter (7622)

max_querydegree configuration parameter (6926), (7834)

max_time_diff database manager configuration parameter (7821)

media failure

logs (6190)

memory

agent communication memory (7568)

agent private memory (7546)

application communication memory (7569)

application heap size (applheapsz) parameter (7556)

application shared memory (7537)

application support layer heap size (aslheapsz) parameter (7571)

configuration parameters (7267)

considerations for system administrator (SYSADM) (7261)

database heap (dbheap) parameter (7522)

database manager instance (7576)

database shared memory (7516)

extending (7393)

for processing a database (7265)

package cache size (pckcachesz) parameter (7534)

setting parameter values (7289)

sort heap size (sortheap) parameter (7548)

sort heap threshold (sheapthres) parameter (7551)

statement heap size (stmtheap) parameter (7553)

use by the database manager (7264)

use of (7260)

when committed (7290)

memory usage

application control heap (7544)

merge join

outer versus inner table determination (7134)

overview of (7124)

message anchor (7791)

Message Reference (7897)

messages

audit facility (6118)

Microsoft Transaction Server

connection pooling (6546)

enabling support in DB2 (6539)

installation and configuration (6541)

reusing ODBC connections (6548)

software prerequisites (6540)

supported DB2 database servers (6544)

testing DB2 with sample application (6550)

transaction time-out and DB2 connection behavior (6545)

tuning TCP/IP communications (6549)

verifying the installation (6542)

migration (7927)

authority required (7931)

overview of (7928)

release-to-release incompatibilities (7933)

restrictions (7930)

steps required (7936)

storage requirements (7932)

migration tasks for HACMP ES (6666)

mincommit configuration parameter (6351), (7667)

minimum recovery time (6361)

MINPCTUSED (6953), (7353)

MINPCTUSED clause (5700)

min_priv_mem configuration parameter (7564)

modifying a column (5754)

modifying a table (5746)

monitor switches (7387)

monitoring (7388)

monitoring rah processes (8586)

mon_heap_sz configuration parameter (7578)

moving data (5895), (6131) See also data transfer

multimedia objects (5151)

multipage_alloc configuration parameter (7742)

effect on memory (7325)

multiple buffer pages, allocating (7327)

multiple instances (5402)

use with ADSTAR Distributed Storage Manager (6436)

multiple logical node failover (6564)

multiple logical nodes (8608)

multisite update (6446)

overview of (6455)

configuration parameters (7692)

recovering indoubt transactions (6480)

updating multiple databases (6458)

mutual takeover HACMP ES example (6606)

mutual takeover mode (6557)

naming scheme, database directories (5270)

national language support (NLS)

bidirectional CCSID support (8534)

character sets (8530)

datetime values (8564)

nested loop join

outer versus inner table determination (7130)

overview of (7121)

newlogpath configuration parameter (6352), (7658)

NFS server node (6612), (6622)

NFS server takeover example (6616)

nickname

creating (5670)

package privilege processing (6069)

privileges (6033)

views across data sources (6075)

nickname query performance tips (6902)

nicknames

creating indexes on (7204)

gathering statistics (6989)

global optimization, characteristics affecting (7201)

pushdown analysis (7174)

pushdown analysis, characteristics affecting (7179)

view statistics (6991)

nname configuration parameter (7752)

NO ACTION delete rule

overview of (5249)

node (6211)

catalog, recovery considerations (6212)

cataloging (5415)

changing in nodegroup (5728)

connection elapse time (7781)

coordinating agent, maximum (7624)

creating database across all (5420)

data location, determining (5315)

data redistribution, process (7466)

determining list of data nodes (6279)

determining where RUNSTATS execution occurs (6997)

failed database partition server, recovering (6263)

maximum number of connection retries (7814)

maximum time difference among (7820)

message buffers, number, specifying (7797)

other operations during redistribution (7481)

redistributing data across database partitions (7437)

synchronization, recovery considerations (6224)

transaction recovery on a failed database partition server (6256)

transaction recovery on an active database partition server (6243)

node configuration file (5306)

changing (5716)

creating (5488)

node configuration file, having the database manager update (7431)

node connection retries (max_connretries) (7813)

node level profile registry (5443)

node number (5490)

node server option (6976)

nodegroup

altering (5729)

creating (5515)

designing (5305)

IBMDEFAULTGROUP, table created in by default (5612)

initial definition (5496)

mapping table spaces (5376)

other operations during redistribution (7480)

partitioning key, changing (5795)

partitioning map entries (5312)

recovering failed database partition server (6269)

redistributing data (7438)

table considerations (5611)

transaction recovery on a failed database partition server (6257)

transaction recovery when a database partition server is active (6249)

nodetype configuration parameter (7862)

node_down event (6583)

non-disruptive maintenance for HACMP ES (6630)

non-recoverable databases (6159)

non-unique index

dropping (5848)

nonprimary index

dropping (5847)

dropping implications for applications (5851)

normal form

first (5212)

fourth (5215)

overview of (5211)

second (5213)

third (5214)

normalizing

definition of (5210)

tables (5208)

notifylevel configuration parameter (7843)

NS (Next Key Share) mode (6815)

NT_SCATTER_DMSDEVICE (8147)

NT_SCATTER_DMSFILE (8146)

NT_SCATTER_SMS (8148)

null value

alternative to default value (5191)

column definition (5557)

number of database backups configuration parameter (7684)

number of FCM message anchors (fcm_num_anchors) database manager parameter (7786)

number of FCM request blocks (fcm_num_rqb) database manager parameter (7806)

numdb configuration parameter (7859)

effect on memory (7268)

numeric string column option (7182)

numsegs configuration parameter (7602)

num_db_backups configuration parameter (7683)

num_estore_segs configuration parameter (7605)

impact on memory (7276)

num_freqvalues configuration parameter (7747)

num_initagents database manager configuration parameter (7634)

num_initdaris configuration parameter (7646)

num_iocleaners configuration parameter (7596)

managing the buffer pool (7294)

num_ioservers configuration parameter (7597)

impact on data prefetch (7321)

num_poolagents (7375)

num_poolagents configuration parameter

impact on parallel systems (7381)

num_poolagents database manager configuration parameter (7630)

num_quantiles configuration parameter (7748)

NW (Next Key Weak Exclusive) mode (6821)

NX (Next Key Exclusive) mode (6820)

object class attributes

DB_Authentication (DAU) (8244)

DB_Comment (DCO) (8250)

DB_Communication_Protocol (8253)

DB_Database_Locator_Name (8259)

DB_Database_Protocol (8256)

DB_Native_Database_Name (8262)

DB_Object_Type (8265)

DB_Principal (DPR) (8247)

DB_Product_Name (8268)

DB_Product_Release (8271)

DB_Target_Database_Info (8274)

object names, federated database (7997)

objectname configuration parameter (7758)

occurrence

definition of (5149)

offline archived logs

definition (6167)

ROLLFORWARD command support (6168), (6170)

versus active logs (6174)

where stored (6175)

offline table space (6140)

OFFLINE table spaces (6201)

one-to-many relationships (5160)

one-to-one relationships (5163)

online archived logs

ROLLFORWARD command support

online index reorganization (7351)

online reorganization

indexes (5687)

opening the Journal (5886)

operating system restrictions (6197)

optimization class

guidelines (6875)

levels of (6870)

setting (6871)

optimization, global

analyzing (7206)

explain tool cost information (7207)

nickname characteristics, affecting (7200)

server characteristics, affecting (7194)

OPTIMIZE FOR clause (6884), (6901)

optimizer (7069), (7073) See also database access, database access

adjusting amount of optimization (6869)

affect of statistics (6988)

creating access plan (7047)

distribution statistics impact (7023)

selecting optimal join (7136)

sorting (7166)

use of replicated summary tables (7145)

ORG sample table (8329)

OS/2 user exit

archive considerations (8454)

archiving log files (8421)

BACKUP DATABASE considerations (8461)

BACKUP DATABASE utility (8417)

calling format (8450)

db2uexit (8432)

db2uexit.CAD (8442)

db2uexit.ex1 (8437)

db2uexit.ex2 (8439)

db2uexit.ex3 (8440)

db2uexit.ex4 (8441)

error handling (8468)

invoking (8430)

overview (8416)

RESTORE DATABASE considerations (8462)

RESTORE DATABASE utility (8419)

retrieve considerations (8455)

retrieving log files (8422)

sample user exit programs (8435)

outbound connection pool (7376)

outer versus inner table determination

merge join (7133)

nested loop join (7129)

overview of (7128)

outer-table join, method (7153)

package

access privileges with SQL (6062)

dependencies (5852)

dropping (5849)

inoperative (5854)

invalid after adding foreign key (5774)

isolation levels, specifying (6764)

owner (6061)

privileges (6036)

revoking privileges (6054)

page cleaners (7295)

page cleaners configuration parameter

managing the buffer pool (7296)

page size

considerations (5290)

parallel operations

configuration parameters (7779)

parallelism concepts

overview (5143)

parallelism, intra-partition

enabling (5412)

parent row

definition (5230)

parent table

definition (5228)

partition compatibility See partitioning data

partitioned database

configuration parameters (7778)

partitioned database environment

decorrelation of a query (7065)

replicated summary tables (5325)

partitioned failover (6563)

partitioning data (5413)

data distribution, specifying (7447)

data redistribution across database partitions (7465)

data redistribution in tables (7469)

data redistribution, error recovery (7475)

designing your physical database (5307)

partition compatibility (5322)

partitioning key and partitioning map interaction (5313)

partitioning keys, designing your physical database (5320)

partitioning map, definition (5317)

partitioning map, target, specifying during data redistribution (7462)

partitioning key

changing (5793)

data hashing (5314)

index partitioned on partitioning key (5689)

table considerations (5610)

partitioning map

definition (5310)

example (5316)

purpose (5311)

redistributing data (7448)

target, specifying during data redistribution (7460)

passing IDs and passwords to data sources (5965)

password server option (6978)

passwords

changing (7984)

naming (7981)

pckcachesz configuration parameter (7535)

impact on memory (7277)

performance

application considerations (6758)

book summary (6757)

catalog information, reducing contention for (5418)

catalog statistics (7205)

configuration parameters (7498)

considerations for ROLLFORWARD command (6204)

data distribution, determining using SQL (7450)

data source updates (7188)

database caching (6918)

database managed storage (DMS) (7354)

db2batch benchmarking tool (7491)

disk storage (6756)

elements of (6751)

environmental consideration (6930)

federated database systems (7170)

global optimization (7193)

governor affect on database manager (7417)

guidelines (6752)

limits to tuning (6754)

locks, effect of (6825)

nickname index considerations (7202)

num_ioservers configuration parameter (7320)

operational considerations (7258)

optimization class, adjusting (6867)

process (6753)

programming considerations (6759)

pushdown analysis (federated systems) (7173)

query rewrite by compiler (7055)

quick determination (6755)

redistributing data (7439)

remote SQL generation (7192)

remote SQL generation for data sources (7189)

replicated summary tables (5327)

row blocking, guidelines (6892)

RUNSTATS utility (7002)

server characteristics (7196)

statistics (6986)

summary table (5654)

table collocation, data redistribution (7443)

tuning using explain (7249)

using explain facility (7217)

Performance Configuration SmartGuide (5720), (5865)

performance information

accessing remote (8606)

displaying (8605)

enable remote access (8604)

resetting values (8607)

performance monitor

using (7383)

Windows NT (8601)

piped versus non-piped sorts

overview of (7168)

plan hints example (7199)

plan_hints server option (6980)

point of recovery (6178)

point-in-time monitoring (7389)

pool size for agents, controlling (7629)

populating typed table (5602)

PRECOMPILE command

OWNER option (6060)

precompiling

isolation level, specifying (6788)

predicate (7105), (7106) See also predicate terminology, predicate category

adding by optimizer (7067)

definition of (7084)

distribution statistics (7024)

inclusive inequality (7090)

strict inequality (7089)

translation by optimizer (7066)

when applied (7062)

predicate category

index SARGable predicate (7108)

overview of (7104)

range delimiting predicate (7107)

residual predicate (7114)

SARGable predicate (7112)

usage (7116)

predicate terminology

overview of (7103)

prefetch (7256), (7314) See also sequential detection

buffer pool (7303)

clustering page reads (7099)

data page (7304)

I/O servers (7318)

index page (7305)

intra-partition parallelism (7317)

list prefetch (7316)

PREFETCHSIZE clause (7309)

sequential (7306)

sequential detection (7313)

tuning using database system monitor (7311)

prefix sequences (8588)

previous leaf pointers (7082)

primary index

definition of (5199)

dropping (5846)

uniqueness for primary key (5571)

primary key

adding (5768)

composite key (5201)

criteria for choosing (5203)

definition of (5198), (5222)

DROP PRIMARY KEY clause, ALTER TABLE statement (5783)

primary index (5570)

primary index, creating (5682)

privileges required for dropping (5784)

UPDATE, referential integrity implications for (5257)

when to create (5573)

PRIMARY KEY clause

adding primary key (5770)

restrictions (5569)

privileges

ALTER (6021)

BINDADD (6001)

CONNECT (6002)

CONTROL (6018)

create view for information (6097)

CREATETAB (6003)

CREATE_NOT_FENCED (6004)

database manager (6000)

definition of (5979)

DELETE (6022)

GRANT statement (6047)

granting and revoking authority (5999)

hierarchy (5984)

implicit for packages (5987)

IMPLICIT_SCHEMA (6005)

INDEX (6041)

indirect privileges, nicknames (6068)

individual (5986)

INSERT (6024)

nickname (6032)

ownership (CONTROL) (5985)

package (6037)

PUBLIC (6013)

REFERENCES (6027)

required for REORG utility (7349)

retrieving authorization names with (6083)

retrieving for names (6092)

REVOKE statement (6050)

schema (6015)

SELECT (6029)

server (6034)

summary of (5983)

system catalog listing (6080)

table (6016)

tasks and required authorities (6078)

view (6017)

views with nicknames (6074)

priv_mem_thresh configuration parameter (7565)

problem determination

XA interface (6528)

process summary for HACMP ES (6650)

process, DB2 (7366)

processors, adding to a machine (7421)

profile registry (5439)

PROJECT sample table (8330)

PUBLIC

privileges (6012)

pushdown analysis

analyzing (7186)

explain tool operators (7187)

nickname characteristics, affecting (7180)

overview (7171)

query characteristics, affecting (7185)

server characteristics, affecting (7176)

pushdown server option (6982)

qualified object names (5407)

quantile value statistics

number to collect (7022)

range statistics (7026)

rules for updating (7034)

query optimizer (7046) See also optimizer

query rewrite See also compiler

overview of (7053)

summary table (5653)

query_heap_sz configuration parameter (7560)

impact on memory (7283)

Quick Beginnings for OS/2 (7906)

Quick Beginnings for UNIX (7907)

Quick Beginnings for Windows NT (7908)

quickly retrieve first few rows (6879)

RACF (8278)

rah (8577), (8578)

RAHDOTFILES (8595)

RAHOSTFILE (8590)

RAHOSTLIST (8591)

RAHWAITTIME (8587)

RAID (6216)

optimize performance (5389)

range delimiting predicate

index SARGable predicate (7110)

overview of (7109), (7111)

raw devices (5541)

raw I/O (5546)

raw logs (5545)

rc.db2pe (6601)

rc.db2pe script (6614)

read locks (6865)

read only cursors

uncommitted read (6782)

read stability, overview (6770)

reading

read stability, overview of (6769)

repeatable read, overview of (6765)

uncommitted read, overview of (6780)

reconcile pending state (6397)

records

audit (6102)

recoverable databases (6158)

recovering inoperative summary table (5832)

recovering inoperative view (5827)

recovery

allocating log during database creation (5519)

configuration parameters (7675)

consistent database (6228)

crash (6226)

damaged table spaces (6200)

definition of (6137)

dropped table (6364)

factors affecting (6157)

history file (6376)

interaction with DB2 Data Links Manager (6413)

operating system restrictions (6198)

overview of (6136)

performance (6205)

point of (6179)

point-in-time (6152), (6374)

reducing logging on work tables (6177)

roll-forward (6334)

storage required (6185)

time required (6183)

to end of logs (6151)

two-phase commit protocol (6242)

version (6271)

recovery history file (6375)

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

recovery log (5518)

recovery program file for HACMP ES (6648)

recovery scripts for HACMP ES (6658)

rec_his_retentn configuration parameter (7685)

redistributing data

across nodes (5732)

connection to catalog database partition (7464)

data distribution, determining using SQL (7451)

database partition, process overview (7463)

database partitions, adding (7455)

database partitions, dropping (7454)

distribution file (7449)

distribution, specifying (7446)

error recovery (7473)

log file (7476)

operation successful (7471)

operation unsuccessful (7472)

other operations during redistribution (7479)

partitioning map, target, specifying (7461)

purpose (7440)

replicated summary table restriction (7444)

table collocation (7442)

table, process overview (7468)

reducing logging on work tables (6176)

reference type (5183)

design (5264)

REFERENCES clause

adding foreign key (5771)

delete rules (5589)

referential constraints (5587)

use of (5588)

REFERENCES privilege, definition (6028)

referential constraints (5239) See also referential integrity

add to table (5766)

defining (5575)

definition of (5237)

FOREIGN KEY clause, CREATE/ALTER TABLE statements (5577)

overview of (5219)

PRIMARY KEY clause, CREATE/ALTER TABLE statements (5576)

REFERENCES clause, CREATE/ALTER TABLE statements (5578)

referential integrity (5238) See also referential constraints

definition of (5218)

DELETE rules (5248)

INSERT rules (5243)

overview of (5220)

refreshing data in summary table (5799)

registry variables (8000)

changing (5713)

DB2ACCOUNT (8002)

DB2ADMINSERVER (8192)

DB2ATLD_PORTS (8118)

DB2ATLD_PWFILE (8120)

DB2BIDI (8004)

DB2BPVARS (8144)

DB2BQTIME (8108)

DB2BQTRY (8110)

DB2CHECKCLIENTINTERVAL (8058)

DB2CHGPWD_EEE (8122)

DB2CHKPTR (8150), (8152)

DB2CLIENTADPT (8102)

DB2CLIENTCOMM (8104)

DB2CLIINIPATH (8194)

DB2CODEPAGE (8006)

DB2COMM (8060)

DB2CONNECT_IN_APP_PROCESS (8044)

DB2COUNTRY (8008)

DB2DBDFT (8010)

DB2DBMSADDR (8012)

DB2DEFPREP (8196)

DB2DIRPATHNAME (8100)

DB2DISCOVERYTIME (8014)

DB2DMNBCKCTLR (8016), (8200)

DB2ENVLIST (8046)

DB2INCLUDE (8018)

DB2INSTANCE (8048)

DB2INSTDEF (8020)

DB2INSTOWNER (8022)

DB2INSTPROF (8050)

DB2IQTIME (8112)

DB2LDAP_SEARCH_SCOPE (8208)

DB2LIBPATH (8052)

DB2LOADREC (8210)

DB2LOCK_TO_RB (8212)

DB2MEMDISCLAIM (8154)

DB2MEMMAXFREE (8156)

DB2NBADAPTERS (8064)

DB2NBBRECVNCBS (8072)

DB2NBCHECKUPTIME (8066)

DB2NBDISCOVERRCVBUFS (8026)

DB2NBINTRLISTENS (8068)

DB2NBRECVBUFFSIZE (8070)

DB2NBRESOURCES (8074)

DB2NBSENDNCBS (8076)

DB2NBSESSIONS (8078)

DB2NBXTRANCBS (8080)

DB2NETREQ (8082)

DB2NODE (8054), (8126)

DB2NOEXITLIST (8214)

DB2NTMEMSIZE (8164)

DB2NTNOCACHE (8166)

DB2NTPRICLASS (8168)

DB2NTREMOTEPREG (8216)

DB2NTWORKSET (8170)

DB2OPTIONS (8028), (8114)

DB2PATH (8056)

DB2PORTRANCE (8128)

DB2PRIORITIES (8174)

DB2RETRY (8084)

DB2RETRYTIME (8086)

DB2ROUTE (8106)

DB2ROUTINE_DEBUG (8218)

DB2RQTIME (8116)

DB2SERVICETPINSTANCE (8088)

DB2SLOGON (8030)

DB2SORCVBUF (8220)

DB2SORT (8222)

DB2SOSNDBUF (8090)

DB2SYSPLEX_SERVER (8092)

DB2SYSTEM (8224)

DB2TIMEOUT (8032)

DB2TRACEFLUSH (8038)

DB2TRACENAME (8034)

DB2TRACEON (8036)

DB2TRCSYSERR (8040)

DB2UPMPR (8226)

DB2YIELD (8042)

DB2_AVOID_PREFETCH (8140)

DB2_BINSORT (8142)

DB2_CORRELATED_PREDICATES (8130)

DB2_DJ_COMM (8198)

DB2_FALLBACK (8202)

DB2_FORCE_FCM_BP (8124)

DB2_FORCE_NLS_CACHE (8062)

DB2_FORCE_TRUNCATION (8204)

DB2_GRP_LOOKUP (8206)

DB2_HASH_JOIN (8132)

DB2_LIC_STAT_SIZE (8024)

DB2_LIKE_VARCHAR (8134)

DB2_MMAP_READ (8158)

DB2_MMAP_WRITE (8160)

DB2_NEW_CORR_SQ_FF (8136)

DB2_NO_PKG_LOCK (8162)

DB2_OVERRIDE_BPF (8172)

DB2_PRED_FACTORIZE (8138)

DB2_RR_TO_RS (8176)

DB2_SORT_AFTER_TQ (8178)

DB2_VI_DEVICE (8098)

DB2_VI_ENABLE (8094)

DB2_VI_VIPL (8096)

Distributed Computing Environment (DCE) (8285)

DLFM_BACKUP_DIR_NAME (8180)

DLFM_ENABLE_STPROC (8182)

DLFM_GC_MODE (8184)

DLFM_INSTALL_PATH (8186)

DLFM_LOG_LEVEL (8188)

DLFM_PORT (8190)

relation scan

definition of (7070)

when used (7100)

relationship

many-to-many (5162)

many-to-one (5158)

one-to-many (5157)

one-to-one (5164)

types of (5156)

release configuration parameter (7703)

release to release incompatibilities

description (7938)

remote administration (5461)

remote data services

node name (nname) parameter (7751)

remote procedure calls (6917) See also stored procedures

remote SQL generation

overview (7190)

remote system (5891)

remote unit of work

overview of (6452)

renaming table (5806)

REORG utility

authority and privileges required (7347)

binding to a database (5525)

overview of (7341)

reorganize index

online (7352)

REORGCHK command (7346)

replicated summary table

redistributed nodegroup restriction (7445)

replicated summary tables (5324)

replicating data (5901)

replication

configuration (5492)

Replication Guide and Reference (7898)

request blocks, FCM daemon to agent communication, number (7811)

residual predicate

overview of (7115)

resource access control facility (RACF) (8280)

RESTART DATABASE command (6232)

restbufsz configuration parameter (7531)

restore

buffer(s) (6320)

database (6148)

existing database (6330)

invoking (6317)

new database (6333)

planning (6314)

redirected (6328)

table space (6154)

RESTORE command

access errors, error handling (6299), (6323)

authority required (6283), (6315)

buffer (6294), (6321)

code page restriction (6326)

concurrency control (6297)

considerations for (6276), (6313)

database alias restriction (6291), (6318)

DB2 Data Links Manager considerations (6389), (6392)

DB2 Data Links Manager, restoring database without roll forward (6399)

disk output created (6305)

overview of (6275), (6310)

system crash (6295), (6337)

tape output created (6306)

use in roll-forward recovery (6341)

use with ADSTAR Distributed Storage Manager (6418)

Restore Database SmartGuide (5866)

RESTORE DATABASE utility

considerations for user exit program (8464)

default restore buffer size (restbufsz) parameter (7530)

error handling for user exits (8470)

user exit program for OS/2 (8420)

restore_pending configuration parameter (7741)

restoring a database

overview of (6308)

RESTORE command (6309), (6312)

restoring database

catalog node considerations (6213)

database partition synchronization (6222)

log disk, considerations for media recovery (6208)

node synchronization (6221)

recovering failed database partition server (6265)

reducing impact of media failure (6207)

timestamp considerations (6223)

transaction recovery on the failed database partition server (6252)

transaction recovery when the database partition server is active (6245)

transaction recovery, overview (6233)

RESTRICT

delete rule, overview of (5250)

resync_interval configuration parameter (7694)

DB2 transaction manager considerations (6469)

retrieve first few rows quickly (6878)

retrieve log files

for OS/2 (8423)

for UNIX-based systems (8428)

retrieving data

index (5691)

reverse scans (7076), (7088)

REVOKE statement

example of (6052)

implicit issuance (6057)

security (8282)

use of (6051)

revoking Authorities and Privileges (5894)

REXX

isolation level, specifying (6789)

roll-forward recovery (6335)

authority required (6357)

invoking (6359)

long space requirements (5303)

overview of (6149)

planning (6356)

rolling forward table space (6355)

table space (6156)

ROLLFORWARD command

backup considerations (6336)

configuration file parameters support (6343)

DB2 Data Links Manager considerations (6393)

DB2 Data Links Manager, point-in-time roll forward example (6411)

DB2 Data Links Manager, rolling forward to a point in time (6409)

DB2 Data Links Manager, rolling forward to end of logs (6404)

log management considerations (6366)

performance considerations (6203)

restore considerations (6340)

timestamps (6360)

ROLLFORWARD DATABASE utility

roll forward pending (rollfwd_pending) parameter (7735)

rollfwd_pending configuration parameter (7736)

root type (5175)

rotating assignment (6595)

route_obj_name configuration parameter (7765)

routing information objects

creating (8239)

example (8240)

row (6888) See also row blocking

blocking (6887)

delete from parent table (5242)

deleting related rows (5252)

dependent (5233)

lock compatibility, ensuring (6830)

locking (6766), (6772), (6776)

occurrence (5150)

parent (5229)

partitioning key and partitioning map determine location (5319)

read stability (6771)

types of locks on (6810)

row blocking

types of (6891)

overview of (6889)

row identifier (RID) (8509)

rqrioblk configuration parameter (7574)

impact on memory (7288)

rules file for HACMP (6636)

rules file restriction (6640)

rules.hacmprd file (6638)

rules.hadmprd file (6574)

running commands in parallel (8582)

RUNSTATS CMD/API

node where execution occurs (6996)

RUNSTATS utility

for reorganization (6999)

use of (6993)

use of in a partitioned database environment (6995)

with distribution clause (7016)

S (Share) mode (6816)

SALES sample table (8331)

sample database

erasing (8320)

installing (8319)

sample tables (8317), (8334)

sample user exit programs

for OS/2 (8436)

for UNIX-based systems (8444)

overview (8434)

SARGable predicate

overview of (7113)

scalability to 16 nodes (6572)

scalar UDF (5622)

scaling a configuration (7418)

scheduling saved command scripts (5885)

schema

creating (5548)

dropping (5744)

naming rules (7985)

overview of (5406)

SCO UnixWare 7

tape devices (6289)

scope (5188)

adding (5757)

Script Center (5882)

using an existing script (5884)

script file installation for HACMP ES (6654)

script files for HACMP ES (6652)

Search Discovery

additional settings (5479)

search discovery communications protocols configuration parameter (7773)

searching for databases (5888)

security

federated database ID and password processing (5963)

APPC setting for federated systems (5975)

authentication (5911)

authentication, federated database details (5957)

authentication, federated database overview (5914)

authorization (5912)

authorization, federated database overview (5913)

CLIENT level (5933)

DCS processing, federated system (5960)

Distributed Computing Environment (DCE) directory services (8275)

federated server authentication example (5977)

overview of (5910)

planning for (5909)

server options (5969)

user mappings (5966)

SELECT privilege, definition (6030)

SELECT statement

referential integrity implications for (5245)

select a view (5646)

select-statement

eliminating DISTINCT clause (7061)

for two or more tables (6906)

guidelines (6900)

guidelines for using (6898)

query rewrite by compiler (7054)

use of (6897)

seqdetect configuration parameter (7599)

understanding sequential detection (7315)

sequential detection (7257)

overview of (7312)

server

characteristics affecting pushdown opportunities (7175)

CPU speed and performance (7197)

creating (5667)

I/O speed and performance (7198)

options (7195)

privileges (6035)

server options

collating_sequence (6959)

comm_rate (6961)

connectstring (6963)

cpu_ratio (6965)

dbname (6967)

fold_id (5973), (6969)

fold_pw (5974), (6971)

io_ratio (6973)

node (6975)

password (5972), (6977)

plan_hints (6979)

pushdown (6981)

security details (5971)

varchar_no_trailing_blanks (6983)

SERVER, authentication type (5923)

SERVER_ENCRYPT, authentication type (5925)

SET CURRENT EXPLAIN MODE statement

use of (7241)

SET CURRENT EXPLAIN SNAPSHOT statement

use of (7247)

SET CURRENT QUERY OPTIMIZATION statement

use of (6874)

SET NULL delete rule

overview of (5253)

setting schema (5550)

setting the default environment profile for rah (8596)

setting up document server (7923)

setting VARCHAR (5755)

share mode

reasons for using (6861)

shared nothing model (6560)

sheapthres configuration parameter (7552)

avoiding post-threshold sorts (7337)

Show Related (5869)

Show SQL (5868)

shutdown HACMP ES (6656)

SIX (Share with Intent Exclusive) mode (6818)

SmartGuide

Performance Configuration (5721)

SmartGuides (5859)

SMS table space

advantages (5387)

caching of (7358)

containers (5348)

creating (5533)

design factors (5350)

multiple containers (5355)

overview (5345)

physical files (5356)

SYSCATSPACE (5335)

TEMPSPACE1 table space (5341)

USERSPACE1 (5338)

snapshot, point-in-time monitoring (7390)

softmax configuration parameter (7669)

managing the buffer pool (7297)

software disk arrays (6218)

Solaris Operating Environment failover

partitioned database system (6728)

binding partitions to a logical host (6742)

choosing a failover configuration (6735)

client application considerations (6750)

components (6729)

creating DB2 instance (6739)

DMS table spaces (6749)

enabling the instance for failover (6741)

hot standby configuration (6731)

hot standby partition failover (6732)

how failover processing works (6743)

mutual takeover configuration (6733)

preliminary requirements (6737)

registering DB2 resource with Sun Cluster 2.1 (6740)

running scripts during failover (6747)

scripts and programs (6738)

setting up failover support (6734)

setting up hot standby configuration (6744)

setting up mutual takeover configuration (6745)

starting and stopping DB2 (6746)

table space considerations (6736), (6748)

types (6730)

single-partition database system

choosing a failover configuration (6719)

client application considerations (6727)

components (6714)

creating a DB2 instance (6721)

enabling the instance for failover (6723)

hot standby (6716)

mutual takeover (6717)

overview (6713)

registering the DB2 resource (6722)

running scripts during failover (6725)

setting up (6718)

starting and stopping DB2 (6724)

table space considerations (6720)

types (6715)

unregistering DB2 for failover (6726)

sortheap configuration parameter (7549)

affect on query optimization (6936)

avoiding post-threshold sorts (7336)

impact on memory (7280)

sorting

configuration parameters (7328)

managing performance (7338)

non-overflowed (7330)

non-piped (7332)

overflowed (7331)

parameters affecting (7334)

performance problems (7335)

piped (7333)

piped versus non-piped sorts (7167)

sort heap size (sortheap) parameter (7547)

sort heap threshold (sheapthres) parameter (7550)

steps (7329)

sorting, specifying collating sequence (8554)

SP frame (6589)

SP switch alias address (6620)

SP switch considerations (6618)

sparse file allocation (5563)

specifying list of machines for rah (8589)

spm_log_file_sz configuration parameter (7697)

DB2 transaction manager considerations (6470)

spm_log_path configuration parameter (7695)

DB2 transaction manager considerations (6472)

spm_max_resync configuration parameter (7698)

DB2 transaction manager considerations (6471)

spm_name configuration parameter (7696)

DB2 transaction manager considerations (6468)

SQL (6895) See also SQL statements

SQL advise facility (7253)

SQL functions

NODENUMBER, data distribution, determining (7453)

PARTITION, data distribution, determining (7452)

SQL Getting Started (7899)

SQL Reference (7900)

SQL statements

benchmarking (7487)

inoperative (5855)

select-statement (6896)

select-statement guidelines (6899)

statement heap size (stmtheap) parameter (7554)

tuning queries (6893)

valid during data redistribution (7482)

SQL00001

example of database subdirectory (5269)

SQLBP.1 database file (5280)

SQLBP.2 database file (5281)

SQLDBCON database file (5272)

SQLINSLK database file (5276)

SQLOGCTL.LFH database file (5274)

SQLSPCS.1 database file (5278)

SQLSPCS.2 database file (5279)

SQLTAG.NAM (5358)

SQLTMPLK database file (5277)

sqluback

support (6286), (6327)

ss_logon configuration parameter (7877)

STAFF sample table (8332)

STAFFG sample table (8333)

standards

X/Open XA interface (6515)

star schema (7141)

start

timeout for command, setting (7827)

start and stop timeout (start_stop_time) database manager parameter (7826)

starting DB2 (5394)

startup recommendations for HACMP ES (6628)

start_stop_time database manager configuration parameter (7831)

START_STOP_TIME parameter (6604)

static SQL

distribution statistics (7019)

evaluating optimization class (6877)

EXECUTE privilege for database access (6064)

explain facility (7238), (7242)

setting optimization class (6872)

statistics

copying from production (7040)

distribution (7013)

distribution, how computed (7017)

frequent value (7014)

gathering for nicknames (6990)

index clustering (7098)

modeling data (7039)

overview of (6985)

quantiles (7015)

rules for updating (7029), (7030), (7031), (7032)

RUNSTATS utility (6992)

RUNSTATS utility in a partitioned database environment (6994)

updating (7027), (8405), (8408), (8414)

user-defined functions (UDF) (7036)

when to collect (7003)

stat_heap_sz configuration parameter (7559)

impact on memory (7282)

stmtheap configuration parameter (7555)

affect on query optimization (6940)

impact on memory (7281)

stop

timeout for command, setting (7828)

stopping DB2 (5395)

storage (7259) See also memory

effect of locks on (6827)

for backup (6186)

for recovery (6188)

media failure considerations (6189)

stored procedures

configuration parameters (7636)

performance impact (6914)

Structured Query Language (SQL)

referential integrity implications for (5241)

structured type (5170)

altering (5801)

attributes (5176)

definition (5177)

hierarchy (5180)

subtype (5178)

supertype (5179)

subagent (7371)

subtype (5171)

summary table

creating (5652)

dropping (5830)

refreshing data (5798)

summary table scan

when used (7101)

summary tables (5323)

alternative to partial clustering (5309)

example (7060)

recovering inoperative (5831)

why replicate (5308)

supertype (5172)

supported DB2 database servers for MTS-coordinated transactions (6543)

svcename configuration parameter (7754)

switch alias address (6610)

synonym (DB2 for MVS/ESA) (5662)

sysadm_group configuration parameter (7870)

SYSCAT views (6081)

SYSCATSPACE table space (5336), (5501)

sysctrl_group configuration parameter (7871)

sysmaint_group configuration parameter (7872)

system administration (SYSADM) authority (5988)

overview (5991)

privileges (5992)

system catalog (8337) See also catalog views

adding new column (5749)

dropping a table (5810)

dropping view implications (5825)

estimating initial size (5286)

privileges listing (6079)

retrieving authorization names with privileges (6082)

retrieving names with DBADM authority (6085)

retrieving names with table access authority (6088)

retrieving privileges granted to names (6091)

RUNSTATS utility (7004)

security (6094)

setting up (5505)

statistics (6987)

table space used (5334)

system catalog table

stored on database catalog node (5417)

system database directory

overview of (5509), (5511)

system log facility

XA interface example (6529)

XA interface use of (6527)

system managed storage (5347) See also SMS table space

system management

configuration parameters (7854)

memory considerations (7262)

System Monitor Guide and Reference (7901)

table (8315)

add referential constraints (5767)

ALTER TABLE statement (5751)

altering (5747)

assigning to nodegroup (5516)

catalog views on system tables (8336)

changing attributes (5796)

changing partitioning key (5794)

CREATE TABLE statement (5553)

creating in partitioned database (5609)

data redistribution, process (7470)

default table space (5337)

defining check constraint (5596)

defining referential constraints (5579)

defining unique constraint (5567)

defining, for a relationship (5155), (5165)

delete connected (5254)

dependent (5231)

descendent (5235)

determining where RUNSTATS execution occurs (6998)

dropping (5809)

estimating size (5288)

joining (7119)

lock compatibility, ensuring (6831)

lock mode (6854)

locking (6859)

naming (5554)

naming rules (7987)

normalizing (5209)

parent (5227)

partitioning map (5318)

redistribution, error recovery (7474)

referential cycle (5236)

renaming (5807)

REORG utility (7340)

reorganizing (7339)

REORGCHK command (7344)

retrieving names with access to (6089)

revoking privileges (6053)

sample (8316)

scan, affect on locks (6852)

self-referencing (5240)

table space considerations (5378)

temporary (5504)

temporary table space (5340)

two or more, select-statement (6907)

types of locks on (6800), (6811)

understanding page use (5287)

volatile (5791)

table check constraint

adding (5776)

defining (5595)

dropping (5789)

table check constraints

overview of (5259)

table collocation (5321)

table queues (7165)

table scan (7071) See also relation scan

table space (5346), (5361) See also SMS table space, DMS table space

adding container (5736)

administration considerations (5379)

affect on query optimization (6943)

changing (5733)

creating (5532)

database managed space (DMS) (5363)

default at database creation (5500)

definition of (5329)

designing (5372)

device container example (5538)

dropping (5739)

dropping a temporary (5742)

extents (5332)

file container example (5536)

file system container example (5535)

in nodegroups (5543)

index (6957)

mapping to buffer pools (5373)

mapping to nodegroups (5377)

minimum space required (5382)

naming rules (7994)

offline (6141)

overhead, setting (6944)

overview of (5328)

page size and performance (5386)

recommendations for catalog table spaces (5384)

recommendations for temporary table spaces (5383)

restoring to an existing database (6332)

separating types of data, example (5607)

system managed space (SMS) (5344)

TRANSFERRATE, setting (6945)

types of locks on (6812)

workload considerations (5385)

table space containers

redefining (6329)

table space restore

overview of (6153)

table space roll-forward recovery

overview of (6155)

table spaces

OFFLINE (6202)

table UDF (5625)

TAKEN AT parameter (6322)

tape devices

SCO (6288)

tape system

backup considerations (6287)

target row (5187)

target table (5185)

target type (5184)

target view (5186)

temporary table space

queries and larger page sizes (5343)

TEMPSPACE1 (5342)

TEMPSPACE1 table space (5503)

territory configuration parameter (7706)

thread, DB2 (7367)

time

definition of (8567)

formats (8574)

time difference among nodes, maximum (7823)

time required for database recovery (6184)

time strings

definition of (8571)

timeout, starting and stopping database manager (7833)

timestamp

definition of (8568)

for logs (6371)

timestamp strings

definition of (8572)

tm_database configuration parameter (7693)

DB2 transaction manager considerations (6467)

XA interface considerations (6511)

tokens (7380)

tpname configuration parameter (7756)

XA interface considerations (6510)

tp_mon_name configuration parameter (7860)

XA interface considerations (6509)

trail

audit (6100)

transaction (6239), (6447) See also unit of work

accessing partitioned databases (6502)

database connection considerations (6498)

failure (6229)

failure recovery on a failed database partition server (6262)

failure recovery on an active database partition server is active (6250)

failure recovery, overview (6240)

global (8306)

loosely coupled (8308)

non-XA (8305)

recovering failed database partition server (6270)

RELEASE statement (6501)

tightly coupled (8309)

two-phase commit (8307)

transaction failure

on the failed database partition server (6251)

recovering failed database partition server (6264)

transaction manager (8311) See also X/Open transactional manager interface (XA)

implementing using IBM TXSeries CICS (6532)

implementing using IBM TXSeries Encina (6533)

configuring DB2 (6534)

configuring Encina for each resource manager (6535)

referencing a DB2 database from and Encina application (6536)

implementing using Microsoft Transaction Server (6538)

implementing using Tuxedo (6537)

not using TCP/IP connectivity (6464)

part of database manager (6459)

specify database when not using TCP/IP connectivity (6465)

specify database when using TCP/IP connectivity (6463)

using TCP/IP connectivity (6460)

transaction processing

configuring XA transaction managers (6530)

transaction recovery on coordinator node (6244)

trigger

benefits of (5615)

creating (5614)

dependencies (5617)

dropping (5813)

Explain tables (8472)

naming rules (7992)

overview of (5260)

triggering crash recovery with DB2START (6259)

troubleshooting (5900)

Troubleshooting Guide (7902)

trusted clients

authentication (5934), (5936)

CLIENT level security (5929)

trust_allclnts configuration parameter (7878)

trust_clntauth configuration parameter (7879)

tuning queries

SQL statements (6894)

two-phase commit

error handling (6478)

overview of (6475)

setting up your environment (6456)

when DB2 Syncpoint Manager is required (6462)

two-phase commit protocol (6241)

type hierarchy (5174)

type mapping, creating (5640)

typed table (5181)

creating (5599)

design (5263)

hierarchy table (5604)

overview (5262)

populating (5601)

updating rows (5803)

typed tables

deleting rows (5805)

typed view (5182)

typed view, creating (5650)

U (Update) mode (6819)

UDF (5620) See also user-defined functions (UDF)

udf_mem_sz configuration parameter (7562)

impact on memory (7285)

UDT (5634) See also user-defined distinct type (UDT)

unique constraint

adding (5764)

defining (5564), (5566)

dropping (5781)

unique constraints (5217)

unique HACMP container names (6597)

unique key (5221)

unit of work (6445)

COMMIT statement (6449)

definition of (6448)

ROLLBACK statement (6450)

using multiple databases (6453)

using one database (6451)

UNIX user exit

archive considerations (8456)

archiving log files (8427)

calling format (8452)

db2uexit (8433)

db2uexit.cadsm (8446)

db2uexit.cdisk (8448)

db2uexit.ctape (8447)

db2uxt2.cxbsa (8449)

error handling (8467)

invoking (8431)

overview (8425)

retrieve considerations (8457)

retrieving log files (8426)

sample user exit programs (8445)

untrusted clients (5932), (5938)

updatable cursor

uncommitted read (6781)

update DAS configuration (5486)

update instance lists (5484)

UPDATE privilege, definition (6031)

UPDATE rules

referential integrity implications (5255)

UPDATE statement

rules for referential integrity implications (5256)

updating statistics (8404), (8407), (8413)

updating typed table (5802)

user exit

archive and retrieve considerations (8458)

BACKUP DATABASE utility (8459)

error handling (8465)

overview (8415)

RESTORE DATABASE utility (8460)

user exit program

backup storage (6195)

logs storage (6193)

user IDs

naming (7982)

user mapping, creating (5968)

user-defined distinct type

column definition (5169)

user-defined distinct type (UDT)

creating (5633)

dropping (5817)

naming rules (7995)

user-defined distinct type, creating (5635)

user-defined events (6573)

user-defined functions (UDF)

creating (5619)

dropping (5815)

naming rules (7991)

privilege to create non-fenced (6009)

types (5621)

updating statistics (7035)

user-defined HACMP ES event (6634)

user-defined structured type, creating (5637)

userexit configuration parameter (6354), (7673)

USERSPACE1 table space (5339), (5502)

user_exit_status configuration parameter (7740)

utilities

reorganization (7342)

reorganization check (7345)

util_heap_sz configuration parameter (7527)

impact on memory (7274)

varchar_no_trailing_blanks column option (7184)

varchar_no_trailing_blanks server option (6984)

version recovery (6272)

overview of (6146)

VI Architecture (8610)

view

access control to table (6071)

access privileges, examples of (6076)

altering (5818)

CHECK OPTION clause, CREATE VIEW statement (5647)

column access (6072)

creating (5643)

data integrity (5649)

data security (5644)

dropping (5819)

dropping implications for system catalogs (5821)

for privileges information (6096)

inoperative (5828)

merging by optimizer (7056)

migration of (7934)

naming rules (7988)

predicate pushdown by optimizer (7063)

recovering inoperative (5826)

restrictions (5820)

row access (6073)

Virtual Interface (VI) Architecture (8609)

virtual telecommunications access method (VTAM) (8279)

Visual Explain (7211), (7250)

VTAM (8277)

W (Weak Exclusive) mode (6823)

weight, definition of (8540)

What's New (7903)

Windows 95 code pages (8521)

DB2CODEPAGE environment variable (8524)

supported code pages (8525)

Windows 95 failover

Administration Server considerations (6709)

Control Center considerations (6710)

Windows NT code pages (8520)

DB2CODEPAGE environment variable (8522)

supported code pages (8523)

Windows NT failover

communications considerations (6707)

considerations for administering DB2 (6700)

database considerations (6705)

DB2MSCS utility

DB2MSCS.CFG parameters (6680)

overview (6678)

setting up a single-partition database system (6682)

setting up partitioned database system (6686)

setting up two single-partition database systems for mutual takeover (6684)

fallback considerations (6689)

hot standby (6676)

limitations (6712)

maintaining the MSCS system (6688)

mutual takeover (6677)

overview (6673)

planning (6674)

reconciling database drive mapping (6691)

restrictions (6711)

running scripts after DB2 resource brought online (6704)

running scripts before DB2 resource brought online (6703)

running scripts, overview (6702)

setting database drive mapping for mutual takeover in a partitioned database environment (6690)

setting up partitioned database system for mutual takeover example

objectives (6695)

preliminary tasks (6696)

registering database drive mapping for ClusterA (6698)

registering database drive mapping for ClusterB (6699)

run DB2MSCS utility (6697)

setting up two instances for mutual takeover example

objectives (6692)

preliminary tasks (6693)

run DB2MSCS utility (6694)

starting and stopping DB2 resources (6701)

system time considerations (6708)

types (6675)

user and group support (6706)

Windows NT Performance Monitor (8600)

registering DB2 (8602)

work space, estimating size (5304)

worksheets for HACMP ES (6668)

wrapper, creating (5664)

X (Exclusive) mode (6822)

X/Open transactional manager interface (XA) (8302)

application program (AP) overview (8304)

database configuration considerations (6508)

database connection considerations (6500)

DB2 UDB XA switch (6519)

DB2 UDB XA switch on OS/2 (6521)

DB2 UDB XA switch on UNIX platforms (6520)

DB2 UDB XA switch on Windows NT (6522)

DB2 UDB XA switch, example C code (6523)

making the transaction manager known to the resource manager (6524)

problem determination (6525)

registration of resource manager (8314)

resource managers (RM) (8313)

security considerations (6506)

support for host databases (6497)

supported function limitations (6514)

transaction manager (TM) overview (8310)

XA close string (6518)

XA open string (6495), (6517)

XA switch usage (6516)

XA transaction managers

configuring (6531)

Z (Superxclusive) mode (6824)

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]