Administration Guide

Index

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

Special Characters

dbexpln tool

data from compiler (4918)

$DB2DBDFT environment variable, running db2gpmap (5990)

$RAHBUFDIR (6013)

$RAHBUFNAME (6014)

$RAHCHECKBUF (6015)

$RAHENV (6024)

access control (4108)

authentication (4109)

concurrency, overview (4681)

database manager (4203)

database objects (4200)

using locks (4710)

view to table (4222)

XA interface considerations (4663)

access path

lock attributes, factors affecting (4763)

access path selection (4793)

access plan

cost estimate (5047)

created by compiler (4914)

db2expln (5029)

graphical representation (5037)

objects (5038)

operators (5040)

using explain facility (5032)

Visual Explain (5068)

ACTIVATE DATABASE command (5163)

active logs

definition (4397)

definition of (4394)

versus archive logs (4395)

adding node to system

restrictions on database operations (5262)

when redistributing nodegroup (5233)

adsm_mgmtclass configuration parameter (5475)

adsm_nodename configuration parameter (5477)

adsm_owner configuration parameter (5478)

adsm_password configuration parameter (5476)

ADSTAR Distributed Storage Manager (ADSM)

backup restrictions (4601)

client set up (on Intel) (4593)

client set up (on UNIX) (4588)

configuration parameters (5468)

environment variables (on Intel) (4594)

environment variables (on UNIX) (4589)

managing backups and log archives (4602)

setting password (on Intel) (4597)

setting password (on UNIX) (4592)

system options file (on Intel) (4595)

system options file (on UNIX) (4590)

timeout problem resolution (4600)

use with BACKUP command (4586)

use with RESTORE command (4587)

user options file (on Intel) (4596)

user options file (on UNIX) (4591)

using (4598)

agent (5171)

agent pool (5175)

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

agent process

application heap size (applheapsz) parameter (5353)

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

maximum number of agents (maxagents) parameter (5411)

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

priority of agents (agentpri) parameter (5407)

agentpri configuration parameter (5408)

agents See also coordinator agent

application control heap size, maximum (5335)

connection entries, number (5573)

governor changes priority of (5201)

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

max_coordagents database manager parameter (5415)

maximum number of coordinating (5414)

pool size, controlling (5422)

agent_stack_sz configuration parameter (5358)

impact on memory (5098)

aggregating function (3989)

alias

authority (4004)

naming rules (5671)

using (4002)

alias (DB2 for MVS/ESA) (4005)

ALTER privilege, definition (4181)

ALTER TABLE statement

adding check constraint example (4060)

adding columns example (4045)

adding keys example (4056)

adding unique constraint example (4049)

dropping check constraint example (4069)

dropping keys example (4067)

dropping unique constraint example (4062)

tips for adding constraints (4057)

ALTER TABLESPACE statement

example of (4038), (4849)

app_ctl_heap_sz database parameter (5336)

applheapsz configuration parameter (5352)

impact on memory (5090)

application control heap

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

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

application design

acquiring locks (4712)

collating sequences, guidelines (5962)

deadlock, avoiding (4758)

lock compatibility, ensuring (4742)

lock escalation (4749)

locking considerations (4779)

locks, converting of (4747)

locks, factors affecting (4761)

overriding locks (4771)

application program (4454)

control heap, setting (5338)

database partition server failure detection (4485)

governor forces (5200)

maximum number of coordinating agents at node (5419)

transaction recovery on the failed database partition server (4472)

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

transaction recovery, overview (4455)

archive log files

for OS/2 (5848)

for UNIX-based systems (5853)

archive logs

definition (4398)

ROLLFORWARD command support (4399), (4401)

versus active logs (4396)

where stored (4403)

ASCII file formats

code page considerations (4326), (4331)

delimited (DEL) format (4324)

nondelimited (ASC) format (4329)

operating system differences (4352)

aslheapsz configuration parameter (5367)

ATTACH command

overview of (3855)

specifying Distributed Computing Environment (DCE) information (5737)

attribute

definition of (3639)

authentication (4106)

DCE security services (4133)

definition of (4110)

Distributed Computing Environment (DCE) directory services (5722)

distributed transaction processing considerations (4654)

partitioned database considerations (4132)

remote client (4131)

authentication configuration parameter (5638)

authentication type (4107)

CLIENT (4113)

DCE (4129)

DCS (4127)

SERVER (4111)

authority (4150)

configuration parameters (5634)

database administration (DBADM) (4158), (4175)

levels of (4143)

removing DBADM from SYSADM (4154)

removing DBADM from SYSCTRL (4156)

required for BACKUP command (4502)

required for EXPORT utility (4311)

required for IMPORT utility (4295)

required for REORG utility (5156)

required for RESTORE command (4532)

required for ROLLFORWARD command (4571)

system control (SYSCTRL) (4155)

system maintenance (SYSMAINT) (4157)

tasks and required authorities (4227)

authorization (4142) See also authority

choosing for database access (3736)

definition (4141)

system administration (SYSADM) (4151)

trusted client (4124)

authorization names

create view for privileges information (4248)

retrieving for privileges information (4234)

retrieving names with DBADM authority (4237)

retrieving names with table access authority (4240)

retrieving privileges granted to (4243)

AutoLoader tool

files required (6001)

hints and tips (6004)

overview (5996)

setup (6002)

troubleshooting (6005)

usage (6003)

automatic restart (4447)

AUTORESTART (4373)

autorestart database configuration parameter (4645), (5470)

DB2 transaction manager considerations (4632)

XA interface considerations (4669)

avg_appls configuration parameter (5403)

affect on query optimization (4838)

backbufsz configuration parameter (5324)

backing up database

fixed-disk media (4523)

backup (4491) See also BACKUP command

buffer for (4509)

container names (4519)

frequency (4408)

images (4517)

invoking (4506)

offline (4410)

online (4409)

planning (4499)

planning your strategy (4500)

quiesce (4503)

storage considerations (4415)

user exit program (4422)

BACKUP command

access errors, error handling (4515)

authority required (4501)

buffer (4510)

concurrency control (4513)

considerations for (4493)

database alias restriction (4507)

disk output created (4521)

overview of (4492)

system crash (4511)

tape output created (4522)

use with ADSTAR Distributed Storage Manager (4585)

BACKUP DATABASE utility

considerations for user exit program (5886)

default backup buffer size (backbufsz) parameter (5323)

error handling for user exits (5894)

user exit program for OS/2 (5842)

backup_pending configuration parameter (5505)

benchmark program

creating (5283)

sample report (5288)

SQL statements (5281)

step summary (5289)

benchmarking

db2batch tool (5284)

overview of (5278)

preparations for (5280)

testing methods (5279)

testing process (5287)

BIND privilege

definition of (4196)

BINDADD privilege, definition (4168)

binding

changing configuration parameters (5304)

command line processor (3906)

database utilities (3907)

default for DEGREE option (4833)

isolation level, specifying (4706)

rebinding invalid packages (4212)

BLOB (3762) See also large objects

block fetch (4798) See also row blocking

block-structured devices (3926)

broadcast inner-table joins (5014)

broadcast outer table joins (5006)

buffer pool

binding database applications (5314)

choosing number of (5111)

consideration for outer versus inner table determination (4988)

database managed storage (DMS) (5160)

memory required (5110)

multiple (5108)

overview of (5102)

performance considerations (5315)

sizing using buffpage configuration parameter (5312)

storage considerations (5316)

buffered inserts

IMPORT utility (4301)

buffpage configuration parameter (5313)

affect on query optimization (4836)

impact on memory (5084)

managing multiple buffer pools (5109)

caching of database (4826)

call level interface

binding to a database (3911)

calling format for user exits

for OS/2 (5874)

for UNIX-based systems (5876)

candidate keys

identifying (3675)

capacity management configuration parameters (5309)

Cartesian products (4996)

star schema (4997)

CASCADE delete rule

overview of (3724)

CATALOG DATABASE

example of (3913)

CATALOG GLOBAL DATABASE command

specifying Distributed Computing Environment (DCE) information (5735)

catalog node (4431)

connection for data redistribution (5244)

description (3863)

importance for recovery (4432)

partitioning map, getting from (5989)

catalog views (3793), (5789) See also system catalog, system catalog

BUFFERPOOLNODES (5793)

BUFFERPOOLS (5792)

CHECKS (5794)

COLAUTH (5795)

COLCHECKS (5796)

COLDIST (4881), (5797)

COLUMNS (4877), (5798)

CONSTDEP (5799)

DATATYPES (5800)

DBAUTH (5801)

EVENTMONITORS (5802)

EVENTS (5803)

FUNCPARMS (5804)

FUNCTIONS (5805)

functions (4908)

INDEXAUTH (5806)

INDEXES (4879), (5807)

KEYCOLUSE (5808)

NODEGROUPDEF (5809)

NODEGROUPS (5810)

overview (5786)

PACKAGEAUTH (5811)

PACKAGEDEP (5812)

PACKAGES (5813)

PARTITIONMAPS (5814)

PROCEDURE PARAMETERS (5816)

PROCEDURES (5815)

read-only (5791)

REFERENCES (5817)

SCHEMAAUTH (5818)

SCHEMATA (5819)

STATEMENTS (5820)

SYSSTAT.COLUMNS (5833)

SYSSTAT.FUNCTIONS (5834)

SYSSTAT.INDEXES (5835)

SYSSTAT.TABLES (5836)

SYSSTAT.COLDIST (4882)

SYSSTAT.COLUMNS (4878)

SYSSTAT.FUNCTIONS (4909)

SYSSTAT.INDEXES (4880)

SYSSTAT.TABLES (4876)

TABAUTH (5821)

TABCONST (5822)

TABLES (4875), (5823)

TABLESPACES (5824)

TRIGDEP (5825)

TRIGGERS (5826)

updatable (5790)

update-capable (4899)

VIEWDEP (5827)

VIEWS (5828)

catalogcache_sz configuration parameter (5319)

CDS (5675)

cell directory service (CDS) (5676)

character comparison, overview (5953)

character conversion

performance considerations (4815)

character serial devices (3925)

chngpgs_thresh configuration parameter (5389)

managing the buffer pool (5103)

CL_SCHED sample table (5773)

client

backing up database, restriction (4498)

CLIENT level security (4115)

client support

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

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

transaction program name (tpname) parameter (5528)

CLIENT, authentication type (4114)

clients

trusted (4117), (4122)

untrusted (4118), (4126)

CLOB (3763) See also large objects

code page

DB2CODEPAGE environment variable (5934)

guidelines for selecting (4817)

how determined (5933)

import/export considerations (4325), (4330), (4339), (4348)

locales

deriving in applications (5943)

how DB2 derives locales (5944)

RESTORE command (4542)

supported Windows 95 code pages (5935)

supported Windows NT code pages (5936)

code page support

character conversion (4816)

code point, definition of (5951)

codepage configuration parameter (5499)

codeset configuration parameter (5497)

collate_info configuration parameter (5501)

collating sequence

overview of (5950)

samples of (5961)

specifying (5955)

use in character comparisons (5954)

collating sequences (5949)

collocated join (5005)

collocation

data redistribution preservation of (5220)

column

adding (4043)

attribute (3640)

defining (3658), (3934)

estimating row size (3757)

naming rules (5667)

column UDF (3988)

command line processor

binding to a database (3908)

commands

db2evmon (5190)

commit

errors during two-phase (4635)

number of commits to group (mincommit) (5457)

two-phase (4634)

communication

connection retries, number (5587)

FCM daemon to agent, request blocks (5580)

node, connection elapse time (5552)

node, message buffers (5568)

communications bandwidth configuration parameter (4845)

comm_bandwidth configuration parameter (5622)

compiler

overview of (4913)

overview of query rewrite (4920)

composite key

definition of (3673), (3699)

composite tables

composite inner (5001)

composite outer (5000)

compound SQL

overview of (4813)

performance considerations (4814)

concurrency

controlling using locks (4711)

overview of (4679)

concurrency and granularity

effect of locks on (4739)

concurrency control

BACKUP command (4514)

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

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

configuration (5292) See also benchmarking

changing database manager parameters (5297)

changing database parameters (5303)

database manager parameters (5294)

database parameters (5302)

parameter details, overview of (5307)

parameter summary, database (5306)

parameter summary, database manager (5299)

parameters, overview of (5290)

tuning parameters (5291)

configuration file

governor example (5207)

configuration file, governor (5204)

configuration parameter

ADSTAR Distributed Storage Manager (5467)

affecting optimizer (4835)

agent communication memory (5361)

agent private memory (5340)

application communication memory (5362)

application shared memory (5331)

applications and agents (5400)

AUTORESTART (4374), (4448)

capacity management (5308)

communication protocol setup (5523)

communications (5522)

compiler settings (5516)

Database Application Remote Interface (DARI) (5432)

database attributes (5488)

database management (5486)

database manager instance memory (5372)

database shared memory (5310)

database status (5503)

database system monitor (5611)

DB2 Discovery (5541)

diagnostic information (5607)

Distributed Computing Environment (DCE) (5730)

distributed services (5534)

distributed unit of work (5479)

I/O and storage (5387)

instance administration (5633)

instance management (5606)

locks (5378)

log activity (5455)

log files (5439)

logging (5437)

migration of (5653)

parallel operations (5546)

partitioned database (3868), (5547)

recovery (5438), (5465)

stored procedure (5431)

system management (5620)

configuration parameters

database logging (4557)

configuration, adding servers when system is running (5267)

configuration, adding servers when system is stopped (5271)

configuration, changing the size of a (5261)

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

conn_elapse configuration parameter (5553)

CONNECT command

specifying Distributed Computing Environment (DCE) information (5736)

CONNECT privilege, definition (4167)

connection

elapse time (5555)

number of retries (5586)

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

connection entry (5575)

constraint

changing (4047)

Explain tables (5896)

constraint name

defining foreign keys (3962)

defining table check constraints (3972)

constraint violations

checking (4284)

constraints

types of (3689)

container names (4520)

containers

adding (to DMS table space) (4036)

DMS table space design (3827)

logical file system (3813)

logical volume device (3829)

overview of (3790)

SMS table space (3809)

SMS table space design (3811)

suggestions for parallel I/O (5133)

Control Center

Event Analyzer (5184)

Performance Monitor (5182)

Snapshot Monitor (5183)

CONTROL privilege

definition of (4180)

implicit issuance (4215)

package privileges (4195)

controlling the shell script (6023)

conversion

of locks, rules for (4746)

cooked devices (3928)

Coordinated Universal Time (5596)

coordinator agent (5172)

maximum number at node (5420)

coordinator database partition, considerations for dropping (5277)

coordinator node (3601)

copyprotect configuration parameter (5502)

country configuration parameter (5495)

CPU speed configuration parameter

affect on query optimization (4842)

cpuspeed configuration parameter (5623)

crash recovery (4445)

overview of (4371)

RESTART DATABASE (4372)

triggering (4475)

CREATE ALIAS statement

example of (4003)

using (4001)

CREATE DATABASE API

SQLEDBDESC structure (5959)

CREATE DATABASE command

example of (3886)

CREATE INDEX statement

example of (4020)

unique index (4022)

CREATE TABLE statement

defining check constraints (3973)

defining referential constraints (3956)

example of (3940)

using multiple table spaces (3975)

CREATE TABLESPACE statement

example of (3920)

CREATE TRIGGER statement

example of (3982)

CREATE VIEW statement

changing column names (3998)

example of (3995)

CREATE_NOT_FENCED privilege, definition (4171)

CREATETAB privilege, definition of (4169)

creating (3646) See also defining

CURRENT DEGREE special register (4831)

cursor

close using WITH RELEASE clause (4777)

read only, uncommitted read (4702)

updatable, uncommitted read (4703)

cursor stability

overview of (4694)

DARI (4820) See also stored procedures

data

caching when database is started (4825)

changing distribution (4031)

connection entries for agents to pass, number (5574)

data integrity

concurrency, overview (4680)

protecting using locks (4714)

unique index (4008)

data security

controlling database access (4100)

importance of (4101)

securing system catalog (4245)

data structure

SQLEDBDESC (5958)

data transfer

AutoLoader tool (5997)

between DB2 for Universal Database databases (4350)

between host and workstation (4358)

EXPORT utility (4307)

file formats supported (4315)

IMPORT utility (4288)

overview of (4252)

data type

column definition (3659), (3935)

multi-byte character set (3938)

database (4436)

activate (5166)

agents (5170)

altering nodegroup (4027)

auto restart enable (autorestart) parameter (5469)

backup (4490)

backup pending indicator (backup_pending) parameter (5504)

catalog node, media failure considerations (4437)

cataloging (3912)

changing (4026)

changing distribution of data (4030)

code page for database (codepage) parameter (5498)

codeset for database (codeset) parameter (5496)

collating information (collate_info) parameter (5500)

configuration parameter summary (5305)

configuration parameters (5300)

connection considerations (4657)

considerations before changing (4024)

considerations for creating (3869)

country code for database (country) parameter (5494)

crash recovery (4477)

creating (3885)

creating across all nodes (3866)

data caching when database is started (4824)

database is consistent (database_consistent) parameter (5506)

database partition synchronization, recovery considerations (4443)

deactivate (5167)

deciding what data to record (3637), (3644)

defining tables (3645)

designing (3636)

determining list of data nodes (4497)

dropping (4033)

enabling data partitioning (3861)

estimating size (3753)

implementing design (3845)

inconsistent after restart (4478)

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

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

migration (5646)

naming rules (5662)

normalizing tables (3680)

number of containers (numsegs) parameter (5395)

object naming rules (5659)

other design considerations (3734)

package dependencies (4096)

parameter file SQLDBCON (5301)

physical design (3737)

recovering failed database partition server (4483)

recovery log (3902)

release level (release) parameter (5489)

resource manager in TP Monitor environment (4652)

restore (4527)

roll-forward changes (4555)

storage for an application (5079)

subdirectory created (3738)

territory for database (territory) parameter (5492)

transaction recovery on the failed database partition server (4470)

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

transaction recovery, overview (4451)

uniquely identifying entities (3677)

updating multiple databases (4620)

user exit enable (userexit) parameter (5463)

user exit status indicator (user_exit_status) parameter (5512)

using multiple databases in a single transaction (4617)

database access

affect of optimization class (4781)

choosing authorizations (3735)

controlling (4099)

overview of (4935), (4939)

privileges through package with SQL (4217)

database administrator (DBADM) authority

privileges (4159)

retrieving names with (4236)

database alias (5658)

for BACKUP command (4508)

naming rules (5661)

RESTORE command (4535)

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

keep DARI process indicator (keepdari) parameter (5433)

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

database configuration

app_ctl_heap_sz parameter (5337)

creating file (3881)

database creation, specifying collating sequence (5956)

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

database files

index data (3820)

log files (3743)

notes of caution (3752)

SMS table space (3817)

SQLINSLK (3745)

table data (3819)

database locator objects

creating (5683)

example (5684)

database logs (4390)

configuration parameters (4558)

database managed storage (3822) See also DMS table space

database manager (4452)

access control (4202)

binding utilities (3905)

configuration parameter summary (5298)

configuration parameters (5295)

default database path (dftdbpath) parameter (5639)

governor affect on performance (5214)

index (4015)

machine node type (nodetype) parameter (5628)

naming rules (5660)

parameter file db2systm (5296)

recovering failed database partition server (4484)

start timeout (5601)

starting and stopping (3847)

stop timeout (5602)

transaction failure, reducing impact (4438)

transaction recovery on the failed database partition server (4471)

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

transaction recovery, overview (4453)

using memory (5076)

database manager configuration

conn_elapse parameter (5554)

fcm_num_anchors parameter (5559)

fcm_num_buffers parameter (5564)

fcm_num_connect parameter (5572)

fcm_num_rqb parameter (5579)

java_heap_sz parameter (5377)

max_connretries parameter (5588)

max_coordagents parameter (5417)

max_time_diff parameter (5593)

num_initagents parameter (5429)

num_poolagents parameter (5425)

start_stop_time parameter (5604)

database managment, configuration parameters (5487)

database monitor

using (5180)

database objects

access control (4201)

creating (5681)

example (5682)

naming rules (5664), (5948)

database partition (3595)

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

database partition, adding when system is running (5266)

database partition, considerations for dropping a server (5276)

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

database partitions, adding to a system (5264)

database partitions, adding when system is stopped (5270)

database restore

overview of (4377)

database roll-forward recovery

overview (4380)

database seed (4548)

database startup cost (5165)

database system monitor

configuration parameters (5612)

fcm_num_rqb database manager parameter, tuning (5582)

databases

non-recoverable (4389)

recoverable (4388)

database_consistent configuration parameter (5507)

database_level configuration parameter (5491)

DataPropagator Relational (DPROPR)

overview (4253)

date

definition of (5966)

formats (5973)

date strings

definition of (5970)

datetime values

overview of (5965)

string representations (5969)

DAU (DB_Authentication) (5689)

DB_Authentication (DAU) (5688)

DB_Comment (DCO) (5694)

DB_Communication_Protocol (DCP) (5697)

DB_Database_Locator_Name (DLN) (5703)

DB_Database_Protocol (DDP) (5700)

DB_Native_Database_Name (DNN) (5706)

DB_Object_Type (DOT) (5709)

DB_Principal (DPR) (5691)

DB_Product_Name (DPN) (5712)

DB_Product_Release (DRL) (5715)

DB_Target_Database_Info (DTI) (5718)

DB2 Administration Server (DAS)

creating (3877)

overview (3876)

ownership rules (3875)

DB2 concepts

overview (3591)

DB2 Connect (4251) See also data transfer

DB2 parallelism concepts

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

coordinator node (3602)

database partition (3596)

enabling parallelism (3635)

I/O parallelism (3609)

inter-partition parallelism (3615)

intra-partition parallelism (3613)

multi-partition nodegroup (3606)

nodegroup (3604)

overview (3594)

partitioned database (3600)

query parallelism (3611)

single-partition database (3598)

types of parallelism (3607)

utility parallelism (3619)

DB2 transaction manager

database configuration considerations (4625)

db2adutl utility (4603)

DELETE command (4606)

EXTRACT command (4605)

QUERY command (4604)

db2adutl utility examples (4607)

db2batch benchmarking tool (5285)

db2empfa (5135)

db2event directory (5647)

db2exfmt tool (5051)

db2expln (5913) See also explain tool

db2gov command (5196)

db2govlg command (5212)

db2gpmap (get partitioning map) tool (5987)

db2icrt command (3871)

DB2INSTANCE environment variable

defining default instance (3854)

DB2LOADREC (4574)

db2look tool

overview of (4912)

DB2NODE environment variable

exported when adding server (5269)

db2nodes.cfg file (3879)

adding database partitions when redistributing data (5235)

dropping database partitions when redistributing data (5236)

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

db2nodes.cfg, updating manually (5273)

db2set command (3874)

db2split program

AutoLoader tool (6000)

configuration file, example (5985)

data file, example (5984)

header information in output files (5994)

parameters (5982)

purpose (5975)

running (5992)

using (5977)

db2start command (3851)

db2stop command (3850)

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

user exit programs for OS/2 (5862)

user exit programs for UNIX-based systems (5867)

db2_all (6007)

db2_call_stack (6011)

db2_kill (6010)

DBCLOB (3764) See also large objects

dbheap configuration parameter (5318)

impact on memory (5086)

DCE network database

connecting (5739), (5740)

creating (5738)

DCE, authentication type (4130)

DCO (DB_Comment) (5695)

DCP (DB_Communication_Protocol) (5698)

DCS, authentication type (4128)

DDP (DB_Database_Protocol) (5701)

DEACTIVATE DATABASE command (5164)

deadlocks

checking for (5382)

configuration parameter (5383)

detecting (4756)

overview of (4757)

decorrelation of a query (4931)

default attribute specification (3939)

default value

alternative to null value (3663)

column definition (3662)

defining synonyms for rah (6009)

DEGREE bind option (4832)

DEL file format (4323) See also ASCII file formats

DELETE privilege, definition (4184)

DELETE rules

types of (3720)

DELETE statement

referential integrity implications for (3719)

DEPARTMENT sample table (5774)

dependent row

definition of (3707)

dependent table

definition of (3705)

design of database

altering (4025)

design, implementing (3846)

DETACH command

overview of (3856)

dft_queryopt configuration parameter (4837)

dftdbpath configuration parameter (5640)

dft_account_str configuration parameter (5630)

dft_client_adpt configuration parameter (5540)

dft_client_comm configuration parameter (5539)

dft_degree configuration parameter (4829), (5518)

dft_extent_sz configuration parameter (5397)

dft_loadrec_ses configuration parameter (5473)

dft_monswitches configuration parameter (5613)

dft_mon_bufpool configuration parameter (5617)

dft_mon_lock configuration parameter (5618)

dft_mon_sort configuration parameter (5619)

dft_mon_stmt configuration parameter (5615)

dft_mon_table configuration parameter (5616)

dft_mon_uow configuration parameter (5614)

dft_prefetch_sz configuration parameter (5394)

dft_queryopt configuration parameter (5519)

dft_sqlmathwarn configuration parameter (5517)

diaglevel configuration parameter (5609)

diagpath configuration parameter (5610)

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

directed inner-table join (5017)

directed outer-table joins (5009)

directories

local database directory (3896)

node directory (3900)

system database directory (3898)

directory cache

effect of cataloging databases (3914)

directory objects

creating (5680)

object classes attributes (5687)

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

dir_cache configuration parameter (5374)

dir_obj_name configuration parameter (5537)

dir_path_name configuration parameter (5536)

dir_type configuration parameter (5535)

disaster recovery

considerations (4428)

discover configuration parameter (5543)

discover_comm configuration parameter (5544)

discover_db configuration parameter (5542)

discover_inst configuration parameter (5545)

Distributed Computing Environment (DCE)

ATTACH command (5734), (5742)

authentication (4135)

CATALOG GLOBAL DATABASE command (5732)

CDS (5674)

configuration parameters (5533)

configuration parameters and environment variables (5729)

CONNECT command (5733), (5743)

directory services restrictions (5747)

directory services tasks (5745)

GDS (5679)

how directories are searched (5741)

overview of directory services (3915)

restrictions (4139)

security services (4134)

setup DB2 client instance (4138)

setup DB2 server (4137)

setup DB2 user (4136)

temporarily overriding DCE directory information (5744)

using directory services (5746)

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

distributed unit of work (4609)

overview of (4618)

configuration parameters (5480)

recovering indoubt transactions (4638)

updating multiple databases (4621)

dlchktime configuration parameter (5381)

DLN (DB_Database_Locator_Name) (5704)

DMS table space

adding containers (3831)

advantages (3844)

allocating space (3828)

choosing extent size (3839)

creating (3923)

increasing storage (3830)

overview of (3824)

performance considerations (5159)

size (3826)

types of (3825)

DNN (DB_Native_Database_Name) (5707)

dos_rqrioblk configuration parameter (5370)

DOT (DB_Object_Type) (5710)

double byte character set user

data type (3937)

DPN (DB_Product_Name) (5713)

DPR (DB_Principal) (5692)

DPROPR (4254) See also DataPropagator Relational (DPROPR)

drda_heap_sz configuration parameter (5356)

impact on memory (5096)

DRL (DB_Product_Release) (5716)

DROP DATABASE command

example of (4034)

DROP INDEX statement; example of (4088)

DROP TABLE statement

example of (4073)

DROP TABLESPACE statement; example of (4040)

DROP VIEW statement; example of (4083)

dropping node from system

when redistributing nodegroup (5234)

DTI (DB_Target_Database_Info) (5719)

dynamic SQL

distribution statistics (4891)

evaluating optimization class (4789)

EXECUTE privilege for database access (4220)

explain facility (5055), (5060)

setting optimization class (4786)

dynexpln (5914) See also explain tool

eliminating duplicate entries from host list (6022)

EMP_ACT sample table (5776)

EMP_PHOTO sample table (5777)

EMP_RESUME sample table (5778)

EMPLOYEE sample table (5775)

Encina

using (4676)

entity

definition of (3638)

values (3678)

environment variables (3872)

$DB2DBDFT, running db2gpmap (5991)

DB2LOADREC (4575)

DB2NODE, exported when adding server (5268)

Distributed Computing Environment (DCE) (5731)

erasing the sample database (5772)

error handling

access errors, BACKUP command (4516)

access errors, RESTORE command (4541)

configuration parameters (5608)

indoubt transaction in TP Monitor environment (4659)

indoubt transactions (4641)

log full (4560)

system crash during BACKUP (4512)

two-phase commit (4640)

user exit program (5889)

user exit program for OS/2 (5892)

XA interface (4671)

estore_seg_sz configuration parameter (5398)

impact on memory (5088)

event snapshots (5189)

exclusive mode

reasons for using (4776)

EXECUTE privilege

database access with dynamic SQL (4221)

database access with static SQL (4219)

definition of (4197)

EXPLAIN (5056)

explain

FOR SNAPSHOT (5061)

Visual (5028), (5067)

WITH SNAPSHOT (5062)

explain facility (4919) See also dbexpln tool

analysis (5034)

capturing information (5030), (5053)

choosing a tool (5025)

concepts (5035)

data from compiler (4917)

data organization (5042)

decision-making (5064)

explain instance (5044)

graphical representation (5036)

instance information (5045)

keywords (5048)

objects (5039)

obtaining data (5052)

operators (5041)

overview of (5024)

snapshot information (5049)

statement information (5046)

table information (5050)

using (5031)

explain instance (5043)

explain snapshot (5059)

explain tables

accessing (5026)

explain tool (5911)

aggregation (5929)

command options (5917), (5919)

data streams (5925)

description of output (5920)

examples of db2expln and dynexpln output (5932)

insert, update, and delete (5926)

joins (5924)

miscellaneous statements (5931)

overview of (5912)

parallel processing (5930)

row identifier (RID) preparation (5927)

running (5915)

syntax (5916), (5918)

table access (5921)

temporary tables (5923)

EXPLAIN_ARGUMENT table (5897)

EXPLAIN_ARGUMENT table definition (5904)

EXPLAIN_INSTANCE table (5898)

EXPLAIN_INSTANCE table definition (5905)

EXPLAIN_OBJECT table (5899)

EXPLAIN_OBJECT table definition (5906)

EXPLAIN_OPERATOR table (5900)

EXPLAIN_OPERATOR table definition (5907)

EXPLAIN_PREDICATE table (5901)

EXPLAIN_PREDICATE table definition (5908)

EXPLAIN_STATEMENT table (5902)

EXPLAIN_STATEMENT table definition (5909)

EXPLAIN_STREAM table (5903)

EXPLAIN_STREAM table definition (5910)

EXPORT utility

export utility

authority (4309)

authorization and privileges required (4310)

delimited ASCII (DEL) files (4321)

general description (4357)

information required (4308)

integrated exchange format (IXF) files (4342)

Lotus worksheet (WSF) files (4333)

overview of (4306)

recreating exported data (4313)

extended storage cache (5192)

Extended UNIX Code (EUC)

code page support (4818)

extent size

choosing (5119)

choosing the value (3838)

definition of (3791)

SMS table space design (3812)

failover support (6028) See also High Availability Cluster Multi-Processing configurations

fast communication manager (FCM)

FCM Connection Entries (fcm_num_connect) parameter (5570)

fcm_num_buffers database manager parameter (5563)

message anchors, number, specifying (5560)

message buffers, number, specifying (5566)

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

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

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

FCM communications (3884)

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

FCM tuning (5101)

fcm_num_anchors configuration parameter (5558)

fcm_num_buffers configuration parameter (5565)

fcm_num_connect configuration parameter (5571)

fcm_num_rqb database manager configuration parameter (5578)

file format

delimited ASCII (DEL) (4322)

for transferring data (4316)

nondelimited ASCII (ASC) (4327)

overview for EXPORT utility (4317)

overview for IMPORT utility (4318)

overview for LOAD utility (4319)

PC/IXF (4343)

worksheet (WSF) (4334)

files (3741)

fileserver configuration parameter (5530)

finding errors

data redistribution log file (5255)

FOR FETCH ONLY clause (4809)

FOR READ ONLY clause (4808)

FOR UPDATE clause (4810)

foreign key

adding (4053)

composite (3961)

constraint name (3960)

DROP FOREIGN KEY clause, ALTER TABLE statement (4065)

IMPORT utility, referential integrity implications for (3968)

LOAD utility, referential integrity implications for (3967)

privileges required for dropping (4066)

rules for foreign key definitions (3959)

update, referential integrity implications for (3731)

FOREIGN KEY clause

referential constraints (3957)

rules for foreign key definitions (3958)

frequent value statistics

equality predicates (4896)

number to collect (4892)

overview of (4888)

rules for updating (4904)

GDS (5677)

global directory service (GDS) (5678)

governor

configuration file (5203)

configuration file example (5206)

daemon (5198)

database manager performance (5213)

db2gov (5197)

db2govlg (5211)

error handling (5202)

log file (5209)

obtains statistics (5199)

purpose (5193)

querying log file (5210)

rules (5205)

starting (5194)

stopping (5195)

GRANT statement

implicit issuance (4213)

security (5727)

use of (4205)

GRANT statement; example of (4206)

HACMP (6027) See also High Availability Cluster Multi-Processing configurations

hardware environments

logical database partitions (3634)

overview (3620)

partitions with multiple processors (3632)

partitions with one processor (3629)

single partition, multiple processors (3626)

single partition, single processor (3623)

hashing algorithm (4287)

header information in data files, db2split (5995)

heuristic operations

guidelines (4643), (4660)

recovering indoubt transactions (4642)

High Availability Cluster Multi-Processing configurations (6026)

hot standby mode (6031)

modes of failover support (6030)

mutual takeover mode (6032)

overview (6029)

I/O

configuration parameters (5388)

enabling parallel I/O (5131)

parallelism (3608)

prefetch parallel (5128)

IBM Relational Data Replication Tools

details (4368)

using (4367)

IBMCATGROUP nodegroup (3888)

IBMDEFAULTGROUP nodegroup (3890)

IBMTEMPGROUP nodegroup (3889)

idle agent (5174)

images

backup (4518)

IMPLICIT_SCHEMA authority (3931)

IMPLICIT_SCHEMA privilege, definition of (4172)

IMPORT

unequal code page (4297)

IMPORT utility

import utility

authority (4293)

authorization and privileges required (4294)

binding to a database (3909)

buffered inserts (4300)

client/server (4302)

delimited ASCII (DEL) files (4320)

differences to LOAD (4304)

general description (4356)

information required (4290)

integrated exchange format (IXF) files (4341)

large objects (4291)

LOAD (3966)

LOBs (4292)

Lotus worksheet (WSF) files (4332)

nondelimited ASCII (ASC) files (4328)

overview of (4289)

recreating exported data (4299)

referential integrity implications for (3969)

remote database (4303)

IN_TRAY sample table (5779)

incompatibilities

description (5655)

index

administering (4854)

changing (4086)

clustering (4857)

consideration for outer versus inner table determination (4989)

CREATE INDEX statement (4018)

CREATE UNIQUE INDEX statement (4021)

creating (4007)

definition of (4009)

definition of index ANDing (4955)

definition of index ORing (4954)

disadvantages of indexing (4852)

DROP INDEX statement (4087)

estimating size (3767)

guidelines for indexing (4853)

how used (4017)

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

index-only access (4952), (5922)

indexing versus no indexing (4851)

lock mode (4769)

look-up, affect on locks (4764)

management, overview of (4850)

multiple (4953)

naming rules (5668)

non-unique (4019)

nonprimary (4093)

optimizing number (4012)

prefetch (5117)

primary (3949)

primary versus user-defined (4011)

privileges (4199)

scan (4943) See also index scan

structure (4942)

temporary space (3768)

unique (4023)

unique on primary key (3667)

unique on unique key (3668)

index clustering

cluster factor statistic (4871)

cluster ratio statistic (4870), (4957)

index creation (4855)

index key, definition (4013)

index page prefetch (5116)

INDEX privilege, definition (4186)

index scan

index clustering (4956)

ordering data (4951)

overview of (4941)

predicate (4947)

predicate terminology (4961)

search process (4944)

use of (4945)

WHERE clause, use of (4948)

indexes

temporary files (4271)

indexrec configuration parameter (5472)

indexsort configuration parameter (5392)

indoubt transactions

definition of (4637)

recovering (4639), (4647), (5758)

recovering using SNA communications (4649)

recovering using TCP/IP communications (4650)

resynchronizing (4646)

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

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

inner-table join, method (5015), (5018)

INSERT privilege, definition (4187)

INSERT statement

referential integrity implications for (3717)

installing the sample database (5769)

instance parallelism support (4828)

instances

creating (3870)

overview of (3852)

time difference among nodes, maximum (5595)

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

inter-partition parallelism (3614)

intra-partition parallelism (3858)

intra-partition and inter-partition parallelism (3616)

intra-partition parallelism (3612)

intra-partition parellelism (5132)

intra_parallel configuration parameter (4827), (5597)

introduction

DB2 concepts (3590)

DB2 parallelism concepts (3593)

ipx_socket configuration parameter (5532)

isolation level

choosing (4704)

cursor stability (4697)

description of (4682)

read stability (4693)

repeatable read (4687)

specifying, overview (4705)

uncommitted read (4698)

issuing commands to multiple partitions (6006)

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

java_heap_sz database manager configuration parameter (5376)

jdk11_path database manager configuration parameter (5632)

join

Cartesian products (4995)

composite tables (4999)

definition of (4976)

eliminating redundancy (4926)

enumeration algorithm (4994)

merge join (4982)

nested loop join (4981)

optimizer search strategies (4992)

outer versus inner table determination (4984)

overview of (4979)

shared aggregation (4927)

subquery transformation by optimizer (4925)

tables (4977)

join path

definition of (3679)

join strategies (5002)

broadcast inner-table (5016)

broadcast outer table (5007)

collocated (5004)

directed inner-table (5019)

directed inner-table and outer-table (5013)

directed outer-table (5010)

in a partitioned database (5003)

keepdari configuration parameter (5434)

keeping related data together (4424)

key (3669) See also primary key

composite (3698)

definition of (3670), (3697)

foreign (3696)

primary (3665)

unique (3666)

Large Object (LOB)

column considerations (3941)

large objects

allocation objects (3766)

column definition (3660)

data objects (3765)

DMS storage (5162)

estimating size (3760)

LIST INDOUBT TRANSACTIONS command

use in performing heuristic actions (4644), (4661)

LIST NODES CMD

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

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

LOAD CMD/API See loading data

LOAD utility

APIs (4269)

authority required (4273)

Build phase (4258)

details (4266)

differences to IMPORT (4305)

exception table (4283)

failure (4264)

limitations (4275)

Load phase (4257)

LOAD QUERY command (4268)

overview (4249)

performance considerations (4278)

process overview (4256)

recovery (4282)

recovery from failures (4280)

restarting (4281)

restrictions (4274)

tasks (4270)

temporary space limitations (4279)

unequal code page (4276)

using (4255)

loading data

AutoLoader tool for loading data on database partitions (5999)

db2split program, splitting data (5976)

db2split, example file (5983)

populating table in existing table space (5981)

populating table in new table space (5979)

LOB (3761) See also large objects

local database directory

overview of (3897)

locales

deriving in application programs (5945)

how DB2 derives (5946)

LOCK TABLE statement

in minimizing escalations (4752)

use to override locks (4770)

locking

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

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

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

locklist configuration parameter (5328)

affect on query optimization (4840)

impact on memory (5085)

locks

acquiring (4713)

attributes of (4715)

attributes, types of processing (4762)

avoiding global deadlocks (4755)

compatibility of, ensuring (4741)

configuration parameter (5379)

conversion of (4745)

creating, using cursor stability (4696)

creating, using repeatable read (4686)

deadlock, using FOR UPDATE OF (4759)

duration attribute (4717)

escalation and actions to take (4751)

escalation of (4748)

exclusive (X) mode (4727)

exclusive mode, reasons for using (4775)

factors affecting (4760)

improving concurrency (4750)

intent exclusive (IX) mode (4724)

intent none (IN) mode (4721)

intent share (IS) mode (4722)

locktimeout configuration parameter (4754)

mode attribute (4718)

modes for index scan (4768)

modes for table scan (4766)

object attribute (4716)

overview of (4709)

read stability (4692)

reducing waits for (4753)

share (S) mode (4723)

share mode, reasons for using (4773)

share with intent exclusive (SIX) mode (4725)

state (mode), types of (4720)

superxclusive (Z) mode (4728)

update (U) mode (4726)

locktimeout configuration parameter (5386)

log files

governor log file (5208)

written for data redistribution (5254)

logbufsz configuration parameter (4563), (5321)

logfilsiz configuration parameter (4562), (5442)

logging facility (4391) See also logs

loghead configuration parameter (5454)

logical database partitions (3633)

logical file system

limits (3814)

logpath configuration parameter (5450)

logprimary configuration parameter (4559), (5444)

logretain configuration parameter (4566), (5462)

logs

active (4392)

archived (4393)

change database log path (newlogpath) parameter (5447)

configuration parameters affecting log activity (5456)

configuration parameters affecting log files (5440)

estimating size (3769)

identifying (4578)

location (4579)

location of log files (logpath) parameter (5449)

log buffer size (logbufsz) parameter (5320)

log head identification (loghead) parameter (5453)

log retain enable (logretain) parameter (5461)

log retain status indicator (log_retain_status) parameter (5510)

losing (4583)

managing (4577)

next active log (nextactive) parameter (5451)

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

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

offline archived logs (4402)

online archived logs (4400)

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

size of log files (logfilsiz) parameter (5441)

storage required (4419)

use of timestamp (4580)

userexit program (4420)

logsecond configuration parameter (4561), (5446)

log_retain_status configuration parameter (5511)

long field data

alternatives to (3759)

DMS storage (5161)

estimating size (3758)

losing logs (4582)

Lotus worksheet files (4335) See also WSF file format

many-to-many relationships (3653)

many-to-one relationships (3651)

max_connretries database manager configuration parameter (5585)

max_coordagents database manager configuration parameter (5416)

max_querydegree configuration parameter (5589)

max_time_diff database manager configuration parameter (5592)

maxagents (5176)

maxagents configuration parameter (5412)

effect on memory (5083)

maxappls configuration parameter (5402)

DB2 transaction manager considerations (4631)

effect on memory (5082)

XA interface considerations (4668)

maxcagents configuration parameter (5410)

maxdari configuration parameter (5436)

maxfilop configuration parameter (5405)

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

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

maximum query degree of parallelism configuration parameter (4844)

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

maxlocks configuration parameter (5385)

affect on query optimization (4841)

maxtotfilop configuration parameter (5406)

max_querydegree configuration parameter (4830)

media failure

logs (4418)

memory

agent communication memory (5363)

agent private memory (5341)

application communication memory (5364)

application heap size (applheapsz) parameter (5351)

application shared memory (5332)

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

configuration parameters (5080)

considerations for system administrator (SYSADM) (5074)

database heap (dbheap) parameter (5317)

database manager instance (5371)

database shared memory (5311)

extending (5191)

for processing a database (5078)

package cache size (pckcachesz) parameter (5329)

setting parameter values (5099)

sort heap size (sortheap) parameter (5343)

sort heap threshold (sheapthres) parameter (5346)

statement heap size (stmtheap) parameter (5348)

use by the database manager (5077)

use of (5073)

when committed (5100)

memory usage (5657)

application control heap (5339)

merge join

outer versus inner table determination (4991)

overview of (4983)

message anchor (5561)

migration (5644)

authority required (5649)

overview of (5645)

release-to-release incompatibilities (5651)

restrictions (5648)

steps required (5654)

storage requirements (5650)

mincommit configuration parameter (4564), (5458)

min_priv_mem configuration parameter (5359)

mixed-byte data (4361)

importing and exporting (4362)

monitor switches (5185)

monitoring (5186) See also database system monitor

monitoring rah processes (6016)

mon_heap_sz configuration parameter (5373)

moving data (4250) See also data transfer

MPP environment (3628)

multi-partition nodegroup (3605)

multimedia objects (3643)

multipage_alloc configuration parameter (5515)

effect on memory (5134)

multiple buffer pages, allocating (5136)

multiple instances (3853)

use with ADSTAR Distributed Storage Manager (4599)

naming scheme, database directories (3740)

national language support

mixed-byte data (4363)

national language support (NLS)

character sets (5947)

datetime values (5964)

nested loop join

outer versus inner table determination (4987)

overview of (4980)

newlogpath configuration parameter (4565), (5448)

Next Key Exclusive Lock (NX) mode (4734)

Next Key Share Lock (NS) mode (4733)

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

nextactive configuration parameter (5452)

nname configuration parameter (5525)

NO ACTION delete rule

overview of (3722)

NOCHECKLENGTHS option (4277), (4298)

node (4433)

catalog, recovery considerations (4434)

cataloging (3862)

changing in nodegroup (4028)

connection elapse time (5551)

coordinating agent, maximum (5418)

creating database across all (3867)

data location, determining (3780)

data redistribution, process (5243)

determining list of data nodes (4496)

determining where RUNSTATS execution occurs (4867)

failed database partition server, recovering (4480)

maximum number of connection retries (5584)

maximum time difference among (5591)

message buffers, number, specifying (5567)

other operations during redistribution (5258)

partitioning map, getting from catalog (5988)

redistributing data across database partitions (5216)

synchronization, recovery considerations (4442)

transaction recovery on a failed database partition server (4473)

transaction recovery on an active database partition server (4460)

node configuration file (3773)

creating (3878)

node connection retries (max_connretries) (5583)

node number (3880)

nodegroup (3603)

altering (4029)

creating (3916)

designing (3772)

IBMDEFAULTGROUP, table created in by default (3979)

initial definition (3887)

mapping table spaces (3834)

other operations during redistribution (5257)

partitioning key, changing (4076)

partitioning map entries (3777)

recovering failed database partition server (4486)

redistributing data (5217)

table considerations (3978)

transaction recovery on a failed database partition server (4474)

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

nodetype configuration parameter (5629)

non-recoverable databases (4387)

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

non-unique index

dropping (4091)

nonprimary index

dropping (4090)

dropping implications for applications (4094)

normal form

first (3685)

fourth (3688)

overview of (3684)

second (3686)

third (3687)

normalizing

definition of (3683)

tables (3681)

NS (Next Key Share Lock) mode (4732)

null value

alternative to default value (3664)

column definition (3936)

num_initagents database manager configuration parameter (5428)

num_poolagents database manager configuration parameter (5424)

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

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

numdb configuration parameter (5626)

effect on memory (5081)

numsegs configuration parameter (5396) See also table space

num_estore_segs configuration parameter (5399)

impact on memory (5089)

num_freqval configuration parameter (5520)

num_iocleaners configuration parameter (5390)

managing the buffer pool (5104)

num_ioservers configuration parameter (5391)

impact on data prefetch (5130)

num_poolagents (5177)

num_poolagents configuration parameter

impact on MPP/SMP systems (5179)

num_quantiles configuration parameter (5521)

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

NX (Next Key Exclusive Lock) mode (4735)

object class attributes

DB_Authentication (DAU) (5690)

DB_Comment (DCO) (5696)

DB_Communication_Protocol (5699)

DB_Database_Locator_Name (5705)

DB_Database_Protocol (5702)

DB_Native_Database_Name (5708)

DB_Object_Type (5711)

DB_Principal (DPR) (5693)

DB_Product_Name (5714)

DB_Product_Release (5717)

DB_Target_Database_Info (5720)

objectname configuration parameter (5531)

occurrence

definition of (3641)

offline archived logs

definition (4398)

ROLLFORWARD command support (4399), (4401)

versus active logs (4396)

where stored (4403)

one-to-many relationships (3652)

one-to-one relationships (3655)

online archived logs

ROLLFORWARD command support

optimization class

guidelines (4788)

levels of (4783)

setting (4784)

OPTIMIZE FOR clause (4794), (4807)

optimizer (4936), (4940) See also database access, database access

adjusting amount of optimization (4782)

affect of statistics (4861)

creating access plan (4916)

distribution statistics impact (4894)

selecting optimal join (4993)

sorting (5021)

ORG sample table (5780)

outer versus inner table determination

merge join (4990)

nested loop join (4986)

overview of (4985)

outer-table join, method (5008)

package

access privileges with SQL (4216)

dependencies (4095)

dropping (4092)

inoperative (4097)

invalid after adding foreign key (4058)

isolation levels, specifying (4683)

privileges (4193)

revoking privileges (4211)

page cleaners (5105)

page cleaners configuration parameter

managing the buffer pool (5106)

parallel operations

configuration parameters (5549)

parallelism in DB2, overview (3592)

parallelism, intra-partition (3859)

parent row

definition (3703)

parent table

definition (3701)

partition compatibility See partitioning data

partitioned database (3599)

configuration parameters (5548)

partitioned database environment

decorrelation of a query (4932)

partitioning data (3860)

AutoLoader tool (5998)

data distribution, specifying (5224)

data redistribution across database partitions (5242)

data redistribution in tables (5246)

data redistribution, error recovery (5252)

db2split, running (5993)

designing your physical database (3774)

partition compatibility (3787)

partitioning key and partitioning map interaction (3778)

partitioning keys, designing your physical database (3785)

partitioning map, definition (3782)

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

partitioning key

changing (4074)

data hashing (3779)

index partitioned on partitioning key (4014)

table considerations (3977)

partitioning keys (4285)

partitioning map

definition (3775)

example (3781)

getting with db2gpmap tool (5986)

purpose (3776)

redistributing data (5225)

target, specifying during data redistribution (5237)

partitions with multiple processors (3630)

partitions with one processor (3627)

PC/IXF file format (4359)

code page considerations (4349)

overview of (4346)

rules for (4347)

use with DB2 for Universal Database products (4351)

pckcachesz configuration parameter (5330)

pending states (4259)

performance

application considerations (4677)

catalog information, reducing contention for (3865)

configuration parameters (5293)

considerations for ROLLFORWARD command (4426)

data distribution, determining using SQL (5227)

database caching (4823)

database managed storage (DMS) (5158)

db2batch benchmarking tool (5286)

environmental consideration (4834)

governor affect on database manager (5215)

locks, effect of (4738)

num_ioservers configuration parameter (5129)

operational considerations (5071)

optimization class, adjusting (4780)

programming considerations (4678)

query rewrite by compiler (4923)

redistributing data (5218)

row blocking, guidelines (4800)

RUNSTATS utility (4872)

statistics (4859)

table collocation, data redistribution (5222)

tuning using explain (5065)

using explain facility (5033)

Performance Configuration SmartGuide (3882)

performance monitor

using (5181)

piped versus non-piped sorts

overview of (5023)

point of recovery (4406)

point-in-time monitoring (5187)

pool size for agents, controlling (5423)

precompiling

isolation level, specifying (4707)

predicate (4964), (4965) See also predicate terminology, predicate category

adding by optimizer (4934)

definition of (4946)

distribution statistics (4895)

inclusive inequality (4950)

strict inequality (4949)

translation by optimizer (4933)

when applied (4929)

predicate category

index SARGable predicate (4967)

overview of (4963)

range delimiting predicate (4966)

residual predicate (4973)

SARGable predicate (4971)

usage (4975)

predicate terminology

overview of (4962)

prefetch (5069), (5123) See also sequential detection

buffer pool (5112)

clustering page reads (4959)

data page (5113)

I/O servers (5127)

index page (5114)

intra-partition parallelism (5126)

list prefetch (5125)

PREFETCHSIZE clause (5118)

sequential (5115)

sequential detection (5122)

tuning using database system monitor (5120)

prefix sequences (6018)

primary index

definition of (3672)

dropping (4089)

uniqueness for primary key (3948)

primary key

adding (4052)

composite key (3674)

criteria for choosing (3676)

definition of (3671), (3695)

DROP PRIMARY KEY clause, ALTER TABLE statement (4063)

primary index (3947)

primary index, creating (4010)

privileges required for dropping (4064)

UPDATE, referential integrity implications for (3730)

when to create (3950)

PRIMARY KEY clause

adding primary key (4054)

restrictions (3946)

privileges

ALTER (4182)

BINDADD (4162)

CONNECT (4163)

CONTROL (4179)

create view for information (4247)

CREATE_NOT_FENCED (4165)

CREATETAB (4164)

database manager (4161)

definition of (4140)

DELETE (4183)

GRANT statement (4204)

granting and revoking authority (4160)

hierarchy (4145)

implicit for packages (4148)

IMPLICIT_SCHEMA (4166)

INDEX (4198)

individual (4147)

INSERT (4185)

ownership (CONTROL) (4146)

package (4194)

PUBLIC (4174)

REFERENCES (4188)

required for EXPORT utility (4312)

required for IMPORT utility (4296)

required for REORG utility (5157)

retrieving authorization names with (4233)

retrieving for names (4242)

REVOKE statement (4207)

schema (4176)

SELECT (4190)

summary of (4144)

system catalog listing (4230)

table (4177)

tasks and required authorities (4228)

view (4178)

priv_mem_thresh configuration parameter (5360)

problem determination

XA interface (4673)

process, DB2 (5168)

processors, adding to a machine (5263)

profile registry (3873)

PROJECT sample table (5781)

PUBLIC

privileges (4173)

quantile value statistics

number to collect (4893)

overview of (4889)

range statistics (4897)

rules for updating (4905)

query optimizer (4915) See also optimizer

query parallelism (3610)

query rewrite See also compiler

overview of (4921)

query_heap_sz configuration parameter (5355)

impact on memory (5094)

quickly retrieve first few rows (4792)

RACF (5724)

rah (6008)

RAHDOTFILES (6025)

RAHOSTFILE (6020)

RAHOSTLIST (6021)

RAHWAITTIME (6017)

range delimiting predicate

index SARGable predicate (4969)

overview of (4968), (4970)

raw devices (3927)

read locks (4778)

read only cursors

uncommitted read (4701)

read stability, overview (4689)

reading

read stability, overview of (4688)

repeatable read, overview of (4684)

uncommitted read, overview of (4699)

recoverable databases (4386)

recovery

allocating log during database creation (3904)

configuration parameters (5466)

consistent database (4446)

crash (4444)

definition of (4370)

factors affecting (4385)

history file (4552)

overview of (4369)

performance (4427)

point of (4407)

point-in-time (4584)

reducing logging on work tables (4405)

restore (4488)

roll-forward (4553)

storage required (4413)

time required (4411)

two-phase commit protocol (4459)

recovery history file (4551)

recovery log (3903)

rec_his_retentn configuration parameter (5474)

redistributing data

across nodes (4032)

connection to catalog database partition (5241)

data distribution, determining using SQL (5228)

database partition, process overview (5240)

database partitions, adding (5232)

database partitions, dropping (5231)

distribution file (5226)

distribution, specifying (5223)

error recovery (5250)

log file (5253)

operation successful (5248)

operation unsuccessful (5249)

other operations during redistribution (5256)

partitioning map, target, specifying (5238)

purpose (5219)

table collocation (5221)

table, process overview (5245)

reducing logging on work tables (4404)

REFERENCES clause

adding foreign key (4055)

delete rules (3965)

referential constraints (3963)

use of (3964)

REFERENCES privilege, definition (4189)

referential constraints (3712) See also referential integrity

add to table (4050)

defining (3951)

definition of (3710)

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

overview of (3692)

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

REFERENCES clause, CREATE/ALTER TABLE statements (3954)

referential integrity (3711) See also referential constraints

definition of (3691)

DELETE rules (3721)

INSERT rules (3716)

overview of (3693)

relation scan

definition of (4937)

when used (4960)

relationship

many-to-many (3654)

many-to-one (3650)

one-to-many (3649)

one-to-one (3656)

types of (3648)

release configuration parameter (5490)

release to release incompatibilities

description (5656)

remote data services

node name (nname) parameter (5524)

remote filename

qualifying (4272)

remote procedure calls (4822) See also stored procedures

remote unit of work

overview of (4615)

REORG utility

authority and privileges required (5155)

binding to a database (3910)

overview of (5150)

REORGCHK command (5154)

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

residual predicate

overview of (4974)

resource access control facility (RACF) (5726)

RESTART DATABASE command (4449)

restbufsz configuration parameter (5326)

restore

buffer(s) (4536)

database (4378)

existing database (4547)

invoking (4533)

new database (4550)

planning (4530)

redirected (4545)

table space (4382)

RESTORE command

access errors, error handling (4515), (4540)

authority required (4501), (4531)

buffer (4510), (4537)

code page restriction (4543)

concurrency control (4513)

considerations for (4493), (4529)

database alias restriction (4507), (4534)

disk output created (4521)

overview of (4492), (4526)

system crash (4511)

tape output created (4522)

use in roll-forward recovery (4539)

use with ADSTAR Distributed Storage Manager (4585)

RESTORE DATABASE utility

considerations for user exit program (5887)

default restore buffer size (restbufsz) parameter (5325)

error handling for user exits (5893)

user exit program for OS/2 (5844)

restore recovery (4489)

overview of (4376)

restore_pending configuration parameter (5514)

restoring a database

overview of (4524)

RESTORE command (4525), (4528)

restoring database

catalog node considerations (4435)

database partition synchronization (4440)

log disk, considerations for media recovery (4430)

node synchronization (4439)

recovering failed database partition server (4482)

reducing impact of media failure (4429)

timestamp considerations (4441)

transaction recovery on the failed database partition server (4469)

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

transaction recovery, overview (4450)

RESTRICT

delete rule, overview of (3723)

restrictions on import and export (4360)

resync_interval configuration parameter

DB2 transaction manager considerations (4628)

resync_interval configuration parameter (5482)

retrieve first few rows quickly (4791)

retrieve log files

for OS/2 (5847)

for UNIX-based systems (5852)

retrieving data

index (4016)

REVOKE statement

example of (4209)

implicit issuance (4214)

security (5728)

use of (4208)

REXX

isolation level, specifying (4708)

roll-forward recovery (4554)

authority required (4570)

invoking (4572)

long space requirements (3770)

overview of (4379)

planning (4569)

rolling forward table space (4568)

table space (4384)

ROLLFORWARD command

configuration file parameters support (4556)

log management considerations (4576)

performance considerations (4425)

timestamps (4573)

ROLLFORWARD DATABASE utility

roll forward pending (rollfwd_pending) parameter (5508)

rollfwd_pending configuration parameter (5509)

route_obj_name configuration parameter (5538)

routing information objects

creating (5685)

example (5686)

row (4796) See also row blocking

blocking (4795)

delete from parent table (3715)

deleting related rows (3725)

dependent (3706)

lock compatibility, ensuring (4743)

locking (4685), (4691), (4695)

occurrence (3642)

parent (3702)

partitioning key and partitioning map determine location (3784)

read stability (4690)

types of locks on (4729)

row blocking

types of (4799)

overview of (4797)

row identifier (RID) (5928)

rqrioblk configuration parameter (5369)

impact on memory (5095)

running commands in parallel (6012)

RUNSTATS CMD/API

node where execution occurs (4866)

RUNSTATS utility

for reorganization (4869)

use of (4863)

use of in a partitioned database environment (4865)

with distribution clause (4886)

SALES sample table (5782)

sample database

erasing (5771)

installing (5770)

sample tables (5768), (5785)

sample user exit programs

for OS/2 (5860)

for UNIX-based systems (5868)

overview (5858)

SARGable predicate

overview of (4972)

scalar UDF (3987)

scaling a configuration (5260)

schema

creating (3930)

dropping (4042)

naming rules (5663)

overview of (3857)

security

authentication (4104)

authorization (4105)

CLIENT level (4120)

Distributed Computing Environment (DCE) directory services (5721)

overview of (4103)

planning for (4102)

SELECT privilege, definition (4191)

SELECT statement

referential integrity implications for (3718)

select a view (3996)

select-statement

eliminating DISTINCT clause (4928)

for two or more tables (4811)

guidelines for using (4806)

query rewrite by compiler (4922)

use of (4805)

seqdetect configuration parameter (5393)

understanding sequential detection (5124)

sequential detection (5070)

overview of (5121)

SERVER, authentication type (4112)

SET CURRENT EXPLAIN MODE statement

use of (5057)

SET CURRENT EXPLAIN SNAPSHOT statement

use of (5063)

SET CURRENT QUERY OPTIMIZATION statement

use of (4787)

SET NULL delete rule

overview of (3726)

share mode

reasons for using (4774)

sheapthres configuration parameter (5347)

avoiding post-threshold sorts (5146)

shift-out and shift-in characters (4364)

single partition, multiple processors environment (3624)

single partition, single processor environment (3621)

single-partition database (3597)

SmartGuide

Performance Configuration (3883)

SMP cluster environment (3631)

SMP environment (3625)

SMS table space

advantages (3843)

containers (3808)

creating (3919)

design factors (3810)

multiple containers (3815)

overview (3805)

physical files (3816)

SYSCATSPACE (3795)

TEMPSPACE1 table space (3801)

USERSPACE1 (3798)

snapshot, point-in-time monitoring (5188)

softmax configuration parameter (5460)

managing the buffer pool (5107)

sortheap configuration parameter (5344)

affect on query optimization (4839)

avoiding post-threshold sorts (5145)

impact on memory (5091)

sorting

configuration parameters (5137)

managing performance (5147)

non-overflowed (5139)

non-piped (5141)

overflowed (5140)

parameters affecting (5143)

performance problems (5144)

piped (5142)

piped versus non-piped sorts (5022)

sort heap size (sortheap) parameter (5342)

sort heap threshold (sheapthres) parameter (5345)

specifying collating sequence (5957)

specifying collating sequences (5963)

steps (5138)

sparse file allocation (3942)

specifying list of hosts (6019)

splitting phase (4286)

spm_log_file_sz configuration parameter

DB2 transaction manager considerations (4629)

spm_max_resync configuration parameter

DB2 transaction manager considerations (4630)

spm_name configuration parameter

DB2 transaction manager considerations (4627)

spm_log_file_sz configuration parameter (5484)

spm_max_resync configuration parameter (5485)

spm_name configuration parameter (5483)

SQL (4803) See also SQL statements

SQL functions

NODENUMBER, data distribution, determining (5230)

PARTITION, data distribution, determining (5229)

SQL statements

benchmarking (5282)

inoperative (4098)

select-statement (4804)

statement heap size (stmtheap) parameter (5349)

tuning queries (4801)

valid during data redistribution (5259)

SQL00001

example of database subdirectory (3739)

SQLBP.1 database file (3750)

SQLBP.2 database file (3751)

SQLDBCON database file (3742)

SQLINSLKdatabase file (3746)

SQLOGCTL.LFH database file (3744)

SQLQMF utility, replaced (4366)

SQLSPCS.1 database file (3748)

SQLSPCS.2 database file (3749)

SQLTAG.NAM (3818)

SQLTMPLK database file (3747)

sqluback

support (4504), (4544)

ss_logon configuration parameter (5641)

STAFF sample table (5783)

STAFFG sample table (5784)

standards

X/Open XA interface (5762)

star schema (4998)

start

timeout for command, setting (5599)

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

start_stop_time database manager configuration parameter (5603)

starting DB2 (3848)

states

backup pending (4260)

check pending (4261)

delete pending (4262)

load pending (4263)

static SQL

distribution statistics (4890)

evaluating optimization class (4790)

EXECUTE privilege for database access (4218)

explain facility (5054), (5058)

setting optimization class (4785)

statistics

copying from production (4911)

distribution (4883)

distribution, how computed (4887)

frequent value (4884)

index clustering (4958)

modelling data (4910)

overview of (4858)

quantiles (4885)

rules for updating (4900), (4901), (4902), (4903)

RUNSTATS utility (4862)

RUNSTATS utility in a partitioned database environment (4864)

updating (4898), (5830), (5832), (5838)

user-defined functions (UDF) (4907)

when to collect (4873)

stat_heap_sz configuration parameter (5354)

impact on memory (5093)

stmtheap configuration parameter (5350)

affect on query optimization (4843)

impact on memory (5092)

stop

timeout for command, setting (5600)

stopping DB2 (3849)

storage (5072) See also memory

effect of locks on (4740)

for backup (4414)

for recovery (4416)

media failure considerations (4417)

stored procedures

configuration parameters (5430)

performance impact (4819)

Structured Query Language (SQL)

referential integrity implications for (3714)

subagent (5173)

svcename configuration parameter (5527)

Sync Point Manager (SPM) (4648)

synonym (DB2 for MVS/ESA) (4006)

sysadm_group configuration parameter (5635)

SYSCAT views (4231)

SYSCATSPACE table space (3796), (3891)

sysctrl_group configuration parameter (5636)

sysmaint_group configuration parameter (5637)

system administration (SYSADM) authority (4149)

overview (4152)

privileges (4153)

system catalog (5788) See also catalog views

adding new column (4044)

dropping a table (4072)

dropping view implications (4084)

estimating initial size (3754)

privileges listing (4229)

retrieving authorization names with privileges (4232)

retrieving names with DBADM authority (4235)

retrieving names with table access authority (4238)

retrieving privileges granted to names (4241)

RUNSTATS utility (4874)

security (4244)

setting up (3895)

statistics (4860)

table space used (3794)

system catalog table

stored on database catalog node (3864)

system database directory

overview of (3899), (3901)

system log facility

XA interface example (4674)

XA interface use of (4672)

system managed storage (3807) See also SMS table space

system management

configuration parameters (5621)

memory considerations (5075)

table (5766)

add referential constraints (4051)

ALTER TABLE statement (4046)

assigning to nodegroup (3917)

catalog views on system tables (5787)

changing partitioning key (4075)

check pending after load (4267)

CREATE TABLE statement (3932)

creating (3976)

data redistribution, process (5247)

default table space (3797)

defining check constraint (3971)

defining referential constraints (3955)

defining unique constraint (3945)

defining, for a relationship (3647), (3657)

delete connected (3727)

dependent (3704)

descendent (3708)

determining where RUNSTATS execution occurs (4868)

dropping (4071)

estimating size (3756)

joining (4978)

lock compatibility, ensuring (4744)

lock mode (4767)

locking (4772)

naming (3933)

naming rules (5665)

normalizing (3682)

parent (3700)

partitioning map (3783)

populating in existing table space (5980)

populating in new table space (5978)

redistribution, error recovery (5251)

referential cycle (3709)

renaming (4070)

REORG utility (5149)

reorganizing (5148)

REORGCHK command (5152)

retrieving names with access to (4239)

revoking privileges (4210)

sample (5767)

scan, affect on locks (4765)

self-referencing (3713)

table space considerations (3836)

temporary (3894)

temporary table space (3800)

two or more, select-statement (4812)

types of locks on (4719), (4730)

understanding page use (3755)

table check constraint

adding (4059)

defining (3970)

dropping (4068)

table check constraints

overview of (3732)

table collocation (3786)

table queues (5020)

table scan (4938) See also relation scan

table space (3806), (3821) See also SMS table space, DMS table space

adding container (4037)

administration considerations (3837)

changing (4035)

changing temporary (4041)

creating (3918)

database managed space (DMS) (3823)

definition of (3789)

designing (3832)

device container example (3924)

dropping (4039)

extents (3792)

file container example (3922)

file system container example (3921)

in nodegroups (3929)

index (4856)

load pending state (4265)

mapping to buffer pools (3833)

mapping to nodegroups (3835)

minimum space required (3840)

naming rules (5672)

overhead, setting (4847)

overview of (3788)

recommendations for temporary table spaces (3841)

restoring to an existing database (4549)

separating types of data, example (3974)

system managed space (SMS) (3804)

TRANSFERRATE, setting (4848)

types of locks on (4731)

workload considerations (3842)

table space configuration parameter

affect on query optimization (4846)

table space containers

redefining (4546)

table space restore

overview of (4381)

table space roll-forward recovery

overview of (4383)

table UDF (3990)

TAKEN AT parameter (4538)

tape system

backup considerations (4505)

temporary table space

guidelines for (3803)

TEMPSPACE1 (3802)

TEMPSPACE1 table space (3893)

territory configuration parameter (5493)

thread, DB2 (5169)

time

definition of (5967)

formats (5974)

time difference among nodes, maximum (5594)

time required for database recovery (4412)

time strings

definition of (5971)

timeout, starting and stopping database manager (5605)

timestamp

definition of (5968)

for logs (4581)

timestamp strings

definition of (5972)

tm_database configuration parameter

DB2 transaction manager considerations (4626)

XA interface considerations (4667)

tm_database configuration parameter (5481)

rules for setting (4624)

tokens (5178)

tp_mon_name configuration parameter

XA interface considerations (4665)

tpname configuration parameter (5529)

XA interface considerations (4666)

tp_mon_name configuration parameter (5627)

transaction (4456), (4610) See also unit of work

database connection considerations (4656)

failure recovery on a failed database partition server (4479)

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

failure recovery, overview (4457)

global (5752)

loosely coupled (5754)

non-XA (5751)

recovering failed database partition server (4487)

tightly coupled (5755)

two-phase commit (5753)

using XA interface (4651)

transaction failure

on the failed database partition server (4468)

recovering failed database partition server (4481)

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

part of database manager (4622)

specify database (4623)

transaction processing

using Encina (4675)

transaction recovery on coordinator node (4461)

transferring data (4314) See also data transfer

trigger

benefits of (3981)

creating (3980)

dependencies (3983)

dropping (4077)

Explain tables (5895)

naming rules (5670)

overview of (3733)

triggering crash recovery with DB2START (4476)

trusted clients

authentication (4121), (4123)

CLIENT level security (4116)

trust_allclnts configuration parameter (5642)

trust_clntauth configuration parameter (5643)

tuning queries

SQL statements (4802)

two-phase commit

error handling (4636)

overview of (4633)

setting up your environment (4619)

two-phase commit protocol (4458)

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

udf_mem_sz configuration parameter (5357)

impact on memory (5097)

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

uniprocessor environment (3622)

unique constraint

adding (4048)

defining (3943), (3944)

dropping (4061)

unique constraints (3690)

unique key (3694)

unit of work (4608)

COMMIT statement (4612)

definition of (4611)

ROLLBACK statement (4613)

using multiple databases (4616)

using one database (4614)

untrusted clients (4119), (4125)

updatable cursor

uncommitted read (4700)

UPDATE privilege, definition (4192)

UPDATE rules

referential integrity implications (3728)

UPDATE statement

rules for referential integrity implications (3729)

updating statistics (5829), (5831), (5837)

user exit program

archive and retrieve considerations (5881)

BACKUP DATABASE utility (5882)

backup storage (4423)

error handling (5888)

logs storage (4421)

overview (5839)

RESTORE DATABASE utility (5883)

user exits for OS/2

archive considerations (5877)

archiving log files (5845)

BACKUP DATABASE considerations (5884)

BACKUP DATABASE utility (5841)

calling format (5873)

db2uexit (5856)

db2uexit.CAD (5866)

db2uexit.ex1 (5861)

db2uexit.ex2 (5863)

db2uexit.ex3 (5864)

db2uexit.ex4 (5865)

error handling (5891)

invoking (5854)

overview (5840)

RESTORE DATABASE considerations (5885)

RESTORE DATABASE utility (5843)

retrieve considerations (5878)

retrieving log files (5846)

sample user exit programs (5859)

user exits for UNIX-based systems

archive considerations (5879)

archiving log files (5851)

calling format (5875)

db2uexit (5857)

db2uexit.cadsm (5870)

db2uexit.cdisk (5872)

db2uexit.ctape (5871)

error handling (5890)

invoking (5855)

overview (5849)

retrieve considerations (5880)

retrieving log files (5850)

sample user exit programs (5869)

user-defined distinct type

column definition (3661)

user-defined distinct type (UDT)

creating (3991)

dropping (4079)

naming rules (5673)

user-defined functions (UDF)

creating (3984)

dropping (4078)

naming rules (5669)

privilege to create non-fenced (4170)

types (3986)

updating statistics (4906)

userexit configuration parameter (4567), (5464)

USERSPACE1 table space (3799), (3892)

user_exit_status configuration parameter (5513)

utilities

export (4355)

import (4354)

reorganization (5151)

reorganization check (5153)

utility parallelism (3618)

util_heap_sz configuration parameter (5322)

impact on memory (5087)

variable-length character columns (4365)

version control (4375)

view

access control to table (4223)

access privileges, examples of (4226)

changing (4080)

CHECK OPTION clause, CREATE VIEW statement (3997)

column access (4224)

creating (3993)

data integrity (4000)

data security (3994)

dropping implications for system catalogs (4082)

for privileges information (4246)

inoperative (4085)

merging by optimizer (4924)

migration of (5652)

modification of (3999)

naming rules (5666)

predicate pushdown by optimizer (4930)

restrictions (4081)

row access (4225)

virtual telecommunications access method (VTAM) (5725)

Visual Explain (5027), (5066)

VTAM (5723)

weight, definition of (5952)

Windows 95 code pages (5938)

DB2CODEPAGE environment variable (5941)

supported code pages (5942)

Windows NT code pages (5937)

DB2CODEPAGE environment variable (5939)

supported code pages (5940)

work space, estimating size (3771)

WSF file format

code page considerations (4340)

conventions for (4337)

exporting, loss of data (4338)

operating system differences (4353)

overview of (4336)

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

application program (AP) overview (5750)

database configuration considerations (4664)

database connection considerations (4658)

problem determination (4670)

registration of resource manager (5760)

resource managers (RM) (5759)

security considerations (4662)

support for DRDA host databases (4655)

supported function limitations (5761)

transaction manager (TM) overview (5756)

XA close string (5765)

XA open string (4653), (5764)

XA switch usage (5763)

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

[ DB2 List of Books | Search the DB2 Books ]