IBM Books

Administration Guide

Index

Special Characters
A B C D E F G H I J K L M N O P Q R S T U V W X Z
Special Characters
  • $RAHBUFDIR (8583)
  • $RAHBUFNAME (8584)
  • $RAHCHECKBUF (8585)
  • $RAHENV (8594)
    • A
  • access control (5919)
  • authentication (5920)
  • concurrency, overview (6762)
  • database manager (6046)
  • database objects (6043)
  • using locks (6791)
  • view to table (6070)
  • XA interface considerations (6507)
  • access path
  • lock attributes, factors affecting (6850)
  • access path selection (6880)
  • access plan
  • cost estimate (7231)
  • created by compiler (7045)
  • db2expln (7213)
  • graphical representation (7221)
  • objects (7222)
  • operators (7224)
  • using explain facility (7216)
  • Visual Explain (7252)
  • ACTIVATE DATABASE command (7361)
  • activating a database (6922)
  • active logs
  • definition (6166)
  • definition of (6172)
  • versus archive logs (6173)
  • adding a scope (5756)
  • adding constraint (5762)
  • adding DB2 for OS/390 subsystems (5877)
  • adding node to system
  • restrictions on database operations (7420)
  • when redistributing nodegroup (7456)
  • adding space to a table space (5899)
  • adding table check constraint (5775)
  • adding unique constraint (5763)
  • Administering Satellites Guide and Reference (7904)
  • administration client (5858)
  • Administration Guide (7884)
  • Administration Server (5874)
  • administration tools
  • Command Center (5881)
  • overview (5857)
  • Script Center (5883)
  • administration using GUI tools (5856)
  • Administrative API Reference (7885)
  • adsm_mgmtclass configuration parameter (7687)
  • adsm_nodename configuration parameter (7689)
  • adsm_owner configuration parameter (7690)
  • adsm_password configuration parameter (7688)
  • ADSTAR Distributed Storage Manager (ADSM)
  • backup restrictions (6438)
  • client set up (on Intel) (6427)
  • client set up (UNIX-based platforms) (6421)
  • configuration parameters (7677)
  • environment variables (on Intel) (6428)
  • environment variables (UNIX-based platforms) (6422)
  • managing backups and log archives (6439)
  • setting password (on Intel) (6434)
  • setting password (UNIX-based platforms) (6426)
  • system options file (on Intel) (6432)
  • timeout problem resolution (6437)
  • use with BACKUP command (6419)
  • use with RESTORE command (6420)
  • user options file (on Intel) (6433)
  • using (6435)
  • ADVISE_INDEX table (8481)
  • ADVISE_INDEX table definition (8490)
  • ADVISE_WORKLOAD table (8482)
  • ADVISE_WORKLOAD table definition (8491)
  • advisor
  • index (7255)
  • agent (7369)
  • agent pool (7373)
  • agent pool size (num_poolagents) database manager parameter (7627)
  • agent process
  • application heap size (applheapsz) parameter (7558)
  • application support layer heap size (aslheapsz) parameter (7570)
  • maximum number of agents (maxagents) parameter (7617)
  • maximum number of concurrent agents (maxcagents) parameter (7615)
  • priority of agents (agentpri) parameter (7613)
  • agentpri configuration parameter (7614)
  • agents
  • application control heap size, maximum (7540)
  • connection entries, number (7803)
  • governor changes priority of (7403)
  • initial number of agents in pool (num_initagents) database manager parameter (7633)
  • maximum number of coordinating (7620)
  • max_coordagents database manager parameter (7621)
  • pool size, controlling (7628)
  • agent_stack_sz configuration parameter (7563)
  • impact on memory (7286)
  • aggregating function (5624)
  • alias
  • authority (5660)
  • naming rules (7993)
  • using (5658)
  • alias (DB2 for MVS/ESA) (5661)
  • alias, creating (5655)
  • allow reverse scans (7075), (7087)
  • ALTER COLUMN (5758)
  • ALTER NICKNAME statement, example of (5840)
  • ALTER privilege, definition (6020)
  • ALTER SERVER statement, example of (5836)
  • ALTER TABLE statement
  • adding check constraint example (5777)
  • adding columns example (5750)
  • adding keys example (5772)
  • adding unique constraint example (5765)
  • dropping check constraint example (5790)
  • dropping keys example (5787)
  • dropping unique constraint example (5782)
  • tips for adding constraints (5773)
  • ALTER TABLESPACE statement
  • example of (5737), (6946)
  • altering a column (5753)
  • altering a nickname (5838)
  • altering a server (5834)
  • altering a structured type (5800)
  • altering a table (5745)
  • altering constraint (5760)
  • altering nodegroup (5726)
  • altering table space (5734)
  • altering view (5822)
  • APPC, CPI-C and SNA Sense Codes (7887)
  • applheapsz configuration parameter (7557)
  • impact on memory (7279)
  • Application Building Guide (7886)
  • application control heap
  • application control heap size (app_ctl_heap_sz) database parameter (7538)
  • application control heap size (app_ctl_heap_sz) databaseparameter (7539)
  • application design
  • acquiring locks (6793)
  • collating sequences, guidelines (8560)
  • deadlock, avoiding (6845)
  • lock compatibility, ensuring (6829)
  • lock escalation (6836)
  • locking considerations (6866)
  • locks, converting of (6834)
  • locks, factors affecting (6848)
  • overriding locks (6858)
  • Application Development Guide (7888)
  • application program (6237)
  • control heap, setting (7543)
  • database partition server failure detection (6268)
  • governor forces (7402)
  • maximum number of coordinating agents at node (7625)
  • transaction recovery on the failed database partition server (6255)
  • transaction recovery when the database partition server is active (6248)
  • transaction recovery, overview (6238)
  • app_ctl_heap_sz configuration parameter
  • impact on memory (7278)
  • app_ctl_heap_sz database parameter (7541)
  • archive log files
  • for OS/2 (8424)
  • for UNIX-based systems (8429)
  • archive logs
  • definition (6167)
  • ROLLFORWARD command support (6168), (6170)
  • versus active logs (6174)
  • where stored (6175)
  • aslheapsz configuration parameter (7572)
  • impact on memory (7287)
  • ATTACH command
  • overview of (5404)
  • specifying Distributed Computing Environment (DCE) information (8291)
  • attribute
  • definition of (5147)
  • attributes (5173)
  • audit activities (6099)
  • audit facility
  • actions (6105)
  • asynchronous record writing (6111)
  • audit events table (6120)
  • authorities/privileges (6104)
  • behavior (6107)
  • checking events table (6121)
  • CONTEXT events table (6126)
  • controlling activities (6128)
  • error handling (6109)
  • ERRORTYPE parameter (6112)
  • events (6106)
  • examples (6129)
  • messages (6117)
  • OBJMAINT events table (6122)
  • parameter descriptions (6116)
  • record layouts (6119)
  • SECMAINT events table (6123)
  • synchronous record writing (6110)
  • syntax (6114)
  • SYSADMIN events table (6124)
  • tips and techniques (6127)
  • usage scenarios (6113)
  • VALIDATE events table (6125)
  • AUDIT_BUF_SZ (6108)
  • audit_buf_sz configuration parameter (7580)
  • authentication (5917)
  • DCE security services (5950)
  • definition of (5921)
  • Distributed Computing Environment (DCE) directory services (8276)
  • distributed transaction processing considerations (6496)
  • federated database processing (5959)
  • partitioned database considerations (5949)
  • remote client (5948)
  • authentication configuration parameter (7873)
  • authentication type (5918)
  • CLIENT (5926)
  • DCE (5944)
  • DCE_SERVER_ENCRYPT (5946)
  • DCS (5940)
  • DCS_ENCRYPT (5942)
  • SERVER (5922)
  • SERVER_ENCRYPT (5924)
  • authority (5989)
  • configuration parameters (7869)
  • database administration (DBADM) (5997), (6014)
  • levels of (5982)
  • removing DBADM from SYSADM (5993)
  • removing DBADM from SYSCTRL (5995)
  • required for BACKUP command (6284)
  • required for REORG utility (7348)
  • required for RESTORE command (6316)
  • required for ROLLFORWARD command (6358)
  • system control (SYSCTRL) (5994)
  • system maintenance (SYSMAINT) (5996)
  • tasks and required authorities (6077)
  • authorization (5981) See also authority
  • choosing for database access (5266)
  • definition (5980)
  • system administration (SYSADM) (5990)
  • trusted client (5937)
  • authorization names
  • create view for privileges information (6098)
  • retrieving for privileges information (6084)
  • retrieving names with DBADM authority (6087)
  • retrieving names with table access authority (6090)
  • retrieving privileges granted to (6093)
  • automatic restart (6230)
  • AUTORESTART (6144)
  • autorestart database configuration parameter (6487), (7679)
  • DB2 transaction manager considerations (6474)
  • XA interface considerations (6513)
  • avg_appls configuration parameter (7609)
  • affect on query optimization (6935)
    • B
  • backbufsz configuration parameter (7529)
  • backing up database
  • fixed-disk media (6307)
  • backup (6274) See also BACKUP command
  • buffer for (6293)
  • container names (6303)
  • frequency (6180)
  • images (6301)
  • invoking (6290)
  • offline (6182)
  • online (6181)
  • planning (6281)
  • planning your strategy (6282)
  • quiesce (6285)
  • storage considerations (6187)
  • user exit program (6194)
  • BACKUP command
  • access errors, error handling (6299)
  • authority required (6283)
  • buffer (6294)
  • concurrency control (6297)
  • considerations for (6276)
  • database alias restriction (6291)
  • DB2 Data Links Manager considerations (6389)
  • disk output created (6305)
  • overview of (6275)
  • system crash (6295), (6337)
  • tape output created (6306)
  • use with ADSTAR Distributed Storage Manager (6418)
  • Backup Database SmartGuide (5860)
  • BACKUP DATABASE utility
  • considerations for user exit program (8463)
  • default backup buffer size (backbufsz) parameter (7528)
  • error handling for user exits (8471)
  • user exit program for OS/2 (8418)
  • backup domain controller
  • configuring DB2 to use (8598)
  • backups
  • active (6378)
  • expired (6380)
  • inactive (6379)
  • log chain (6384)
  • log sequence (6382)
  • backup_pending configuration parameter (7732)
  • benchmark program
  • creating (7488)
  • sample report (7493)
  • SQL statements (7486)
  • step summary (7494)
  • benchmarking
  • db2batch tool (7489)
  • overview of (7483)
  • preparations for (7485)
  • testing methods (7484)
  • testing process (7492)
  • bidirectional CCSID support (8535)
  • CCSID table (8536)
  • DB2 Connect implementation (8538)
  • DB2 UDB implementation (8537)
  • BIND command
  • OWNER option (6059)
  • BIND privilege
  • definition of (6039)
  • BINDADD privilege, definition (6007)
  • binding
  • changing configuration parameters (7509)
  • command line processor (5521)
  • database utilities (5522)
  • default for DEGREE option (6929)
  • isolation level, specifying (6787)
  • rebinding invalid packages (6055)
  • BLOB (5295) See also large objects
  • block fetch (6890) See also row blocking
  • block-structured devices (5540)
  • broadcast inner-table joins (7159)
  • broadcast outer table joins (7151)
  • buffer pool
  • binding database applications (7519)
  • choosing number of (7302)
  • consideration for outer versus inner table determination (7131)
  • database managed storage (DMS) (7356)
  • larger page size and storage requirements (5375)
  • mapping table space to (5374)
  • memory required (7300)
  • multiple (7298)
  • overview of (7292)
  • performance considerations (7520)
  • sizing using buffpage configuration parameter (7517)
  • storage considerations (7521)
  • buffpage configuration parameter (7518)
  • affect on query optimization (6932)
  • impact on memory (7271)
  • managing multiple buffer pools (7299)
    • C
  • caching of database (6921)
  • call level interface
  • binding to a database (5526)
  • calling format for user exits
  • for OS/2 (8451)
  • for UNIX-based systems (8453)
  • candidate keys
  • identifying (5202)
  • capacity management configuration parameters (7514)
  • Cartesian products (7139)
  • star schema (7140)
  • CASCADE delete rule
  • overview of (5251)
  • cascading assignment (6593)
  • case sensitive names, federated database (7999)
  • CATALOG DATABASE
  • example of (5529)
  • CATALOG GLOBAL DATABASE command
  • specifying Distributed Computing Environment (DCE) information (8289)
  • catalog node (6209)
  • connection for data redistribution (7467)
  • description (5416)
  • importance for recovery (6210)
  • catalog views (5333), (8338) See also system catalog, system catalog
  • BUFFERPOOLNODES (8343)
  • BUFFERPOOLS (8344)
  • CASTFUNCTIONS (8345)
  • CHECKS (8346)
  • COLAUTH (8347)
  • COLCHECKS (8348)
  • COLDIST (7011), (8349)
  • COLOPTIONS (8350)
  • COLUMNS (7007), (8351)
  • CONSTDEP (8352)
  • DATATYPES (8353)
  • DBAUTH (8354)
  • EVENTMONITORS (8355)
  • EVENTS (8356)
  • FUNCDEP (8358)
  • FUNCMAPOPTIONS (8359)
  • FUNCMAPPARMOPTIONS (8360)
  • FUNCMAPPINGS (8361)
  • FUNCPARMS (8362)
  • FUNCTIONS (8363)
  • functions (7037)
  • INDEXAUTH (8365)
  • INDEXCOLUSE (8366)
  • INDEXDEP (8367)
  • INDEXES (7009), (8368)
  • INDEXOPTIONS (8369)
  • KEYCOLUSE (8370)
  • NAMEMAPPINGS (8371)
  • NODEGROUPDEF (8372)
  • NODEGROUPS (8373)
  • overview (8335)
  • PACKAGEAUTH (8374)
  • PACKAGEDEP (8375)
  • PACKAGES (8376)
  • PARTITIONMAPS (8377)
  • PASSTHRUAUTH (8378)
  • PROCEDURES (8379)
  • PROCOPTIONS (8380)
  • PROCPARMOPTIONS (8381)
  • PROCPARMS (8382)
  • read-only (8340)
  • REFERENCES (8383)
  • REVTYPEMAPPINGS (8384)
  • SCHEMAAUTH (8385)
  • SCHEMATA (8386)
  • SERVEROPTIONS (8387)
  • SERVERS (8388)
  • STATEMENTS (8389)
  • SYSDUMMY1 (8341)
  • SYSSTAT.COLDIST (7012), (8406)
  • SYSSTAT.COLUMNS (7008), (8409)
  • SYSSTAT.FUNCTIONS (7038), (8410)
  • SYSSTAT.INDEXES (7010), (8411)
  • SYSSTAT.TABLES (7006), (8412)
  • TABAUTH (8390)
  • TABCONST (8391)
  • TABLES (7005), (8392)
  • TABLESPACES (8393)
  • TABOPTIONS (8394)
  • TBSPACEAUTH (8395)
  • TRIGDEP (8396)
  • TRIGGERS (8397)
  • TYPEMAPPINGS (8398)
  • updatable (8339)
  • update-capable (7028)
  • USEROPTIONS (8399)
  • VIEWDEP (8400)
  • VIEWS (8401)
  • WRAPOPTIONS (8402)
  • WRAPPERS (8403)
  • catalog views (structured types)
  • ATTRIBUTES (8342)
  • FULLHIERARCHIES (8357)
  • HIERARCHIES (8364)
  • catalogcache_sz configuration parameter (7524)
  • cataloging database (5527)
  • catalog_noauth configuration parameter (7874)
  • CDS (8229)
  • cell directory service (CDS) (8230)
  • changing database configuration (5719)
  • changing environment variables (5714)
  • changing node configuration file (5717)
  • changing partitioning key (5792)
  • changing passwords (7983)
  • changing registry variables (5715)
  • changing table attributes (5797)
  • character comparison, overview (8547)
  • character conversion
  • performance considerations (6910)
  • character serial devices (5539)
  • character sets
  • extended UNIX code (EUC) (8532)
  • checking available space (DMS) (5898)
  • chngpgs_thresh configuration parameter (7595)
  • managing the buffer pool (7293)
  • CLI Guide and Reference (7889)
  • client
  • backing up database, restriction (6339)
  • Client Configuration Assistant (5889)
  • CLIENT level security (5928)
  • client support
  • client I/O block size (rqrioblk) parameter (7573)
  • TCP/IP service name (svcename) parameter (7753)
  • transaction program name (tpname) parameter (7755)
  • CLIENT, authentication type (5927)
  • clients
  • trusted (5930), (5935)
  • untrusted (5931), (5939)
  • CLOB (5296) See also large objects
  • cluster configuration (6587)
  • cluster management (6591)
  • Cluster Manager (6646)
  • cluster monitoring for HACMP ES (6661)
  • clustered index
  • cluster ratio statistic (7097)
  • CL_SCHED sample table (8322)
  • code page
  • DB2CODEPAGE environment variable (8517)
  • guidelines for selecting (6912)
  • how determined (8516)
  • locales
  • deriving in applications (8526)
  • how DB2 derives locales (8527)
  • RESTORE command (6325)
  • supported Windows 95 code pages (8518)
  • supported Windows NT code pages (8519)
  • code page support
  • character conversion (6911)
  • code point (8543)
  • code point, definition of (8539)
  • codepage configuration parameter (7712)
  • codeset configuration parameter (7710)
  • collate_info configuration parameter (7714)
  • collating sequence
  • case independent comparisons (8549)
  • code point (8542)
  • collating_sequence option (8563)
  • EBCDIC and ASCII sort order example (8551)
  • federated database concerns (8562)
  • general concerns (8559)
  • identity sequence (8544)
  • multi-byte characters (8546)
  • overview of (8541)
  • samples of (8558)
  • sort order example (8550)
  • specifying (8552)
  • use in character comparisons (8548)
  • collating sequence performance ramifications, federated systems (7178)
  • collating_sequence server option (6960)
  • collocated join (7150)
  • collocation
  • data redistribution preservation of (7441)
  • replicated summary tables (5326), (7146)
  • column
  • adding (5748)
  • altering (5752)
  • attribute (5148)
  • defining (5166), (5555)
  • estimating row size (5289)
  • naming rules (7989)
  • column options
  • numeric string (7181)
  • varchar_no_trailing_blanks (7183)
  • column UDF (5623)
  • Command Center (5880)
  • command line processor
  • binding to a database (5523)
  • Command Reference (7890)
  • commands
  • db2evmon (7392)
  • commit
  • errors during two-phase (6477)
  • number of commits to group (mincommit) (7666)
  • two-phase (6476)
  • communication
  • connection retries, number (7817)
  • FCM daemon to agent, request blocks (7810)
  • node, connection elapse time (7782)
  • node, message buffers (7798)
  • communication protocol
  • VI Architecture (8611)
  • communications bandwidth configuration parameter (6942)
  • comm_bandwidth configuration parameter (7855)
  • comm_rate server option (6962), (6964)
  • compensation (7177)
  • compiler
  • overview of (7042)
  • overview of federated database phases (7044)
  • overview of pushdown analysis (7043)
  • overview of query rewrite (7052)
  • overview of remote SQL generation (7049)
  • composite key
  • definition of (5200), (5226)
  • composite tables
  • composite inner (7144)
  • composite outer (7143)
  • compound SQL
  • overview of (6908)
  • performance considerations (6909)
  • concurrency
  • controlling using locks (6792)
  • overview of (6760)
  • concurrency and granularity
  • effect of locks on (6826)
  • concurrency control
  • BACKUP command (6298)
  • maximum number of active applications (maxappls) parameter (7607)
  • maximum number of concurrently active databases (numdb) parameter (7858)
  • concurrent access mode (6558)
  • configuration (7497) See also benchmarking
  • changing database manager parameters (7502)
  • changing database parameters (7508)
  • database manager parameters (7499)
  • database parameters (7507)
  • parameter details, overview of (7512)
  • parameter summary, database (7511)
  • parameter summary, database manager (7504)
  • parameters, overview of (7495)
  • tuning parameters (7496)
  • configuration file
  • governor example (7409)
  • configuration file, governor (7406)
  • configuration parameter
  • ADSTAR Distributed Storage Manager (7676)
  • affecting optimizer (6931)
  • agent communication memory (7566)
  • agent private memory (7545)
  • application communication memory (7567)
  • application shared memory (7536)
  • applications and agents (7606)
  • AUTORESTART (6145), (6231)
  • capacity management (7513)
  • communication protocol setup (7750)
  • communications (7749)
  • compiler settings (7743)
  • Database Application Remote Interface (DARI) (7638)
  • database attributes (7701)
  • database management (7699)
  • database manager instance memory (7577)
  • database shared memory (7515)
  • database status (7730)
  • database system monitor (7844)
  • DB2 Data Links Manager (7716)
  • DB2 Discovery (7768)
  • diagnostic information (7839)
  • Distributed Computing Environment (DCE) (8284)
  • distributed services (7761)
  • distributed unit of work (7691)
  • I/O and storage (7593)
  • instance administration (7868)
  • instance management (7838)
  • locks (7584)
  • log activity (7664)
  • log files (7649)
  • logging (7647)
  • migration of (7935)
  • parallel operations (7776)
  • partitioned database (5421), (7777)
  • recovery (7648), (7674)
  • stored procedure (7637)
  • system management (7853)
  • configuration parameters
  • database logging (6344)
  • configuration, adding servers when system is running (7425)
  • configuration, adding servers when system is stopped (7429)
  • configuration, changing the size of a (7419)
  • configuration, dropping server with DB2STOP CMD/API (7434)
  • Configure Multisite Update SmartGuide (5867)
  • CONNECT privilege, definition (6006)
  • CONNECT statement
  • specifying Distributed Computing Environment (DCE) information (8290)
  • connect time reduction (7378)
  • connection
  • elapse time (7785)
  • number of retries (7816)
  • connection elapse time (conn_elapse) database manager configuration parameter (7780)
  • connection entry (7805)
  • connection pooling, MTS (6547)
  • Connectivity Supplement (7894)
  • conn_elapse configuration parameter (7783)
  • constraint
  • adding (5761)
  • changing (5759)
  • defining unique (5568)
  • dropping (5778)
  • Explain tables (8473)
  • constraint name
  • defining foreign keys (5586)
  • defining table check constraints (5597)
  • constraints
  • types of (5216)
  • container names (6304)
  • containers
  • adding (to DMS table space) (5735)
  • DMS table space design (5367)
  • logical file system (5353)
  • logical volume device (5369)
  • overview of (5330)
  • SMS table space (5349)
  • SMS table space design (5351)
  • suggestions for parallel I/O (7324)
  • Control Center
  • displaying systems (5873)
  • Event Analyzer (7386)
  • Performance Monitor (7384)
  • Snapshot Monitor (7385)
  • Control Center as a Java Applet (5905)
  • CONTROL privilege
  • definition of (6019)
  • implicit issuance (6058)
  • package privileges (6038)
  • controlling the rah command (8593)
  • conversion
  • of locks, rules for (6833)
  • cooked devices (5542)
  • Coordinated Universal Time (7825)
  • coordinator agent (7370)
  • maximum number at node (7626)
  • coordinator database partition, considerations for dropping (7436)
  • copyprotect configuration parameter (7715)
  • country configuration parameter (7708)
  • CPU speed configuration parameter
  • affect on query optimization (6939)
  • cpuspeed configuration parameter (7856)
  • cpu_ratio server option (6966)
  • crash recovery (6227)
  • offline table space (6139)
  • overview of (6138)
  • point of consistency (6142)
  • RESTART DATABASE (6143)
  • triggering (6258)
  • CREATE ALIAS statement
  • example of (5659)
  • using (5657)
  • CREATE DATABASE API
  • SQLEDBDESC structure (8556)
  • CREATE DATABASE command
  • example of (5495)
  • Create Database SmartGuide (5861)
  • create HACMP ES container examples (6599)
  • CREATE INDEX statement
  • example of (5695)
  • online reorganization (5686), (5699)
  • unique index (5697)
  • Create Table SmartGuide (5862)
  • Create Table space SmartGuide (5863)
  • CREATE TABLE statement
  • defining check constraints (5598)
  • defining referential constraints (5580)
  • example of (5561)
  • using multiple table spaces (5608)
  • CREATE TABLESPACE statement
  • example of (5534)
  • CREATE TRIGGER statement
  • example of (5616)
  • CREATE VIEW statement
  • changing column names (5648)
  • example of (5645)
  • CREATETAB privilege, definition of (6008)
  • CREATE_NOT_FENCED privilege, definition (6010)
  • creating (5154) See also defining
  • creating a function mapping (5627)
  • creating a function template (5630)
  • creating a nickname (5671)
  • creating a server (5668)
  • creating a type mapping (5641)
  • creating a wrapper (5665)
  • creating alias (5656)
  • creating an index specification (5679)
  • creating index (5677)
  • creating schema (5547)
  • creating table (5552)
  • creating table in multiple table spaces (5606)
  • creating table space (5531)
  • creating trigger (5613)
  • creating typed table (5600)
  • creating typed view (5651)
  • creating user-defined distinct type (5636)
  • creating user-defined function (5618)
  • creating user-defined structured type (5638)
  • creating user-defined type (5632)
  • creating view (5642)
  • CURRENT DEGREE special register (6927)
  • CURRENT SCHEMA (5551)
  • CURRENT SCHEMA special register (5410)
  • cursor
  • close using WITH RELEASE clause (6864)
  • read only, uncommitted read (6783)
  • updatable, uncommitted read (6784)
  • cursor stability
  • overview of (6775)
  • customized Control Center (5872)
    • D
  • damaged table spaces (6199)
  • DARI (6915) See also stored procedures
  • data
  • caching when database is started (6920)
  • changing distribution (5731)
  • connection entries for agents to pass, number (7804)
  • data integrity
  • concurrency, overview (6761)
  • protecting using locks (6795)
  • unique index (5680)
  • Data Links access token expiry interval configuration parameter (7719)
  • Data Links number of copies configuration parameter (7721)
  • Data Links time after drop configuration parameter (7723)
  • Data Links token algorithm configuration parameter (7725)
  • Data Links token in upper case configuration parameter (7727)
  • Data Movement Utilities Guide and Reference (7891)
  • data security
  • controlling database access (5907)
  • importance of (5908)
  • securing system catalog (6095)
  • data sources
  • CPU speed and performance (7197)
  • I/O speed and performance (7198)
  • data structure
  • SQLEDBDESC (8555)
  • data transfer
  • overview of (6133)
  • data type
  • column definition (5167), (5556)
  • multi-byte character set (5559)
  • database (6214)
  • activate (7364)
  • agents (7368)
  • altering nodegroup (5727)
  • auto restart enable (autorestart) parameter (7678)
  • backup (6273)
  • backup pending indicator (backup_pending) parameter (7731)
  • catalog node, media failure considerations (6215)
  • cataloging (5528)
  • changing (5722)
  • changing distribution of data (5730)
  • code page for database (codepage) parameter (7711)
  • codeset for database (codeset) parameter (7709)
  • collating information (collate_info) parameter (7713)
  • configuration parameter summary (7510)
  • configuration parameters (7505)
  • connection considerations (6499)
  • considerations before changing (5702)
  • considerations for creating (5422)
  • country code for database (country) parameter (7707)
  • crash recovery (6260)
  • creating (5494)
  • creating across all nodes (5419)
  • data caching when database is started (6919)
  • database is consistent (database_consistent) parameter (7733)
  • database partition synchronization, recovery considerations (6225)
  • deactivate (7365)
  • deciding what data to record (5145), (5152)
  • defining tables (5153)
  • designing (5144)
  • determining list of data nodes (6280)
  • dropping (5724)
  • enabling data partitioning (5414)
  • estimating size (5285)
  • federated database design considerations (5390)
  • implementing design (5391)
  • inconsistent after restart (6261)
  • maximum file open per application (maxfilop) parameter (7610)
  • maximum number of concurrently active databases (numdb) parameter (7857)
  • migration (7929)
  • naming rules (7980)
  • normalizing tables (5207)
  • number of containers (numsegs) parameter (7601)
  • object naming rules (7977)
  • other design considerations (5261)
  • package dependencies (5853)
  • parameter file SQLDBCON (7506)
  • physical design (5267)
  • recovering failed database partition server (6266)
  • recovery log (5517)
  • release level (release) parameter (7702)
  • resource manager in TP Monitor environment (6494)
  • restore (6311)
  • roll-forward changes (6342)
  • storage for an application (7266)
  • subdirectory created (5268)
  • territory for database (territory) parameter (7705)
  • transaction recovery on the failed database partition server (6253)
  • transaction recovery when the database partition server is active (6246)
  • transaction recovery, overview (6234)
  • uniquely identifying entities (5204)
  • updating multiple databases (6457)
  • user exit enable (userexit) parameter (7672)
  • user exit status indicator (user_exit_status) parameter (7739)
  • using multiple databases in a single transaction (6454)
  • database access
  • affect of optimization class (6868)
  • choosing authorizations (5265)
  • controlling (5906)
  • overview of (7068), (7072)
  • privileges through package with SQL (6063)
  • database administrator (DBADM) authority
  • privileges (5998)
  • retrieving names with (6086)
  • database alias (7976)
  • for BACKUP command (6292)
  • naming rules (7979)
  • RESTORE command (6319)
  • Database Application Remote Interface (DARI) (6916) See also stored procedures
  • initial number of fenced DARI processes in pool (num_initdaris) parameter (7645)
  • initialize DARI process with JVM (initdari_jvm) parameter (7643)
  • keep DARI process indicator (keepdari) parameter (7639)
  • maximum number of DARI processes (maxdari) parameter (7641)
  • database configuration
  • app_ctl_heap_sz parameter (7542)
  • changing (5718)
  • created file (5491)
  • database creation, specifying collating sequence (8553)
  • Database Descriptor Block (SQLEDBDESC), specifying collating sequences (8557)
  • database files
  • index data (5360)
  • log files (5273)
  • notes of caution (5284)
  • SMS table space (5357)
  • SQLINSLK (5275)
  • table data (5359)
  • database locator objects
  • creating (8237)
  • example (8238)
  • database logs (6162)
  • configuration parameters (6345)
  • database managed storage (5362) See also DMS table space
  • database management, configuration parameters (7700)
  • database manager (6235)
  • access control (6045)
  • binding utilities (5520)
  • configuration parameter summary (7503)
  • configuration parameters (7500)
  • default database path (dftdbpath) parameter (7875)
  • governor affect on performance (7416)
  • index (5690)
  • machine node type (nodetype) parameter (7861)
  • naming rules (7978)
  • parameter file db2systm (7501)
  • recovering failed database partition server (6267)
  • start timeout (7829)
  • starting and stopping (5393)
  • stop timeout (7830)
  • transaction failure, reducing impact (6220)
  • transaction recovery on the failed database partition server (6254)
  • transaction recovery when the database partition server is active (6247)
  • transaction recovery, overview (6236)
  • using memory (7263)
  • database manager configuration
  • conn_elapse parameter (7784)
  • fcm_num_anchors parameter (7789)
  • fcm_num_buffers parameter (7794)
  • fcm_num_connect parameter (7802)
  • fcm_num_rqb parameter (7809)
  • java_heap_sz parameter (7583)
  • max_connretries parameter (7818)
  • max_coordagents parameter (7623)
  • max_time_diff parameter (7822)
  • num_initagents parameter (7635)
  • num_poolagents parameter (7631)
  • start_stop_time parameter (7832)
  • database monitor
  • using (7382)
  • database objects
  • access control (6044)
  • creating (8235)
  • example (8236)
  • naming rules (7986), (8533)
  • database partition, adding to a system with no databases (7423)
  • database partition, adding when system is running (7424)
  • database partition, considerations for dropping a server (7435)
  • database partition, dropping with DB2STOP CMD/API (7433)
  • database partitions, adding to a system (7422)
  • database partitions, adding when system is stopped (7428)
  • database restore
  • overview of (6147)
  • database roll-forward recovery
  • overview (6150)
  • database seed (6331)
  • database startup cost (7363)
  • database system monitor
  • configuration parameters (7845)
  • fcm_num_rqb database manager parameter, tuning (7812)
  • databases
  • non-recoverable (6161)
  • recoverable (6160)
  • database_consistent configuration parameter (7734)
  • database_level configuration parameter (7704)
  • datalinks configuration parameter (7728)
  • Datalink_Reconcile_Not_Possible state (6395)
  • DataPropagator Relational (DPROPR)
  • overview (6134)
  • date
  • definition of (8566)
  • formats (8573)
  • date strings
  • definition of (8570)
  • datetime values
  • overview of (8565)
  • string representations (8569)
  • DAU (DB_Authentication) (8243)
  • DB2
  • starting on Windows NT (5400)
  • DB2 Administration Server
  • update configuration (5485)
  • update instance lists (5483)
  • using CCA and Control Center (5482)
  • DB2 Administration Server (DAS) (5462)
  • communications (5467)
  • configuration (5464), (5465)
  • configuring (5456)
  • Control Center communications (5466)
  • creating (5453)
  • enabling discovery of (5478)
  • environment (5476)
  • internode administrative communications (5468)
  • internode administrative communications in partitioned database system (UNIX) (5470)
  • internode administrative communications in partitioned database system (Windows NT) (5472)
  • listing (5455)
  • overview (5452)
  • ownership rules (5450)
  • registry variable considerations (5475)
  • registry variables (5477)
  • removing (5459)
  • security (5474)
  • security considerations (5457)
  • service ports (5469)
  • setting up with partitioned database system (5460)
  • example (5463)
  • starting and stopping (5454)
  • UNIX EEE servers (5471)
  • updating (5458)
  • Windows NT EEE servers (5473)
  • DB2 Connect (6132) See also data transfer
  • connect time reduction (7379)
  • DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (7911)
  • DB2 Connect Enterprise Edition for UNIX Quick Beginnings (7912)
  • DB2 Connect Personal Edition Quick Beginnings (7892)
  • DB2 Connect User's Guide (7893)
  • DB2 Data Links Manager (7717)
  • backup utility considerations (6388)
  • crash recovery (6385)
  • Datalink_Reconcile_Not_Possible state (6394)
  • Datalink_Reconcile_Pending state (6396)
  • detection of situations requiring reconciliations (6416)
  • garbage collection (6381)
  • indoubt transactions (6387)
  • interactions with recovery (6412)
  • point-in-time roll-forward example (6410)
  • reconciliation procedure (6417)
  • reconciling (6415)
  • removing table from Datalink_Reconcile_Not_Possible state (6414)
  • restore utility considerations (6390)
  • restoring databases (6400), (6405)
  • restoring databases from an offline backup without rolling forward (6398)
  • restoring table spaces (6401), (6406)
  • rollforward utility considerations (6391)
  • rolling forward databases to a point in time (6407)
  • rolling forward databases to end of logs (6402)
  • rolling forward table spaces to a point in time (6408)
  • rolling forward table spaces to end of logs (6403)
  • two-phase commit (6386)
  • DB2 Data Links Manager for AIX Quick Beginnings (7913)
  • DB2 Data Links Manager for Windows NT Quick Beginnings (7914)
  • DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (7909)
  • DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (7910)
  • DB2 failover examples (6566)
  • DB2 for Windows NT Performance Counters (8603)
  • DB2 library
  • books (7883)
  • Information Center (7921)
  • language identifier for books (7918)
  • late-breaking information (7919)
  • online help (7882)
  • ordering printed books (7926)
  • printing PostScript books (7925)
  • searching online information (7924)
  • setting up document server (7922)
  • SmartGuides (7881)
  • structure of (7880)
  • viewing online information (7920)
  • DB2 Personal Edition Quick Beginnings (7905)
  • DB2 Query Patroller Administration Guide (7915)
  • DB2 Query Patroller Installation Guide (7916)
  • DB2 Query Patroller User's Guide (7917)
  • DB2 shared nothing model (6559)
  • DB2 Syncpoint Manager
  • recovery of indoubt transactions (6492)
  • when required (6461)
  • DB2 Syncpoint Manager (SPM) (6490)
  • DB2 transaction manager
  • database configuration considerations (6466)
  • DB2ACCOUNT (8003)
  • DB2ADMINSERVER (8193)
  • db2adutl utility (6440)
  • DELETE command (6443)
  • EXTRACT command (6442)
  • QUERY command (6441)
  • db2adutl utility examples (6444)
  • DB2ATLD_PORTS (8119)
  • DB2ATLD_PWFILE (8121)
  • db2audit (6115)
  • db2audit.log (6103)
  • db2batch benchmarking tool (7490)
  • DB2BIDI (8005)
  • DB2BPVARS (8145)
  • DB2BQTIME (8109)
  • DB2BQTRY (8111)
  • DB2CHECKCLIENTINTERVAL (8059)
  • DB2CHGPWD_EEE (8123)
  • DB2CHKPTR (8151), (8153)
  • DB2CLIENTADPT (8103)
  • DB2CLIENTCOMM (8105)
  • DB2CLIINIPATH (8195)
  • DB2CODEPAGE (8007)
  • DB2COMM (8061)
  • DB2CONNECT_IN_APP_PROCESS (8045)
  • DB2COUNTRY (8009)
  • DB2DBDFT (8011)
  • DB2DBMSADDR (8013)
  • DB2DEFPREP (8197)
  • DB2DIRPATHNAME (8101)
  • DB2DISCOVERYTIME (8015)
  • DB2DMNBCKCTLR (8017), (8201)
  • db2dmnbckctlr
  • using (8599)
  • db2empfa (7326)
  • DB2ENVLIST (8047)
  • db2exfmt tool (7235), (8515)
  • db2expln (8494) See also explain tool
  • db2gov command (7398)
  • db2govlg command (7414)
  • db2icrt command (5432)
  • DB2INCLUDE (8019)
  • DB2INSTANCE (8049)
  • DB2INSTANCE environment variable
  • defining default instance (5403)
  • DB2INSTDEF (8021)
  • DB2INSTOWNER (8023)
  • DB2INSTPROF (8051)
  • DB2IQTIME (8113)
  • DB2LDAP_SEARCH_SCOPE (8209)
  • DB2LIBPATH (8053)
  • DB2LOADREC (6362), (8211)
  • DB2LOCK_TO_RB (8213)
  • db2look tool
  • overview of (7041)
  • DB2MEMDISCLAIM (8155)
  • DB2MEMMAXFREE (8157)
  • DB2MSCS utility
  • DB2MSCS.CFG parameters (6681)
  • overview (6679)
  • setting up a single-partition database system (6683)
  • setting up partitioned database system (6687)
  • setting up two single-partition database systems for mutual takeover (6685)
  • DB2NBADAPTERS (8065)
  • DB2NBBRECVNCBS (8073)
  • DB2NBCHECKUPTIME (8067)
  • DB2NBDISCOVERRCVBUFS (8027)
  • DB2NBINTRLISTENS (8069)
  • DB2NBRECVBUFFSIZE (8071)
  • DB2NBRESOURCES (8075)
  • DB2NBSENDNCBS (8077)
  • DB2NBSESSIONS (8079)
  • DB2NBXTRANCBS (8081)
  • DB2NETREQ (8083)
  • DB2NODE (8055), (8127)
  • DB2NODE environment variable
  • exported when adding server (7427)
  • db2nodes.cfg file (5489)
  • adding database partitions when redistributing data (7458)
  • dropping database partitions when redistributing data (7459)
  • db2nodes.cfg, having the database manager update (7430)
  • db2nodes.cfg, updating manually (7432)
  • DB2NOEXITLIST (8215)
  • DB2NTMEMSIZE (8165)
  • DB2NTNOCACHE (8149), (8167)
  • DB2NTPRICLASS (8169)
  • DB2NTREMOTEPREG (8217)
  • DB2NTWORKSET (8171)
  • DB2OPTIONS (8029), (8115)
  • DB2PATH (8057)
  • DB2PORTRANGE (8129)
  • DB2PRIORITIES (8175)
  • DB2RETRY (8085)
  • DB2RETRYTIME (8087)
  • DB2RHIST.ASC database file (5282)
  • DB2RHIST.BAK database file (5283)
  • DB2ROUTE (8107)
  • DB2ROUTINE_DEBUG (8219)
  • DB2RQTIME (8117)
  • DB2SERVICETPINSTANCE (8089)
  • db2set command (5440), (5445)
  • DB2SLOGON (8031)
  • DB2SORCVBUF (8221)
  • DB2SORT (8223)
  • DB2SOSNDBUF (8091)
  • db2start command (5397)
  • db2stop command (5396)
  • DB2SYSPLEX_SERVER (8093)
  • DB2SYSTEM (8225)
  • DB2TIMEOUT (8033)
  • DB2TRACEFLUSH (8039)
  • DB2TRACENAME (8035)
  • DB2TRACEON (8037)
  • DB2TRCSYSERR (8041)
  • db2uexit
  • user exit programs for OS/2 (8438)
  • user exit programs for UNIX-based systems (8443)
  • DB2UPMPR (8227)
  • DB2YIELD (8043)
  • db2_all (8576), (8579)
  • DB2_AVOID_PREFETCH (8141)
  • DB2_BINSORT (8143)
  • db2_call_stack (8581)
  • DB2_CORRELATED_PREDICATES (8131)
  • DB2_DJ_COMM (8199)
  • DB2_FALLBACK (8203)
  • DB2_FORCE_FCM_BP (8125)
  • DB2_FORCE_NLS_CACHE (8063)
  • DB2_FORCE_TRUNCATION (8205)
  • DB2_GRP_LOOKUP (8207)
  • DB2_HASH_JOIN (8133)
  • db2_kill (8580)
  • DB2_LIC_STAT_SIZE (8025)
  • DB2_LIKE_VARCHAR (8135)
  • DB2_MMAP_READ (8159)
  • DB2_MMAP_WRITE (8161)
  • DB2_NEW_CORR_SQ_FF (8137)
  • DB2_NO_PKG_LOCK (8163)
  • DB2_OVERRIDE_BPF (8173)
  • db2_override_bpf (7301)
  • DB2_PRED_FACTORIZE (8139)
  • DB2_RR_TO_RS (8177)
  • DB2_SORT_AFTER_TQ (8179)
  • DB2_VI_DEVICE (8099)
  • DB2_VI_ENABLE (8095)
  • DB2_VI_VIPL (8097)
  • DBCLOB (5297) See also large objects
  • dbexpln tool
  • data from compiler (7050)
  • dbheap configuration parameter (7523)
  • impact on memory (7273)
  • dbname server option (6968)
  • DB_Authentication (DAU) (8242)
  • DB_Comment (DCO) (8248)
  • DB_Communication_Protocol (DCP) (8251)
  • DB_Database_Locator_Name (DLN) (8257)
  • DB_Database_Protocol (DDP) (8254)
  • DB_Native_Database_Name (DNN) (8260)
  • DB_Object_Type (DOT) (8263)
  • DB_Principal (DPR) (8245)
  • DB_Product_Name (DPN) (8266)
  • DB_Product_Release (DRL) (8269)
  • DB_Target_Database_Info (DTI) (8272)
  • DCE network database
  • connecting (8293), (8294)
  • creating (8292)
  • DCE, authentication type (5945)
  • DCE_SERVER_ENCRYPT, authentication type (5947)
  • DCO (DB_Comment) (8249)
  • DCP (DB_Communication_Protocol) (8252)
  • DCS
  • authentication type (5941)
  • federated database processing (5962)
  • DCS_ENCRYPT, authentication type (5943)
  • DDP (DB_Database_Protocol) (8255)
  • DEACTIVATE DATABASE command (7362)
  • deadlocks
  • checking for (7588)
  • configuration parameter (7589)
  • detecting (6843)
  • overview of (6844)
  • DECLARE CURSOR WITH HOLD statement (6886)
  • decorrelation of a query (7064)
  • default attribute specification (5560)
  • default value
  • alternative to null value (5190)
  • column definition (5189)
  • defining referential constraint (5574)
  • defining table check constraint (5594)
  • defining unique constraint (5565)
  • DEGREE bind option (6928)
  • DELETE privilege, definition (6023)
  • DELETE rules
  • types of (5247)
  • DELETE statement
  • referential integrity implications for (5246)
  • deleting rows from typed tables (5804)
  • DEPARTMENT sample table (8323)
  • dependent row
  • definition of (5234)
  • dependent table
  • definition of (5232)
  • dereference operator (5603)
  • design of database
  • altering (5703)
  • design, implementing (5392)
  • DETACH command
  • overview of (5405)
  • determining problems with rah (8597)
  • dftdbpath configuration parameter (7876)
  • dft_account_str configuration parameter (7863)
  • dft_client_adpt configuration parameter (7767)
  • dft_client_comm configuration parameter (7766)
  • dft_degree configuration parameter (6925), (6933), (7745)
  • dft_extent_sz configuration parameter (7603)
  • dft_loadrec_ses configuration parameter (7682)
  • dft_monswitches configuration parameter (7846)
  • dft_mon_bufpool configuration parameter (7850)
  • dft_mon_lock configuration parameter (7851)
  • dft_mon_sort configuration parameter (7852)
  • dft_mon_stmt configuration parameter (7848)
  • dft_mon_table configuration parameter (7849)
  • dft_mon_uow configuration parameter (7847)
  • dft_prefetch_sz configuration parameter (7600)
  • dft_queryopt configuration parameter (6934), (7746)
  • dft_sqlmathwarn configuration parameter (7744)
  • diaglevel configuration parameter (7841)
  • diagpath configuration parameter (7842)
  • directed inner-table and outer-table joins (7156)
  • directed inner-table join (7162)
  • directed outer-table joins (7154)
  • directories
  • local database directory (5506)
  • node directory (5510)
  • system database directory (5508)
  • directory cache
  • effect of cataloging databases (5530)
  • directory objects
  • creating (8234)
  • object classes attributes (8241)
  • directory under which Java Development Kit 1.1 is installed (jkd11_path) database manager parameter (7864)
  • dir_cache configuration parameter (7579)
  • dir_obj_name configuration parameter (7764)
  • dir_path_name configuration parameter (7763)
  • dir_type configuration parameter (7762)
  • disaster recovery
  • considerations (6206)
  • discover configuration parameter (7770)
  • discover server instance configuration parameter (7775)
  • Discovery
  • configuration (5487)
  • hiding server instances (5480)
  • setting parameters (5481)
  • discovery mode configuration parameter (7771)
  • discover_comm configuration parameter (7772)
  • discover_db configuration parameter (7769)
  • discover_inst configuration parameter (7774)
  • disk-mirroring (6219)
  • Distributed Computing Environment (DCE)
  • ATTACH command (8288), (8296)
  • authentication (5952)
  • CATALOG GLOBAL DATABASE command (8286)
  • CDS (8228)
  • configuration parameters (7760)
  • configuration parameters and registry variables (8283)
  • CONNECT statement (8287), (8297)
  • directory services restrictions (8301)
  • directory services tasks (8299)
  • GDS (8233)
  • how directories are searched (8295)
  • overview of directory services (5512)
  • restrictions (5956)
  • security services (5951)
  • setup DB2 client instance (5955)
  • setup DB2 server (5954)
  • setup DB2 user (5953)
  • temporarily overriding DCE directory information (8298)
  • using directory services (8300)
  • distributed transaction processing (8303) See also X/Open transactional manager interface (XA)
  • dlchktime configuration parameter (7587)
  • DLFM_BACKUP_DIR_NAME (8181)
  • DLFM_ENABLE_STPROC (8183)
  • DLFM_GC_MODE (8185)
  • DLFM_INSTALL_PATH (8187)
  • DLFM_LOG_LEVEL (8189)
  • DLFM_PORT (8191)
  • DLN (DB_Database_Locator_Name) (8258)
  • dl_expint configuration parameter (7718)
  • dl_num_copies configuration parameter (7720)
  • dl_time_drop configuration parameter (7722)
  • dl_token configuration parameter (7724)
  • dl_upper configuration parameter (7726)
  • DMS table space
  • adding containers (5371)
  • advantages (5388)
  • allocating space (5368)
  • caching of (7357)
  • choosing extent size (5381)
  • creating (5537)
  • increasing storage (5370)
  • overview of (5364)
  • performance considerations (7355)
  • size (5366)
  • types of (5365)
  • DNN (DB_Native_Database_Name) (8261)
  • dos_rqrioblk configuration parameter (7575)
  • DOT (DB_Object_Type) (8264)
  • double byte character set user
  • data type (5558)
  • DPN (DB_Product_Name) (8267)
  • DPR (DB_Principal) (8246)
  • DPROPR (6135) See also DataPropagator Relational (DPROPR)
  • drda_heap_sz configuration parameter (7561)
  • impact on memory (7284)
  • DRL (DB_Product_Release) (8270)
  • drop a temporary table space (5741)
  • DROP DATABASE command
  • example of (5725)
  • DROP INDEX statement; example of (5845)
  • DROP NICKNAME statement, example of (5841)
  • DROP SERVER statement, example of (5837)
  • DROP TABLE statement
  • example of (5811)
  • DROP TABLESPACE statement; example of (5740)
  • DROP VIEW statement; example of (5824)
  • dropped table
  • recovery (6365)
  • dropping a nickname (5839)
  • dropping a server (5835)
  • dropping a summary table (5829)
  • dropping a wrapper (5833)
  • dropping constraint (5779)
  • dropping database (5723)
  • dropping index (5842)
  • dropping node from system
  • when redistributing nodegroup (7457)
  • dropping schema (5743)
  • dropping table (5808)
  • dropping table check constraint (5788)
  • dropping trigger (5812)
  • dropping unique constraint (5780)
  • dropping user table space (5738)
  • dropping user-defined function (5814)
  • dropping user-defined type (5816)
  • dropping view (5823)
  • DSMI_CONFIG (6424), (6430)
  • DSMI_DIR (6423), (6429)
  • DSMI_LOG (6425), (6431)
  • DTI (DB_Target_Database_Info) (8273)
  • dynamic SQL
  • distribution statistics (7020)
  • evaluating optimization class (6876)
  • EXECUTE privilege for database access (6066)
  • explain facility (7239), (7244)
  • setting optimization class (6873)
  • dynexpln (8495) See also explain tool
    • E
  • eliminating duplicate entries from machine list (8592)
  • EMPLOYEE sample table (8324)
  • EMP_ACT sample table (8325)
  • EMP_PHOTO sample table (8326)
  • EMP_RESUME sample table (8327)
  • enable Data Links support configuration parameter (7729)
  • enable intra-partition parallelism configuration parameter (7837)
  • enhanced scalability (6570) See also HACMP ES
  • entity
  • definition of (5146)
  • values (5205)
  • environment variables (5438), (8001)
  • changing (5712)
  • DB2LOADREC (6363)
  • DB2NODE, exported when adding server (7426)
  • setting on OS/2 (5446)
  • setting on UNIX (5449)
  • setting on Windows 3.x (5451)
  • setting on Windows 95 (5448)
  • setting on Windows NT (5447)
  • Eprimary node (6624)
  • erasing the sample database (8321)
  • error handling
  • access errors, BACKUP command (6300)
  • access errors, RESTORE command (6324)
  • configuration parameters (7840)
  • indoubt transaction in TP Monitor environment (6503)
  • indoubt transactions (6483)
  • log full (6347)
  • system crash during BACKUP (6296), (6338)
  • two-phase commit (6482)
  • user exit program (8466)
  • user exit program for OS/2 (8469)
  • XA interface (6526)
  • estimating size (5897)
  • estore_seg_sz configuration parameter (7604)
  • impact on memory (7275)
  • event definition example for HACMP ES (6642)
  • Event Management (6644)
  • event monitoring (6632)
  • event snapshots (7391)
  • exclusive mode
  • reasons for using (6863)
  • EXECUTE privilege
  • database access with dynamic SQL (6067)
  • database access with static SQL (6065)
  • definition of (6040)
  • EXPLAIN (7240)
  • explain
  • FOR SNAPSHOT (7245)
  • Visual (7212), (7251)
  • WITH SNAPSHOT (7246)
  • explain tool (8492)
  • aggregation (8510)
  • command options (8498), (8500)
  • data streams (8506)
  • description of output (8501)
  • examples of db2expln and dynexpln output (8513)
  • insert, update, and delete (8507)
  • joins (8505)
  • miscellaneous statements (8512)
  • overview of (8493)
  • parallel processing (8511)
  • row identifier (RID) preparation (8508)
  • running (8496)
  • syntax (8497), (8499)
  • table access (8502)
  • temporary tables (8504)
  • explain facility (7051) See also dbexpln tool
  • analysis (7218)
  • capturing information (7214), (7237)
  • choosing a tool (7209)
  • concepts (7219)
  • data from compiler (7048)
  • data organization (7226)
  • decision-making (7248)
  • explain instance (7228)
  • graphical representation (7220)
  • instance information (7229)
  • keywords (7232)
  • objects (7223)
  • obtaining data (7236)
  • operators (7225)
  • overview of (7208)
  • snapshot information (7233)
  • statement information (7230)
  • table information (7234)
  • using (7215)
  • explain instance (7227)
  • explain snapshot (7243)
  • explain table format tool (8514)
  • explain tables
  • accessing (7210)
  • EXPLAIN_ARGUMENT table (8474)
  • EXPLAIN_ARGUMENT table definition (8483)
  • EXPLAIN_INSTANCE table (8475)
  • EXPLAIN_INSTANCE table definition (8484)
  • EXPLAIN_OBJECT table (8476)
  • EXPLAIN_OBJECT table definition (8485)
  • EXPLAIN_OPERATOR table (8477)
  • EXPLAIN_OPERATOR table definition (8486)
  • EXPLAIN_PREDICATE table (8478)
  • EXPLAIN_PREDICATE table definition (8487)
  • EXPLAIN_STATEMENT table (8479)
  • EXPLAIN_STATEMENT table definition (8488)
  • EXPLAIN_STREAM table (8480)
  • EXPLAIN_STREAM table definition (8489)
  • explicit schema use (5408)
  • extended storage cache (7394)
  • Extended UNIX Code (EUC)
  • extended UNIX code (EUC)
  • character sets (8531)
  • code page support (6913)
  • extent size
  • choosing (7310)
  • choosing the value (5380)
  • definition of (5331)
  • SMS table space design (5352)
    • F
  • failover examples (6562)
  • failover support (6553), (6569) See also High Availability Cluster Multi-Processing configurations, High Availability Cluster Multi-Processing configurations
  • fast communication manager (FCM)
  • FCM Connection Entries (fcm_num_connect) parameter (7800)
  • fcm_num_buffers database manager parameter (7793)
  • message anchors, number, specifying (7790)
  • message buffers, number, specifying (7796)
  • number of FCM message anchors fcm_num_anchors database manager parameter (7787)
  • Number of FCM Request Blocks (fcm_num_rqb) parameter (7807)
  • FCM buffers (fcm_num_buffers) database manager configuration parameter (7792)
  • FCM communications (5493)
  • FCM connection entries (fcm_num_connect) database manager parameter (7799)
  • FCM tuning (7291)
  • fcm_num_anchors configuration parameter (7788)
  • fcm_num_buffers configuration parameter (7795)
  • fcm_num_connect configuration parameter (7801)
  • fcm_num_rqb database manager configuration parameter (7808)
  • federated configuration parameter (7867)
  • federated database
  • APPC setting (5976)
  • authentication details (5958)
  • authentication example (5978)
  • authentication overview (5915)
  • authorization overview (5916)
  • case-sensitive names (7998)
  • collating sequences, guidelines (8561)
  • compiler phases (7169)
  • DCS setting (5961)
  • function mapping, creating (5626)
  • function template, creating (5629)
  • index specification, creating (5676)
  • nickname, creating (5669)
  • nickname, identifying (5674)
  • nickname, working with (5673)
  • object names (7996)
  • passing IDs and passwords to data sources (5964)
  • pushdown analysis (7172)
  • referencing nicknames (5672)
  • remote SQL generation (7191)
  • server options, security (5970)
  • server, creating (5666)
  • type mapping, creating (5639)
  • user mapping, creating (5967)
  • wrapper, creating (5663)
  • federated database system support configuration parameter (7866)
  • FETCH FIRST clause (6885)
  • files (5271)
  • fileserver configuration parameter (7757)
  • filter (5871)
  • finding errors
  • data redistribution log file (7478)
  • first active log file (loghead) parameter (7663)
  • fold_id server option (6970)
  • fold_pw server option (6972)
  • FOR FETCH ONLY clause (6883), (6904)
  • FOR READ ONLY clause (6882), (6903)
  • FOR UPDATE clause (6881), (6905)
  • foreign key
  • adding (5769)
  • composite (5585)
  • constraint name (5584)
  • DROP FOREIGN KEY clause, ALTER TABLE statement (5785)
  • IMPORT utility, referential integrity implications for (5592)
  • LOAD utility, referential integrity implications for (5591)
  • privileges required for dropping (5786)
  • rules for foreign key definitions (5583)
  • update, referential integrity implications for (5258)
  • FOREIGN KEY clause
  • referential constraints (5581)
  • rules for foreign key definitions (5582)
  • frequent value statistics
  • equality predicates (7025)
  • number to collect (7021)
  • overview of (7018)
  • rules for updating (7033)
  • function mapping, creating (5628)
  • function template, creating (5631)
    • G
  • garbage collection (6377)
  • gateway connections (5878)
  • GDS (8231)
  • generate DDL (5870)
  • generation, remote SQL
  • overview (7190)
  • global directory service (GDS) (8232)
  • global level profile registry (5442)
  • global optimization
  • analyzing (7206)
  • explain tool cost information (7207)
  • nickname characteristics, affecting (7200)
  • server characteristics, affecting (7194)
  • Glossary (7895)
  • governor
  • configuration file (7405)
  • configuration file example (7408)
  • daemon (7400)
  • database manager performance (7415)
  • db2gov (7399)
  • db2govlg (7413)
  • error handling (7404)
  • log file (7411)
  • obtains statistics (7401)
  • purpose (7395)
  • querying log file (7412)
  • rules (7407)
  • starting (7396)
  • stopping (7397)
  • GRANT statement
  • implicit issuance (6056)
  • security (8281)
  • use of (6048)
  • GRANT statement; example of (6049)
  • granting authorities and privileges (5893)
    • H
  • HACMP (6552), (6568) See also High Availability Cluster Multi-Processing configurations, High Availability Cluster Multi-Processing configurations
  • HACMP ES (6567)
  • blank NFS server worksheet (6672)
  • blank volume and filesystems worksheet (6670)
  • cascading assignment (6592)
  • cluster configuration (6586)
  • cluster management (6590)
  • Cluster Manager (6645)
  • cluster monitoring (6660)
  • configuration examples (6625)
  • configuring (6600)
  • create container examples (6598)
  • enhanced scalability (6571)
  • Eprimary (6623)
  • event definition example (6641)
  • Event Management (6643)
  • event monitoring (6631)
  • failover (6584)
  • heartbeats (6577)
  • hot standby takeover (6607)
  • installation (6662)
  • keepalive packets (6579)
  • messages (6576)
  • migration (6665)
  • mutual takeover (6605)
  • new install (6664)
  • NFS server node (6611), (6621)
  • NFS server takeover example (6615)
  • NFS server worksheet (6671)
  • node availability (6581)
  • node_down event (6582)
  • non-disruptive maintenance (6629)
  • other scripts (6659)
  • process summary (6649)
  • rc.db2pe (6602)
  • rc.db2pe script (6613)
  • recovery program file (6647)
  • recovery scripts (6657)
  • rotating assignment (6594)
  • rules file (6635)
  • rules file restriction (6639)
  • rules.hacmprd file (6637)
  • script file installation (6653)
  • script files (6651)
  • shutdown (6655)
  • SP frame (6588)
  • SP switch alias address (6619)
  • SP switch considerations (6617)
  • startup recommendations (6627)
  • START_STOP_TIME (6603)
  • switch alias address (6609)
  • unique names (6596)
  • user-defined event (6633)
  • user-defined events (6585)
  • volume and filesystems worksheet (6669)
  • worksheets (6667)
  • HACMP ES configuration examples (6626)
  • HACMP ES rules file (6575)
  • hardware disk arrays (6217)
  • hash join
  • overview of (7126)
  • heartbeats (6578)
  • heuristic operations
  • guidelines (6485), (6504)
  • recovering indoubt transactions (6484)
  • hierarchy table (5605)
  • High Availability Cluster Multi-Processing configurations (6551)
  • hot standby mode (6561)
  • modes of failover support (6555)
  • mutual takeover mode (6565)
  • overview (6554)
  • hot standby mode (6556)
  • hot standby takeover HACMP ES example (6608)
    • I
  • I/O
  • configuration parameters (7594)
  • enabling parallel I/O (7322)
  • prefetch parallel (7319)
  • IBM eNetwork Directory
  • extending the directory schema (8630)
  • object classes and attributes (8632)
  • IBMCATGROUP nodegroup (5497)
  • IBMDEFAULTGROUP nodegroup (5499)
  • IBMTEMPGROUP nodegroup (5498)
  • identifying nicknames (5675)
  • identity sequence (8545)
  • idle agent (7372)
  • images
  • backup (6302)
  • implicit schema use (5409)
  • IMPLICIT_SCHEMA authority (5549)
  • IMPLICIT_SCHEMA privilege, definition of (6011)
  • IMPORT utility
  • binding to a database (5524)
  • LOAD (5590)
  • referential integrity implications for (5593)
  • IN (Intent None) mode (6813)
  • inactive DRDA agent (7377)
  • incompatibilities
  • COLNAMES (planned) (7943)
  • Column Data Type to BIGINT (7951)
  • column mismatch (7952)
  • creating databases (7967), (7975)
  • description (7937)
  • FK_COLNAMES (planned) (7942)
  • foreign key column names (7946)
  • PK_COLNAMES (planned) (7941)
  • planned (7939)
  • primary key column names (7945)
  • read-only views (planned) (7940)
  • SYSCAT.CHECKS Column TEXT (7950)
  • SYSCAT.INDEXES Column COLNAMES (7949)
  • SYSCAT.STATEMENTS column TEXT (7948)
  • SYSCAT.VIEWS column TEXT (7947)
  • Version 5 (7973)
  • Version 6 (7944)
  • incompatibilities for Version 5
  • external table functions (7974)
  • incompatibilities for Version 6
  • character name sizes (7959)
  • current explain mode (7969)
  • datalink columns (7964)
  • dependency codes (7954)
  • event monitor output stream format (7963)
  • FOR UPDATE syntax (7958)
  • Java programming (7957)
  • OBJCAT views (7953)
  • obsolete configuration keywords (7962)
  • obsolete database configuration parameters (7972)
  • PC/IXF format changes (7960)
  • RUMBA (7971)
  • SELECT privilege on hierarchy (7968)
  • SQLNAME in a non-doubled SQLVAR (7961)
  • SYSFUN string function signatures (7965)
  • SYSIBM base catalogs (7955)
  • SYSTABLE column change (7966)
  • USING and SORT BUFFER (7970)
  • VARCHAR data type (7956)
  • index
  • administering (6955)
  • changing (5843)
  • clustering (6958)
  • consideration for outer versus inner table determination (7132)
  • CREATE INDEX statement (5693)
  • CREATE UNIQUE INDEX statement (5696)
  • creating (5678)
  • definition of (5681)
  • definition of index ANDing (7095)
  • definition of index ORing (7094)
  • disadvantages of indexing (6949)
  • DROP INDEX statement (5844)
  • estimating size