Administration Guide

Index

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

Special Characters

$DB2DBDFT environment variable, running db2gpmap (7829)

$RAHBUFDIR (7842)

$RAHBUFNAME (7843)

$RAHCHECKBUF (7844)

$RAHENV (7853)

Numerics

8 KB page size (4868)

access control (5361)

authentication (5362)

concurrency, overview (6061)

database manager (5456)

database objects (5453)

using locks (6090)

view to table (5475)

XA interface considerations (6013)

access path

lock attributes, factors affecting (6143)

access path selection (6173)

access plan

cost estimate (6437)

created by compiler (6297)

db2expln (6419)

graphical representation (6427)

objects (6428)

operators (6430)

using explain facility (6422)

Visual Explain (6458)

ACTIVATE DATABASE command (6559)

activating a database (6208)

active logs

definition (5709)

definition of (5715)

versus archive logs (5716)

adding a scope (5261)

adding constraint (5267)

adding node to system

restrictions on database operations (6614)

when redistributing nodegroup (6650)

adding table check constraint (5280)

adding unique constraint (5268)

Administration Engine Log (4677)

adsm_mgmtclass configuration parameter (6875)

adsm_nodename configuration parameter (6877)

adsm_owner configuration parameter (6878)

adsm_password configuration parameter (6876)

ADSTAR Distributed Storage Manager (ADSM)

backup restrictions (5944)

client set up (on Intel) (5936)

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

configuration parameters (6868)

environment variables (on Intel) (5937)

environment variables (UNIX-based platforms) (5934)

managing backups and log archives (5945)

setting password (on Intel) (5940)

setting password (UNIX-based platforms) (5935)

system options file (on Intel) (5938)

timeout problem resolution (5943)

use with BACKUP command (5931)

use with RESTORE command (5932)

user options file (on Intel) (5939)

using (5941)

agent (6567)

agent pool (6571)

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

agent process

application heap size (applheapsz) parameter (6753)

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

maximum number of agents (maxagents) parameter (6811)

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

priority of agents (agentpri) parameter (6807)

agentpri configuration parameter (6808)

agents See also coordinator agent

application control heap size, maximum (6735)

connection entries, number (6974)

governor changes priority of (6597)

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

max_coordagents database manager parameter (6815)

maximum number of coordinating (6814)

pool size, controlling (6822)

agent_stack_sz configuration parameter (6758)

impact on memory (6489)

aggregating function (5169)

alias

authority (5196)

naming rules (7300)

using (5194)

alias (DB2 for MVS/ESA) (5197)

alias, creating (5191)

ALTER COLUMN (5263)

ALTER privilege, definition (5434)

ALTER TABLE statement

adding check constraint example (5282)

adding columns example (5256)

adding keys example (5277)

adding unique constraint example (5270)

dropping check constraint example (5295)

dropping keys example (5292)

dropping unique constraint example (5287)

tips for adding constraints (5278)

ALTER TABLESPACE statement

example of (5244), (6232)

altering a column (5259)

altering a structured type (5298)

altering a table (5252)

altering constraint (5265)

altering nodegroup (5233)

altering structured type (5299)

altering table space (5241)

altering temporary table space (5248)

altering view (5327)

app_ctl_heap_sz database parameter (6736)

applheapsz configuration parameter (6752)

impact on memory (6482)

application control heap

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

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

application design

acquiring locks (6092)

collating sequences, guidelines (7803)

deadlock, avoiding (6138)

lock compatibility, ensuring (6122)

lock escalation (6129)

locking considerations (6159)

locks, converting of (6127)

locks, factors affecting (6141)

overriding locks (6151)

application program (5770)

control heap, setting (6738)

database partition server failure detection (5801)

governor forces (6596)

maximum number of coordinating agents at node (6819)

transaction recovery on the failed database partition server (5788)

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

transaction recovery, overview (5771)

app_ctl_heap_sz configuration parameter

impact on memory (6481)

archive log files

for OS/2 (7681)

for UNIX-based systems (7686)

archive logs

definition (5710)

ROLLFORWARD command support (5711), (5713)

versus active logs (5717)

where stored (5718)

ASCII file formats

code page considerations (5630), (5635)

delimited (DEL) format (5628)

nondelimited (ASC) format (5633)

operating system differences (5656)

aslheapsz configuration parameter (6767)

impact on memory (6490)

ATTACH command

overview of (4979)

specifying Distributed Computing Environment (DCE) information (7550)

attribute

definition of (4727)

attributes (4753)

audit activities (5502)

audit facility

actions (5508)

asynchronous record writing (5514)

audit events table (5523)

authorities/privileges (5507)

behavior (5510)

checking events table (5524)

CONTEXT events table (5529)

controlling activities (5531)

error handling (5512)

ERRORTYPE parameter (5515)

events (5509)

examples (5532)

messages (5520)

OBJMAINT events table (5525)

parameter descriptions (5519)

record layouts (5522)

SECMAINT events table (5526)

synchronous record writing (5513)

syntax (5517)

SYSADMIN events table (5527)

tips and techniques (5530)

usage scenarios (5516)

VALIDATE events table (5528)

AUDIT_BUF_SZ (5511)

audit_buf_sz configuration parameter (6730)

authentication (5359)

DCE security services (5386)

definition of (5363)

Distributed Computing Environment (DCE) directory services (7535)

distributed transaction processing considerations (6002)

partitioned database considerations (5385)

remote client (5384)

authentication configuration parameter (7039)

authentication type (5360)

CLIENT (5366)

DCE (5382)

DCS (5380)

SERVER (5364)

authority (5403)

configuration parameters (7035)

database administration (DBADM) (5411), (5428)

levels of (5396)

removing DBADM from SYSADM (5407)

removing DBADM from SYSCTRL (5409)

required for BACKUP command (5817)

required for EXPORT utility (5615)

required for IMPORT utility (5599)

required for REORG utility (6550)

required for RESTORE command (5847)

required for ROLLFORWARD command (5889)

system control (SYSCTRL) (5408)

system maintenance (SYSMAINT) (5410)

tasks and required authorities (5480)

authorization (5395) See also authority

choosing for database access (4846)

definition (5394)

system administration (SYSADM) (5404)

trusted client (5377)

authorization names

create view for privileges information (5501)

retrieving for privileges information (5487)

retrieving names with DBADM authority (5490)

retrieving names with table access authority (5493)

retrieving privileges granted to (5496)

AutoLoader utility

troubleshooting (5582)

automatic restart (5763)

AUTORESTART (5689)

autorestart database configuration parameter (5993), (6870)

DB2 transaction manager considerations (5980)

XA interface considerations (6019)

avg_appls configuration parameter (6803)

affect on query optimization (6221)

backbufsz configuration parameter (6723)

backing up database

fixed-disk media (5838)

backup (5807) See also BACKUP command

buffer for (5824)

container names (5834)

frequency (5723)

images (5832)

invoking (5821)

offline (5725)

online (5724)

planning (5814)

planning your strategy (5815)

quiesce (5818)

storage considerations (5730)

user exit program (5737)

BACKUP command

access errors, error handling (5830)

authority required (5816)

buffer (5825)

concurrency control (5828)

considerations for (5809)

database alias restriction (5822)

DB2 File Manager considerations (5907)

disk output created (5836)

overview of (5808)

system crash (5826), (5868)

tape output created (5837)

use with ADSTAR Distributed Storage Manager (5930)

BACKUP DATABASE utility

considerations for user exit program (7719)

default backup buffer size (backbufsz) parameter (6722)

error handling for user exits (7727)

user exit program for OS/2 (7675)

backup domain controller

configuring DB2 to use (7857)

backup_pending configuration parameter (6906)

benchmark program

creating (6682)

sample report (6687)

SQL statements (6680)

step summary (6688)

benchmarking

db2batch tool (6683)

overview of (6677)

preparations for (6679)

testing methods (6678)

testing process (6686)

bidirectional CCSID support (7787)

CCSID table (7788)

implementation (7789)

BIND privilege

definition of (5449)

BINDADD privilege, definition (5421)

binding

changing configuration parameters (6703)

command line processor (5066)

database utilities (5067)

default for DEGREE option (6215)

isolation level, specifying (6086)

rebinding invalid packages (5465)

BLOB (4874) See also large objects

block fetch (6179) See also row blocking

block-structured devices (5088)

broadcast inner-table joins (6404)

broadcast outer table joins (6396)

buffer pool

8 KB page size and storage requirements (4955)

binding database applications (6713)

choosing number of (6504)

consideration for outer versus inner table determination (6376)

database managed storage (DMS) (6554)

mapping table space to (4954)

memory required (6503)

multiple (6501)

overview of (6495)

performance considerations (6714)

sizing using buffpage configuration parameter (6711)

storage considerations (6715)

buffered inserts

IMPORT utility (5605)

buffpage configuration parameter (6712)

affect on query optimization (6218)

impact on memory (6474)

managing multiple buffer pools (6502)

caching of database (6207)

call level interface

binding to a database (5071)

calling format for user exits

for OS/2 (7707)

for UNIX-based systems (7709)

candidate keys

identifying (4782)

capacity management configuration parameters (6708)

Cartesian products (6384)

star schema (6385)

CASCADE delete rule

overview of (4831)

cascading assignment (7098)

CATALOG DATABASE

example of (5074)

CATALOG GLOBAL DATABASE command

specifying Distributed Computing Environment (DCE) information (7548)

catalog node (5746)

connection for data redistribution (6661)

description (4991)

importance for recovery (5747)

catalog views (4912), (7597), (7650) See also system catalog, system catalog, system catalog

BUFFERPOOLNODES (7601)

BUFFERPOOLS (7600)

CHECKS (7602)

COLAUTH (7603)

COLCHECKS (7604)

COLDIST (6264), (7605)

COLUMNS (6260), (7606)

CONSTDEP (7607)

DATATYPES (7608)

DBAUTH (7609)

EVENTMONITORS (7610)

EVENTS (7611)

FUNCPARMS (7612)

FUNCTIONS (7613)

functions (6291)

INDEXAUTH (7614)

INDEXES (6262), (7615)

KEYCOLUSE (7616)

NODEGROUPDEF (7617)

NODEGROUPS (7618)

overview (7594)

PACKAGEAUTH (7619)

PACKAGEDEP (7620)

PACKAGES (7621)

PARTITIONMAPS (7622)

PROCEDURE PARAMETERS (7624)

PROCEDURES (7623)

read-only (7599), (7652)

REFERENCES (7625)

SCHEMAAUTH (7626)

SCHEMATA (7627)

STATEMENTS (7628)

SYSSTAT.COLDIST (6265)

SYSSTAT.COLUMNS (6261), (7641)

SYSSTAT.FUNCTIONS (6292), (7642)

SYSSTAT.INDEXES (6263), (7643)

SYSSTAT.TABLES (6259), (7644)

TABAUTH (7629)

TABCONST (7630)

TABLES (6258), (7631)

TABLESPACES (7632)

TRIGDEP (7633)

TRIGGERS (7634)

updatable (7598)

update-capable (6282)

VIEWDEP (7635)

VIEWS (7636)

catalog views (structured types)

ATTRIBUTES (7653)

CHECKS (7654)

COLCHECKS (7655)

COLUMNS (7656)

CONSTDEP (7657)

DATATYPES (7658)

FUNCPARMS (7659)

FUNCTIONS (7660)

HIERARCHIES (7661)

INDEXES (7662)

KEYCOLUSE (7663)

OBJSTAT.TABLES (7671)

overview (7647)

PACKAGEDEP (7664)

REFERENCES (7665)

TABCONST (7666)

TABLES (7667)

TRIGDEP (7668)

TRIGGERS (7669)

updatable (7651)

VIEWDEP (7670)

catalogcache_sz configuration parameter (6718)

cataloging database (5072)

catalog_noauth configuration parameter (7040)

CDS (7488)

cell directory service (CDS) (7489)

changing database configuration (5226)

changing environment variables (5221)

changing node configuration file (5224)

changing partitioning key (5309)

changing passwords (7290)

changing registry variables (5222)

changing table attributes (5314)

character comparison, overview (7794)

character conversion

performance considerations (6196)

character serial devices (5087)

character sets

extended UNIX code (EUC) (7784)

chngpgs_thresh configuration parameter (6789)

managing the buffer pool (6496)

CL_SCHED sample table (7581)

client

backing up database, restriction (5870)

CLIENT level security (5368)

client support

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

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

transaction program name (tpname) parameter (6929)

CLIENT, authentication type (5367)

clients

trusted (5370), (5375)

untrusted (5371), (5379)

CLOB (4875) See also large objects

cluster configuration (7092)

cluster management (7096)

Cluster Manager (7151)

cluster monitoring for HACMP ES (7166)

clustered index

cluster ratio statistic (6342)

code page

DB2CODEPAGE environment variable (7769)

guidelines for selecting (6198)

how determined (7768)

import/export considerations (5629), (5634), (5643), (5652)

locales

deriving in applications (7778)

how DB2 derives locales (7779)

RESTORE command (5856)

supported Windows 95 code pages (7770)

supported Windows NT code pages (7771)

code page support

character conversion (6197)

code point, definition of (7792)

codepage configuration parameter (6900)

codeset configuration parameter (6898)

collate_info configuration parameter (6902)

collating sequence

overview of (7791)

samples of (7802)

specifying (7796)

use in character comparisons (7795)

collating sequences (7790)

collocated join (6395)

collocation

data redistribution preservation of (6635)

replicated summary tables (4905), (6391)

column

adding (5254)

altering (5258)

attribute (4728)

defining (4746), (5103)

estimating row size (4867)

naming rules (7296)

column UDF (5168)

command line processor

binding to a database (5068)

commands

db2evmon (6586)

commit

errors during two-phase (5983)

number of commits to group (mincommit) (6857)

two-phase (5982)

communication

connection retries, number (6988)

FCM daemon to agent, request blocks (6981)

node, connection elapse time (6953)

node, message buffers (6969)

communication protocol

VIA (7862)

communications bandwidth configuration parameter (6228)

comm_bandwidth configuration parameter (7023)

compiler

overview of (6296)

overview of query rewrite (6303)

composite key

definition of (4780), (4806)

composite tables

composite inner (6389)

composite outer (6388)

compound SQL

overview of (6194)

performance considerations (6195)

concurrency

controlling using locks (6091)

overview of (6059)

concurrency and granularity

effect of locks on (6119)

concurrency control

BACKUP command (5829)

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

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

concurrent access mode (7063)

configuration (6691) See also benchmarking

changing database manager parameters (6696)

changing database parameters (6702)

database manager parameters (6693)

database parameters (6701)

parameter details, overview of (6706)

parameter summary, database (6705)

parameter summary, database manager (6698)

parameters, overview of (6689)

tuning parameters (6690)

configuration file

governor example (6603)

configuration file, governor (6600)

configuration parameter

ADSTAR Distributed Storage Manager (6867)

affecting optimizer (6217)

agent communication memory (6761)

agent private memory (6740)

application communication memory (6762)

application shared memory (6731)

applications and agents (6800)

AUTORESTART (5690), (5764)

capacity management (6707)

communication protocol setup (6924)

communications (6923)

compiler settings (6917)

Database Application Remote Interface (DARI) (6832)

database attributes (6889)

database management (6887)

database manager instance memory (6772)

database shared memory (6709)

database status (6904)

database system monitor (7012)

DB2 Discovery (6942)

DB2 File Manager (7046)

diagnostic information (7008)

Distributed Computing Environment (DCE) (7543)

distributed services (6935)

distributed unit of work (6879)

I/O and storage (6787)

instance administration (7034)

instance management (7007)

locks (6778)

log activity (6855)

log files (6839)

logging (6837)

migration of (7278)

parallel operations (6947)

partitioned database (4996), (6948)

recovery (6838), (6865)

stored procedure (6831)

system management (7021)

configuration parameters

database logging (5875)

configuration, adding servers when system is running (6619)

configuration, adding servers when system is stopped (6623)

configuration, changing the size of a (6613)

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

conn_elapse configuration parameter (6954)

CONNECT privilege, definition (5420)

CONNECT statement

specifying Distributed Computing Environment (DCE) information (7549)

connection

elapse time (6956)

number of retries (6987)

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

connection entry (6976)

connection pooling, MTS (6053)

constraint

adding (5266)

changing (5264)

dropping (5283)

Explain tables (7729)

constraint name

defining foreign keys (5133)

defining table check constraints (5144)

constraint violations

checking (5577)

constraints

types of (4796)

container names (5835)

containers

adding (to DMS table space) (5242)

DMS table space design (4947)

logical file system (4933)

logical volume device (4949)

overview of (4909)

SMS table space (4929)

SMS table space design (4931)

suggestions for parallel I/O (6526)

Control Center

Event Analyzer (6580)

Performance Monitor (6578)

Snapshot Monitor (6579)

CONTROL privilege

definition of (5433)

implicit issuance (5468)

package privileges (5448)

controlling the rah command (7852)

conversion

of locks, rules for (6126)

cooked devices (5090)

Coordinated Universal Time (6997)

coordinator agent (6568)

maximum number at node (6820)

coordinator database partition, considerations for dropping (6630)

coordinator node (4689)

copyprotect configuration parameter (6903)

country configuration parameter (6896)

CPU speed configuration parameter

affect on query optimization (6225)

cpuspeed configuration parameter (7024)

crash recovery (5760)

overview of (5687)

RESTART DATABASE (5688)

triggering (5791)

CREATE ALIAS statement

example of (5195)

using (5193)

CREATE DATABASE API

SQLEDBDESC structure (7800)

CREATE DATABASE command

example of (5045)

create HACMP ES container examples (7104)

CREATE INDEX statement

example of (5213)

unique index (5215)

CREATE TABLE statement

defining check constraints (5145)

defining referential constraints (5127)

example of (5109)

using multiple table spaces (5153)

CREATE TABLESPACE statement

example of (5082)

CREATE TRIGGER statement

example of (5161)

CREATE VIEW statement

changing column names (5184)

example of (5181)

CREATE_NOT_FENCED privilege, definition (5424)

CREATETAB privilege, definition of (5422)

creating (4734) See also defining

creating alias (5192)

creating index (5199)

creating schema (5095)

creating table (5100)

creating table in multiple table spaces (5151)

creating table space (5079)

creating trigger (5158)

creating typed table (5147)

creating typed view (5187)

creating user-defined distinct type (5175)

creating user-defined function (5163)

creating user-defined structured type (5177)

creating user-defined type (5171)

creating view (5178)

CURRENT DEGREE special register (6213)

CURRENT SCHEMA (5099)

CURRENT SCHEMA special register (4985)

cursor

close using WITH RELEASE clause (6157)

read only, uncommitted read (6082)

updatable, uncommitted read (6083)

cursor stability

overview of (6074)

DARI (6201) See also stored procedures

data

caching when database is started (6206)

changing distribution (5238)

connection entries for agents to pass, number (6975)

data integrity

concurrency, overview (6060)

protecting using locks (6094)

unique index (5201)

data security

controlling database access (5353)

importance of (5354)

securing system catalog (5498)

data structure

SQLEDBDESC (7799)

data transfer

between DB2 for Universal Database databases (5654)

between host and workstation (5662)

EXPORT utility (5611)

file formats supported (5619)

IMPORT utility (5589)

overview of (5536)

data type

column definition (4747), (5104)

multi-byte character set (5107)

database (5751)

activate (6562)

agents (6566)

altering nodegroup (5234)

auto restart enable (autorestart) parameter (6869)

backup (5806)

backup pending indicator (backup_pending) parameter (6905)

catalog node, media failure considerations (5752)

cataloging (5073)

changing (5229)

changing distribution of data (5237)

code page for database (codepage) parameter (6899)

codeset for database (codeset) parameter (6897)

collating information (collate_info) parameter (6901)

configuration parameter summary (6704)

configuration parameters (6699)

connection considerations (6005)

considerations before changing (5217)

considerations for creating (4997)

country code for database (country) parameter (6895)

crash recovery (5793)

creating (5044)

creating across all nodes (4994)

data caching when database is started (6205)

database is consistent (database_consistent) parameter (6907)

database partition synchronization, recovery considerations (5758)

deactivate (6563)

deciding what data to record (4725), (4732)

defining tables (4733)

designing (4724)

determining list of data nodes (5813)

dropping (5231)

enabling data partitioning (4989)

estimating size (4863)

implementing design (4968)

inconsistent after restart (5794)

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

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

migration (7271)

naming rules (7287)

normalizing tables (4787)

number of containers (numsegs) parameter (6795)

object naming rules (7284)

other design considerations (4841)

package dependencies (5349)

parameter file SQLDBCON (6700)

physical design (4847)

recovering failed database partition server (5799)

recovery log (5062)

release level (release) parameter (6890)

resource manager in TP Monitor environment (6000)

restore (5842)

roll-forward changes (5873)

storage for an application (6469)

subdirectory created (4848)

territory for database (territory) parameter (6893)

transaction recovery on the failed database partition server (5786)

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

transaction recovery, overview (5767)

uniquely identifying entities (4784)

updating multiple databases (5963)

user exit enable (userexit) parameter (6863)

user exit status indicator (user_exit_status) parameter (6913)

using multiple databases in a single transaction (5960)

database access

affect of optimization class (6161)

choosing authorizations (4845)

controlling (5352)

overview of (6319), (6323)

privileges through package with SQL (5470)

database administrator (DBADM) authority

privileges (5412)

retrieving names with (5489)

database alias (7283)

for BACKUP command (5823)

naming rules (7286)

RESTORE command (5850)

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

keep DARI process indicator (keepdari) parameter (6833)

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

database configuration

app_ctl_heap_sz parameter (6737)

changing (5225)

created file (5042)

database creation, specifying collating sequence (7797)

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

database files

index data (4940)

log files (4853)

notes of caution (4862)

SMS table space (4937)

SQLINSLK (4855)

table data (4939)

database locator objects

creating (7496)

example (7497)

database logs (5705)

configuration parameters (5876)

database managed storage (4942) See also DMS table space

database manager (5768)

access control (5455)

binding utilities (5065)

configuration parameter summary (6697)

configuration parameters (6694)

default database path (dftdbpath) parameter (7041)

governor affect on performance (6610)

index (5208)

machine node type (nodetype) parameter (7029)

naming rules (7285)

parameter file db2systm (6695)

recovering failed database partition server (5800)

start timeout (7002)

starting and stopping (4970)

stop timeout (7003)

transaction failure, reducing impact (5753)

transaction recovery on the failed database partition server (5787)

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

transaction recovery, overview (5769)

using memory (6466)

database manager configuration

conn_elapse parameter (6955)

fcm_num_anchors parameter (6960)

fcm_num_buffers parameter (6965)

fcm_num_connect parameter (6973)

fcm_num_rqb parameter (6980)

java_heap_sz parameter (6777)

max_connretries parameter (6989)

max_coordagents parameter (6817)

max_time_diff parameter (6994)

num_initagents parameter (6829)

num_poolagents parameter (6825)

start_stop_time parameter (7005)

database managment, configuration parameters (6888)

database monitor

using (6576)

database objects

access control (5454)

creating (7494)

example (7495)

naming rules (7293), (7785)

database partition (4683)

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

database partition, adding when system is running (6618)

database partition, considerations for dropping a server (6629)

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

database partitions, adding to a system (6616)

database partitions, adding when system is stopped (6622)

database restore

overview of (5692)

database roll-forward recovery

overview (5695)

database seed (5862)

database startup cost (6561)

database system monitor

configuration parameters (7013)

fcm_num_rqb database manager parameter, tuning (6983)

databases

non-recoverable (5704)

recoverable (5703)

database_consistent configuration parameter (6908)

database_level configuration parameter (6892)

DataLink access token expiry interval configuration parameter (7049)

DataLink number of backups configuration parameter (7051)

DataLink number of copies configuration parameter (7053)

DataLink time after drop configuration parameter (7055)

DataPropagator Relational (DPROPR)

overview (5537)

date

definition of (7807)

formats (7814)

date strings

definition of (7811)

datetime values

overview of (7806)

string representations (7810)

DAU (DB_Authentication) (7502)

DB_Authentication (DAU) (7501)

DB_Comment (DCO) (7507)

DB_Communication_Protocol (DCP) (7510)

DB_Database_Locator_Name (DLN) (7516)

DB_Database_Protocol (DDP) (7513)

DB_Native_Database_Name (DNN) (7519)

DB_Object_Type (DOT) (7522)

DB_Principal (DPR) (7504)

DB_Product_Name (DPN) (7525)

DB_Product_Release (DRL) (7528)

DB_Target_Database_Info (DTI) (7531)

DB2

starting on Windows NT (4975)

DB2 Administration Server (DAS) (5021)

communications (5026)

configuration (5023), (5024)

configuring (5016)

Control Center communications (5025)

creating (5014)

discovery of other servers (5038)

enabling discovery of (5037)

environment (5035)

internode administrative communications (5027)

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

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

overview (5013)

ownership rules (5012)

registry variable considerations (5034)

registry variables (5036)

removing (5018)

security (5033)

security considerations (5017)

service ports (5028)

setting up with partitioned database system (5019)

example (5022)

starting and stopping (5015)

UNIX EEE servers (5030)

Windows NT EEE servers (5032)

DB2 concepts

overview (4679)

DB2 Connect (5535) See also data transfer

DB2 failover examples (7071)

DB2 File Manager (7047)

backup utility considerations (5906)

detection of situations requiring reconciliations (5928)

export utility considerations (5585)

exporting between instances (5587)

import utility considerations (5588)

interactions with recovery (5924)

load utility considerations (5583)

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

reconcile_not_possible state (5912)

reconcile_pending state (5914)

reconciliation procedure (5929)

reconciling (5927)

removing table from reconcile_not_possible state (5926)

restore utility considerations (5908)

restoring databases and table spaces and rolling forward to end of logs (5918)

restoring databases and table spaces and rolling forward to point in time (5920)

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

rollforward utility considerations (5909)

running export utility (5586)

troubleshooting load utility (5584)

DB2 library

books (7259)

Information Center (7268)

language identifier for books (7260)

late breaking information (7261)

online help (7258)

ordering printed books (7267)

printing PostScript books (7266)

searching online books (7265)

setting up document server (7263)

SmartGuides (7257)

structure of (7256)

viewing online books (7262)

DB2 parallelism concepts

both intra-partition and inter-partition parallelism (4705)

coordinator node (4690)

database partition (4684)

enabling parallelism (4723)

I/O parallelism (4697)

inter-partition parallelism (4703)

intra-partition parallelism (4701)

multi-partition nodegroup (4694)

nodegroup (4692)

overview (4682)

partitioned database (4688)

query parallelism (4699)

single-partition database (4686)

types of parallelism (4695)

utility parallelism (4707)

DB2 shared nothing model (7064)

DB2 Syncpoint Manager

recovery of indoubt transactions (5998)

when required (5967)

DB2 Syncpoint Manager (SPM) (5996)

DB2 transaction manager

database configuration considerations (5972)

DB2_AVOID_PREFETCH (7428)

DB2_CORRELATED_PREDICATES (7422)

DB2_FALLBACK (7460)

DB2_FORCE_FCM_BP (7414)

DB2_FORCE_NLS_CACHE (7354)

DB2_FORCE_TRUNCATION (7462)

DB2_GRP_LOOKUP (7464)

DB2_LIKE_VARCHAR (7466)

DB2_LOADSORT_STACKSZ (7470)

DB2_MMAP_READ (7432)

DB2_MMAP_WRITE (7434)

DB2_NO_PKG_LOCK (7436)

DB2_PRED_FACTORIZE (7424)

DB2_RR_TO_RS (7448)

DB2_SORT_AFTER_TQ (7482)

DB2_VECTOR (7426)

DB2_VI_DEVICE (7390)

DB2_VI_ENABLE (7386)

DB2_VI_VIPL (7388)

DB2ACCOUNT (7306)

DB2ADMINSERVER (7450)

db2adutl utility (5946)

DELETE command (5949)

EXTRACT command (5948)

QUERY command (5947)

db2adutl utility examples (5950)

DB2ATLD_PORTS (7410), (7412)

db2audit (5518)

db2audit.log (5506)

db2batch benchmarking tool (6684)

DB2BIDI (7308)

DB2BQTIME (7400)

DB2BQTRY (7402)

DB2CHECKCLIENTINTERVAL (7350)

DB2CHKPTR (7430)

DB2CLIENTADPT (7396)

DB2CLIENTCOMM (7394)

DB2CLIINIPATH (7452)

DB2CODEPAGE (7310)

DB2COMM (7352)

DB2COUNTRY (7312)

DB2DATALINK (7454)

DB2DBDFT (7314)

DB2DBMSADDR (7316)

DB2DEFPREP (7456)

DB2DIRPATHNAME (7392)

DB2DISCOVERYTIME (7318)

DB2DMNBCKCTLR (7458)

db2dmnbckctlr

using (7858)

db2empfa (6528)

DB2ENVLIST (7340)

db2event directory (7272)

db2exfmt tool (6441), (7767)

db2expln (7746) See also explain tool

db2gov command (6592)

db2govlg command (6608)

db2gpmap (get partitioning map) tool (7828)

db2icrt command (4999)

DB2INCLUDE (7320)

DB2INSTANCE (7342)

DB2INSTANCE environment variable

defining default instance (4978)

DB2INSTDEF (7322)

DB2INSTOWNER (7416)

DB2INSTPROF (7344)

DB2IQTIME (7404)

DB2LIBPATH (7346)

DB2LOADREC (5893), (7468)

DB2LOCK_TO_RB (7472)

db2look tool

overview of (6295)

DB2MSCS utility

DB2MSCS.CFG parameters (7186)

overview (7184)

setting up a single-partition database system (7188)

setting up partitioned database system (7192)

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

DB2NBADAPTERS (7356)

DB2NBBRECVNCBS (7364)

DB2NBCHECKUPTIME (7358)

DB2NBDISCOVERRCVBUFS (7324)

DB2NBINTRLISTENS (7360)

DB2NBRECVBUFFSIZE (7362)

DB2NBRESOURCES (7366)

DB2NBSENDNCBS (7368)

DB2NBSESSIONS (7370)

DB2NBXTRANCBS (7372)

DB2NETREQ (7374)

DB2NODE (7418)

DB2NODE environment variable

exported when adding server (6621)

db2nodes.cfg file (5040)

adding database partitions when redistributing data (6652)

dropping database partitions when redistributing data (6653)

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

db2nodes.cfg, updating manually (6626)

DB2NOEXITLIST (7474)

DB2NTMEMSIZE (7438)

DB2NTNOCACHE (7440)

DB2NTPRICLASS (7442)

DB2NTREMOTEPREG (7476)

DB2NTWORKSET (7444)

DB2OPTIONS (7406)

DB2PATH (7348)

DB2PORTRANGE (7420)

DB2PRIORITIES (7446)

DB2RETRY (7376)

DB2RETRYTIME (7378)

DB2ROUTE (7398)

DB2RQTIME (7408)

DB2SERVICETPINSTANCE (7380)

db2set command (5002), (5007)

DB2SLOGON (7326)

DB2SORCVBUF (7478)

DB2SORT (7480)

DB2SOSNDBUF (7382)

db2split program

configuration file, example (7826)

data file, example (7825)

header information in output files (7832)

parameters (7823)

purpose (7816)

running (7831)

using (7818)

db2start command (4974)

db2stop command (4973)

DB2SYSPLEX_SERVER (7384)

DB2SYSTEM (7484)

DB2TIMEOUT (7328)

DB2TRACEFLUSH (7334)

DB2TRACENAME (7330)

DB2TRACEON (7332)

DB2TRCSYSERR (7336)

db2uexit See also user exit program, user exits for OS/2, user exits for UNIX-based systems

user exit programs for OS/2 (7695)

user exit programs for UNIX-based systems (7700)

DB2UPMPR (7486)

DB2YIELD (7338)

db2_all (7835), (7838)

db2_call_stack (7840)

db2_kill (7839)

DBCLOB (4876) See also large objects

dbexpln tool

data from compiler (6301)

dbheap configuration parameter (6717)

impact on memory (6476)

DCE network database

connecting (7552), (7553)

creating (7551)

DCE, authentication type (5383)

DCO (DB_Comment) (7508)

DCP (DB_Communication_Protocol) (7511)

DCS, authentication type (5381)

DDP (DB_Database_Protocol) (7514)

DEACTIVATE DATABASE command (6560)

deadlocks

checking for (6782)

configuration parameter (6783)

detecting (6136)

overview of (6137)

decorrelation of a query (6315)

default attribute specification (5108)

default value

alternative to null value (4770)

column definition (4769)

defining referential constraint (5121)

defining table check constraint (5141)

defining unique constraint (5113)

DEGREE bind option (6214)

DEL file format (5627) See also ASCII file formats

DELETE privilege, definition (5437)

DELETE rules

types of (4827)

DELETE statement

referential integrity implications for (4826)

deleting rows from typed tables (5301)

DEPARTMENT sample table (7582)

dependent row

definition of (4814)

dependent table

definition of (4812)

dereference operator (5150)

design of database

altering (5218)

design, implementing (4969)

DETACH command

overview of (4980)

determining problems with rah (7856)

dft_degree configuration parameter (6219)

dft_queryopt configuration parameter (6220)

dftdbpath configuration parameter (7042)

dft_account_str configuration parameter (7031)

dft_client_adpt configuration parameter (6941)

dft_client_comm configuration parameter (6940)

dft_degree configuration parameter (6211), (6919)

dft_extent_sz configuration parameter (6797)

dft_loadrec_ses configuration parameter (6873)

dft_monswitches configuration parameter (7014)

dft_mon_bufpool configuration parameter (7018)

dft_mon_lock configuration parameter (7019)

dft_mon_sort configuration parameter (7020)

dft_mon_stmt configuration parameter (7016)

dft_mon_table configuration parameter (7017)

dft_mon_uow configuration parameter (7015)

dft_prefetch_sz configuration parameter (6794)

dft_queryopt configuration parameter (6920)

dft_sqlmathwarn configuration parameter (6918)

diaglevel configuration parameter (7010)

diagpath configuration parameter (7011)

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

directed inner-table join (6407)

directed outer-table joins (6399)

directories

local database directory (5056)

node directory (5060)

system database directory (5058)

directory cache

effect of cataloging databases (5075)

directory objects

creating (7493)

object classes attributes (7500)

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

dir_cache configuration parameter (6774)

dir_obj_name configuration parameter (6938)

dir_path_name configuration parameter (6937)

dir_type configuration parameter (6936)

disaster recovery

considerations (5743)

discover configuration parameter (6944)

discover_comm configuration parameter (6945)

discover_db configuration parameter (6943)

discover_inst configuration parameter (6946)

Distributed Computing Environment (DCE)

ATTACH command (7547), (7555)

authentication (5388)

CATALOG GLOBAL DATABASE command (7545)

CDS (7487)

configuration parameters (6934)

configuration parameters and registry variables (7542)

CONNECT statement (7546), (7556)

directory services restrictions (7560)

directory services tasks (7558)

GDS (7492)

how directories are searched (7554)

overview of directory services (5076)

restrictions (5392)

security services (5387)

setup DB2 client instance (5391)

setup DB2 server (5390)

setup DB2 user (5389)

temporarily overriding DCE directory information (7557)

using directory services (7559)

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

dlchktime configuration parameter (6781)

DLN (DB_Database_Locator_Name) (7517)

dl_expint configuration parameter (7048)

dl_num_backup configuration parameter (7050)

dl_num_copies configuration parameter (7052)

dl_time_drop configuration parameter (7054)

DMS table space

adding containers (4951)

advantages (4967)

allocating space (4948)

caching of (6555)

choosing extent size (4961)

creating (5085)

increasing storage (4950)

overview of (4944)

performance considerations (6553)

size (4946)

types of (4945)

DNN (DB_Native_Database_Name) (7520)

dos_rqrioblk configuration parameter (6770)

DOT (DB_Object_Type) (7523)

double byte character set user

data type (5106)

DPN (DB_Product_Name) (7526)

DPR (DB_Principal) (7505)

DPROPR (5538) See also DataPropagator Relational (DPROPR)

drda_heap_sz configuration parameter (6756)

impact on memory (6487)

DRL (DB_Product_Release) (7529)

DROP DATABASE command

example of (5232)

DROP INDEX statement; example of (5337)

DROP TABLE statement

example of (5308)

DROP TABLESPACE statement; example of (5247)

DROP VIEW statement; example of (5329)

dropping a summary table (5344)

dropping constraint (5284)

dropping database (5230)

dropping index (5334)

dropping node from system

when redistributing nodegroup (6651)

dropping schema (5250)

dropping table (5305)

dropping table check constraint (5293)

dropping trigger (5317)

dropping unique constraint (5285)

dropping user table space (5245)

dropping user-defined function (5319)

dropping user-defined type (5321)

dropping view (5328)

DTI (DB_Target_Database_Info) (7532)

dynamic SQL

distribution statistics (6274)

evaluating optimization class (6169)

EXECUTE privilege for database access (5473)

explain facility (6445), (6450)

setting optimization class (6166)

dynexpln (7747) See also explain tool

eliminating duplicate entries from machine list (7851)

EMP_ACT sample table (7584)

EMP_PHOTO sample table (7585)

EMP_RESUME sample table (7586)

EMPLOYEE sample table (7583)

enhanced scalability (7075) See also HACMP ES

entity

definition of (4726)

values (4785)

environment variables (5000), (7304)

$DB2DBDFT, running db2gpmap (7830)

changing (5219)

DB2LOADREC (5894)

DB2NODE, exported when adding server (6620)

setting on OS/2 (5008)

setting on UNIX (5011)

setting on Windows 95 (5010)

setting on Windows NT (5009)

Eprimary node (7129)

erasing the sample database (7580)

error handling

access errors, BACKUP command (5831)

access errors, RESTORE command (5855)

configuration parameters (7009)

indoubt transaction in TP Monitor environment (6009)

indoubt transactions (5989)

log full (5878)

system crash during BACKUP (5827), (5869)

two-phase commit (5988)

user exit program (7722)

user exit program for OS/2 (7725)

XA interface (6032)

estore_seg_sz configuration parameter (6798)

impact on memory (6478)

event definition example for HACMP ES (7147)

Event Management (7149)

event monitoring (7137)

event snapshots (6585)

exclusive mode

reasons for using (6156)

EXECUTE privilege

database access with dynamic SQL (5474)

database access with static SQL (5472)

definition of (5450)

EXPLAIN (6446)

explain

FOR SNAPSHOT (6451)

Visual (6418), (6457)

WITH SNAPSHOT (6452)

explain facility (6302) See also dbexpln tool

analysis (6424)

capturing information (6420), (6443)

choosing a tool (6415)

concepts (6425)

data from compiler (6300)

data organization (6432)

decision-making (6454)

explain instance (6434)

graphical representation (6426)

instance information (6435)

keywords (6438)

objects (6429)

obtaining data (6442)

operators (6431)

overview of (6414)

snapshot information (6439)

statement information (6436)

table information (6440)

using (6421)

explain instance (6433)

explain snapshot (6449)

explain table format tool (7766)

explain tables

accessing (6416)

explain tool (7744)

aggregation (7762)

command options (7750), (7752)

data streams (7758)

description of output (7753)

examples of db2expln and dynexpln output (7765)

insert, update, and delete (7759)

joins (7757)

miscellaneous statements (7764)

overview of (7745)

parallel processing (7763)

row identifier (RID) preparation (7760)

running (7748)

syntax (7749), (7751)

table access (7754)

temporary tables (7756)

EXPLAIN_ARGUMENT table (7730)

EXPLAIN_ARGUMENT table definition (7737)

EXPLAIN_INSTANCE table (7731)

EXPLAIN_INSTANCE table definition (7738)

EXPLAIN_OBJECT table (7732)

EXPLAIN_OBJECT table definition (7739)

EXPLAIN_OPERATOR table (7733)

EXPLAIN_OPERATOR table definition (7740)

EXPLAIN_PREDICATE table (7734)

EXPLAIN_PREDICATE table definition (7741)

EXPLAIN_STATEMENT table (7735)

EXPLAIN_STATEMENT table definition (7742)

EXPLAIN_STREAM table (7736)

EXPLAIN_STREAM table definition (7743)

explicit schema use (4983)

EXPORT utility

export utility

authority (5613)

authorization and privileges required (5614)

delimited ASCII (DEL) files (5625)

general description (5661)

information required (5612)

integrated exchange format (IXF) files (5646)

Lotus worksheet (WSF) files (5637)

overview of (5610)

recreating exported data (5617)

extended storage cache (6588)

Extended UNIX Code (EUC)

extended UNIX code (EUC)

character sets (7783)

code page support (6199)

extent size

choosing (6512)

choosing the value (4960)

definition of (4910)

SMS table space design (4932)

failover examples (7067)

failover support (7058), (7074) 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 (6971)

fcm_num_buffers database manager parameter (6964)

message anchors, number, specifying (6961)

message buffers, number, specifying (6967)

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

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

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

FCM communications (5043)

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

FCM tuning (6494)

fcm_num_anchors configuration parameter (6959)

fcm_num_buffers configuration parameter (6966)

fcm_num_connect configuration parameter (6972)

fcm_num_rqb database manager configuration parameter (6979)

FETCH FIRST clause (6175)

file format

delimited ASCII (DEL) (5626)

for transferring data (5620)

nondelimited ASCII (ASC) (5631)

overview for EXPORT utility (5621)

overview for IMPORT utility (5622)

overview for LOAD utility (5623)

PC/IXF (5647)

worksheet (WSF) (5638)

files (4851)

fileserver configuration parameter (6931)

finding errors

data redistribution log file (6672)

FOR FETCH ONLY clause (6190)

FOR READ ONLY clause (6189)

FOR UPDATE clause (6191)

foreign key

adding (5274)

composite (5132)

constraint name (5131)

DROP FOREIGN KEY clause, ALTER TABLE statement (5290)

IMPORT utility, referential integrity implications for (5139)

LOAD utility, referential integrity implications for (5138)

privileges required for dropping (5291)

rules for foreign key definitions (5130)

update, referential integrity implications for (4838)

FOREIGN KEY clause

referential constraints (5128)

rules for foreign key definitions (5129)

frequent value statistics

equality predicates (6279)

number to collect (6275)

overview of (6271)

rules for updating (6287)

GDS (7490)

global directory service (GDS) (7491)

global level profile registry (5004)

governor

configuration file (6599)

configuration file example (6602)

daemon (6594)

database manager performance (6609)

db2gov (6593)

db2govlg (6607)

error handling (6598)

log file (6605)

obtains statistics (6595)

purpose (6589)

querying log file (6606)

rules (6601)

starting (6590)

stopping (6591)

GRANT statement

implicit issuance (5466)

security (7540)

use of (5458)

GRANT statement; example of (5459)

HACMP (7057), (7073) See also High Availability Cluster Multi-Processing configurations, High Availability Cluster Multi-Processing configurations

HACMP ES (7072)

blank NFS server worksheet (7177)

blank volume and filesystems worksheet (7175)

cascading assignment (7097)

cluster configuration (7091)

cluster management (7095)

Cluster Manager (7150)

cluster monitoring (7165)

configuration examples (7130)

configuring (7105)

create container examples (7103)

enhanced scalability (7076)

Eprimary (7128)

event definition example (7146)

Event Management (7148)

event monitoring (7136)

failover (7089)

heartbeats (7082)

hot standby takeover (7112)

installation (7167)

keepalive packets (7084)

messages (7081)

migration (7170)

mutual takeover (7110)

new install (7169)

NFS server node (7116), (7126)

NFS server takeover example (7120)

NFS server worksheet (7176)

node availability (7086)

node_down event (7087)

non-disruptive maintenance (7134)

other scripts (7164)

process summary (7154)

rc.db2pe (7107)

rc.db2pe script (7118)

recovery program file (7152)

recovery scripts (7162)

rotating assignment (7099)

rules file (7140)

rules file restriction (7144)

rules.hacmprd file (7142)

script file installation (7158)

script files (7156)

shutdown (7160)

SP frame (7093)

SP switch alias address (7124)

SP switch considerations (7122)

startup recommendations (7132)

START_STOP_TIME (7108)

switch alias address (7114)

unique names (7101)

user-defined event (7138)

user-defined events (7090)

volume and filesystems worksheet (7174)

worksheets (7172)

HACMP ES configuration examples (7131)

HACMP ES rules file (7080)

hardware environments

logical database partitions (4722)

overview (4708)

partitions with multiple processors (4720)

partitions with one processor (4717)

single partition, multiple processors (4714)

single partition, single processor (4711)

hash join

overview of (6371)

hashing algorithm (5581)

header information in data files, db2split (7833)

heartbeats (7083)

heuristic operations

guidelines (5991), (6010)

recovering indoubt transactions (5990)

High Availability Cluster Multi-Processing configurations (7056)

hot standby mode (7066)

modes of failover support (7060)

mutual takeover mode (7070)

overview (7059)

hot standby mode (7061)

hot standby takeover HACMP ES example (7113)

I/O

configuration parameters (6788)

enabling parallel I/O (6524)

parallelism (4696)

prefetch parallel (6521)

IBM Relational Data Replication Tools

details (5684)

using (5683)

IBMCATGROUP nodegroup (5047)

IBMDEFAULTGROUP nodegroup (5049)

IBMTEMPGROUP nodegroup (5048)

idle agent (6570)

images

backup (5833)

implicit schema use (4984)

IMPLICIT_SCHEMA authority (5097)

IMPLICIT_SCHEMA privilege, definition of (5425)

IMPORT

unequal code page (5601)

IMPORT utility

import utility

authority (5597)

authorization and privileges required (5598)

binding to a database (5069)

buffered inserts (5604)

client/server (5606)

delimited ASCII (DEL) files (5624)

differences to LOAD (5608)

general description (5660)

information required (5592)

integrated exchange format (IXF) files (5645)

large objects (5595)

LOAD (5137)

LOBs (5596)

Lotus worksheet (WSF) files (5636)

nondelimited ASCII (ASC) files (5632)

overview of (5590)

recreating exported data (5603)

referential integrity implications for (5140)

remote database (5607)

IN_TRAY sample table (7587)

incompatibilities

description (7280)

index

administering (6237)

changing (5335)

clustering (6240)

consideration for outer versus inner table determination (6377)

CREATE INDEX statement (5211)

CREATE UNIQUE INDEX statement (5214)

creating (5200)

definition of (5202)

definition of index ANDing (6340)

definition of index ORing (6339)

disadvantages of indexing (6235)

DROP INDEX statement (5336)

estimating size (4879)

guidelines for indexing (6236)

how used (5210)

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

index-only access (6337), (7755)

indexing versus no indexing (6234)

lock mode (6149)

look-up, affect on locks (6144)

management, overview of (6233)

multiple (6338)

naming rules (7297)

non-unique (5212)

nonprimary (5342)

optimizing number (5205)

prefetch (6510)

primary (5119)

primary versus user-defined (5204)

privileges (5452)

reorganizing (6545)

scan (6327) See also index scan

structure (6326)

temporary space (4880)

unique (5216)

unique on primary key (4774)

unique on unique key (4775)

index clustering

cluster factor statistic (6254)

cluster ratio statistic (6253)

index creation (6238)

index key, definition (5206)

index page prefetch (6509)

INDEX privilege, definition (5439)

index scan

clustered index (6341)

ordering data (6336)

overview of (6325)

predicate (6332)

predicate terminology (6347)

search process (6328)

to delimit a range (6330)

use of (6329)

WHERE clause, use of (6333)

indexes

temporary files (5555)

indexrec configuration parameter (6872)

indexsort configuration parameter (6792)

indoubt transactions

definition of (5985)

recovering (5987), (5995), (7571)

recovery when not using DB2 Syncpoint Manager (5999)

recovery when using DB2 Syncpoint Manager (5997)

resynchronizing (5994)

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

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

inner-table join, method (6405), (6408)

INSERT privilege, definition (5440)

INSERT statement

referential integrity implications for (4824)

installation tasks for HACMP ES (7168)

installing the sample database (7577)

instance level profile registry (5003)

instance parallelism support (6210)

instance profile registry (5006)

instances

creating (4998)

overview of (4976)

time difference among nodes, maximum (6996)

Integrated Exchange Format (5649) See also PC/IXF file format

inter-partition parallelism (4702)

intra-partition parallelism

enabling (4986)

intra-partition and inter-partition parallelism (4704)

intra-partition parallelism (4700)

intra-partition parellelism (6525)

intra_parallel configuration parameter (6209), (6998)

introduction

DB2 concepts (4678)

DB2 parallelism concepts (4681)

ipx_socket configuration parameter (6933)

isolation level

choosing (6084)

cursor stability (6077)

description of (6062)

read stability (6073)

repeatable read (6067)

specifying, overview (6085)

uncommitted read (6078)

issuing commands to multiple database partition servers (7834)

IXF file format (5648) See also PC/IXF file format

java_heap_sz database manager configuration parameter (6776)

jdk11_path database manager configuration parameter (7033)

join

Cartesian products (6383)

composite tables (6387)

definition of (6362)

eliminating redundancy (6309)

enumeration algorithm (6382)

hash join (6370)

merge join (6368)

nested loop join (6367)

optimizer search strategies (6380)

outer versus inner table determination (6372)

overview of (6365)

shared aggregation (6310)

subquery transformation by optimizer (6308)

tables (6363)

join path

definition of (4786)

join strategies (6392)

broadcast inner-table (6406)

broadcast outer table (6397)

collocated (6394)

directed inner-table (6409)

directed inner-table and outer-table (6403)

directed outer-table (6400)

in a partitioned database (6393)

keepalive packets (7085)

keepdari configuration parameter (6834)

keeping related data together (5739)

key (4776) See also primary key

composite (4805)

definition of (4777), (4804)

foreign (4803)

primary (4772)

unique (4773)

Large Object (LOB)

column considerations (5110)

large objects

allocation objects (4878)

column definition (4748)

data objects (4877)

DMS storage (6558)

estimating size (4872)

LIST INDOUBT TRANSACTIONS command

use in performing heuristic actions (5992), (6011)

LIST NODES CMD

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

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

LOAD CMD/API See loading data

LOAD utility

APIs (5553)

authority required (5557)

Build phase (5542)

details (5550)

differences to IMPORT (5609)

exception table (5576)

failure (5548)

limitations (5559)

Load phase (5541)

LOAD QUERY command (5552)

overview (5533)

performance considerations (5562)

phantom quiesce (5572)

process overview (5540)

recovery (5575)

recovery from failures (5567)

REMOTE FILE considerations (5568)

restarting using RESTART (5570)

restarting using RESTARTCOUNT (5571)

restrictions (5558)

running concurrent jobs (5566)

tasks (5554)

temporary files (5564)

temporary space limitations (5563)

unequal code page (5560)

using (5539)

using LOAD QUERY (5565)

loading data

db2split program, splitting data (7817)

db2split, example file (7824)

populating table in existing table space (7822)

populating table in new table space (7820)

LOB (4873) See also large objects

local database directory

overview of (5057)

locales

deriving in application programs (7780)

how DB2 derives (7781)

LOCK TABLE statement

in minimizing escalations (6132)

use to override locks (6150)

locking

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

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

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

locklist configuration parameter (6727)

affect on query optimization (6223)

impact on memory (6475)

locks

acquiring (6093)

attributes of (6095)

attributes, types of processing (6142)

avoiding global deadlocks (6135)

compatibility of, ensuring (6121)

configuration parameter (6779)

conversion of (6125)

creating, using cursor stability (6076)

creating, using repeatable read (6066)

deadlock, using FOR UPDATE OF (6139)

duration attribute (6097)

escalation and actions to take (6131)

escalation of (6128)

exclusive (X) mode (6107)

exclusive mode, reasons for using (6155)

factors affecting (6140)

improving concurrency (6130)

intent exclusive (IX) mode (6104)

intent none (IN) mode (6101)

intent share (IS) mode (6102)

locktimeout configuration parameter (6134)

mode attribute (6098)

modes for index scan (6148)

modes for table scan (6146)

object attribute (6096)

overview of (6089)

read stability (6072)

reducing waits for (6133)

share (S) mode (6103)

share mode, reasons for using (6153)

share with intent exclusive (SIX) mode (6105)

state (mode), types of (6100)

superxclusive (Z) mode (6108)

update (U) mode (6106)

locktimeout configuration parameter (6786)

log

audit (5504)

log files

governor log file (6604)

written for data redistribution (6671)

logbufsz configuration parameter (5881), (6720)

logfilsiz configuration parameter (5880), (6842)

logging

raw devices (5092)

logging facility (5706) See also logs

loghead configuration parameter (6854)

logical database partitions (4721)

logical file system

limits (4934)

logpath configuration parameter (6850)

logprimary configuration parameter (5877), (6844)

logretain configuration parameter (5884), (6862)

logs

active (5707)

archived (5708)

change database log path (newlogpath) parameter (6847)

configuration parameters affecting log activity (6856)

configuration parameters affecting log files (6840)

estimating size (4881)

identifying (5897)

location (5898)

location of log files (logpath) parameter (6849)

log buffer size (logbufsz) parameter (6719)

log head identification (loghead) parameter (6853)

log retain enable (logretain) parameter (6861)

log retain status indicator (log_retain_status) parameter (6911)

losing (5902)

managing (5896)

next active log (nextactive) parameter (6851)

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

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

offline archived logs (5714)

online archived logs (5712)

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

size of log files (logfilsiz) parameter (6841)

storage required (5734)

use of timestamp (5899)

userexit program (5735)

logsecond configuration parameter (5879), (6846)

log_retain_status configuration parameter (6912)

long field data

alternatives to (4871)

DMS storage (6557)

estimating size (4870)

losing logs (5901)

Lotus worksheet files (5639) See also WSF file format

many-to-many relationships (4741)

many-to-one relationships (4739)

max_connretries database manager configuration parameter (6986)

max_coordagents database manager configuration parameter (6816)

max_querydegree configuration parameter (6990)

max_time_diff database manager configuration parameter (6993)

maxagents (6572)

maxagents configuration parameter (6812)

effect on memory (6473)

maxappls configuration parameter (6802)

DB2 transaction manager considerations (5979)

effect on memory (6472)

XA interface considerations (6018)

maxcagents configuration parameter (6810)

maxdari configuration parameter (6836)

maxfilop configuration parameter (6805)

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

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

maximum query degree of parallelism configuration parameter (6227)

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

maxlocks configuration parameter (6785)

affect on query optimization (6224)

maxtotfilop configuration parameter (6806)

max_querydegree configuration parameter (6212)

media failure

logs (5733)

memory

agent communication memory (6763)

agent private memory (6741)

application communication memory (6764)

application heap size (applheapsz) parameter (6751)

application shared memory (6732)

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

configuration parameters (6470)

considerations for system administrator (SYSADM) (6464)

database heap (dbheap) parameter (6716)

database manager instance (6771)

database shared memory (6710)

extending (6587)

for processing a database (6468)

package cache size (pckcachesz) parameter (6728)

setting parameter values (6492)

sort heap size (sortheap) parameter (6743)

sort heap threshold (sheapthres) parameter (6746)

statement heap size (stmtheap) parameter (6748)

use by the database manager (6467)

use of (6463)

when committed (6493)

memory usage (7282)

application control heap (6739)

merge join

outer versus inner table determination (6379)

overview of (6369)

message anchor (6962)

messages

audit facility (5521)

Microsoft Transaction Server

connection pooling (6052)

enabling support in DB2 (6045)

installation and configuration (6047)

reusing ODBC connections (6054)

software prerequisites (6046)

supported DB2 database servers (6050)

testing DB2 with sample application (6056)

transaction time-out and DB2 connection behavior (6051)

tuning TCP/IP communications (6055)

verifying the installation (6048)

migration (7269)

authority required (7274)

overview of (7270)

release-to-release incompatibilities (7276)

restrictions (7273)

steps required (7279)

storage requirements (7275)

migration tasks for HACMP ES (7171)

mincommit configuration parameter (5882), (6858)

minimum recovery time (5892)

min_priv_mem configuration parameter (6759)

mixed-byte data (5665)

importing and exporting (5666)

monitor switches (6581)

monitoring (6582) See also database system monitor

monitoring rah processes (7845)

mon_heap_sz configuration parameter (6773)

moving data (5534) See also data transfer

MPP environment (4716)

multi-partition nodegroup (4693)

multimedia objects (4731)

multipage_alloc configuration parameter (6916)

effect on memory (6527)

multiple buffer pages, allocating (6529)

multiple instances (4977)

use with ADSTAR Distributed Storage Manager (5942)

multiple logical node failover (7069)

multiple logical nodes (7859)

multisite update (5952)

overview of (5961)

configuration parameters (6880)

recovering indoubt transactions (5986)

updating multiple databases (5964)

mutual takeover HACMP ES example (7111)

mutual takeover mode (7062)

naming scheme, database directories (4850)

national language support

mixed-byte data (5667)

national language support (NLS)

bidirectional CCSID support (7786)

character sets (7782)

datetime values (7805)

nested loop join

outer versus inner table determination (6375)

overview of (6366)

newlogpath configuration parameter (5883), (6848)

Next Key Exclusive Lock (NX) mode (6114)

Next Key Share Lock (NS) mode (6113)

Next Key Weak Exclusive Lock (NW) mode (6116)

nextactive configuration parameter (6852)

NFS server node (7117), (7127)

NFS server takeover example (7121)

nname configuration parameter (6926)

NO ACTION delete rule

overview of (4829)

NOCHECKLENGTHS option (5561), (5602)

node (5748)

catalog, recovery considerations (5749)

cataloging (4990)

changing in nodegroup (5235)

connection elapse time (6952)

coordinating agent, maximum (6818)

creating database across all (4995)

data location, determining (4894)

data redistribution, process (6660)

determining list of data nodes (5812)

determining where RUNSTATS execution occurs (6250)

failed database partition server, recovering (5796)

maximum number of connection retries (6985)

maximum time difference among (6992)

message buffers, number, specifying (6968)

other operations during redistribution (6675)

redistributing data across database partitions (6631)

synchronization, recovery considerations (5757)

transaction recovery on a failed database partition server (5789)

transaction recovery on an active database partition server (5776)

node configuration file (4885)

changing (5223)

creating (5039)

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

node connection retries (max_connretries) (6984)

node level profile registry (5005)

node number (5041)

nodegroup (4691)

altering (5236)

creating (5077)

designing (4884)

IBMDEFAULTGROUP, table created in by default (5157)

initial definition (5046)

mapping table spaces (4956)

other operations during redistribution (6674)

partitioning key, changing (5312)

partitioning map entries (4891)

recovering failed database partition server (5802)

redistributing data (6632)

table considerations (5156)

transaction recovery on a failed database partition server (5790)

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

nodetype configuration parameter (7030)

node_down event (7088)

non-disruptive maintenance for HACMP ES (7135)

non-recoverable databases (5702)

non-uniform distribution See quantile value statistics, frequent value statistics

non-unique index

dropping (5340)

nonprimary index

dropping (5339)

dropping implications for applications (5343)

normal form

first (4792)

fourth (4795)

overview of (4791)

second (4793)

third (4794)

normalizing

definition of (4790)

tables (4788)

NS (Next Key Share Lock) mode (6112)

null value

alternative to default value (4771)

column definition (5105)

num_initagents database manager configuration parameter (6828)

num_poolagents database manager configuration parameter (6824)

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

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

numdb configuration parameter (7027)

effect on memory (6471)

numsegs configuration parameter (6796) See also table space

num_estore_segs configuration parameter (6799)

impact on memory (6479)

num_freqval configuration parameter (6921)

num_iocleaners configuration parameter (6790)

managing the buffer pool (6497)

num_ioservers configuration parameter (6791)

impact on data prefetch (6523)

num_poolagents (6573)

num_poolagents configuration parameter

impact on parallel systems (6575)

num_quantiles configuration parameter (6922)

NW (Next Key Weak Exclusive Lock) mode (6117)

NX (Next Key Exclusive Lock) mode (6115)

object class attributes

DB_Authentication (DAU) (7503)

DB_Comment (DCO) (7509)

DB_Communication_Protocol (7512)

DB_Database_Locator_Name (7518)

DB_Database_Protocol (7515)

DB_Native_Database_Name (7521)

DB_Object_Type (7524)

DB_Principal (DPR) (7506)

DB_Product_Name (7527)

DB_Product_Release (7530)

DB_Target_Database_Info (7533)

objectname configuration parameter (6932)

occurrence

definition of (4729)

offline archived logs

definition (5710)

ROLLFORWARD command support (5711), (5713)

versus active logs (5717)

where stored (5718)

one-to-many relationships (4740)

one-to-one relationships (4743)

online archived logs

ROLLFORWARD command support

optimization class

guidelines (6168)

levels of (6163)

setting (6164)

OPTIMIZE FOR clause (6174), (6188)

optimizer (6320), (6324) See also database access, database access

adjusting amount of optimization (6162)

affect of statistics (6244)

creating access plan (6299)

distribution statistics impact (6277)

selecting optimal join (6381)

sorting (6411)

use of replicated summaryt tables (6390)

ORG sample table (7588)

outer versus inner table determination

merge join (6378)

nested loop join (6374)

overview of (6373)

outer-table join, method (6398)

package

access privileges with SQL (5469)

dependencies (5348)

dropping (5341)

inoperative (5350)

invalid after adding foreign key (5279)

isolation levels, specifying (6063)

privileges (5446)

revoking privileges (5464)

page cleaners (6498)

page cleaners configuration parameter

managing the buffer pool (6499)

page size

8 KB considerations (4869)

parallel operations

configuration parameters (6950)

parallelism in DB2, overview (4680)

parallelism, intra-partition

enabling (4987)

parent row

definition (4810)

parent table

definition (4808)

partition compatibility See partitioning data

partitioned database (4687)

configuration parameters (6949)

partitioned database environment

decorrelation of a query (6316)

replicated summary tables (4904)

partitioned failover (7068)

partitioning data (4988)

data distribution, specifying (6641)

data redistribution across database partitions (6659)

data redistribution in tables (6663)

data redistribution, error recovery (6669)

designing your physical database (4886)

partition compatibility (4901)

partitioning key and partitioning map interaction (4892)

partitioning keys, designing your physical database (4899)

partitioning map, definition (4896)

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

partitioning key

changing (5310)

data hashing (4893)

index partitioned on partitioning key (5207)

table considerations (5155)

partitioning keys (5579)

partitioning map

definition (4889)

example (4895)

getting with db2gpmap tool (7827)

purpose (4890)

redistributing data (6642)

target, specifying during data redistribution (6654)

partitions with multiple processors (4718)

partitions with one processor (4715)

passwords

changing (7291)

naming (7288)

PC/IXF file format (5663)

code page considerations (5653)

overview of (5650)

rules for (5651)

use with DB2 for Universal Database products (5655)

pckcachesz configuration parameter (6729)

impact on memory (6480)

pending states (5543)

performance

application considerations (6057)

catalog information, reducing contention for (4993)

configuration parameters (6692)

considerations for ROLLFORWARD command (5741)

data distribution, determining using SQL (6644)

database caching (6204)

database managed storage (DMS) (6552)

db2batch benchmarking tool (6685)

environmental consideration (6216)

governor affect on database manager (6611)

locks, effect of (6118)

num_ioservers configuration parameter (6522)

operational considerations (6461)

optimization class, adjusting (6160)

programming considerations (6058)

query rewrite by compiler (6306)

redistributing data (6633)

replicated summary tables (4906)

row blocking, guidelines (6181)

RUNSTATS utility (6255)

statistics (6242)

summary table (5190)

table collocation, data redistribution (6637)

tuning using explain (6455)

using explain facility (6423)

Performance Configuration SmartGuide (5227)

performance monitor

using (6577)

phantom quiesce (5573)

piped versus non-piped sorts

overview of (6413)

point of recovery (5721)

point-in-time monitoring (6583)

pool size for agents, controlling (6823)

populating typed table (5149)

precompiling

isolation level, specifying (6087)

predicate (6350), (6351) See also predicate terminology, predicate category

adding by optimizer (6318)

definition of (6331)

distribution statistics (6278)

inclusive inequality (6335)

strict inequality (6334)

translation by optimizer (6317)

when applied (6313)

predicate category

index SARGable predicate (6353)

overview of (6349)

range delimiting predicate (6352)

residual predicate (6359)

SARGable predicate (6357)

usage (6361)

predicate terminology

overview of (6348)

prefetch (6459), (6516) See also sequential detection

buffer pool (6505)

clustering page reads (6344)

data page (6506)

I/O servers (6520)

index page (6507)

intra-partition parallelism (6519)

list prefetch (6518)

PREFETCHSIZE clause (6511)

sequential (6508)

sequential detection (6515)

tuning using database system monitor (6513)

prefix sequences (7847)

primary index

definition of (4779)

dropping (5338)

uniqueness for primary key (5118)

primary key

adding (5273)

composite key (4781)

criteria for choosing (4783)

definition of (4778), (4802)

DROP PRIMARY KEY clause, ALTER TABLE statement (5288)

primary index (5117)

primary index, creating (5203)

privileges required for dropping (5289)

UPDATE, referential integrity implications for (4837)

when to create (5120)

PRIMARY KEY clause

adding primary key (5275)

restrictions (5116)

privileges

ALTER (5435)

BINDADD (5415)

CONNECT (5416)

CONTROL (5432)

create view for information (5500)

CREATE_NOT_FENCED (5418)

CREATETAB (5417)

database manager (5414)

definition of (5393)

DELETE (5436)

GRANT statement (5457)

granting and revoking authority (5413)

hierarchy (5398)

implicit for packages (5401)

IMPLICIT_SCHEMA (5419)

INDEX (5451)

individual (5400)

INSERT (5438)

ownership (CONTROL) (5399)

package (5447)

PUBLIC (5427)

REFERENCES (5441)

required for EXPORT utility (5616)

required for IMPORT utility (5600)

required for REORG utility (6551)

retrieving authorization names with (5486)

retrieving for names (5495)

REVOKE statement (5460)

schema (5429)

SELECT (5443)

summary of (5397)

system catalog listing (5483)

table (5430)

tasks and required authorities (5481)

view (5431)

priv_mem_thresh configuration parameter (6760)

problem determination

XA interface (6034)

process summary for HACMP ES (7155)

process, DB2 (6564)

processors, adding to a machine (6615)

profile registry (5001)

PROJECT sample table (7589)

PUBLIC

privileges (5426)

qualified object names (4982)

quantile value statistics

number to collect (6276)

overview of (6272)

range statistics (6280)

rules for updating (6288)

query optimizer (6298) See also optimizer

query parallelism (4698)

query rewrite See also compiler

overview of (6304)

summary table (5189)

query_heap_sz configuration parameter (6755)

impact on memory (6486)

quickly retrieve first few rows (6172)

quiesce

phantom (5574)

RACF (7537)

rah (7836), (7837)

RAHDOTFILES (7854)

RAHOSTFILE (7849)

RAHOSTLIST (7850)

RAHWAITTIME (7846)

range delimiting predicate

index SARGable predicate (6355)

overview of (6354), (6356)

raw devices (5089)

raw I/O (5094)

raw logs (5093)

rc.db2pe (7106)

rc.db2pe script (7119)

read locks (6158)

read only cursors

uncommitted read (6081)

read stability, overview (6069)

reading

read stability, overview of (6068)

repeatable read, overview of (6064)

uncommitted read, overview of (6079)

reconcile pending state (5915)

reconcile_not_possible state (5913)

records

audit (5505)

recoverable databases (5701)

recovering inoperative summary table (5347)

recovering inoperative view (5332)

recovery

allocating log during database creation (5064)

configuration parameters (6866)

consistent database (5761)

crash (5759)

definition of (5686)

factors affecting (5700)

history file (5905)

interaction with DB2 File Manager (5925)

overview of (5685)

performance (5742)

point of (5722)

point-in-time (5903)

reducing logging on work tables (5720)

roll-forward (5865)

storage required (5728)

time required (5726)

two-phase commit protocol (5775)

version (5804)

recovery history file (5904)

recovery log (5063)

recovery program file for HACMP ES (7153)

recovery scripts for HACMP ES (7163)

rec_his_retentn configuration parameter (6874)

redistributing data

across nodes (5239)

connection to catalog database partition (6658)

data distribution, determining using SQL (6645)

database partition, process overview (6657)

database partitions, adding (6649)

database partitions, dropping (6648)

distribution file (6643)

distribution, specifying (6640)

error recovery (6667)

log file (6670)

operation successful (6665)

operation unsuccessful (6666)

other operations during redistribution (6673)

partitioning map, target, specifying (6655)

purpose (6634)

replicated summary table restriction (6638)

table collocation (6636)

table, process overview (6662)

reducing logging on work tables (5719)

reference type (4763)

design (4844)

REFERENCES clause

adding foreign key (5276)

delete rules (5136)

referential constraints (5134)

use of (5135)

REFERENCES privilege, definition (5442)

referential constraints (4819) See also referential integrity

add to table (5271)

defining (5122)

definition of (4817)

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

overview of (4799)

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

REFERENCES clause, CREATE/ALTER TABLE statements (5125)

referential integrity (4818) See also referential constraints

definition of (4798)

DELETE rules (4828)

INSERT rules (4823)

overview of (4800)

refreshing data in summary table (5316)

registry variables (7303)

changing (5220)

DB2_AVOID_PREFETCH (7427)

DB2_CORRELATED_PREDICATES (7421)

DB2_FALLBACK (7459)

DB2_FORCE_FCM_BP (7413)

DB2_FORCE_NLS_CACHE (7353)

DB2_FORCE_TRUNCATION (7461)

DB2_GRP_LOOKUP (7463)

DB2_LIKE_VARCHAR (7465)

DB2_LOADSORT_STACKSZ (7469)

DB2_MMAP_READ (7431)

DB2_MMAP_WRITE (7433)

DB2_NO_PKG_LOCK (7435)

DB2_PRED_FACTORIZE (7423)

DB2_RR_TO_RS (7447)

DB2_SORT_AFTER_TQ (7481)

DB2_VECTOR (7425)

DB2_VI_DEVICE (7389)

DB2_VI_ENABLE (7385)

DB2_VI_VIPL (7387)

DB2ACCOUNT (7305)

DB2ADMINSERVER (7449)

DB2ATLD_PORTS (7409), (7411)

DB2BIDI (7307)

DB2BQTIME (7399)

DB2BQTRY (7401)

DB2CHECKCLIENTINTERVAL (7349)

DB2CHKPTR (7429)

DB2CLIENTADPT (7395)

DB2CLIENTCOMM (7393)

DB2CLIINIPATH (7451)

DB2CODEPAGE (7309)

DB2COMM (7351)

DB2COUNTRY (7311)

DB2DATALINK (7453)

DB2DBDFT (7313)

DB2DBMSADDR (7315)

DB2DEFPREP (7455)

DB2DIRPATHNAME (7391)

DB2DISCOVERYTIME (7317)

DB2DMNBCKCTLR (7457)

DB2ENVLIST (7339)

DB2INCLUDE (7319)

DB2INSTANCE (7341)

DB2INSTDEF (7321)

DB2INSTOWNER (7415)

DB2INSTPROF (7343)

DB2IQTIME (7403)

DB2LIBPATH (7345)

DB2LOADREC (7467)

DB2LOCK_TO_RB (7471)

DB2NBADAPTERS (7355)

DB2NBBRECVNCBS (7363)

DB2NBCHECKUPTIME (7357)

DB2NBDISCOVERRCVBUFS (7323)

DB2NBINTRLISTENS (7359)

DB2NBRECVBUFFSIZE (7361)

DB2NBRESOURCES (7365)

DB2NBSENDNCBS (7367)

DB2NBSESSIONS (7369)

DB2NBXTRANCBS (7371)

DB2NETREQ (7373)

DB2NODE (7417)

DB2NOEXITLIST (7473)

DB2NTMEMSIZE (7437)

DB2NTNOCACHE (7439)

DB2NTPRICLASS (7441)

DB2NTREMOTEPREG (7475)

DB2NTWORKSET (7443)

DB2OPTIONS (7405)

DB2PATH (7347)

DB2PORTRANCE (7419)

DB2PRIORITIES (7445)

DB2RETRY (7375)

DB2RETRYTIME (7377)

DB2ROUTE (7397)

DB2RQTIME (7407)

DB2SERVICETPINSTANCE (7379)

DB2SLOGON (7325)

DB2SORCVBUF (7477)

DB2SORT (7479)

DB2SOSNDBUF (7381)

DB2SYSPLEX_SERVER (7383)

DB2SYSTEM (7483)

DB2TIMEOUT (7327)

DB2TRACEFLUSH (7333)

DB2TRACENAME (7329)

DB2TRACEON (7331)

DB2TRCSYSERR (7335)

DB2UPMPR (7485)

DB2YIELD (7337)

Distributed Computing Environment (DCE) (7544)

relation scan

definition of (6321)

when used (6345)

relationship

many-to-many (4742)

many-to-one (4738)

one-to-many (4737)

one-to-one (4744)

types of (4736)

release configuration parameter (6891)

release to release incompatibilities

description (7281)

remote administration (5020)

remote data services

node name (nname) parameter (6925)

remote filename

qualifying (5556)

REMOTE FILEs (5569)

remote procedure calls (6203) See also stored procedures

remote unit of work

overview of (5958)

renaming table (5296)

REORG utility

authority and privileges required (6549)

binding to a database (5070)

overview of (6543)

REORGCHK command (6548)

replicated summary table

redistributed nodegroup restriction (6639)

replicated summary tables (4903)

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

residual predicate

overview of (6360)

resource access control facility (RACF) (7539)

RESTART DATABASE command (5765)

restbufsz configuration parameter (6725)

restore

buffer(s) (5851)

database (5693)

existing database (5861)

invoking (5848)

new database (5864)

planning (5845)

redirected (5859)

table space (5697)

RESTORE command

access errors, error handling (5830), (5854)

authority required (5816), (5846)

buffer (5825), (5852)

code page restriction (5857)

concurrency control (5828)

considerations for (5809), (5844)

database alias restriction (5822), (5849)

DB2 File Manager considerations (5907), (5910)

DB2 File Manager, restoring database without roll forward (5917)

disk output created (5836)

overview of (5808), (5841)

system crash (5826), (5868)

tape output created (5837)

use in roll-forward recovery (5872)

use with ADSTAR Distributed Storage Manager (5930)

RESTORE DATABASE utility

considerations for user exit program (7720)

default restore buffer size (restbufsz) parameter (6724)

error handling for user exits (7726)

user exit program for OS/2 (7677)

restore_pending configuration parameter (6915)

restoring a database

overview of (5839)

RESTORE command (5840), (5843)

restoring database

catalog node considerations (5750)

database partition synchronization (5755)

log disk, considerations for media recovery (5745)

node synchronization (5754)

recovering failed database partition server (5798)

reducing impact of media failure (5744)

timestamp considerations (5756)

transaction recovery on the failed database partition server (5785)

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

transaction recovery, overview (5766)

RESTRICT

delete rule, overview of (4830)

restrictions on import and export (5664)

resync_interval configuration parameter

DB2 transaction manager considerations (5975)

resync_interval configuration parameter (6882)

retrieve first few rows quickly (6171)

retrieve log files

for OS/2 (7680)

for UNIX-based systems (7685)

retrieving data

index (5209)

REVOKE statement

example of (5462)

implicit issuance (5467)

security (7541)

use of (5461)

REXX

isolation level, specifying (6088)

roll-forward recovery (5866)

authority required (5888)

invoking (5890)

long space requirements (4882)

overview of (5694)

planning (5887)

rolling forward table space (5886)

table space (5699)

ROLLFORWARD command

backup considerations (5867)

configuration file parameters support (5874)

DB2 File Manager considerations (5911)

DB2 File Manager, point-in-time roll forward example (5923)

DB2 File Manager, rolling forward to end of logs (5919)

DB2 File Manager, rolling forward to point in time (5921)

log management considerations (5895)

performance considerations (5740)

restore considerations (5871)

timestamps (5891)

ROLLFORWARD DATABASE utility

roll forward pending (rollfwd_pending) parameter (6909)

rollfwd_pending configuration parameter (6910)

root type (4755)

rotating assignment (7100)

route_obj_name configuration parameter (6939)

routing information objects

creating (7498)

example (7499)

row (6177) See also row blocking

blocking (6176)

delete from parent table (4822)

deleting related rows (4832)

dependent (4813)

lock compatibility, ensuring (6123)

locking (6065), (6071), (6075)

occurrence (4730)

parent (4809)

partitioning key and partitioning map determine location (4898)

read stability (6070)

types of locks on (6109)

row blocking

types of (6180)

overview of (6178)

row identifier (RID) (7761)

rqrioblk configuration parameter (6769)

impact on memory (6491)

rules file for HACMP (7141)

rules file restriction (7145)

rules.hacmprd file (7143)

rules.hadmprd file (7079)

running commands in parallel (7841)

RUNSTATS CMD/API

node where execution occurs (6249)

RUNSTATS utility

for reorganization (6252)

use of (6246)

use of in a partitioned database environment (6248)

with distribution clause (6269)

SALES sample table (7590)

sample database

erasing (7579)

installing (7578)

sample tables (7576), (7593)

sample user exit programs

for OS/2 (7693)

for UNIX-based systems (7701)

overview (7691)

SARGable predicate

overview of (6358)

scalability to 16 nodes (7077)

scalar UDF (5167)

scaling a configuration (6612)

schema

creating (5096)

dropping (5251)

naming rules (7292)

overview of (4981)

scope (4768)

adding (5262)

script file installation for HACMP ES (7159)

script files for HACMP ES (7157)

security

authentication (5357)

authorization (5358)

CLIENT level (5373)

Distributed Computing Environment (DCE) directory services (7534)

overview of (5356)

planning for (5355)

SELECT privilege, definition (5444)

SELECT statement

referential integrity implications for (4825)

select a view (5182)

select-statement

eliminating DISTINCT clause (6312)

for two or more tables (6192)

guidelines for using (6187)

query rewrite by compiler (6305)

use of (6186)

seqdetect configuration parameter (6793)

understanding sequential detection (6517)

sequential detection (6460)

overview of (6514)

SERVER, authentication type (5365)

SET CURRENT EXPLAIN MODE statement

use of (6447)

SET CURRENT EXPLAIN SNAPSHOT statement

use of (6453)

SET CURRENT QUERY OPTIMIZATION statement

use of (6167)

SET NULL delete rule

overview of (4833)

setting schema (5098)

setting the default environment profile for rah (7855)

setting up document server (7264)

setting VARCHAR (5260)

share mode

reasons for using (6154)

shared nothing model (7065)

sheapthres configuration parameter (6747)

avoiding post-threshold sorts (6539)

shift-out and shift-in characters (5668)

shutdown HACMP ES (7161)

single partition, multiple processors environment (4712)

single partition, single processor environment (4709)

single-partition database (4685)

SmartGuide

Performance Configuration (5228)

SMP cluster environment (4719)

SMP environment (4713)

SMS table space

advantages (4966)

caching of (6556)

containers (4928)

creating (5081)

design factors (4930)

multiple containers (4935)

overview (4925)

physical files (4936)

SYSCATSPACE (4914)

TEMPSPACE1 table space (4920)

USERSPACE1 (4917)

snapshot, point-in-time monitoring (6584)

softmax configuration parameter (6860)

managing the buffer pool (6500)

Solaris Operating Environment failover

partitioned database system (7233)

binding partitions to a logical host (7247)

choosing a failover configuration (7240)

client application considerations (7255)

components (7234)

creating DB2 instance (7244)

DMS table spaces (7254)

enabling the instance for failover (7246)

hot standby configuration (7236)

hot standby partition failover (7237)

how failover processing works (7248)

mutual takeover configuration (7238)

preliminary requirements (7242)

registering DB2 resource with Sun Cluster 2.1 (7245)

running scripts during failover (7252)

scripts and programs (7243)

setting up failover support (7239)

setting up hot standby configuration (7249)

setting up mutual takeover configuration (7250)

starting and stopping DB2 (7251)

table space considerations (7241), (7253)

types (7235)

single-partition database system

choosing a failover configuration (7224)

client application considerations (7232)

components (7219)

creating a DB2 instance (7226)

enabling the instance for failover (7228)

hot standby (7221)

mutual takeover (7222)

overview (7218)

registering the DB2 resource (7227)

running scripts during failover (7230)

setting up (7223)

starting and stopping DB2 (7229)

table space considerations (7225)

types (7220)

unregistering DB2 for failover (7231)

sortheap configuration parameter (6744)

affect on query optimization (6222)

avoiding post-threshold sorts (6538)

impact on memory (6483)

sorting

configuration parameters (6530)

managing performance (6540)

non-overflowed (6532)

non-piped (6534)

overflowed (6533)

parameters affecting (6536)

performance problems (6537)

piped (6535)

piped versus non-piped sorts (6412)

sort heap size (sortheap) parameter (6742)

sort heap threshold (sheapthres) parameter (6745)

specifying collating sequence (7798)

specifying collating sequences (7804)

steps (6531)

SP frame (7094)

SP switch alias address (7125)

SP switch considerations (7123)

sparse file allocation (5111)

specifying list of machines for rah (7848)

splitting phase (5580)

spm_log_file_sz configuration parameter

DB2 transaction manager considerations (5976)

spm_log_path configuration parameter

DB2 transaction manager considerations (5978)

spm_max_resync configuration parameter

DB2 transaction manager considerations (5977)

spm_name configuration parameter

DB2 transaction manager considerations (5974)

spm_log_file_sz configuration parameter (6885)

spm_log_path configuration parameter (6883)

spm_max_resync configuration parameter (6886)

spm_name configuration parameter (6884)

SQL (6184) See also SQL statements

SQL functions

NODENUMBER, data distribution, determining (6647)

PARTITION, data distribution, determining (6646)

SQL statements

benchmarking (6681)

inoperative (5351)

select-statement (6185)

statement heap size (stmtheap) parameter (6749)

tuning queries (6182)

valid during data redistribution (6676)

SQL00001

example of database subdirectory (4849)

SQLBP.1 database file (4860)

SQLBP.2 database file (4861)

SQLDBCON database file (4852)

SQLINSLKdatabase file (4856)

SQLOGCTL.LFH database file (4854)

SQLQMF utility, replaced (5670)

SQLSPCS.1 database file (4858)

SQLSPCS.2 database file (4859)

SQLTAG.NAM (4938)

SQLTMPLK database file (4857)

sqluback

support (5819), (5858)

ss_logon configuration parameter (7043)

STAFF sample table (7591)

STAFFG sample table (7592)

standards

X/Open XA interface (6021)

star schema (6386)

start

timeout for command, setting (7000)

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

start_stop_time database manager configuration parameter (7004)

starting DB2 (4971)

startup recommendations for HACMP ES (7133)

START_STOP_TIME parameter (7109)

states

backup pending (5544)

check pending (5545)

delete pending (5546)

load pending (5547)

static SQL

distribution statistics (6273)

evaluating optimization class (6170)

EXECUTE privilege for database access (5471)

explain facility (6444), (6448)

setting optimization class (6165)

statistics

copying from production (6294)

distribution (6266)

distribution, how computed (6270)

frequent value (6267)

index clustering (6343)

modelling data (6293)

overview of (6241)

quantiles (6268)

rules for updating (6283), (6284), (6285), (6286)

RUNSTATS utility (6245)

RUNSTATS utility in a partitioned database environment (6247)

updating (6281), (7638), (7640), (7646)

user-defined functions (UDF) (6290)

when to collect (6256)

stat_heap_sz configuration parameter (6754)

impact on memory (6485)

stmtheap configuration parameter (6750)

affect on query optimization (6226)

impact on memory (6484)

stop

timeout for command, setting (7001)

stopping DB2 (4972)

storage (6462) See also memory

effect of locks on (6120)

for backup (5729)

for recovery (5731)

media failure considerations (5732)

stored procedures

configuration parameters (6830)

performance impact (6200)

Structured Query Language (SQL)

referential integrity implications for (4821)

structured type (4750)

altering (5300)

attributes (4756)

definition (4757)

hierarchy (4760)

subtype (4758)

supertype (4759)

subagent (6569)

subtype (4751)

summary table

check pending state (5578)

creating (5188)

dropping (5345)

import restriction (5591)

refreshing data (5315)

summary table scan

when used (6346)

summary tables (4902)

alternative to partial clustering (4888)

example (6311)

recovering inoperative (5346)

why replicate (4887)

supertype (4752)

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

svcename configuration parameter (6928)

switch alias address (7115)

synonym (DB2 for MVS/ESA) (5198)

sysadm_group configuration parameter (7036)

SYSCAT views (5484)

SYSCATSPACE table space (4915), (5051)

sysctrl_group configuration parameter (7037)

sysmaint_group configuration parameter (7038)

system administration (SYSADM) authority (5402)

overview (5405)

privileges (5406)

system catalog (7596), (7649) See also catalog views, catalog views

adding new column (5255)

dropping a table (5307)

dropping view implications (5330)

estimating initial size (4864)

privileges listing (5482)

retrieving authorization names with privileges (5485)

retrieving names with DBADM authority (5488)

retrieving names with table access authority (5491)

retrieving privileges granted to names (5494)

RUNSTATS utility (6257)

security (5497)

setting up (5055)

statistics (6243)

table space used (4913)

system catalog table

stored on database catalog node (4992)

system database directory

overview of (5059), (5061)

system log facility

XA interface example (6035)

XA interface use of (6033)

system managed storage (4927) See also SMS table space

system management

configuration parameters (7022)

memory considerations (6465)

table (7574)

add referential constraints (5272)

ALTER TABLE statement (5257)

altering (5253)

assigning to nodegroup (5078)

catalog views for use with structured types (7648)

catalog views on system tables (7595)

changing attributes (5313)

changing partitioning key (5311)

check pending after load (5551)

CREATE TABLE statement (5101)

creating in partitioned database (5154)

data redistribution, process (6664)

default table space (4916)

defining check constraint (5143)

defining referential constraints (5126)

defining unique constraint (5115)

defining, for a relationship (4735), (4745)

delete connected (4834)

dependent (4811)

descendent (4815)

determining where RUNSTATS execution occurs (6251)

dropping (5306)

estimating size (4866)

joining (6364)

lock compatibility, ensuring (6124)

lock mode (6147)

locking (6152)

naming (5102)

naming rules (7294)

normalizing (4789)

parent (4807)

partitioning map (4897)

populating in existing table space (7821)

populating in new table space (7819)

redistribution, error recovery (6668)

referential cycle (4816)

renaming (5297)

REORG utility (6542)

reorganizing (6541)

REORGCHK command (6546)

retrieving names with access to (5492)

revoking privileges (5463)

sample (7575)

scan, affect on locks (6145)

self-referencing (4820)

table space considerations (4958)

temporary (5054)

temporary table space (4919)

two or more, select-statement (6193)

types of locks on (6099), (6110)

understanding page use (4865)

table check constraint

adding (5281)

defining (5142)

dropping (5294)

table check constraints

overview of (4839)

table collocation (4900)

table queues (6410)

table scan (6322) See also relation scan

table space (4926), (4941) See also SMS table space, DMS table space

adding container (5243)

administration considerations (4959)

changing (5240)

changing temporary (5249)

creating (5080)

database managed space (DMS) (4943)

default at database creation (5050)

definition of (4908)

designing (4952)

device container example (5086)

dropping (5246)

extents (4911)

file container example (5084)

file system container example (5083)

in nodegroups (5091)

index (6239)

load pending state (5549)

mapping to buffer pools (4953)

mapping to nodegroups (4957)

minimum space required (4962)

naming rules (7301)

overhead, setting (6230)

overview of (4907)

page size and performance (4965)

recommendations for temporary table spaces (4963)

restoring to an existing database (5863)

separating types of data, example (5152)

system managed space (SMS) (4924)

TRANSFERRATE, setting (6231)

types of locks on (6111)

workload considerations (4964)

table space configuration parameter

affect on query optimization (6229)

table space containers

redefining (5860)

table space restore

overview of (5696)

table space roll-forward recovery

overview of (5698)

table UDF (5170)

TAKEN AT parameter (5853)

tape system

backup considerations (5820)

target row (4767)

target table (4765)

target type (4764)

target view (4766)

temporary table space

guidelines for (4923)

queries and 8 KB page size (4922)

TEMPSPACE1 (4921)

TEMPSPACE1 table space (5053)

territory configuration parameter (6894)

thread, DB2 (6565)

time

definition of (7808)

formats (7815)

time difference among nodes, maximum (6995)

time required for database recovery (5727)

time strings

definition of (7812)

timeout, starting and stopping database manager (7006)

timestamp

definition of (7809)

for logs (5900)

timestamp strings

definition of (7813)

tm_database configuration parameter

DB2 transaction manager considerations (5973)

tm_database configuration parameter (6881)

XA interface considerations (6017)

tokens (6574)

tp_mon_name configuration parameter

XA interface considerations (6015)

tpname configuration parameter (6930)

XA interface considerations (6016)

tp_mon_name configuration parameter (7028)

trail

audit (5503)

transaction (5772), (5953) See also unit of work

accessing partitioned databases (6008)

database connection considerations (6004)

failure (5762)

failure recovery on a failed database partition server (5795)

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

failure recovery, overview (5773)

global (7565)

loosely coupled (7567)

non-XA (7564)

recovering failed database partition server (5803)

RELEASE statement (6007)

tightly coupled (7568)

two-phase commit (7566)

transaction failure

on the failed database partition server (5784)

recovering failed database partition server (5797)

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

implementing using IBM TXSeries CICS (6038)

implementing using IBM TXSeries Encina (6039)

configuring DB2 (6040)

configuring Encina for each resource manager (6041)

referencing a DB2 database from and Encina application (6042)

implementing using Microsoft Transaction Server (6044)

implementing using Tuxedo (6043)

not using TCP/IP connectivity (5970)

part of database manager (5965)

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

specify database when using TCP/IP connectivity (5969)

using TCP/IP connectivity (5966)

transaction processing

configuring XA transaction managers (6036)

transaction recovery on coordinator node (5777)

transferring data (5618) See also data transfer

traverse order (5593), (5676)

default (5677)

user-specified (5678)

trigger

benefits of (5160)

creating (5159)

dependencies (5162)

dropping (5318)

Explain tables (7728)

naming rules (7299)

overview of (4840)

triggering crash recovery with DB2START (5792)

trusted clients

authentication (5374), (5376)

CLIENT level security (5369)

trust_allclnts configuration parameter (7044)

trust_clntauth configuration parameter (7045)

tuning queries

SQL statements (6183)

two-phase commit

error handling (5984)

overview of (5981)

setting up your environment (5962)

when DB2 Syncpoint Manager is required (5968)

two-phase commit protocol (5774)

type hierarchy (4754)

typed table (4761)

creating (5146)

design (4843)

overview (4842)

populating (5148)

updating rows (5304)

typed tables

data movement considerations (5680)

data movement examples (5681)

data selection (5679)

deleting rows (5302)

EXPORT (5672)

IMPORT (5673)

moving data between (5671)

moving data concepts (5674)

traverse order (5594), (5675)

typed tables examples (5682)

typed view (4762)

typed view, creating (5186)

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

udf_mem_sz configuration parameter (6757)

impact on memory (6488)

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

uniprocessor environment (4710)

unique constraint

adding (5269)

defining (5112), (5114)

dropping (5286)

unique constraints (4797)

unique HACMP container names (7102)

unique key (4801)

unit of work (5951)

COMMIT statement (5955)

definition of (5954)

ROLLBACK statement (5956)

using multiple databases (5959)

using one database (5957)

untrusted clients (5372), (5378)

updatable cursor

uncommitted read (6080)

UPDATE privilege, definition (5445)

UPDATE rules

referential integrity implications (4835)

UPDATE statement

rules for referential integrity implications (4836)

updating statistics (7637), (7639), (7645)

updating typed table (5303)

user exit program

archive and retrieve considerations (7714)

BACKUP DATABASE utility (7715)

backup storage (5738)

error handling (7721)

logs storage (5736)

overview (7672)

RESTORE DATABASE utility (7716)

user exits for OS/2

archive considerations (7710)

archiving log files (7678)

BACKUP DATABASE considerations (7717)

BACKUP DATABASE utility (7674)

calling format (7706)

db2uexit (7689)

db2uexit.CAD (7699)

db2uexit.ex1 (7694)

db2uexit.ex2 (7696)

db2uexit.ex3 (7697)

db2uexit.ex4 (7698)

error handling (7724)

invoking (7687)

overview (7673)

RESTORE DATABASE considerations (7718)

RESTORE DATABASE utility (7676)

retrieve considerations (7711)

retrieving log files (7679)

sample user exit programs (7692)

user exits for UNIX-based systems

archive considerations (7712)

archiving log files (7684)

calling format (7708)

db2uexit (7690)

db2uexit.cadsm (7703)

db2uexit.cdisk (7705)

db2uexit.ctape (7704)

error handling (7723)

invoking (7688)

overview (7682)

retrieve considerations (7713)

retrieving log files (7683)

sample user exit programs (7702)

user IDs

naming (7289)

user-defined distinct type

column definition (4749)

user-defined distinct type (UDT)

creating (5172)

dropping (5322)

naming rules (7302)

user-defined distinct type, creating (5174)

user-defined events (7078)

user-defined functions (UDF)

creating (5164)

dropping (5320)

naming rules (7298)

privilege to create non-fenced (5423)

types (5166)

updating statistics (6289)

user-defined HACMP ES event (7139)

user-defined structured type, creating (5176)

userexit configuration parameter (5885), (6864)

USERSPACE1 table space (4918), (5052)

user_exit_status configuration parameter (6914)

utilities

export (5659)

import (5658)

reorganization (6544)

reorganization check (6547)

utility parallelism (4706)

util_heap_sz configuration parameter (6721)

impact on memory (6477)

variable-length character columns (5669)

version recovery (5805)

overview of (5691)

VI Architecture (VIA) (7861)

view

access control to table (5476)

access privileges, examples of (5479)

altering (5323)

CHECK OPTION clause, CREATE VIEW statement (5183)

column access (5477)

creating (5179)

data integrity (5185)

data security (5180)

dropping (5324)

dropping implications for system catalogs (5326)

for privileges information (5499)

inoperative (5333)

merging by optimizer (6307)

migration of (7277)

naming rules (7295)

predicate pushdown by optimizer (6314)

recovering inoperative (5331)

restrictions (5325)

row access (5478)

Virtual Interface Architecture (VIA) (7860)

virtual telecommunications access method (VTAM) (7538)

Visual Explain (6417), (6456)

VTAM (7536)

weight, definition of (7793)

Windows 95 code pages (7773)

DB2CODEPAGE environment variable (7776)

supported code pages (7777)

Windows 95 failover

Administration Server considerations (7214)

Control Center considerations (7215)

Windows NT code pages (7772)

DB2CODEPAGE environment variable (7774)

supported code pages (7775)

Windows NT failover

communications considerations (7212)

considerations for administering DB2 (7205)

database considerations (7210)

DB2MSCS utility

DB2MSCS.CFG parameters (7185)

overview (7183)

setting up a single-partition database system (7187)

setting up partitioned database system (7191)

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

fallback considerations (7194)

hot standby (7181)

limitations (7217)

maintaining the MSCS system (7193)

mutual takeover (7182)

overview (7178)

planning (7179)

reconciling database drive mapping (7196)

restrictions (7216)

running scripts after DB2 resource brought online (7209)

running scripts before DB2 resource brought online (7208)

running scripts, overview (7207)

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

setting up partitioned database system for mutual takeover example

objectives (7200)

preliminary tasks (7201)

registering database drive mapping for ClusterB (7204)

run DB2MSCS utility (7202)

setting up partitioned database sytstem for mutual takeover example

registering database drive mapping for ClusterA (7203)

setting up two instances for mutual takeover example

objectives (7197)

preliminary tasks (7198)

run DB2MSCS utility (7199)

starting and stopping DB2 resources (7206)

system time considerations (7213)

types (7180)

user and group support (7211)

work space, estimating size (4883)

worksheets for HACMP ES (7173)

WSF file format

code page considerations (5644)

conventions for (5641)

exporting, loss of data (5642)

operating system differences (5657)

overview of (5640)

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

application program (AP) overview (7563)

database configuration considerations (6014)

database connection considerations (6006)

DB2 UDB XA switch (6025)

DB2 UDB XA switch on OS/2 (6027)

DB2 UDB XA switch on UNIX platforms (6026)

DB2 UDB XA switch on Windows NT (6028)

DB2 UDB XA switch, example C code (6029)

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

problem determination (6031)

registration of resource manager (7573)

resource managers (RM) (7572)

security considerations (6012)

support for host databases (6003)

supported function limitations (6020)

transaction manager (TM) overview (7569)

XA close string (6024)

XA open string (6001), (6023)

XA switch usage (6022)

XA transaction managers

configuring (6037)

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

[ DB2 List of Books | Search the DB2 Books ]