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 (8625)
  • $RAHBUFNAME (8626)
  • $RAHCHECKBUF (8627)
  • $RAHENV (8636)
    • A
  • access control (6309)
  • authentication (6310)
  • concurrency, overview (6843)
  • database manager (6443)
  • database objects (6440)
  • using locks (6874)
  • view to table (6467)
  • access path
  • lock attributes, factors affecting (6933)
  • access path selection (6965)
  • access plan
  • cost estimate (7312)
  • created by compiler (7129)
  • db2expln (7294)
  • graphical representation (7302)
  • objects (7303)
  • operators (7305)
  • using explain facility (7297)
  • Visual Explain (7333)
  • ACTIVATE DATABASE command (7441)
  • activating a database (7006)
  • active directory (8686)
  • configuring to use (8690)
  • extending the directory schema (8715)
  • objects (8717)
  • security (8709)
  • active logs (5302)
  • add database wizard (8751)
  • adding a scope (6191)
  • adding constraint (6197)
  • adding containers to DMS table spaces (5633)
  • adding DB2 for OS/390 subsystems (5771)
  • adding node to system
  • restrictions on database operations (7504)
  • when redistributing nodegroup (7540)
  • adding space to a table space (5791)
  • adding table check constraint (6210)
  • adding unique constraint (6198)
  • administration client (5752)
  • Administration Server (5768)
  • administration server (5862)
  • administration tools
  • Command Center (5775)
  • overview (5751)
  • Script Center (5777)
  • administration using GUI tools (5750)
  • ADVISE_INDEX table (8554)
  • ADVISE_INDEX table definition (8563)
  • ADVISE_WORKLOAD table (8555)
  • ADVISE_WORKLOAD table definition (8564)
  • advisor
  • index (7336)
  • agent (7451)
  • high availability (8062)
  • warehouse (5440)
  • agent pool (7455)
  • agent pool size (num_poolagents) database manager parameter (7712)
  • agent process
  • application heap size (applheapsz) parameter (7642)
  • application support layer heap size (aslheapsz) parameter (7654)
  • maximum number of agents (maxagents) parameter (7699)
  • maximum number of concurrent agents (maxcagents) parameter (7701)
  • priority of agents (agentpri) parameter (7697)
  • agent site (5441)
  • agentpri configuration parameter (7698)
  • agents
  • application control heap size, maximum (7624)
  • connection entries, number (7891)
  • governor changes priority of (7487)
  • initial number of agents in pool (num_initagents) database manager parameter (7718)
  • maximum number of coordinating (7704)
  • max_coordagents database manager parameter (7705)
  • pool size, controlling (7713)
  • agent_stack_sz configuration parameter (7647)
  • impact on memory (7367)
  • aggregating function (6044)
  • alias
  • authority (6078)
  • naming rules (8112)
  • using (6077)
  • alias (DB2 for MVS/ESA) (6080)
  • alias address (7995)
  • alias, creating (6074)
  • allow reverse scans (7159), (7171)
  • ALTER COLUMN (6193)
  • ALTER NICKNAME statement, example of (6285)
  • ALTER privilege, definition (6417)
  • ALTER SERVER statement, example of (6281)
  • alter summary table properties (6237)
  • ALTER TABLE statement
  • adding check constraint example (6212)
  • adding columns example (6185)
  • adding keys example (6209)
  • adding unique constraint example (6200)
  • dropping check constraint example (6225)
  • dropping keys example (6222)
  • dropping unique constraint example (6217)
  • tips for adding constraints (6207)
  • ALTER TABLESPACE statement
  • example of (6165), (7030)
  • altering a column (6188)
  • altering a nickname (6283)
  • altering a server (6279)
  • altering a structured type (6240)
  • altering a table (6180)
  • altering constraint (6195)
  • altering nodegroup (6154)
  • altering table space (6162)
  • altering view (6267)
  • applheapsz configuration parameter (7641)
  • impact on memory (7360)
  • application control heap
  • application control heap size (app_ctl_heap_sz) database parameter (7622)
  • application control heap size (app_ctl_heap_sz) databaseparameter (7623)
  • application design
  • acquiring locks (6876)
  • collating sequences, guidelines (8602)
  • deadlock, avoiding (6928)
  • lock compatibility, ensuring (6912)
  • lock escalation (6919)
  • locking considerations (6951)
  • locks, converting of (6917)
  • locks, factors affecting (6931)
  • overriding locks (6943)
  • application program (6545)
  • control heap, setting (7627)
  • database partition server failure detection (6576)
  • governor forces (7486)
  • maximum number of coordinating agents at node (7709)
  • transaction recovery on the failed database partition server (6563)
  • transaction recovery when the database partition server is active (6556)
  • transaction recovery, overview (6546)
  • app_ctl_heap_sz configuration parameter
  • impact on memory (7359)
  • app_ctl_heap_sz database parameter (7625)
  • architecture
  • overview (6771)
  • storage (6781)
  • archive log files
  • for OS/2 (8497)
  • for UNIX-based systems (8502)
  • archive logging (5300)
  • archived logs
  • offline (5305)
  • online (5304)
  • aslheapsz configuration parameter (7656)
  • impact on memory (7368)
  • ATTACH command
  • overview of (5809)
  • specifying Distributed Computing Environment (DCE) information (8477)
  • attribute (5473)
  • attribute data (5465)
  • audit activities (6496)
  • overview (5550)
  • audit facility
  • actions (6502)
  • asynchronous record writing (6508)
  • audit events table (6517)
  • authorities/privileges (6501)
  • behavior (6504)
  • checking events table (6518)
  • CONTEXT events table (6523)
  • controlling activities (6525)
  • error handling (6506)
  • ERRORTYPE parameter (6509)
  • events (6503)
  • examples (6526)
  • messages (6514)
  • OBJMAINT events table (6519)
  • parameter descriptions (6513)
  • record layouts (6516)
  • SECMAINT events table (6520)
  • synchronous record writing (6507)
  • syntax (6511)
  • SYSADMIN events table (6521)
  • tips and techniques (6524)
  • usage scenarios (6510)
  • VALIDATE events table (6522)
  • AUDIT_BUF_SZ (6505)
  • audit_buf_sz configuration parameter (7664)
  • authentication (5368), (6307)
  • DCE security services (6345)
  • definition of (6311)
  • Distributed Computing Environment (DCE) directory services (8462)
  • domain security (8649)
  • federated database overview (5373)
  • federated database processing (6354)
  • groups (8648)
  • partitioned database considerations (6344)
  • remote client (6343)
  • authentication configuration parameter (7961)
  • authentication type (6308)
  • CLIENT (6316)
  • DCE (6334)
  • DCE_SERVER_ENCRYPT (6336)
  • DCS (6330)
  • DCS_ENCRYPT (6332)
  • KERBEROS (6338)
  • KRB_SERVER_ENCRYPT (6341)
  • SERVER (6312)
  • SERVER_ENCRYPT (6314)
  • authority (6383)
  • configuration parameters (7957)
  • database administration (DBADM) (6391), (6409)
  • levels of (6376)
  • removing DBADM from SYSADM (6387)
  • removing DBADM from SYSCTRL (6389)
  • required for BACKUP command (6592)
  • required for REORG utility (7428)
  • required for RESTORE command (6628)
  • required for ROLLFORWARD command (6669)
  • system control (SYSCTRL) (6388)
  • system maintenance (SYSMAINT) (6390)
  • tasks and required authorities (6474)
  • authority level (5371)
  • authorization (5369)
  • definition (6375)
  • federated database overview (5372)
  • overview (5549)
  • system administration (SYSADM) (6384)
  • trusted client (6327)
  • authorization names
  • create view for privileges information (6495)
  • retrieving for privileges information (6481)
  • retrieving names with DBADM authority (6484)
  • retrieving names with table access authority (6487)
  • retrieving privileges granted to (6490)
  • automatic restart (6538)
  • autorestart database configuration parameter (7764)
  • avg_appls configuration parameter (7693)
  • affect on query optimization (7019)
    • B
  • back up database wizard (8753)
  • backbufsz configuration parameter (7613)
  • backing up database
  • fixed-disk media (6616)
  • backup (6582) See also BACKUP command
  • buffer for (6602)
  • container names (6612)
  • display information (6617)
  • frequency (5313)
  • images (6610)
  • invoking (6599)
  • offline (5315)
  • online (5314)
  • planning (6589)
  • planning your strategy (6590)
  • quiesce (6593)
  • storage considerations (5318)
  • user exit program (5326)
  • utility to display (6618)
  • BACKUP command
  • access errors, error handling (6608)
  • authority required (6591)
  • buffer (6603)
  • concurrency control (6606)
  • considerations for (6584)
  • database alias restriction (6600)
  • DB2 Data Links Manager considerations (6702)
  • disk output created (6614)
  • overview of (6583)
  • system crash (6604), (6648)
  • tape output created (6615)
  • use with Tivoli Storage Manager (6733)
  • BACKUP DATABASE utility
  • considerations for user exit program (8536)
  • default backup buffer size (backbufsz) parameter (7612)
  • error handling for user exits (8544)
  • user exit program for OS/2 (8491)
  • Backup Database Wizard (5754)
  • backup domain controller
  • configuring DB2 to use (8640), (8646)
  • backups
  • active (6689)
  • expired (6691)
  • inactive (6690)
  • log chain (6695)
  • log sequence (6693)
  • backup_pending configuration parameter (7819)
  • base address (7994)
  • benchmark program
  • creating (7572)
  • sample report (7577)
  • SQL statements (7570)
  • step summary (7578)
  • benchmarking
  • db2batch tool (7573)
  • overview of (7567)
  • preparations for (7569)
  • testing methods (7568)
  • testing process (7576)
  • bidirectional CCSID support (8597)
  • CCSID table (8598)
  • DB2 Connect implementation (8600)
  • DB2 UDB implementation (8599)
  • BIND command
  • OWNER option (6456)
  • BIND privilege
  • definition of (6436)
  • BINDADD privilege, definition (6402)
  • binding
  • changing configuration parameters (7593)
  • command line processor (5932)
  • database utilities (5933)
  • default for DEGREE option (7013)
  • isolation level, specifying (6868)
  • rebinding invalid packages (6452)
  • block fetch (6975)
  • block-structured devices (5951)
  • books (8723), (8736)
  • broadcast inner-table joins (7240)
  • broadcast outer table joins (7232)
  • buffer pool (6774)
  • binding database applications (7603)
  • choosing number of (7383)
  • consideration for outer versus inner table determination (7212)
  • database managed storage (DMS) (7436)
  • IBMDEFAULTBP (5641)
  • memory required (7381)
  • multiple (7379)
  • overview (5257)
  • overview of (7373)
  • performance considerations (7604)
  • sizing using buffpage configuration parameter (7601)
  • storage considerations (7605)
  • buffpage configuration parameter (7602)
  • affect on query optimization (7016)
  • impact on memory (7352)
  • managing multiple buffer pools (7380)
  • business meta-data (5459)
  • business rules
  • overview (5263)
    • C
  • caching of database (7005)
  • call level interface
  • binding to a database (5937)
  • calling format for user exits
  • for OS/2 (8524)
  • for UNIX-based systems (8526)
  • campus clustering (8071)
  • capacity (5407)
  • capacity management configuration parameters (7598)
  • Cartesian products (7220)
  • star schema (7221)
  • cascading assignment (7986)
  • case-sensitive names, federated database (8118)
  • CATALOG DATABASE
  • example of (5940)
  • CATALOG GLOBAL DATABASE command
  • specifying Distributed Computing Environment (DCE) information (8475)
  • catalog node (6837)
  • connection for data redistribution (7551)
  • description (5823)
  • catalog table space (5605)
  • catalog views
  • COLDIST (7095)
  • COLUMNS (7091)
  • functions (7121)
  • INDEXES (7093)
  • SYSSTAT.COLDIST (7096)
  • SYSSTAT.COLUMNS (7092)
  • SYSSTAT.FUNCTIONS (7122)
  • SYSSTAT.INDEXES (7094)
  • SYSSTAT.TABLES (7090)
  • TABLES (7089)
  • update-capable (7112)
  • catalogcache_sz configuration parameter (7608)
  • cataloging database (5938)
  • catalogs
  • reorganizing (7420)
  • catalog_noauth configuration parameter (7962)
  • cconsole utility (8069)
  • CDS (8415)
  • cell directory service (CDS) (8416)
  • changing database configuration (6147)
  • changing environment variables (6142)
  • changing node configuration file (6145)
  • changing partitioning key (6230)
  • changing passwords (8102)
  • changing registry variables (6143)
  • changing table attributes (6235)
  • character conversion
  • performance considerations (6994)
  • character serial devices (5950)
  • check constraint (5272)
  • checking available space (DMS) (5790)
  • chngpgs_thresh configuration parameter (7679)
  • managing the buffer pool (7374)
  • choosing an extent size (5646)
  • circular logging (5299), (6814)
  • client
  • backing up database, restriction (6650)
  • CLIENT level security (6318)
  • client support
  • client I/O block size (rqrioblk) parameter (7657)
  • TCP/IP service name (svcename) parameter (7841)
  • transaction program name (tpname) parameter (7843)
  • CLIENT, authentication type (6317)
  • clients
  • trusted (6320), (6325)
  • untrusted (6321), (6329)
  • cluster
  • configuration (7981)
  • management (7985)
  • monitoring (8010)
  • clustered index
  • cluster ratio statistic (7181)
  • clustering
  • campus (8073)
  • continental (8074)
  • clustering index (6801)
  • code page
  • DB2CODEPAGE registry variable (8589)
  • guidelines for selecting (6996)
  • RESTORE command (6637)
  • supported Windows code pages (8590)
  • code page support
  • character conversion (6995)
  • codepage configuration parameter (7799)
  • codeset configuration parameter (7797)
  • collate_info configuration parameter (7801)
  • collating sequence
  • collating_sequence option (8605)
  • federated database concerns (8604)
  • general concerns (8601)
  • collating sequence performance ramifications, federated systems (7259)
  • collating_sequence server option (7044)
  • collocated join (7231)
  • collocation
  • data redistribution preservation of (7525)
  • replicated summary tables (7227)
  • collocation, table (5596)
  • column
  • adding (6183)
  • altering (6187)
  • defining (5970)
  • defining for a table (5483)
  • naming rules (8108)
  • column options
  • numeric string (7262)
  • varchar_no_trailing_blanks (7264)
  • column UDF (6043)
  • Command Center (5774)
  • command line processor
  • binding to a database (5934)
  • commands
  • db2evmon (7476)
  • commit
  • errors during two-phase (5681)
  • number of commits to group (mincommit) (7751)
  • two-phase (5679)
  • communication
  • connection retries, number (7905)
  • FCM daemon to agent, request blocks (7898)
  • node, connection elapse time (7870)
  • node, message buffers (7886)
  • communication protocol
  • VI Architecture (8681)
  • communications
  • high speed (8673)
  • communications bandwidth configuration parameter (7026)
  • comm_bandwidth configuration parameter (7943)
  • comm_rate server option (7046), (7048)
  • compatibility
  • partition (5598)
  • compiler
  • overview of (7126)
  • overview of federated database phases (7128)
  • overview of pushdown analysis (7127)
  • overview of query rewrite (7135)
  • overview of remote SQL generation (7132)
  • composite key (5507), (5527)
  • composite tables
  • composite inner (7225)
  • composite outer (7224)
  • compound SQL
  • overview of (6992)
  • performance considerations (6993)
  • concentrator (7458)
  • concurrency
  • controlling using locks (6875)
  • declared temporary tables (6872)
  • overview of (6841)
  • concurrency and granularity
  • effect of locks on (6909)
  • concurrency control
  • BACKUP command (6607)
  • maximum number of active applications (maxappls) parameter (7691)
  • maximum number of concurrently active databases (numdb) parameter (7946)
  • Concurrent Resource Manager (5741)
  • configuration (7581) See also benchmarking
  • changing database manager parameters (7586)
  • changing database parameters (7592)
  • database manager parameters (7583)
  • database parameters (7591)
  • multiple partition (5416)
  • parameter details, overview of (7596)
  • parameter summary, database (7595)
  • parameter summary, database manager (7588)
  • parameters, overview of (7579)
  • tuning parameters (7580)
  • configuration file
  • governor example (7493)
  • configuration file, governor (7490)
  • configuration parameter
  • affecting optimizer (7015)
  • agent communication memory (7650)
  • agent private memory (7629)
  • application communication memory (7651)
  • application shared memory (7620)
  • applications and agents (7690)
  • AUTORESTART (6539)
  • capacity management (7597)
  • communication protocol setup (7838)
  • communications (7837)
  • compiler settings (7830)
  • Database Application Remote Interface (DARI) (7723)
  • database attributes (7788)
  • database management (7784)
  • database manager instance memory (7661)
  • database shared memory (7599)
  • database status (7817)
  • database system monitor (7932)
  • DB2 Data Links Manager (7803)
  • DB2 Discovery (7856)
  • diagnostic information (7927)
  • Distributed Computing Environment (DCE) (8470)
  • distributed services (7849)
  • distributed unit of work (7776)
  • I/O and storage (7677)
  • instance administration (7956)
  • instance management (7926)
  • locks (7668)
  • log activity (7749)
  • log files (7734)
  • logging (7732)
  • parallel operations (7864)
  • partitioned database (5828), (7865)
  • query enabler (7786)
  • recovery (7733), (7759)
  • stored procedure (7722)
  • system management (7941)
  • Tivoli Storage Manager (7761)
  • configuration parameters
  • database logging (6655)
  • DB2 transaction manager considerations (5673)
  • overview (5260)
  • configuration, adding servers when system is running (7509)
  • configuration, adding servers when system is stopped (7513)
  • configuration, changing the size of a (7503)
  • configuration, dropping server with DB2STOP CMD/API (7518)
  • Configure Multisite Update Wizard (5761)
  • configure multisite update wizard (8755)
  • configuring LDAP (8691)
  • configuring LDAP user for applications (8693)
  • CONNECT privilege, definition (6401)
  • CONNECT statement
  • specifying Distributed Computing Environment (DCE) information (8476)
  • connect time reduction (7462)
  • connected applications (7459)
  • connection
  • elapse time (7873)
  • number of retries (7904)
  • connection elapse time (conn_elapse) database manager configuration parameter (7868)
  • connection entry (7893)
  • connection pooling, MTS (5727)
  • conn_elapse configuration parameter (7871)
  • constraint (5520)
  • adding (6196)
  • changing (6194)
  • check (5273)
  • defining unique (5983)
  • dropping (6213)
  • Explain tables (8546)
  • foreign key (5271)
  • NOT NULL (5265)
  • primary key (5269)
  • unique (5267)
  • constraint name
  • defining foreign keys (6001)
  • defining table check constraints (6012)
  • container
  • overview (5254)
  • container names (6613)
  • containers (6785)
  • adding (to DMS table space) (6163)
  • modifying (to DMS table space) (6166)
  • suggestions for parallel I/O (7404)
  • continental clustering (8072)
  • continuous availability (8061)
  • Control Center
  • displaying systems (5767)
  • Event Analyzer (7470)
  • Performance Monitor (7468)
  • Snapshot Monitor (7469)
  • Control Center as a Java Applet (5797)
  • control methods (8067)
  • CONTROL privilege
  • definition of (6416)
  • implicit issuance (6455)
  • package privileges (6435)
  • controlling the rah command (8635)
  • conversion
  • of locks, rules for (6916)
  • cooked devices (5953)
  • coordinate system (5467)
  • Coordinated Universal Time (7913)
  • coordinator agent (6773), (7452)
  • maximum number at node (7710)
  • coordinator database partition, considerations for dropping (7520)
  • coordinator node (5384)
  • copyprotect configuration parameter (7802)
  • correlated subqueries (7148)
  • country configuration parameter (7795)
  • CPU speed configuration parameter
  • affect on query optimization (7023)
  • cpuspeed configuration parameter (7944)
  • cpu_ratio server option (7050)
  • crash recovery (5276), (6535)
  • triggering (6566)
  • CREATE ALIAS statement
  • example of (6079)
  • using (6076)
  • CREATE DATABASE command
  • example of (5906)
  • Create Database Wizard (5755)
  • create database wizard (8757)
  • create index (6099)
  • CREATE INDEX statement
  • example of (6119)
  • online reorganization (6110), (6123)
  • unique index (6121)
  • CREATE NICKNAME (6093)
  • CREATE SERVER (6089)
  • Create Table space Wizard (5757)
  • create table space wizard (8761)
  • CREATE TABLE statement
  • defining check constraints (6013)
  • defining referential constraints (5995)
  • example of (5976)
  • using multiple table spaces (6029)
  • Create Table Wizard (5756)
  • create table wizard (8759)
  • CREATE TABLESPACE statement (6789)
  • example of (5945)
  • CREATE TRIGGER statement
  • example of (6037)
  • CREATE VIEW statement
  • changing column names (6068)
  • example of (6065)
  • CREATE WRAPPER (6085)
  • CREATETAB privilege, definition of (6403)
  • CREATE_NOT_FENCED privilege, definition (6405)
  • creating a function mapping (6047)
  • creating a function template (6050)
  • creating a nickname (6092)
  • creating a server (6088)
  • creating a type mapping (6060)
  • creating a wrapper (6084)
  • creating alias (6075)
  • creating an index extension (6103)
  • creating an index specification (6102)
  • creating an LDAP user (8692)
  • creating schema (5962)
  • creating table (5967)
  • creating table in multiple table spaces (6027)
  • creating table space (5942)
  • creating trigger (6034)
  • creating typed table (6022)
  • creating typed view (6070)
  • creating user-defined distinct type (6055)
  • creating user-defined function (6039)
  • creating user-defined structured type (6057)
  • creating user-defined type (6052)
  • creating view (6061)
  • ctelnet utility (8070)
  • CURRENT DEGREE special register (7011)
  • CURRENT SCHEMA (5966)
  • CURRENT SCHEMA special register (5815)
  • cursor
  • close using WITH RELEASE clause (6949)
  • read only, uncommitted read (6864)
  • updatable, uncommitted read (6865)
  • cursor stability
  • overview of (6856)
  • customized Control Center (5766)
    • D
  • damaged table space (5332)
  • DARI (6999)
  • data
  • caching when database is started (7004)
  • changing distribution (6159)
  • connection entries for agents to pass, number (7892)
  • informational (5432)
  • large object (LOB) (5576)
  • long field (5573)
  • operational (5431)
  • partitioning (5587)
  • data and parity striping by sectors (RAID-5) (5354)
  • data integrity
  • concurrency, overview (6842)
  • protecting using locks (6878)
  • unique index (6104)
  • Data Links access token expiry interval configuration parameter (7806)
  • Data Links number of copies configuration parameter (7808)
  • Data Links time after drop configuration parameter (7810)
  • Data Links token algorithm configuration parameter (7812)
  • Data Links token in upper case configuration parameter (7814)
  • data management (6793)
  • data page (6794)
  • data security
  • controlling database access (6304)
  • importance of (6305)
  • securing system catalog (6492)
  • data source (5379)
  • data sources
  • CPU speed and performance (7278)
  • I/O speed and performance (7279)
  • data transfer
  • overview of (6530)
  • data type
  • column definition (5971)
  • multi-byte character set (5974)
  • data typing
  • overview (5554)
  • Data Warehouse Center (5429)
  • database (5798)
  • activate (7444)
  • agents (7450)
  • altering nodegroup (6155)
  • auto restart enable (autorestart) parameter (7763)
  • backup (6581)
  • backup pending indicator (backup_pending) parameter (7818)
  • before creating (5799)
  • cataloging (5939)
  • changing (6150)
  • changing distribution of data (6158)
  • code page for database (codepage) parameter (7798)
  • codeset for database (codeset) parameter (7796)
  • collating information (collate_info) parameter (7800)
  • configuration parameter summary (7594)
  • configuration parameters (7589)
  • considerations before changing (6130)
  • considerations for creating (5833)
  • country code for database (country) parameter (7794)
  • crash recovery (6568)
  • creating (5905)
  • creating across all nodes (5826)
  • data caching when database is started (7003)
  • database is consistent (database_consistent) parameter (7820)
  • deactivate (7445)
  • determining list of data nodes (6588)
  • directories (5562)
  • distributed (5658)
  • dropping (6152)
  • enabling data partitioning (5821)
  • files (5564)
  • inconsistent after restart (6569)
  • maximum file open per application (maxfilop) parameter (7694)
  • maximum number of concurrently active databases (numdb) parameter (7945)
  • naming rules (8099)
  • non-recoverable (5294)
  • number of containers (numsegs) parameter (7685)
  • object naming rules (8096)
  • on a host system (5665)
  • overview (5225)
  • package dependencies (6300)
  • parameter file SQLDBCON (7590)
  • recoverable (5293)
  • recovering failed database partition server (6574)
  • recovery log (5928)
  • release level (release) parameter (7789)
  • restore (6623)
  • roll-forward changes (6653)
  • storage for an application (7347)
  • territory for database (territory) parameter (7792)
  • transaction recovery on the failed database partition server (6561)
  • transaction recovery when the database partition server is active (6554)
  • transaction recovery, overview (6542)
  • user exit enable (userexit) parameter (7757)
  • user exit status indicator (user_exit_status) parameter (7826)
  • using several databases in a single transaction (5662)
  • database access
  • affect of optimization class (6953)
  • controlling (6303)
  • overview of (7152), (7156)
  • privileges through package with SQL (6460)
  • database administrator (DBADM) authority
  • privileges (6392)
  • retrieving names with (6483)
  • database alias (8095)
  • for BACKUP command (6601)
  • naming rules (8098)
  • RESTORE command (6631)
  • Database Application Remote Interface (DARI) (7000)
  • initial number of fenced DARI processes in pool (num_initdaris) parameter (7730)
  • initialize DARI process with JVM (initdari_jvm) parameter (7728)
  • keep DARI process indicator (keepdari) parameter (7724)
  • maximum number of DARI processes (maxdari) parameter (7726)
  • database configuration
  • app_ctl_heap_sz parameter (7626)
  • changing (6146)
  • created file (5902)
  • database configuration parameter
  • overview (5262)
  • database design
  • logical (5470)
  • physical (5561)
  • database locator objects
  • creating (8423)
  • example (8424)
  • database logs (5295)
  • configuration parameters (6656)
  • Database Managed Space (DMS) (6788)
  • database managed space (DMS) (5251), (5630)
  • database management, configuration parameters (7785)
  • database manager (6543)
  • access control (6442)
  • binding utilities (5931)
  • configuration parameter summary (7587)
  • configuration parameters (7584)
  • default database path (dftdbpath) parameter (7963)
  • governor affect on performance (7500)
  • index (6114)
  • machine node type (nodetype) parameter (7949)
  • naming rules (8097)
  • parameter file db2systm (7585)
  • recovering failed database partition server (6575)
  • start timeout (7917)
  • starting (5801)
  • stop timeout (7918)
  • stopping (5829)
  • transaction recovery on the failed database partition server (6562)
  • transaction recovery when the database partition server is active (6555)
  • transaction recovery, overview (6544)
  • using memory (7344)
  • database manager configuration
  • conn_elapse parameter (7872)
  • fcm_num_anchors parameter (7877)
  • fcm_num_buffers parameter (7882)
  • fcm_num_connect parameter (7890)
  • fcm_num_rqb parameter (7897)
  • java_heap_sz parameter (7667)
  • max_connretries parameter (7906)
  • max_coordagents parameter (7707)
  • max_time_diff parameter (7910)
  • num_initagents parameter (7720)
  • num_poolagents parameter (7716)
  • start_stop_time parameter (7920)
  • database manager configuration parameter
  • overview (5261)
  • database migration (8120)
  • database monitor
  • using (7466)
  • database objects
  • access control (6441)
  • creating (8421)
  • database (5224)
  • example (8422)
  • index (5232)
  • instance (5222)
  • naming rules (8105), (8595)
  • nodegroup (5226)
  • overview (5221)
  • schema (5237)
  • system catalog table (5239)
  • table (5228)
  • view (5230)
  • database partition (5381)
  • synchronization (5361)
  • database partition servers
  • Windows 2000 (8663)
  • Windows NT (8662)
  • database partition, adding to a system with no databases (7507)
  • database partition, adding when system is running (7508)
  • database partition, considerations for dropping a server (7519)
  • database partition, dropping with DB2STOP CMD/API (7517)
  • database partitions, adding to a system (7506)
  • database partitions, adding when system is stopped (7512)
  • database restore (5278)
  • database roll-forward recovery (5282)
  • database seed (6642)
  • database startup cost (7443)
  • database system
  • federated (5377)
  • database system monitor
  • configuration parameters (7933)
  • fcm_num_rqb database manager parameter, tuning (7900)
  • database_consistent configuration parameter (7821)
  • database_level configuration parameter (7791)
  • datalinks configuration parameter (7815)
  • Datalink_Reconcile_Not_Possible state (6710)
  • DataPropagator Relational (DPROPR)
  • overview (6531)
  • date
  • definition of (8608)
  • formats (8615)
  • date strings
  • definition of (8612)
  • datetime values
  • overview of (8607)
  • string representations (8611)
  • DAU (DB_Authentication) (8429)
  • DB2
  • starting on Windows NT (5805)
  • DB2 Administration Server
  • update configuration (5896)
  • update instance lists (5894)
  • using Client Configuration Assistant and Control Center (5893)
  • DB2 Administration Server (DAS) (5873)
  • communications (5878)
  • configuration (5875), (5876)
  • configuring (5867)
  • Control Center communications (5877)
  • creating (5864)
  • enabling discovery of (5889)
  • environment (5887)
  • internode administrative communications (5879)
  • internode administrative communications in partitioned database system (UNIX) (5881)
  • internode administrative communications in partitioned database system (Windows NT) (5883)
  • listing (5866)
  • overview (5863)
  • ownership rules (5861)
  • registry variable considerations (5886)
  • registry variables (5888)
  • removing (5870)
  • security (5885)
  • security considerations (5868)
  • service ports (5880)
  • setting up with partitioned database system (5871)
  • example (5874)
  • starting and stopping (5865)
  • UNIX EEE servers (5882)
  • updating (5869)
  • Windows NT EEE servers (5884)
  • DB2 Connect (6529)
  • connect time reduction (7463)
  • using, for multisite database updates (5666)
  • DB2 Data Links Manager (7804)
  • backup utility considerations (6701)
  • considerations (6696)
  • crash recovery (6697)
  • Datalink_Reconcile_Not_Possible state (6709)
  • Datalink_Reconcile_Pending state (6711)
  • detection of situations requiring reconciliations (6731)
  • garbage collection (6692)
  • indoubt transactions (6700)
  • interactions with recovery (6727)
  • linked files (6703)
  • phases (6698)
  • point in time roll-forward example (6725)
  • reconciliation procedure (6732)
  • reconciling (6730)
  • removing table from Datalink_Reconcile_Not_Possible state (6729)
  • restore utility considerations (6705)
  • restoring databases (6715), (6720)
  • restoring databases from an offline backup without rolling forward (6713)
  • restoring table spaces (6716), (6721)
  • rollforward utility considerations (6706)
  • rolling forward databases to a point in time (6722)
  • rolling forward databases to end of logs (6717)
  • rolling forward table spaces to a point in time (6723)
  • rolling forward table spaces to end of logs (6718)
  • two-phase commit (6699)
  • unlinked files (6704)
  • DB2 for Windows NT Performance Counters (8654)
  • DB2 high availability agent (8084)
  • control methods for (8087)
  • hadb2tab configuration file (8086)
  • registering (8085)
  • DB2 library
  • books (8722)
  • Information Center (8744)
  • language identifier for books (8727)
  • late-breaking information (8729)
  • online help (8737)
  • ordering printed books (8735)
  • printing PDF books (8732)
  • searching online information (8770)
  • setting up document server (8768)
  • structure of (8721)
  • viewing online information (8739)
  • wizards (8747)
  • DB2 shared nothing model (5739)
  • DB2 sync point manager (SPM) (5677)
  • DB2 Syncpoint Manager
  • recovery of indoubt transactions (6762)
  • DB2ACCOUNT (8161)
  • DB2ADMINSERVER (8369)
  • db2adutl utility (6755)
  • DELETE command (6758)
  • EXTRACT command (6757)
  • QUERY command (6756)
  • db2adutl utility examples (6759)
  • DB2ATLD_PORTS (8283)
  • DB2ATLD_PWFILE (8285)
  • db2audit (6512)
  • db2audit.log (6500)
  • db2batch benchmarking tool (7574)
  • DB2BIDI (8163)
  • DB2BPVARS (8311)
  • DB2BQTIME (8275)
  • DB2BQTRY (8277)
  • DB2CHECKCLIENTINTERVAL (8223)
  • DB2CHGPWD_EEE (8287)
  • DB2CHKPTR (8317)
  • db2ckbkp (6619)
  • DB2CLIENTADPT (8269)
  • DB2CLIENTCOMM (8271)
  • DB2CLIINIPATH (8371)
  • DB2CODEPAGE (8165)
  • DB2CODEPAGE registry variable (8593)
  • DB2COMM (8225)
  • DB2CONNECT_IN_APP_PROCESS (8203)
  • DB2COUNTRY (8167)
  • DB2DBDFT (8169)
  • DB2DBMSADDR (8171)
  • DB2DEFPREP (8373)
  • DB2DIRPATHNAME (8267)
  • DB2DISCOVERYTIME (8175)
  • DB2DMNBCKCTLR (8377)
  • db2dmnbckctlr
  • using (8641), (8647)
  • DB2DOMAINLIST (8205)
  • db2empfa (7406)
  • DB2ENVLIST (8207)
  • db2exfmt tool (7316), (8588)
  • db2expln (8566)
  • db2gncol utility (6228)
  • db2gov command (7482)
  • db2govlg command (7498)
  • db2icrt command (5843)
  • db2idrop (6139)
  • db2ilist (6135)
  • DB2INCLUDE (8177)
  • DB2INSTANCE (8209)
  • DB2INSTANCE environment variable
  • defining default instance (5808)
  • DB2INSTDEF (8179)
  • DB2INSTOWNER (8181)
  • DB2INSTPROF (8211)
  • DB2IQTIME (8279)
  • db2iupdt (6137)
  • DB2LDAPCACHE (8389)
  • DB2LDAPHOST (8393)
  • DB2LDAP_BASEDN (8387)
  • DB2LDAP_CLIENT_PROVIDER (8391), (8688)
  • DB2LDAP_SEARCH_SCOPE (8395)
  • db2ldcfg utility (8694)
  • DB2LIBPATH (8213)
  • DB2LOADREC (6673), (8397)
  • DB2LOCK_TO_RB (8399)
  • db2look tool
  • overview of (7125)
  • DB2MAXFSCRSEARCH (6800)
  • DB2MEMDISCLAIM (8323)
  • DB2MEMMAXFREE (8325)
  • DB2MSCS utility
  • DB2MSCS.CFG parameters (8023)
  • overview (8021)
  • setting up a partitioned database system (8029)
  • setting up a single-partition database system (8025)
  • setting up two single-partition database systems for mutual takeover (8027)
  • DB2NBADAPTERS (8229)
  • DB2NBBRECVNCBS (8237)
  • DB2NBCHECKUPTIME (8231)
  • DB2NBDISCOVERRCVBUFS (8185)
  • DB2NBINTRLISTENS (8233)
  • DB2NBRECVBUFFSIZE (8235)
  • DB2NBRESOURCES (8239)
  • DB2NBSENDNCBS (8241)
  • DB2NBSESSIONS (8243)
  • DB2NBXTRANCBS (8245)
  • db2nchg (8669)
  • db2ncrt (8667)
  • db2ndrop (8671)
  • DB2NETREQ (8247)
  • db2nlist (8665)
  • DB2NODE (8215)
  • exported when adding server (7511)
  • db2nodes.cfg file (5900)
  • adding database partitions when redistributing data (7542)
  • dropping database partitions when redistributing data (7543)
  • db2nodes.cfg, having the database manager update (7514)
  • db2nodes.cfg, updating manually (7516)
  • DB2NOEXITLIST (8401)
  • DB2NTMEMSIZE (8333)
  • DB2NTNOCACHE (8315), (8335)
  • DB2NTPRICLASS (8337)
  • DB2NTWORKSET (8339)
  • DB2OPTIONS (8187)
  • DB2PATH (8219)
  • db2perfc (8661)
  • db2perfi (8655)
  • db2perfr (8657)
  • DB2PORTRANGE (8293)
  • DB2PRIORITIES (8343)
  • DB2REMOTEPREG (8403)
  • DB2RETRY (8249)
  • DB2RETRYTIME (8251)
  • DB2ROUTE (8273)
  • DB2ROUTINE_DEBUG (8405)
  • DB2RQTIME (8281)
  • DB2SERVICETPINSTANCE (8253)
  • db2set command (5851), (5856)
  • DB2SLOGON (8189)
  • DB2SORCVBUF (8407)
  • DB2SORT (8409)
  • DB2SOSNDBUF (8255)
  • db2start command (5803)
  • db2stop command (5831)
  • DB2SYSPLEX_SERVER (8257)
  • DB2SYSTEM (8411)
  • DB2TCPCONNMGRS (8259)
  • DB2TIMEOUT (8191)
  • DB2TRACEFLUSH (8197)
  • DB2TRACENAME (8193)
  • DB2TRACEON (8195)
  • DB2TRCSYSERR (8199)
  • db2uexit
  • user exit programs for OS/2 (8511)
  • user exit programs for UNIX-based systems (8516)
  • DB2UPMPR (8413)
  • DB2YIELD (8201)
  • db2_all (8618), (8621)
  • DB2_ANTIJOIN (8295)
  • DB2_AVOID_PREFETCH (8307)
  • DB2_BINSORT (8309)
  • db2_call_stack (8623)
  • DB2_CORRELATED_PREDICATES (8297)
  • DB2_DARI_LOOKUP_ALL (8319)
  • DB2_DISABLE_FLUSH_LOG (8173)
  • DB2_DJ_COMM (8375)
  • DB2_ENABLE_LDAP (8379)
  • DB2_EXTENDED_OPTIMIZATION (8321)
  • DB2_FALLBACK (8381)
  • DB2_FORCE_FCM_BP (8289)
  • DB2_FORCE_NLS_CACHE (8227)
  • DB2_FORCE_TRUNCATION (8383)
  • DB2_GRP_LOOKUP (8385)
  • DB2_HASH_JOIN (8299)
  • db2_kill (8622)
  • DB2_LIC_STAT_SIZE (8183)
  • DB2_LIKE_VARCHAR (8301)
  • DB2_MMAP_READ (8327)
  • DB2_MMAP_WRITE (8329)
  • DB2_NEW_CORR_SQ_FF (8303)
  • DB2_NO_PKG_LOCK (8331)
  • DB2_NUM_FAILOVER_NODES (8291)
  • DB2_OVERRIDE_BPF (8341)
  • db2_override_bpf (7382)
  • DB2_PARALLEL_IO (8217)
  • DB2_PRED_FACTORIZE (8305)
  • DB2_RR_TO_RS (8345)
  • DB2_SORT_AFTER_TQ (8347)
  • DB2_STRIPED_CONTAINERS (8221)
  • DB2_VI_DEVICE (8265)
  • DB2_VI_ENABLE (8261)
  • DB2_VI_VIPL (8263)
  • dbexpln tool
  • data from compiler (7133)
  • dbheap configuration parameter (7607)
  • impact on memory (7354)
  • dbname server option (7052)
  • DB_Authentication (DAU) (8428)
  • DB_Comment (DCO) (8434)
  • DB_Communication_Protocol (DCP) (8437)
  • DB_Database_Locator_Name (DLN) (8443)
  • DB_Database_Protocol (DDP) (8440)
  • DB_Native_Database_Name (DNN) (8446)
  • DB_Object_Type (DOT) (8449)
  • DB_Principal (DPR) (8431)
  • DB_Product_Name (DPN) (8452)
  • DB_Product_Release (DRL) (8455)
  • DB_Target_Database_Info (DTI) (8458)
  • DCE network database
  • connecting (8479), (8480)
  • creating (8478)
  • DCE, authentication type (6335)
  • DCE_SERVER_ENCRYPT, authentication type (6337)
  • DCO (DB_Comment) (8435)
  • DCP (DB_Communication_Protocol) (8438)
  • DCS
  • authentication type (6331)
  • federated database processing (6357)
  • DCS_ENCRYPT, authentication type (6333)
  • DDP (DB_Database_Protocol) (8441)
  • DEACTIVATE DATABASE command (7442)
  • deadlock (6778)
  • deadlock detector (6777)
  • deadlocks
  • checking for (7672)
  • configuration parameter (7673)
  • detecting (6926)
  • overview of (6927)
  • DECLARE CURSOR WITH HOLD statement (6971)
  • DECLARE GLOBAL TEMPORARY TABLE (6018)
  • declared temporary tables
  • concurrency (6871)
  • locking (6940)
  • declustering
  • partial (5589)
  • decorrelation of a query (7146)
  • dedicated interconnect (8678), (8682)
  • default agent site (5442)
  • default attribute specification (5975)
  • default table spaces (6783)
  • defining referential constraint (5989)
  • defining table check constraint (6009)
  • defining table columns (5482)
  • defining unique constraint (5980)
  • DEGREE bind option (7012)
  • DELETE privilege, definition (6420)
  • delete rules (5542)
  • deleting rows from typed tables (6244)
  • dependent row (5533)
  • dependent table (5532)
  • descendent table (5534)
  • design
  • federated database (5656)
  • table space (5636)
  • design of database
  • altering (6131)
  • design, implementing (5800)
  • designing and choosing table spaces (5603)
  • DETACH command
  • overview of (5810)
  • determining problems with rah (8639)
  • dftdbpath configuration parameter (7964)
  • dft_account_str configuration parameter (7951)
  • dft_client_adpt configuration parameter (7855)
  • dft_client_comm configuration parameter (7854)
  • dft_degree configuration parameter (7009), (7017), (7832)
  • dft_extent_sz configuration parameter (7687)
  • dft_loadrec_ses configuration parameter (7767)
  • dft_monswitches configuration parameter (7934)
  • dft_mon_bufpool configuration parameter (7938)
  • dft_mon_lock configuration parameter (7939)
  • dft_mon_sort configuration parameter (7940)
  • dft_mon_stmt configuration parameter (7936)
  • dft_mon_table configuration parameter (7937)
  • dft_mon_uow configuration parameter (7935)
  • dft_prefetch_sz configuration parameter (7684)
  • dft_queryopt configuration parameter (7018), (7833)
  • dft_refresh_age configuration parameter (7834)
  • dft_sqlmathwarn configuration parameter (7831)
  • diaglevel configuration parameter (7929)
  • diagpath configuration parameter (7930)
  • directed inner-table and outer-table joins (7237)
  • directed inner-table join (7243)
  • directed outer-table joins (7235)
  • directories
  • local database directory (5917)
  • node directory (5921)
  • system database directory (5919)
  • directory
  • database (5563)
  • directory cache
  • effect of cataloging databases (5941)
  • directory objects
  • creating (8420)
  • object classes attributes (8427)
  • directory structure (6782)
  • directory under which Java Development Kit 1.1 is installed (jkd11_path) database manager parameter (7952)
  • dir_cache configuration parameter (7663)
  • dir_obj_name configuration parameter (7852)
  • dir_path_name configuration parameter (7851)
  • dir_type configuration parameter (7850)
  • disaster recovery (5337)
  • discover configuration parameter (7858)
  • discover server instance configuration parameter (7863)
  • Discovery
  • configuration (5898)
  • hiding server instances (5891)
  • setting parameters (5892)
  • discovery mode configuration parameter (7859)
  • discover_comm configuration parameter (7860)
  • discover_db configuration parameter (7857)
  • discover_inst configuration parameter (7862)
  • disk
  • array (5343)
  • RAID (Redundant Array of Independent Disks) (5344)
  • striping (5345)
  • disk arrays
  • hardware (5348)
  • software (5355)
  • disk failure
  • protecting against (5342)
  • disk groups (8066)
  • disk mirroring (5357)
  • disk mirroring or duplexing (RAID-1) (5352)
  • disruptive maintenance (8000)
  • Distributed Computing Environment (DCE)
  • ATTACH command (8474), (8482)
  • authentication (6347)
  • CATALOG GLOBAL DATABASE command (8472)
  • CDS (8414)
  • configuration parameters (7848)
  • configuration parameters and registry variables (8469)
  • CONNECT statement (8473), (8483)
  • directory services restrictions (8487)
  • directory services tasks (8485)
  • GDS (8419)
  • how directories are searched (8481)
  • overview of directory services (5923)
  • restrictions (6351)
  • security services (6346)
  • setup DB2 client instance (6350)
  • setup DB2 server (6349)
  • setup DB2 user (6348)
  • temporarily overriding DCE directory information (8484)
  • using directory services (8486)
  • distributed database (5657)
  • distributed request (5378)
  • distributed transaction processing
  • application program (5686)
  • configuration considerations (5708)
  • database connection considerations (5699)
  • error handling (5702)
  • RELEASE statement (5700)
  • resource manager (5694)
  • security considerations (5707)
  • support for host and AS/400 database servers (5698)
  • transaction manager (5692)
  • dlchktime configuration parameter (7671)
  • DLFM_BACKUP_DIR_NAME (8349)
  • DLFM_BACKUP_LOCAL_MP (8351)
  • DLFM_BACKUP_TARGET (8353)
  • DLFM_BACKUP_TARGET_LIBRARY (8355)
  • DLFM_ENABLE_STPROC (8357)
  • DLFM_FS_ENVIRONMENT (8359)
  • DLFM_GC_MODE (8361)
  • DLFM_INSTALL_PATH (8363)
  • DLFM_LOG_LEVEL (8365)
  • DLFM_PORT (8367)
  • DLN (DB_Database_Locator_Name) (8444)
  • dl_expint configuration parameter (7805)
  • dl_num_copies configuration parameter (7807)
  • dl_time_drop configuration parameter (7809)
  • dl_token configuration parameter (7811)
  • dl_upper configuration parameter (7813)
  • DMS (database managed space) (5252), (5631)
  • adding containers to (5634)
  • DMS table space
  • caching of (7437)
  • creating (5948)
  • performance considerations (7435)
  • DNN (DB_Native_Database_Name) (8447)
  • domain security
  • authentication (8650)
  • dos_rqrioblk configuration parameter (7659)
  • DOT (DB_Object_Type) (8450)
  • double byte character set user
  • data type (5973)
  • DPN (DB_Product_Name) (8453)
  • DPR (DB_Principal) (8432)
  • DPROPR (6532) See also DataPropagator Relational (DPROPR)
  • drda_heap_sz configuration parameter (7645)
  • impact on memory (7365)
  • DRL (DB_Product_Release) (8456)
  • drop a system temporary table space (6174)
  • drop a user temporary table space (6176)
  • DROP DATABASE command
  • example of (6153)
  • DROP INDEX statement; example of (6292)
  • DROP NICKNAME statement, example of (6286)
  • DROP SERVER statement, example of (6282)
  • DROP TABLE statement
  • example of (6251)
  • DROP TABLESPACE statement; example of (6173)
  • DROP VIEW statement; example of (6269)
  • dropped table
  • recovery (6676)
  • dropping a nickname (6284)
  • dropping a server (6280)
  • dropping a summary table (6274)
  • dropping a wrapper (6278)
  • dropping constraint (6214)
  • dropping database (6151)
  • dropping index (6287)
  • dropping index extensions (6289)
  • dropping index specifications (6290)
  • dropping node from system
  • when redistributing nodegroup (7541)
  • dropping schema (6178)
  • dropping table (6248)
  • dropping table check constraint (6223)
  • dropping trigger (6257)
  • dropping unique constraint (6215)
  • dropping user table space (6171)
  • dropping user-defined function (6259)
  • dropping user-defined tables (6253)
  • dropping user-defined type (6261)
  • dropping view (6268)
  • DSMI_CONFIG (6739), (6745)
  • DSMI_DIR (6738), (6744)
  • DSMI_LOG (6740), (6746)
  • DTI (DB_Target_Database_Info) (8459)
  • DTP (distributed transaction processing) (5685)
  • dynamic SQL
  • distribution statistics (7104)
  • evaluating optimization class (6961)
  • EXECUTE privilege for database access (6463)
  • explain facility (7320), (7325)
  • setting optimization class (6958)
  • dynexpln (8567)
  • dyn_query_mgmt configuration parameter (7787)
    • E
  • eliminating duplicate entries from machine list (8634)
  • enable Data Links support configuration parameter (7816)
  • enable intra-partition parallelism configuration parameter (7925)
  • engine dispatchable unit (EDU) (6772), (6829)
  • enhanced scalability (ES) (7971)
  • entity (5472)
  • environment variables (5849), (8159)
  • changing (6140)
  • DB2NODE, exported when adding server (7510)
  • setting on OS/2 (5857)
  • setting on UNIX (5860)
  • setting on Windows 95 (5859)
  • setting on Windows NT (5858)
  • Eprimary node of the SP switch (7998)
  • error handling
  • access errors, BACKUP command (6609)
  • access errors, RESTORE command (6636)
  • configuration parameters (7928)
  • log full (6658)
  • system crash during BACKUP (6605), (6649)
  • user exit program (8539)
  • user exit program for OS/2 (8542)
  • ES (enhanced scalability) (7972)
  • estimating size (5789)
  • estimating size requirements for
  • index space (5581)
  • large object (LOB) data (5579)
  • log file space (5583)
  • long field data (5575)
  • tables (5567)
  • temporary work space (5585)
  • estore_seg_sz (6836)
  • estore_seg_sz configuration parameter (7688)
  • impact on memory (7356)
  • event monitoring (8002)
  • event snapshots (7475)
  • exclusive mode
  • reasons for using (6948)
  • EXECUTE privilege
  • database access with dynamic SQL (6464)
  • database access with static SQL (6462)
  • definition of (6437)
  • EXPLAIN (7321)
  • explain
  • FOR SNAPSHOT (7326)
  • Visual (7293), (7332)
  • WITH SNAPSHOT (7327)
  • explain facility
  • analysis (7299)
  • capturing information (7295), (7318)
  • choosing a tool (7290)
  • concepts (7300)
  • data from compiler (7131)
  • data organization (7307)
  • dbexpln tool (7134)
  • decision-making (7329)
  • explain instance (7309)
  • graphical representation (7301)
  • instance information (7310)
  • keywords (7313)
  • objects (7304)
  • obtaining data (7317)
  • operators (7306)
  • overview of (7289)
  • snapshot information (7314)
  • statement information (7311)
  • table information (7315)
  • using (7296)
  • explain instance (7308)
  • explain snapshot (7324)
  • explain table format tool (8587)
  • explain tables
  • accessing (7291)
  • explain tool (8565)
  • aggregation (8582)
  • command options (8570), (8572)
  • data streams (8578)
  • description of output (8573)
  • examples of db2expln and dynexpln output (8586)
  • federated statement processing (8584)
  • insert, update, and delete (8579)
  • joins (8577)
  • miscellaneous statements (8585)
  • parallel processing (8583)
  • row identifier (RID) preparation (8580)
  • running (8568)
  • syntax (8569), (8571)
  • table access (8574)
  • temporary tables (8576)
  • EXPLAIN_ARGUMENT table (8547)
  • EXPLAIN_ARGUMENT table definition (8556)
  • EXPLAIN_INSTANCE table (8548)
  • EXPLAIN_INSTANCE table definition (8557)
  • EXPLAIN_OBJECT table (8549)
  • EXPLAIN_OBJECT table definition (8558)
  • EXPLAIN_OPERATOR table (8550)
  • EXPLAIN_OPERATOR table definition (8559)
  • EXPLAIN_PREDICATE table (8551)
  • EXPLAIN_PREDICATE table definition (8560)
  • EXPLAIN_STATEMENT table (8552)
  • EXPLAIN_STATEMENT table definition (8561)
  • EXPLAIN_STREAM table (8553)
  • EXPLAIN_STREAM table definition (8562)
  • explicit schema use (5813)
  • extended storage (6834)
  • extended storage cache (7478)
  • Extended UNIX Code (EUC)
  • code page support (6997)
  • extent (6787)
  • extent map pages (EMP) (6791)
  • extent size (5255), (5604)
  • choosing (5647), (7391)
    • F
  • failover (7980)
  • overview (8058)
  • failover support (5735), (7970), (8013), (8056)
  • concurrent access mode (5738)
  • hot standby mode (5736), (5742)
  • instance failover (5743)
  • multiple logical node failover (5745)
  • mutual instance failover (5747)
  • mutual partition failover (5748)
  • mutual takeover mode (5737), (5746)
  • partition failover (5744)
  • reconnecting after a failover (5749)
  • failover time (8093)
  • fast communication manager (FCM) (6830)
  • FCM Connection Entries (fcm_num_connect) parameter (7888)
  • fcm_num_buffers database manager parameter (7881)
  • message anchors, number, specifying (7878)
  • message buffers, number, specifying (7884)
  • number of FCM message anchors fcm_num_anchors database manager parameter (7875)
  • Number of FCM Request Blocks (fcm_num_rqb) parameter (7895)
  • fault monitoring (8089)
  • fault tolerance (8060)
  • FCM buffers (fcm_num_buffers) database manager configuration parameter (7880)
  • FCM communications (5904)
  • FCM connection entries (fcm_num_connect) database manager parameter (7887)
  • FCM tuning (7372)
  • fcm_num_anchors configuration parameter (7876)
  • fcm_num_buffers configuration parameter (7883)
  • fcm_num_connect configuration parameter (7889)
  • fcm_num_rqb database manager configuration parameter (7896)
  • federated configuration parameter (7955)
  • federated database
  • APPC setting (6371)
  • authentication (5374)
  • authentication details (6353)
  • authentication example (6373)
  • authorization (5375)
  • case-sensitive names (8117)
  • collating sequences, guidelines (8603)
  • compiler phases (7251)
  • DCS setting (6356)
  • design considerations (5655)
  • function mapping, creating (6046)
  • function template, creating (6049)
  • index specification, creating (6098)
  • nickname, creating (6090)
  • nickname, identifying (6096)
  • nickname, working with (6095)
  • object names (8115)
  • passing IDs and passwords to data sources (6359)
  • pushdown analysis (7254)
  • referencing nicknames (6094)
  • remote SQL generation (7272)
  • server options, security (6365)
  • server, creating (6086)
  • systems (5376)
  • type mapping, creating (6058)
  • user mapping, creating (6362)
  • wrapper, creating (6082)
  • federated database system support configuration parameter (7954)
  • FETCH FIRST clause (6970)
  • file
  • database (5565)
  • fileserver configuration parameter (7845)
  • filter (5765)
  • finding errors
  • data redistribution log file (7562)
  • first active log file (loghead) parameter (7748)
  • first normal form (5516)
  • first-fit order (5572)
  • flush logs (5308)
  • fold_id server option (7054)
  • fold_pw server option (7056)
  • FOR FETCH ONLY clause (6968), (6988)
  • FOR READ ONLY clause (6967), (6987)
  • FOR UPDATE clause (6966), (6989)
  • foreign key (5526)
  • adding (6204)
  • composite (6000)
  • constraint name (5999)
  • DROP FOREIGN KEY clause, ALTER TABLE statement (6220)
  • IMPORT utility, referential integrity implications for (6007)
  • LOAD utility, referential integrity implications for (6006)
  • privileges required for dropping (6221)
  • rules for foreign key definitions (5998)
  • FOREIGN KEY clause
  • referential constraints (5996)
  • rules for foreign key definitions (5997)
  • foreign key constraint (5270)
  • fourth normal form (5519)
  • free space control record (FSCR) (6795)
  • frequent value statistics
  • equality predicates (7109)
  • number to collect (7105)
  • overview of (7102)
  • rules for updating (7117)
  • FSCR (6796)
  • function invocation
  • selectivity (6128)
  • function mapping, creating (6048)
  • function template, creating (6051)
    • G
  • garbage collection (6688)
  • gateway connections (5772)
  • GDS (8417)
  • generate DDL (5764)
  • generated column (6015), (6227)
  • generation, remote SQL
  • overview (7271)
  • geocoding (5468)
  • geographic information system (GIS) (5462)
  • GIS (geographic information system) (5463)
  • global directory service (GDS) (8418)
  • global level profile registry (5853)
  • global optimization
  • analyzing (7287)
  • explain tool cost information (7288)
  • nickname characteristics, affecting (7281)
  • server characteristics, affecting (7275)
  • governor
  • configuration file (7489)
  • configuration file example (7492)
  • daemon (7484)
  • database manager performance (7499)
  • db2gov (7483)
  • db2govlg (7497)
  • error handling (7488)
  • log file (7495)
  • obtains statistics (7485)
  • purpose (7479)
  • querying log file (7496)
  • rules (7491)
  • starting (7480)
  • stopping (7481)
  • GRANT statement
  • implicit issuance (6453)
  • security (8467)
  • use of (6445)
  • GRANT statement; example of (6446)
  • granting authorities and privileges (5785)
    • H
  • HA.config file (8090)
  • HA-NFS (8068)
  • HACMP (high availability cluster multi-processing) (5734), (7969)
  • HACMP ES configuration examples (7999)
  • hardware disk arrays (5350)
  • hardware environments (5406)
  • logical database partitions (5424)
  • partitions with multiple processors (5422)
  • partitions with one processor (5419)
  • single partition, multiple processors (5414)
  • single partition, single processor (5411)
  • types of parallelism (5426)
  • hash join
  • overview of (7207)
  • heartbeat (7976), (8059)
  • heuristic operations (5706)
  • hierarchy table (6026)
  • dropping (6252)
  • high availability (5732), (8012), (8055)
  • high availability cluster multi-processing (HACMP) (5733), (7968)
  • high availability on Sun Cluster 2.2
  • applications connecting to an HA instance (8075)
  • crash recovery (8081)
  • data replication (8082)
  • database and database manager configuration parameters (8080)
  • DB2 high availability agent (8083)
  • DB2 installation location and options (8079)
  • disk layout for EE and EEE instances (8076)
  • hadb2_setup command (8092)
  • home directory layout for EE and EEE instances (8077)
  • logical hosts and DB2 UDB EEE (8078)
  • setup (8091)
  • troubleshooting (8094)
  • high speed communications (8675)
  • historical data
  • overview (5551)
  • hot standby configuration (7982)
  • example (7989)
  • HTML
  • sample programs (8726)
    • I
  • I/O
  • configuration parameters (7678)
  • enabling parallel I/O (7402)
  • prefetch parallel (7399)
  • I/O parallelism (5389)
  • IBM eNetwork Directory
  • extending the directory schema (8712)
  • object classes and attributes (8719)
  • IBMCATGROUP (5607)
  • IBMCATGROUP nodegroup (5908)
  • IBMDEFAULTGROUP (5613)
  • IBMDEFAULTGROUP nodegroup (5910)
  • IBMTEMPGROUP (5621)
  • IBMTEMPGROUP nodegroup (5909)
  • identifying candidate key columns (5508)
  • identifying nicknames (6097)
  • identity column (5510), (6020)
  • idle agent (7448), (7454)
  • images
  • backup (6611)
  • implicit schema use (5814)
  • IMPLICIT_SCHEMA authority (5964)
  • IMPLICIT_SCHEMA privilege, definition of (6406)
  • IMPORT utility
  • binding to a database (5935)
  • LOAD (6005)
  • referential integrity implications for (6008)
  • IN (Intent None) mode (6896)
  • inactive agent (7449)
  • inactive DRDA agent (7461)
  • INCLUDE clause (6807)
  • incompatibilities
  • COLNAMES (planned) (8127)
  • Column Data Type to BIGINT (8136)
  • column mismatch (8137)
  • creating databases (8152)
  • description (8121)
  • FK_COLNAMES (planned) (8126)
  • foreign key column names (8131)
  • PK_COLNAMES (planned) (8125)
  • planned (8123)
  • primary key column names (8130)
  • read-only views (planned) (8124)
  • SYSCAT.CHECKS Column TEXT (8135)
  • SYSCAT.INDEXES Column COLNAMES (8134)
  • SYSCAT.STATEMENTS column TEXT (8133)
  • SYSCAT.VIEWS column TEXT (8132)
  • Version 6 (8129)
  • Version 7 (8128)
  • incompatibilities for Version 6
  • character name sizes (8144)
  • current explain mode (8154)
  • DATALINK columns (8149)
  • dependency codes (8139)
  • event monitor output stream format (8148)
  • FOR UPDATE syntax (8143)
  • Java programming (8142)
  • OBJCAT views (8138)
  • obsolete configuration keywords (8147)
  • obsolete database configuration parameters (8157)
  • PC/IXF format changes (8145)
  • RUMBA (8156)
  • SELECT privilege on hierarchy (8153)
  • SQLNAME in a non-doubled SQLVAR (8146)
  • SYSFUN string function signatures (8150)
  • SYSIBM base catalogs (8140)
  • SYSTABLE column change (8151)
  • USING and SORT BUFFER (8155)
  • VARCHAR data type (8141)
  • index
  • administering (7039)
  • changing (6288)
  • clustering (7042)
  • consideration for outer versus inner table determination (7213)
  • CREATE INDEX statement (6117)
  • CREATE UNIQUE INDEX statement (6120)
  • creating (6101)
  • definition of (6105)
  • definition of index ANDing (7179)
  • definition of index ORing (7178)
  • disadvantages of indexing (7033)
  • DROP INDEX statement (6291)
  • guidelines for indexing (7036)
  • how used (6116)
  • index advisor (7034)
  • index re-creation time (indexrec) parameter (7765)
  • index-only access (8575)
  • index-only access (7176)
  • indexing versus no indexing (7032)
  • lock mode (6939)
  • look-up, affect on locks (6934)
  • management, overview of (7031)
  • multiple (7177)
  • naming rules (8109)
  • nickname performance considerations (7284)
  • non-unique (6118)
  • nonprimary (6297)
  • optimizing number (6108)
  • overview (5233)
  • prefetch (7389)
  • primary (5987)
  • primary versus user-defined (6107)
  • privileges (6439)
  • reorganizing (7423), (7430)
  • scan (7162)
  • selectivity (6127)
  • structure (7161)
  • unique (6122)
  • user-defined extended (6126)
  • index advisor (7035), (7335)
  • index clustering
  • cluster factor statistic (7085)
  • cluster ratio statistic (7084)
  • index creation (7040)
  • index extension (6100)
  • index key (5236)
  • index key, definition (6109)
  • index management (6804)
  • index page prefetch (7388)
  • index pointer (6805)
  • INDEX privilege, definition (6422)
  • index reorganization (7038)
  • index scan (6797)
  • clustered index (7180)
  • ordering data (7175)
  • overview of (7158)
  • predicate (7169)
  • predicate terminology (7185)
  • previous leaf pointers (7165)
  • search process (7163)
  • to delimit a range (7167)
  • use of (7164)
  • WHERE clause, use of (7170)
  • index space
  • estimating size requirements for (5580)
  • Index Wizard (5758)
  • index wizard (8763)
  • indexes
  • online reorganization (6112), (6125)
  • indexrec configuration parameter (7766)
  • indexsort configuration parameter (7682)
  • indoubt transactions (5703)
  • manual recovery of (5705)
  • recovering (5682), (5693)
  • recovering on the host (6760)
  • recovery when not using DB2 Syncpoint Manager (6763)
  • recovery when using DB2 Syncpoint Manager (6761)
  • resynchronizing (5683)
  • information catalog (5457)
  • Information Center (8745)
  • informational data (5433)
  • initdari_jvm configuration parameter (7729)
  • initial number of agents in pool (num_initagents) database manager parameter (7717)
  • inner-table and outer-table joins, method (7238)
  • inner-table join, method (7241), (7244)
  • input and output (I/O) considerations
  • table space (5638)
  • INSERT privilege, definition (6423)
  • insert rules (5540)
  • installing
  • Netscape browser (8742)
  • instance (5769)
  • adding a partition server (8666)
  • changing a partition server (8668)
  • default (5839)
  • definition (5834)
  • directory (5837)
  • dropping a partition server (8670)
  • overview (5223)
  • owner (5841)
  • removing (6138)
  • setting the current (5845)
  • instance level profile registry (5852)
  • instance owner (5842)
  • instance parallelism support (7008)
  • instance profile registry (5855)
  • instance user
  • setting the environment (5840)
  • instances
  • altering (6133)
  • auto-starting (5846)
  • creating (5838)
  • disadvantages (5836)
  • listing (5844), (6134)
  • listing database partition servers (8664)
  • overview of (5806)
  • reasons for using (5835)
  • running multiple (5847)
  • starting (5804)
  • stopping (5832)
  • time difference among nodes, maximum (7912)
  • updating (6136)
  • inter-node communications (8674)
  • inter-partition parallelism (5397)
  • used with intra-partition parallelism (5399)
  • inter-query parallelism (5392)
  • intra-partition parallelism (5395), (7403)
  • enabling (5818)
  • used with inter-partition parallelism (5398)
  • intra-query parallelism (5393)
  • intra_parallel configuration parameter (7007), (7924)
  • io_ratio server option (7058)
  • ipx_socket configuration parameter (7847)
  • IS (Intent Share) mode (6897)
  • isolation level (6810)
  • choosing (6866)
  • cursor stability (6859)
  • description of (6844)
  • read stability (6855)
  • repeatable read (6849)
  • specifying, overview (6867)
  • uncommitted read (6860)
  • issuing commands to multiple database partition servers (8617)
  • IX (Intent Exclusive) mode (6900)
    • J
  • java applet (5796)
  • java_heap_sz database manager configuration parameter (7666)
  • jdk11_path database manager configuration parameter (7953)
  • join
  • Cartesian products (7219)
  • composite tables (7223)
  • definition of (7198)
  • eliminating redundancy (7141)
  • enumeration algorithm (7218)
  • hash join (7206)
  • merge join (7204)
  • nested loop join (7203)
  • optimizer search strategies (7216)
  • outer versus inner table determination (7208)
  • overview of (7201)
  • shared aggregation (7142)
  • subquery transformation by optimizer (7140)
  • tables (7199)
  • join path (5513)
  • join strategies (7228)
  • broadcast inner-table (7242)
  • broadcast outer table (7233)
  • collocated (7230)
  • directed inner-table (7245)
  • directed inner-table and outer-table (7239)
  • directed outer-table (7236)
  • in a partitioned database (7229)
    • K
  • keepalive packets (7977)
  • keepdari (6825)
  • keepdari configuration parameter (7725)
  • Kerberos security protocol (6340)
  • KERBEROS, authentication type (6339)
  • key (5503)
  • partitioning (5594)
  • key columns
  • identifying (5509)
  • KRB_SERVER_ENCRYPT, authentication type (6342)
    • L
  • language identifier
  • books (8728)
  • Large Object (LOB)
  • column considerations (5977)
  • large object (LOB) data
  • column definition (5484)
  • estimating size requirements for (5577)
  • large objects
  • DMS storage (7440)
  • late-breaking information (8730)
  • LDAP (5795), (5925), (8685)
  • License Center (5781)
  • license information
  • altering (6132)
  • license management (5848)
  • Lightweight Directory Access Protocol (5794)
  • lightweight directory access protocol (5924), (8684)
  • attaching remotely (8699)
  • cataloging a node entry (8696)
  • configure host databases (8703)
  • DB2 Connect (8707)
  • deregistering databases (8700)
  • deregistering servers (8697)
  • disable (8706)
  • enable (8705)
  • extending directory schema (8710)
  • IBM eNetwork Directory (8711)
  • object classes and attributes (8718)
  • refreshing entries (8701)
  • registering databases (8698)
  • searching (8702)
  • security (8708)
  • setting registry variables (8704)
  • updating protocol information (8695)
  • Windows 2000 Active Directory (8713)
  • LIST INDOUBT TRANSACTIONS command (5704)
  • LIST NODES CMD
  • backing up database, determining list of data nodes (6586)
  • LIST NODES command, using when backing up database (6585)
  • LOAD authority (6393)
  • LOAD utility
  • overview (6527)
  • LOB (large object) data
  • column definition (5485)
  • estimating size requirements for (5578)
  • local database directory
  • overview of (5918)
  • Locate (5773)
  • lock definition (6809)
  • lock escalation (6812)
  • LOCK TABLE statement
  • in minimizing escalations (6922)
  • use to override locks (6942)
  • locking (6808)
  • declared temporary tables (6941)
  • maximum percent of lock list before escalation (maxlocks) parameter (7674)
  • maximum storage for lock lists (locklist) parameter (7616)
  • time interval for checking deadlock (dlchktime) parameter (7670)
  • locklist configuration parameter (7617)
  • affect on query optimization (7021)
  • impact on memory (7353)
  • locks
  • acquiring (6877)
  • attributes of (6879)
  • attributes, types of processing (6932)
  • avoiding global deadlocks (6925)
  • compatibility of, ensuring (6911)
  • configuration parameter (7669)
  • conversion of (6915)
  • creating, using cursor stability (6858)
  • creating, using repeatable read (6848)
  • deadlock, using FOR UPDATE OF (6929)
  • duration attribute (6881)
  • escalation and actions to take (6921)
  • escalation of (6918)
  • exclusive (X) mode (6891)
  • exclusive mode, reasons for using (6947)
  • factors affecting (6930)
  • improving concurrency (6920)
  • intent exclusive (IX) mode (6888)
  • intent none (IN) mode (6885)
  • intent share (IS) mode (6886)
  • locktimeout configuration parameter (6924)
  • mode attribute (6882)
  • modes for index scan (6938)
  • modes for table scan (6936)
  • object attribute (6880)
  • overview of (6873)
  • read stability (6854)
  • reducing waits for (6923)
  • share (S) mode (6887)
  • share mode, reasons for using (6945)
  • share with intent exclusive (SIX) mode (6889)
  • state (mode), types of (6884)
  • superxclusive (Z) mode (6892)
  • update (U) mode (6890)
  • LOCKSIZE clause (6811)
  • locktimeout configuration parameter (7676)
  • log
  • audit (6498)
  • log buffer (6779), (6817)
  • log file space
  • estimating size requirements for (5582)
  • log files
  • governor log file (7494)
  • written for data redistribution (7561)
  • log sequence (6694)
  • logbufsz configuration parameter (6661), (7610)
  • logfilsiz configuration parameter (6660), (7737)
  • logging (6780), (6813)
  • archive (5298)
  • circular (5297)
  • raw devices (5959)
  • loghead configuration parameter (7747)
  • logical database design (5469)
  • deciding what data to record (5471)
  • defining tables (5476)
  • relationships (5477)
  • logical database partitions (5423)
  • logical host (8064)
  • logical network interface (8065)
  • logpath configuration parameter (7745)
  • logprimary configuration parameter (6657), (7739)
  • logretain configuration parameter (6664), (7756)
  • logs
  • active (5301)
  • change database log path (newlogpath) parameter (7742)
  • configuration parameters affecting log activity (7750)
  • configuration parameters affecting log files (7735)
  • database (5296)
  • first active log file (loghead) parameter (7746)
  • identifying (6679)
  • location (6680)
  • location of log files (logpath) parameter (7744)
  • log buffer size (logbufsz) parameter (7609)
  • log retain enable (logretain) parameter (7755)
  • log retain status indicator (log_retain_status) parameter (7824)
  • losing (6684)
  • managing (6678)
  • number of primary log files (logprimary) parameter (7738)
  • number of secondary log files (logsecond) parameter (7740)
  • online archived logs (5303)
  • recovery range and soft checkpoint interval (softmax) parameter (7753)
  • size of log files (logfilsiz) parameter (7736)
  • storage required (5323)
  • use of timestamp (6681)
  • userexit program (5324)
  • logsecond configuration parameter (6659), (7741)
  • log_retain_status configuration parameter (7825)
  • long field data
  • DMS storage (7439)
  • estimating size requirements for (5574)
  • losing logs (6683)
    • M
  • managing DB2 for OS/390 objects (5770)
  • managing remote databases (5782)
  • managing storage (5788)
  • managing users (5784)
  • map
  • partitioning (5591)
  • mapping
  • table spaces to buffer pools (5639)
  • table spaces to nodegroups (5642)
  • tables to table spaces (5644)
  • maxagents (6833), (7456)
  • maxagents configuration parameter (7700)
  • effect on memory (7351)
  • maxappls (6832)
  • maxappls configuration parameter (7692)
  • effect on memory (7350)
  • maxcagents configuration parameter (7702)
  • maxdari configuration parameter (7727)
  • maxfilop configuration parameter (7695)
  • maximum Java interpreter heap size (java_heap_sz) database manager parameter (7665)
  • maximum number of coordinating agents (max_coordagents) database manager parameter (7703)
  • maximum query degree of parallelism configuration parameter (7025), (7923)
  • maximum time difference among nodes (max_time_diff) database manager parameter (7907)
  • maxlocks configuration parameter (7675)
  • affect on query optimization (7022)
  • maxtotfilop configuration parameter (7696)
  • max_connretries database manager configuration parameter (7903)
  • max_coordagents database manager configuration parameter (7706)
  • max_logicagents configuration parameter (7711)
  • max_querydegree configuration parameter (7010), (7922)
  • max_time_diff database manager configuration parameter (7909)
  • media failure
  • catalog node considerations (5340)
  • logs (5322)
  • reducing the impact of (5339)
  • memory
  • agent communication memory (7652)
  • agent private memory (7630)
  • application communication memory (7653)
  • application heap size (applheapsz) parameter (7640)
  • application shared memory (7621)
  • application support layer heap size (aslheapsz) parameter (7655)
  • configuration parameters (7348)
  • considerations for system administrator (SYSADM) (7342)
  • database heap (dbheap) parameter (7606)
  • database manager instance (7660)
  • database shared memory (7600)
  • extending (7477)
  • for processing a database (7346)
  • package cache size (pckcachesz) parameter (7618)
  • setting parameter values (7370)
  • sort heap size (sortheap) parameter (7632)
  • sort heap threshold (sheapthres) parameter (7635)
  • statement heap size (stmtheap) parameter (7637)
  • use by the database manager (7345)
  • use of (7340)
  • when committed (7371)
  • memory model (6828)
  • memory usage
  • application control heap (7628)
  • merge join
  • outer versus inner table determination (7215)
  • overview of (7205)
  • message anchor (7879)
  • messages
  • audit facility (6515)
  • meta-data (5458)
  • methods
  • Sun Cluster (8063)
  • Microsoft Cluster Server (MSCS) (8014)
  • Microsoft Transaction Server
  • connection pooling (5726)
  • connection pooling using ADO 2.1 and later (5728)
  • enabling support in DB2 (5719)
  • installation and configuration (5721)
  • reusing ODBC connections (5729)
  • software prerequisites (5720)
  • supported DB2 database servers (5724)
  • testing DB2 with sample application (5731)
  • transaction time-out and DB2 connection behavior (5725)
  • tuning TCP/IP communications (5730)
  • verifying the installation (5722)
  • migration
  • database (8119)
  • migration tasks for HACMP ES (8011)
  • mincommit configuration parameter (6662), (7752)
  • minimum recovery time (6672)
  • MINPCTUSED (7037), (7433)
  • MINPCTUSED clause (6124), (6806)
  • min_priv_mem configuration parameter (7648)
  • modifying a column (6189)
  • modifying a table (6181)
  • monitor switches (7471)
  • monitoring (7472)
  • monitoring rah processes (8628)
  • mon_heap_sz configuration parameter (7662)
  • moving data (5787), (6528)
  • MPP environment (5418)
  • MSCS (Microsoft Cluster Server) (8015)
  • multi-partition nodegroup (5386)
  • multimedia objects (5475)
  • multipage_alloc configuration parameter (7829)
  • effect on memory (7405)
  • multiple buffer pages, allocating (7407)
  • multiple instances (5807)
  • use with Tivoli Storage Manager (6751)
  • multiple logical node (6827)
  • multiple logical nodes (8672)
  • multiple logical partition (6826)
  • multiple partition configurations (5415)
  • multisite update (5663), (5667), (6838)
  • configuration parameters (7777)
  • host or AS/400 applications accessing a DB2 UDB server (5674)
  • mutual takeover configuration (7983)
  • example (7990)
    • N
  • naming
  • Windows NT restrictions (8643)
  • national language support (NLS)
  • bidirectional CCSID support (8596)
  • character sets (8594)
  • datetime values (8606)
  • nested loop join
  • outer versus inner table determination (7211)
  • overview of (7202)
  • Netscape browser
  • installing (8743)
  • newlogpath configuration parameter (6663), (7743)
  • NFS server node (7991)
  • NFS server takeover configuration example (7992)
  • nickname
  • creating (6091)
  • package privilege processing (6466)
  • privileges (6430)
  • views across data sources (6472)
  • nickname query performance tips (6986)
  • nicknames
  • creating indexes on (7285)
  • gathering statistics (7073)
  • global optimization, characteristics affecting (7282)
  • pushdown analysis (7256)
  • pushdown analysis, characteristics affecting (7260)
  • view statistics (7075)
  • nname configuration parameter (7840)
  • node (5816)
  • cataloging (5822)
  • changing in nodegroup (6156)
  • connection elapse time (7869)
  • coordinating agent, maximum (7708)
  • creating database across all (5827)
  • data location, determining (5593)
  • data redistribution, process (7550)
  • determining list of data nodes (6587)
  • determining where RUNSTATS execution occurs (7081)
  • failed database partition server, recovering (6571)
  • maximum number of connection retries (7902)
  • maximum time difference among (7908)
  • message buffers, number, specifying (7885)
  • other operations during redistribution (7565)
  • redistributing data across database partitions (7521)
  • transaction recovery on a failed database partition server (6564)
  • transaction recovery on an active database partition server (6551)
  • node configuration file
  • changing (6144)
  • creating (5899)
  • node configuration file, having the database manager update (7515)
  • node connection retries (max_connretries) (7901)
  • node level profile registry (5854)
  • node number (5901)
  • node server option (7060)
  • node synchronization (5360)
  • nodegroup
  • altering (6157)
  • creating (5926)
  • IBMDEFAULTGROUP, table created in by default (6033)
  • initial definition (5907)
  • other operations during redistribution (7564)
  • partitioning key, changing (6233)
  • recovering failed database partition server (6577)
  • redistributing data (7522)
  • table considerations (6032)
  • transaction recovery on a failed database partition server (6565)
  • transaction recovery when a database partition server is active (6557)
  • nodegroups (5385)
  • designing (5586)
  • IBMCATGROUP (5610)
  • IBMDEFAULTGROUP (5616)
  • IBMTEMPGROUP (5624)
  • overview (5227)
  • nodetype configuration parameter (7950)
  • node_down event (7979)
  • node_up event (7978)
  • non-disruptive maintenance (8001)
  • non-recoverable databases (5292)
  • non-unique index
  • dropping (6295)
  • nonprimary index
  • dropping (6294)
  • dropping implications for applications (6298)
  • normalizing tables (5514)
  • NOT NULL constraint (5264)
  • notifylevel configuration parameter (7931)
  • NS (Next Key Share) mode (6898)
  • NT_SCATTER_DMSDEVICE (8313)
  • NT_SCATTER_DMSFILE (8312)
  • NT_SCATTER_SMS (8314)
  • NULL value (5502)
  • null value
  • column definition (5972)
  • number of database backups configuration parameter (7769)
  • number of FCM message anchors (fcm_num_anchors) database manager parameter (7874)
  • number of FCM request blocks (fcm_num_rqb) database manager parameter (7894)
  • numdb (6831)
  • numdb configuration parameter (7947)
  • effect on memory (7349)
  • numeric string column option (7263)
  • numsegs configuration parameter (7686)
  • num_db_backups configuration parameter (7768)
  • num_estore_segs (6835)
  • num_estore_segs configuration parameter (7689)
  • impact on memory (7357)
  • num_freqvalues configuration parameter (7835)
  • num_initagents database manager configuration parameter (7719)
  • num_initdaris configuration parameter (7731)
  • num_iocleaners configuration parameter (7680)
  • managing the buffer pool (7375)
  • num_ioservers configuration parameter (7681)
  • impact on data prefetch (7401)
  • num_poolagents (7457)
  • num_poolagents configuration parameter
  • impact on parallel systems (7465)
  • num_poolagents database manager configuration parameter (7715)
  • num_quantiles configuration parameter (7836)
  • NW (Next Key Weak Exclusive) mode (6904)
  • NX (Next Key Exclusive) mode (6903)
    • O
  • object class attributes
  • DB_Authentication (DAU) (8430)
  • DB_Comment (DCO) (8436)
  • DB_Communication_Protocol (8439)
  • DB_Database_Locator_Name (8445)
  • DB_Database_Protocol (8442)
  • DB_Native_Database_Name (8448)
  • DB_Object_Type (8451)
  • DB_Principal (DPR) (8433)
  • DB_Product_Name (8454)
  • DB_Product_Release (8457)
  • DB_Target_Database_Info (8460)
  • object names, federated database (8116)
  • objectname configuration parameter (7846)
  • occurrence (5474)
  • offline archived logs (5307)
  • online archived logs (5306)
  • online help (8738)
  • online index reorganization (7431)
  • online information
  • searching (8772)
  • viewing (8741)
  • online reorganization
  • indexes (6111)
  • opening the Journal (5780)
  • operating system restrictions (5330)
  • operational data (5430)
  • optimization class
  • guidelines (6960)
  • levels of (6955)
  • setting (6956)
  • optimization, global
  • analyzing (7287)
  • explain tool cost information (7288)
  • nickname characteristics, affecting (7281)
  • server characteristics, affecting (7275)
  • OPTIMIZE FOR clause (6969), (6985)
  • optimizer
  • adjusting amount of optimization (6954)
  • affect of statistics (7072)
  • creating access plan (7130)
  • database access (7153), (7157)
  • distribution statistics impact (7107)
  • selecting optimal join (7217)
  • sorting (7247)
  • use of replicated summary tables (7226)
  • OS/2 user exit
  • archive considerations (8527)
  • archiving log files (8494)
  • BACKUP DATABASE considerations (8534)
  • BACKUP DATABASE utility (8490)
  • calling format (8523)
  • db2uexit (8505)
  • db2uexit.CAD (8515)
  • db2uexit.ex1 (8510)
  • db2uexit.ex2 (8512)
  • db2uexit.ex3 (8513)
  • db2uexit.ex4 (8514)
  • error handling (8541)
  • invoking (8503)
  • overview (8489)
  • RESTORE DATABASE considerations (8535)
  • RESTORE DATABASE utility (8492)
  • retrieve considerations (8528)
  • retrieving log files (8495)
  • sample user exit programs (8508)
  • outbound connection pool (7460)
  • outer versus inner table determination
  • merge join (7214)
  • nested loop join (7210)
  • overview of (7209)
  • outer-table join, method (7234)
  • overflow record (6803)
  • overview of warehousing (5428)
    • P
  • package
  • access privileges with SQL (6459)
  • dependencies (6299)
  • dropping (6296)
  • inoperative (6301)
  • invalid after adding foreign key (6208)
  • isolation levels, specifying (6845)
  • owner (6458)
  • privileges (6433)
  • revoking privileges (6451)
  • page cleaners (6776), (7376)
  • page cleaners configuration parameter
  • managing the buffer pool (7377)
  • parallel operations
  • configuration parameters (7867)
  • parallel processing capability
  • overview (5559)
  • parallelism
  • and different hardware environments (5425)
  • and index creation (5403)
  • AutoLoader utility (5402)
  • database backup and restore utilities (5404)
  • enabling (5817)
  • I/O (5388)
  • inter-partition (5396)
  • intra-partition (5394)
  • load utility (5401)
  • overview (5380)
  • query (5390)
  • types (5387)
  • utility (5400)
  • parallelism, intra-partition
  • enabling (5819)
  • parent
  • key (5524), (5528)
  • row (5531)
  • table (5530)
  • partial declustering (5590)
  • partition
  • database (5382)
  • partition compatibility (5599)
  • partitioned database (5383)
  • configuration parameters (7866)
  • data distribution, specifying (7531)
  • data redistribution across database partitions (7549)
  • data redistribution in tables (7553)
  • data redistribution, error recovery (7559)
  • partitioning map, target, specifying during data redistribution (7546)
  • partitioned database environment
  • decorrelation of a query (7147)
  • partitioning
  • data (5588)
  • key (5595)
  • map (5592)
  • partitioning data (5820)
  • partitioning key
  • changing (6231)
  • index partitioned on partitioning key (6113)
  • table considerations (6031)
  • partitioning map
  • redistributing data (7532)
  • target, specifying during data redistribution (7544)
  • partitions with multiple processors (5420)
  • partitions with one processor (5417)
  • passing IDs and passwords to data sources (6360)
  • password server option (7062)
  • passwords
  • changing (8103)
  • naming (8100)
  • pckcachesz configuration parameter (7619)
  • impact on memory (7358)
  • PCTFREE clause (6802)
  • PDF (8733)
  • performance
  • application considerations (6839)
  • book summary (6770)
  • catalog information, reducing contention for (5825)
  • catalog statistics (7286)
  • configuration parameters (7582)
  • data distribution, determining using SQL (7534)
  • data source updates (7269)
  • database caching (7002)
  • database managed storage (DMS) (7434)
  • db2batch benchmarking tool (7575)
  • disk storage (6766)
  • elements of (6764)
  • environmental consideration (7014)
  • federated database systems (7252)
  • global optimization (7274)
  • governor affect on database manager (7501)
  • guidelines (6765)
  • limits to tuning (6768)
  • locks, effect of (6908)
  • nickname index considerations (7283)
  • num_ioservers configuration parameter (7400)
  • operational considerations (7339)
  • optimization class, adjusting (6952)
  • process (6767)
  • programming considerations (6840)
  • pushdown analysis (federated systems) (7255)
  • query rewrite by compiler (7138)
  • quick determination (6769)
  • recovery (5336)
  • redistributing data (7523)
  • remote SQL generation (7273)
  • remote SQL generation for data sources (7270)
  • row blocking, guidelines (6977)
  • RUNSTATS utility (7086)
  • server characteristics (7277)
  • statistics (7070)
  • summary table (6073)
  • table collocation, data redistribution (7527)
  • tuning using explain (7330)
  • using explain facility (7298)
  • Performance Configuration Wizard (5759), (6148)
  • performance configuration wizard (8765)
  • performance information
  • accessing remote (8659)
  • displaying (8658)
  • enable remote access (8656)
  • resetting values (8660)
  • performance monitor
  • using (7467)
  • Windows NT (8652)
  • physical database design (5560)
  • physical files
  • SMS (5629)
  • piped versus non-piped sorts
  • overview of (7249)
  • plan hints example (7280)
  • plan_hints server option (7064)
  • point in time monitoring (7473)
  • point of consistency (5277)
  • point of recovery (5311)
  • pool size for agents, controlling (7714)
  • populating typed table (6024)
  • PRECOMPILE command
  • OWNER option (6457)
  • precompiling
  • isolation level, specifying (6869)
  • predicate
  • adding by optimizer (7151)
  • definition of (7168)
  • distribution statistics (7108)
  • inclusive inequality (7174)
  • strict inequality (7173)
  • translation by optimizer (7150)
  • when applied (7144)
  • predicate category
  • index SARGable predicate (7189)
  • overview of (7187)
  • range delimiting predicate (7188)
  • residual predicate (7195)
  • SARGable predicate (7193)
  • usage (7197)
  • predicate terminology
  • overview of (7186)
  • prefetch (7337)
  • buffer pool (7384)
  • clustering page reads (7183)
  • data page (7385)
  • I/O servers (7398)
  • index page (7386)
  • intra-partition parallelism (7397)
  • list prefetch (7396)
  • PREFETCHSIZE clause (7390)
  • sequential (7387)
  • sequential detection (7394)
  • tuning using database system monitor (7392)
  • prefetchers (6775)
  • prefix sequences (8630)
  • previous leaf pointers (7166)
  • primary index (5506)
  • dropping (6293)
  • uniqueness for primary key (5986)
  • primary key (5505), (5525)
  • adding (6203)
  • DROP PRIMARY KEY clause, ALTER TABLE statement (6218)
  • primary index (5985)
  • primary index, creating (6106)
  • privileges required for dropping (6219)
  • when to create (5988)
  • PRIMARY KEY clause
  • adding primary key (6205)
  • restrictions (5984)
  • primary key constraint (5268), (5529)
  • primary key values
  • generating unique (5511)
  • printing PDF books (8734)
  • privilege (5370)
  • privileges
  • ALTER (6418)
  • BINDADD (6396)
  • CONNECT (6397)
  • CONTROL (6415)
  • create view for information (6494)
  • CREATETAB (6398)
  • CREATE_NOT_FENCED (6399)
  • database manager (6395)
  • definition of (6374)
  • DELETE (6419)
  • GRANT statement (6444)
  • granting and revoking authority (6394)
  • hierarchy (6378)
  • implicit for packages (6381)
  • IMPLICIT_SCHEMA (6400)
  • INDEX (6438)
  • indirect privileges, nicknames (6465)
  • individual (6380)
  • INSERT (6421)
  • nickname (6429)
  • ownership (CONTROL) (6379)
  • package (6434)
  • PUBLIC (6408)
  • REFERENCES (6424)
  • required for REORG utility (7429)
  • retrieving authorization names with (6480)
  • retrieving for names (6489)
  • REVOKE statement (6447)
  • schema (6410)
  • SELECT (6426)
  • server (6431)
  • summary of (6377)
  • system catalog listing (6477)
  • table (6413)
  • table space (6411)
  • tasks and required authorities (6475)
  • view (6414)
  • views with nicknames (6471)
  • priv_mem_thresh configuration parameter (7649)
  • process (in warehousing) (5446)
  • process model (6822)
  • process, DB2 (7446)
  • processes (6823)
  • processors, adding to a machine (7505)
  • profile registry (5850)
  • program step (5450)
  • protecting against disk failure (5341)
  • PUBLIC
  • privileges (6407)
  • public interconnect (8676)
  • pushdown analysis
  • analyzing (7267)
  • explain tool operators (7268)
  • nickname characteristics, affecting (7261)
  • overview (7253)
  • query characteristics, affecting (7266)
  • server characteristics, affecting (7258)
  • pushdown server option (7066)
    • Q
  • qualified object names (5812)
  • quantile value statistics
  • number to collect (7106)
  • range statistics (7110)
  • rules for updating (7118)
  • query parallelism (5391)
  • query rewrite See also compiler
  • overview of (7136)
  • summary table (6072)
  • query_heap_sz configuration parameter (7644)
  • impact on memory (7364)
  • quickly retrieve first few rows (6964)
    • R
  • RACF (8464)
  • rah (8619), (8620)
  • RAHDOTFILES (8637)
  • RAHOSTFILE (8632)
  • RAHOSTLIST (8633)
  • RAHWAITTIME (8629)
  • RAID (Redundant Array of Independent Disks) (5346), (5349)
  • RAID devices
  • optimizing performance with (5654)
  • RAID-1 (disk mirroring or duplexing) (5351)
  • RAID-5 (data and parity striping by sectors) (5353)
  • range delimiting predicate
  • index SARGable predicate (7191)
  • overview of (7190), (7192)
  • raw devices (5952)
  • raw I/O (5961)
  • raw logs (5960)
  • read locks (6950)
  • read only cursors
  • uncommitted read (6863)
  • read stability, overview (6851)
  • reading
  • read stability, overview of (6850)
  • repeatable read, overview of (6846)
  • uncommitted read, overview of (6861)
  • recommendations for catalog table spaces (5650)
  • reconcile pending state (6712)
  • record identifier (RID) (6798)
  • records
  • audit (6499)
  • recoverable databases (5291)
  • recovering inoperative summary table (6277)
  • recovering inoperative view (6272)
  • recovery (5275)
  • allocating log during database creation (5930)
  • configuration parameters (7760)
  • consistent database (6536)
  • crash (6534)
  • damaged table spaces (5333)
  • dropped table (6675)
  • factors affecting (5290)
  • history file (5245), (6687)
  • interaction with DB2 Data Links Manager (6728)
  • log file (5243)
  • operating system restrictions (5331)
  • overview of (6533)
  • performance (5335)
  • point in time (6685)
  • point of (5312)
  • point-in-time (5287)
  • reducing logging on work tables (5310)
  • roll-forward (6645)
  • storage considerations (5319)
  • time required (5316)
  • to end of logs (5286)
  • two-phase commit protocol (6550)
  • version (6579)
  • recovery history file (6686)
  • recovery history retention period (rec_his_retentn) configuration parameter (7771)
  • recovery log (5929)
  • recovery objects
  • history file (5244)
  • log file (5242)
  • overview (5241)
  • recovery program file for HACMP ES (8006)
  • recovery scripts for HACMP ES (8009)
  • rec_his_retentn configuration parameter (7770)
  • redistributing data
  • across nodes (6160)
  • connection to catalog database partition (7548)
  • data distribution, determining using SQL (7535)
  • database partition, process overview (7547)
  • database partitions, adding (7539)
  • database partitions, dropping (7538)
  • distribution file (7533)
  • distribution, specifying (7530)
  • error recovery (7557)
  • log file (7560)
  • operation successful (7555)
  • operation unsuccessful (7556)
  • other operations during redistribution (7563)
  • partitioning map, target, specifying (7545)
  • purpose (7524)
  • replicated summary table restriction (7528)
  • table collocation (7526)
  • table, process overview (7552)
  • reducing logging on work tables (5309)
  • reducing the impact of media failure (5338)
  • reducing the impact of transaction failure (5358)
  • Redundant Array of Independent Disks (RAID) (5347)
  • reference type (5494)
  • overview (5558)
  • REFERENCES clause
  • adding foreign key (6206)
  • delete rules (6004)
  • referential constraints (6002)
  • use of (6003)
  • REFERENCES privilege, definition (6425)
  • referential constraints (5522)
  • add to table (6201)
  • defining (5990)
  • delete-connected relationships (5544)
  • FOREIGN KEY clause, CREATE/ALTER TABLE statements (5992)
  • implications for SQL operations (5539)
  • PRIMARY KEY clause, CREATE/ALTER TABLE statements (5991)
  • REFERENCES clause, CREATE/ALTER TABLE statements (5993)
  • SQL DELETE rules (5543)
  • SQL INSERT rules (5541)
  • SQL UPDATE rules (5546)
  • referential cycle (5535)
  • refreshing data in summary table (6239)
  • registry variables (8158)
  • changing (6141)
  • DB2ACCOUNT (8160)
  • DB2ADMINSERVER (8368)
  • DB2ATLD_PORTS (8282)
  • DB2ATLD_PWFILE (8284)
  • DB2BIDI (8162)
  • DB2BPVARS (8310)
  • DB2BQTIME (8274)
  • DB2BQTRY (8276)
  • DB2CHECKCLIENTINTERVAL (8222)
  • DB2CHGPWD_EEE (8286)
  • DB2CHKPTR (8316)
  • DB2CLIENTADPT (8268)
  • DB2CLIENTCOMM (8270)
  • DB2CLIINIPATH (8370)
  • DB2CODEPAGE (8164)
  • DB2COMM (8224)
  • DB2CONNECT_IN_APP_PROCESS (8202)
  • DB2COUNTRY (8166)
  • DB2DBDFT (8168)
  • DB2DBMSADDR (8170)
  • DB2DEFPREP (8372)
  • DB2DIRPATHNAME (8266)
  • DB2DISCOVERYTIME (8174)
  • DB2DMNBCKCTLR (8376)
  • DB2DOMAINLIST (8204)
  • DB2ENVLIST (8206)
  • DB2INCLUDE (8176)
  • DB2INSTANCE (8208)
  • DB2INSTDEF (8178)
  • DB2INSTOWNER (8180)
  • DB2INSTPROF (8210)
  • DB2IQTIME (8278)
  • DB2LDAPCACHE (8388)
  • DB2LDAPHOST (8392)
  • DB2LDAP_BASEDN (8386)
  • DB2LDAP_CLIENT_PROVIDER (8390)
  • DB2LDAP_SEARCH_SCOPE (8394)
  • DB2LIBPATH (8212)
  • DB2LOADREC (6674), (8396)
  • DB2LOCK_TO_RB (8398)
  • DB2MEMDISCLAIM (8322)
  • DB2MEMMAXFREE (8324)
  • DB2NBADAPTERS (8228)
  • DB2NBBRECVNCBS (8236)
  • DB2NBCHECKUPTIME (8230)
  • DB2NBDISCOVERRCVBUFS (8184)
  • DB2NBINTRLISTENS (8232)
  • DB2NBRECVBUFFSIZE (8234)
  • DB2NBRESOURCES (8238)
  • DB2NBSENDNCBS (8240)
  • DB2NBSESSIONS (8242)
  • DB2NBXTRANCBS (8244)
  • DB2NETREQ (8246)
  • DB2NODE (8214)
  • DB2NOEXITLIST (8400)
  • DB2NTMEMSIZE (8332)
  • DB2NTNOCACHE (8334)
  • DB2NTPRICLASS (8336)
  • DB2NTWORKSET (8338)
  • DB2OPTIONS (8186)
  • DB2PATH (8218)
  • DB2PORTRANCE (8292)
  • DB2PRIORITIES (8342)
  • DB2REMOTEPREG (8402)
  • DB2RETRY (8248)
  • DB2RETRYTIME (8250)
  • DB2ROUTE (8272)
  • DB2ROUTINE_DEBUG (8404)
  • DB2RQTIME (8280)
  • DB2SERVICETPINSTANCE (8252)
  • DB2SLOGON (8188)
  • DB2SORCVBUF (8406)
  • DB2SORT (8408)
  • DB2SOSNDBUF (8254)
  • DB2SYSPLEX_SERVER (8256)
  • DB2SYSTEM (8410)
  • DB2TCPCONNMGRS (8258)
  • DB2TIMEOUT (8190)
  • DB2TRACEFLUSH (8196)
  • DB2TRACENAME (8192)
  • DB2TRACEON (8194)
  • DB2TRCSYSERR (8198)
  • DB2UPMPR (8412)
  • DB2YIELD (8200)
  • DB2_ANTIJOIN (8294)
  • DB2_AVOID_PREFETCH (8306)
  • DB2_BINSORT (8308)
  • DB2_CORRELATED_PREDICATES (8296)
  • DB2_DARI_LOOKUP_ALL (8318)
  • DB2_DISABLE_FLUSH_LOG (8172)
  • DB2_DJ_COMM (8374)
  • DB2_ENABLE_LDAP (8378)
  • DB2_EXTENDED_OPTIMIZATION (8320)
  • DB2_FALLBACK (8380)
  • DB2_FORCE_FCM_BP (8288)
  • DB2_FORCE_NLS_CACHE (8226)
  • DB2_FORCE_TRUNCATION (8382)
  • DB2_GRP_LOOKUP (8384)
  • DB2_HASH_JOIN (8298)
  • DB2_LIC_STAT_SIZE (8182)
  • DB2_LIKE_VARCHAR (8300)
  • DB2_MMAP_READ (8326)
  • DB2_MMAP_WRITE (8328)
  • DB2_NEW_CORR_SQ_FF (8302)
  • DB2_NO_PKG_LOCK (8330)
  • DB2_NUM_FAILOVER_NODES (8290)
  • DB2_OVERRIDE_BPF (8340)
  • DB2_PARALLEL_IO (8216)
  • DB2_PRED_FACTORIZE (8304)
  • DB2_RR_TO_RS (8344)
  • DB2_SORT_AFTER_TQ (8346)
  • DB2_STRIPED_CONTAINERS (8220)
  • DB2_VI_DEVICE (8264)
  • DB2_VI_ENABLE (8260)
  • DB2_VI_VIPL (8262)
  • Distributed Computing Environment (DCE) (8471)
  • DLFM_BACKUP_DIR_NAME (8348)
  • DLFM_BACKUP_LOCAL_MP (8350)
  • DLFM_BACKUP_TARGET (8352)
  • DLFM_BACKUP_TARGET_LIBRARY (8354)
  • DLFM_ENABLE_STPROC (8356)
  • DLFM_FS_ENVIRONMENT (8358)
  • DLFM_GC_MODE (8360)
  • DLFM_INSTALL_PATH (8362)
  • DLFM_LOG_LEVEL (8364)
  • DLFM_PORT (8366)
  • relation scan
  • definition of (7154)
  • when used (7184)
  • relational database concepts
  • overview (5220)
  • relationship
  • many-to-many (5480)
  • many-to-one (5479)
  • one-to-many (5478)
  • one-to-one (5481)
  • relationships between tables (5329)
  • release configuration parameter (7790)
  • release notes (8731)
  • release to release incompatibilities
  • description (8122)
  • remote administration (5872)
  • remote data services
  • node name (nname) parameter (7839)
  • remote SQL generation
  • overview (7271)
  • remote system (5783)
  • remote unit of work (5660)
  • renaming a table space (6169)
  • renaming table (6246)
  • REORG utility
  • authority and privileges required (7427)
  • binding to a database (5936)
  • overview of (7421)
  • reorganize index
  • online (7432)
  • reorganizing tables (5365)
  • REORGCHK command (7426)
  • replicated summary table
  • redistributed nodegroup restriction (7529)
  • replicated summary tables (5601)
  • replicating data (5793)
  • replication
  • configuration (5903)
  • request blocks, FCM daemon to agent communication, number (7899)
  • residual predicate
  • overview of (7196)
  • resource access control facility (RACF) (8466)
  • resource manager
  • setting up a database as (5695)
  • RESTART DATABASE command (6540)
  • restbufsz configuration parameter (7615)
  • restore
  • buffer(s) (6632)
  • database (5279)
  • existing database (6641)
  • invoking (6629)
  • new database (6644)
  • planning (6626)
  • redirected (6639)
  • table space (5285)
  • RESTORE command
  • access errors, error handling (6608), (6635)
  • authority required (6591), (6627)
  • buffer (6603), (6633)
  • code page restriction (6638)
  • concurrency control (6606)
  • considerations for (6584), (6625)
  • database alias restriction (6600), (6630)
  • DB2 Data Links Manager considerations (6702), (6707)
  • DB2 Data Links Manager, restoring database without roll forward (6714)
  • disk output created (6614)
  • overview of (6583), (6622)
  • system crash (6604), (6648)
  • tape output created (6615)
  • use in roll-forward recovery (6652)
  • use with Tivoli Storage Manager (6733)
  • RESTORE DATABASE utility
  • considerations for user exit program (8537)
  • default restore buffer size (restbufsz) parameter (7614)
  • error handling for user exits (8543)
  • user exit program for OS/2 (8493)
  • Restore Database Wizard (5760)
  • restore wizard (8767)
  • restore_pending configuration parameter (7828)
  • restoring a database
  • overview of (6620)
  • RESTORE command (6621), (6624)
  • restoring database
  • recovering failed database partition server (6573)
  • transaction recovery on the failed database partition server (6560)
  • transaction recovery when the database partition server is active (6553)
  • transaction recovery, overview (6541)
  • restrictions
  • Windows NT naming (8644)
  • resync_interval configuration parameter (7779)
  • retain log records (6815)
  • retrieve first few rows quickly (6963)
  • retrieve log files
  • for OS/2 (8496)
  • for UNIX-based systems (8501)
  • retrieving data
  • index (6115)
  • reverse scans (7160), (7172)
  • REVOKE statement
  • example of (6449)
  • implicit issuance (6454)
  • security (8468)
  • use of (6448)
  • revoking Authorities and Privileges (5786)
  • REXX
  • isolation level, specifying (6870)
  • roll-forward recovery (5281), (6646), (6816)
  • authority required (6668)
  • database (5283)
  • invoking (6670)
  • planning (6667)
  • rolling forward table space (6666)
  • table space (5289)
  • ROLLFORWARD command
  • backup considerations (6647)
  • configuration file parameters support (6654)
  • DB2 Data Links Manager considerations (6708)
  • DB2 Data Links Manager, point in time roll forward example (6726)
  • DB2 Data Links Manager, rolling forward to a point in time (6724)
  • DB2 Data Links Manager, rolling forward to end of logs (6719)
  • log management considerations (6677)
  • restore considerations (6651)
  • timestamps (6671)
  • ROLLFORWARD DATABASE utility
  • roll forward pending (rollfwd_pending) parameter (7822)
  • rollfwd_pending configuration parameter (7823)
  • root type (5491)
  • rotating assignment (7987)
  • route_obj_name configuration parameter (7853)
  • routing information objects
  • creating (8425)
  • example (8426)
  • row
  • blocking (6972)
  • lock compatibility, ensuring (6913)
  • locking (6847), (6853), (6857)
  • read stability (6852)
  • types of locks on (6893)
  • row blocking
  • types of (6976)
  • block fetch (6974)
  • overview of (6973)
  • row identifier (RID) (8581)
  • rqrioblk configuration parameter (7658)
  • impact on memory (7369)
  • rules file (7975)
  • for HACMP (8004)
  • restriction (8005)
  • running commands in parallel (8624)
  • RUNSTATS CMD/API
  • node where execution occurs (7080)
  • RUNSTATS utility
  • for reorganization (7083)
  • use of (7077)
  • use of in a partitioned database environment (7079)
  • with distribution clause (7100)
    • S
  • S (Share) mode (6899)
  • sample programs
  • cross-platform (8725)
  • HTML (8724)
  • sample user exit programs
  • for OS/2 (8509)
  • for UNIX-based systems (8517)
  • overview (8507)
  • SARGable predicate
  • overview of (7194)
  • scalability (5408), (7973)
  • scalar UDF (6042)
  • scaling a configuration (7502)
  • scheduling saved command scripts (5779)
  • schema
  • creating (5963)
  • dropping (6179)
  • naming rules (8104)
  • overview (5238)
  • overview of (5811)
  • SESSION (6256)
  • SCO UnixWare 7
  • tape devices (6597)
  • scope (5499)
  • adding (6192)
  • Script Center (5776)
  • using an existing script (5778)
  • script files for HACMP ES (8007)
  • installation (8008)
  • SDR (System Data Repository) (7997)
  • Search Discovery
  • additional settings (5890)
  • search discovery communications protocols configuration parameter (7861)
  • searching
  • online information (8746), (8771)
  • second normal form (5517)
  • security (5367), (5553)
  • federated database ID and password processing (6358)
  • APPC setting for federated systems (6370)
  • authentication, federated database details (6352)
  • CLIENT level (6323)
  • DCS processing, federated system (6355)
  • Distributed Computing Environment (DCE) directory services (8461)
  • federated server authentication example (6372)
  • planning for (6306)
  • server options (6364)
  • user mappings (6361)
  • security service
  • Windows NT (8645)
  • SELECT privilege, definition (6427)
  • SELECT statement
  • select a view (6066)
  • select-statement
  • eliminating DISTINCT clause (7143)
  • for two or more tables (6990)
  • guidelines (6984)
  • guidelines for using (6982)
  • query rewrite by compiler (7137)
  • use of (6981)
  • selectivity (6129)
  • self-referencing
  • constraint (5538)
  • row (5537)
  • table (5536)
  • seqdetect configuration parameter (7683)
  • understanding sequential detection (7395)
  • sequential detection (7338)
  • overview of (7393)
  • server
  • characteristics affecting pushdown opportunities (7257)
  • CPU speed and performance (7278)
  • creating (6087)
  • I/O speed and performance (7279)
  • options (7276)
  • privileges (6432)
  • server options
  • collating_sequence (7043)
  • comm_rate (7045)
  • connectstring (7047)
  • cpu_ratio (7049)
  • dbname (7051)
  • fold_id (6368), (7053)
  • fold_pw (6369), (7055)
  • io_ratio (7057)
  • node (7059)
  • password (6367), (7061)
  • plan_hints (7063)
  • pushdown (7065)
  • security details (6366)
  • varchar_no_trailing_blanks (7067)
  • SERVER, authentication type (6313)
  • SERVER_ENCRYPT, authentication type (6315)
  • SET CURRENT EXPLAIN MODE statement
  • use of (7322)
  • SET CURRENT EXPLAIN SNAPSHOT statement
  • use of (7328)
  • SET CURRENT QUERY OPTIMIZATION statement
  • use of (6959)
  • setting schema (5965)
  • setting the default environment profile for rah (8638)
  • setting up document server (8769)
  • setting VARCHAR (6190)
  • shadow paging (6819)
  • share mode
  • reasons for using (6946)
  • shared nothing model (5740)
  • sheapthres configuration parameter (7636)
  • avoiding post-threshold sorts (7417)
  • Show Related (5763)
  • Show SQL (5762)
  • single partition
  • multiple processor environment (5412)
  • single processor environment (5409)
  • SIX (Share with Intent Exclusive) mode (6901)
  • SmartGuides
  • wizards (8748)
  • SMP cluster environment (5421)
  • SMP environment (5413)
  • SMS (system managed space) (5250), (5626)
  • SMS physical files (5628)
  • SMS table space
  • caching of (7438)
  • creating (5944)
  • SNA (Systems Network Architecture) (5675)
  • snapshot, point in time monitoring (7474)
  • softmax configuration parameter (7754)
  • managing the buffer pool (7378)
  • software disk arrays (5356)
  • sortheap configuration parameter (7633)
  • affect on query optimization (7020)
  • avoiding post-threshold sorts (7416)
  • impact on memory (7361)
  • sorting
  • configuration parameters (7408)
  • managing performance (7418)
  • non-overflowed (7410)
  • non-piped (7412)
  • overflowed (7411)
  • parameters affecting (7414)
  • performance problems (7415)
  • piped (7413)
  • piped versus non-piped sorts (7248)
  • sort heap size (sortheap) parameter (7631)
  • sort heap threshold (sheapthres) parameter (7634)
  • steps (7409)
  • SP frame (7984)
  • SP switch configuration considerations (7993)
  • space management (6799)
  • space map pages (SMP) (6790)
  • sparse file allocation (5978)
  • spatial
  • data (5466)
  • information (5464)
  • Spatial Extender
  • overview (5461)
  • specifying list of machines for rah (8631)
  • SPM (sync point manager) (5672)
  • spm_log_file_sz configuration parameter (7782)
  • spm_log_path configuration parameter (7780)
  • spm_max_resync configuration parameter (7783)
  • spm_name configuration parameter (7781)
  • SQL advise facility (7334)
  • SQL functions
  • NODENUMBER, data distribution, determining (7537)
  • PARTITION, data distribution, determining (7536)
  • SQL optimizer (5234)
  • SQL statements
  • benchmarking (7571)
  • inoperative (6302)
  • select-statement (6980)
  • select-statement guidelines (6983)
  • statement heap size (stmtheap) parameter (7638)
  • tuning queries (6978)
  • valid during data redistribution (7566)
  • SQL step (5448)
  • sqluback
  • support (6594)
  • ss_logon configuration parameter (7965)
  • star schema (5460), (7222)
  • start
  • timeout for command, setting (7915)
  • start and stop timeout (start_stop_time) database manager parameter (7914)
  • starting DB2 (5802)
  • start_stop_time database manager configuration parameter (7919)
  • static SQL
  • distribution statistics (7103)
  • evaluating optimization class (6962)
  • EXECUTE privilege for database access (6461)
  • explain facility (7319), (7323)
  • setting optimization class (6957)
  • statistics
  • copying from production (7124)
  • distribution (7097)
  • distribution, how computed (7101)
  • frequent value (7098)
  • gathering for nicknames (7074)
  • index clustering (7182)
  • modeling data (7123)
  • overview of (7069)
  • quantiles (7099)
  • rules for updating (7113), (7114), (7115), (7116)
  • RUNSTATS utility (7076)
  • RUNSTATS utility in a partitioned database environment (7078)
  • updating (7111)
  • user-defined functions (UDF) (7120)
  • when to collect (7087)
  • stat_heap_sz configuration parameter (7643)
  • impact on memory (7363)
  • step (in warehousing) (5444)
  • stmtheap configuration parameter (7639)
  • affect on query optimization (7024)
  • impact on memory (7362)
  • stop
  • timeout for command, setting (7916)
  • stopping DB2 (5830)
  • storage
  • effect of locks on (6910)
  • media failure (5321)
  • required for backup and recovery (5320)
  • use of (7341)
  • storage objects
  • buffer pool (5256)
  • container (5253)
  • overview (5246)
  • table space (5247)
  • stored procedures
  • configuration parameters (7721)
  • performance impact (6998)
  • remote procedure calls (7001)
  • structured type (5487)
  • altering (6241)
  • overview (5555)
  • subagent (7453)
  • subject area (5436)
  • subqueries
  • correlated (7149)
  • subtype (5488)
  • summary table
  • altering properties (6236)
  • creating (6071)
  • dropping (6275)
  • refreshing data (6238)
  • summary tables
  • example (7250)
  • overview (5552)
  • recovering inoperative (6276)
  • replicated (5600)
  • Sun Cluster 2.x (8057)
  • supertype (5489)
  • supported DB2 database servers for MTS-coordinated transactions (5723)
  • supporting active directory (8689)
  • supporting LDAP configurations (8687)
  • svcename configuration parameter (7842)
  • switch alias address (7988)
  • sync point manager (SPM) (5671)
  • synchronization
  • database partition (5363)
  • node (5362)
  • recovery considerations (5364)
  • synonym (DB2 for MVS/ESA) (6081)
  • sysadm_group configuration parameter (7958)
  • SYSCAT views (6478)
  • SYSCATSPACE (5606)
  • SYSCATSPACE table space (5912)
  • sysctrl_group configuration parameter (7959)
  • sysmaint_group configuration parameter (7960)
  • system administration (SYSADM) authority (6382)
  • overview (6385)
  • privileges (6386)
  • system catalog
  • adding new column (6184)
  • dropping a table (6250)
  • dropping view implications (6270)
  • privileges listing (6476)
  • retrieving authorization names with privileges (6479)
  • retrieving names with DBADM authority (6482)
  • retrieving names with table access authority (6485)
  • retrieving privileges granted to names (6488)
  • RUNSTATS utility (7088)
  • security (6491)
  • setting up (5916)
  • statistics (7071)
  • system catalog table
  • estimating initial size (5569)
  • overview (5240)
  • stored on database catalog node (5824)
  • System Data Repository (SDR) (7996)
  • system database directory
  • overview of (5920), (5922)
  • system log facility
  • XA interface example (5709)
  • System Managed Space (SMS) (6786)
  • system managed space (SMS) (5249), (5625)
  • system management
  • configuration parameters (7942)
  • memory considerations (7343)
  • system objects
  • configuration parameter (5259)
  • overview (5258)
  • system temporary table space (5618), (5955)
  • Systems Network Architecture (SNA) (5676)
    • T
  • table
  • add referential constraints (6202)
  • ALTER TABLE statement (6186)
  • altering (6182)
  • assigning to nodegroup (5927)
  • changing attributes (6234)
  • changing partitioning key (6232)
  • check constraints (5547)
  • collocation (5597)
  • CREATE TABLE statement (5968)
  • creating in partitioned database (6030)
  • data redistribution, process (7554)
  • defining check constraint (6011)
  • defining referential constraints (5994)
  • defining unique constraint (5982)
  • determining where RUNSTATS execution occurs (7082)
  • dropping (6249)
  • estimating size requirements for (5566)
  • generated column (6014), (6226)
  • identity column (6019)
  • joining (7200)
  • lock compatibility, ensuring (6914)
  • lock mode (6937)
  • locking (6944)
  • mapping to table spaces (5645)
  • naming (5969)
  • naming rules (8106)
  • normalization (5515)
  • overview (5229)
  • redistribution, error recovery (7558)
  • relationships (5328)
  • renaming (6247)
  • reorganizing (5366), (7419)
  • REORGCHK command (7424)
  • retrieving names with access to (6486)
  • revoking privileges (6450)
  • scan, affect on locks (6935)
  • system catalog (5568)
  • temporary (5915)
  • two or more, select-statement (6991)
  • types of locks on (6883), (6894)
  • user (5570)
  • volatile (6229)
  • table check constraint
  • adding (6211)
  • defining (6010)
  • dropping (6224)
  • table queues (7246)
  • table scan (7155)
  • table space
  • adding container (6164)
  • affect on query optimization (7027)
  • catalog (5608), (5651)
  • changing (6161)
  • choosing SMS or DMS (5653)
  • comparisons (6792)
  • creating (5943)
  • database managed space (DMS) (5632)
  • default at database creation (5911)
  • design (5635)
  • designing and choosing (5602)
  • device container example (5949)
  • dropping (6172)
  • dropping a system temporary (6175)
  • dropping a user temporary (6177)
  • extending container (6167)
  • file container example (5947)
  • file system container example (5946)
  • in nodegroups (5958)
  • index (7041)
  • input and output (I/O) considerations (5637)
  • mapping to buffer pools (5640)
  • mapping to nodegroups (5643)
  • naming rules (8113)
  • overhead, setting (7028)
  • overview (5248)
  • privileges (6412)
  • recovery (5334)
  • renaming (6170)
  • resizing container (6168)
  • restore (5284)
  • restoring to an existing database (6643)
  • roll-forward recovery (5288)
  • separating types of data, example (6028)
  • SYSCATSPACE (5609)
  • system managed space (SMS) (5627)
  • system temporary (5954)
  • temporary (5622), (5649)
  • TEMPSPACE1 (5623)
  • TRANSFERRATE, setting (7029)
  • types of locks on (6895)
  • user (5614)
  • user temporary (5956)
  • USERSPACE1 (5615)
  • workload considerations (5652)
  • table space containers
  • redefining (6640)
  • table spaces
  • default (6784)
  • table UDF (6045)
  • TAKEN AT parameter (6634)
  • tape backup
  • planning (6598)
  • tape devices
  • SCO (6596)
  • tape system
  • backup considerations (6595)
  • target
  • row (5498)
  • table (5496)
  • type (5495)
  • view (5497)
  • tasks
  • warehousing (5456)
  • TCP/IP (8677)
  • temporary table
  • user-defined (6016)
  • temporary table space (5617), (5648)
  • temporary tables
  • dropping user-defined (6255)
  • temporary work space
  • estimating size requirements for (5584)
  • TEMPSPACE1 (5620)
  • TEMPSPACE1 table space (5914)
  • territory configuration parameter (7793)
  • third normal form (5518)
  • thread, DB2 (7447)
  • threads (6824)
  • time
  • definition of (8609)
  • formats (8616)
  • time difference among nodes, maximum (7911)
  • time required for database recovery (5317)
  • time stamp
  • definition of (8610)
  • time strings
  • definition of (8613)
  • timeout, starting and stopping database manager (7921)
  • timestamp
  • for logs (6682)
  • timestamp strings
  • definition of (8614)
  • Tivoli Storage Manager (ADSM)
  • configuration parameters (7762)
  • Tivoli Storage Manager (TSM)
  • backup restrictions (6753)
  • client set up (on Intel) (6742)
  • client set up (UNIX-based platforms) (6736)
  • environment variables (on Intel) (6743)
  • environment variables (UNIX-based platforms) (6737)
  • managing backups and log archives (6754)
  • setting password (on Intel) (6749)
  • setting password (UNIX-based platforms) (6741)
  • system options file (on Intel) (6747)
  • timeout problem resolution (6752)
  • use with BACKUP command (6734)
  • use with RESTORE command (6735)
  • user options file (on Intel) (6748)
  • using (6750)
  • tm_database configuration parameter (7778)
  • tokens (7464)
  • TPM and TP_MON_NAME values (5697)
  • tpname configuration parameter (7844)
  • tp_mon_name configuration parameter (7948)
  • trail
  • audit (6497)
  • transaction (6547)
  • accessing partitioned databases (5701)
  • failure (6537)
  • failure recovery on a failed database partition server (6570)
  • failure recovery on an active database partition server is active (6558)
  • failure recovery, overview (6548)
  • global (5688)
  • loosely coupled (5690)
  • non-XA (5687)
  • recovering failed database partition server (6578)
  • tightly coupled (5691)
  • two-phase commit (5689)
  • transaction failure
  • on the failed database partition server (6559)
  • recovering failed database partition server (6572)
  • reducing the impact of (5359)
  • transaction manager
  • implementing using IBM TXSeries CICS (5712)
  • implementing using IBM TXSeries Encina (5713)
  • configuring DB2 (5714)
  • configuring Encina for each resource manager (5715)
  • referencing a DB2 database from an Encina application (5716)
  • implementing using Microsoft Transaction Server (5718)
  • implementing using Tuxedo (5717)
  • transaction manager (TM) (5669), (5670)
  • transaction processing
  • configuring XA transaction managers (5710)
  • transaction recovery on coordinator node (6552)
  • transformer step (5452)
  • trigger (5274), (5548)
  • benefits of (6036)
  • creating (6035)
  • dependencies (6038)
  • dropping (6258)
  • Explain tables (8545)
  • naming rules (8111)
  • triggering crash recovery with DB2START (6567)
  • troubleshooting (5792)
  • trusted clients
  • authentication (6324), (6326)
  • CLIENT level security (6319)
  • trust_allclnts configuration parameter (7966)
  • trust_clntauth configuration parameter (7967)
  • tsm_mgmtclass configuration parameter (7772)
  • tsm_nodename configuration parameter (7774)
  • tsm_owner configuration parameter (7775)
  • tsm_password configuration parameter (7773)
  • tuning queries
  • SQL statements (6979)
  • two-phase commit (5664), (5668), (5678)
  • error handling (5680)
  • two-phase commit protocol (6549)
  • type hierarchy (5490)
  • overview (5557)
  • type mapping, creating (6059)
  • typed
  • table (5492), (5556)
  • view (5493)
  • typed table
  • creating (6021)
  • hierarchy table (6025)
  • populating (6023)
  • updating rows (6243)
  • typed tables
  • deleting rows (6245)
  • typed view, creating (6069)
    • U
  • U (Update) mode (6902)
  • UDF (user-defined function) (5501)
  • udf_mem_sz configuration parameter (7646)
  • impact on memory (7366)
  • uniprocessor environment (5410)
  • unique
  • constraints (5521)
  • index (5235)
  • key (5504), (5523)
  • unique constraint (5266)
  • adding (6199)
  • defining (5979), (5981)
  • dropping (6216)
  • uniquely identifying entities (5512)
  • unit of work (5659)
  • remote (5661)
  • UNIX user exit
  • archive considerations (8529)
  • archiving log files (8500)
  • calling format (8525)
  • db2uexit (8506)
  • db2uexit.cadsm (8519)
  • db2uexit.cdisk (8521)
  • db2uexit.ctape (8520)
  • db2uxt2.cxbsa (8522)
  • error handling (8540)
  • invoking (8504)
  • overview (8498)
  • retrieve considerations (8530)
  • retrieving log files (8499)
  • sample user exit programs (8518)
  • untrusted clients (6322), (6328)
  • updatable cursor
  • uncommitted read (6862)
  • update DAS configuration (5897)
  • update instance lists (5895)
  • UPDATE privilege, definition (6428)
  • update process (6821)
  • update protocol (6820)
  • update rules (5545)
  • updating typed table (6242)
  • user authentication
  • Windows NT (8642)
  • user exit
  • archive and retrieve considerations (8531)
  • BACKUP DATABASE utility (8532)
  • error handling (8538)
  • overview (8488)
  • RESTORE DATABASE utility (8533)
  • user exit program
  • backup (5327)
  • logs (5325)
  • user IDs
  • naming (8101)
  • user mapping, creating (6363)
  • user scripts (8088)
  • user table
  • page limits (5571)
  • user table space (5611)
  • user temporary table space (5619), (5957)
  • user-defined distinct type (UDT)
  • column definition (5486)
  • creating (6053)
  • dropping (6262)
  • naming rules (8114)
  • user-defined distinct type, creating (6054)
  • user-defined events (7974), (8003)
  • user-defined functions (UDF) (5500)
  • creating (6040)
  • dropping (6260)
  • naming rules (8110)
  • privilege to create non-fenced (6404)
  • types (6041)
  • updating statistics (7119)
  • user-defined program step (5454)
  • user-defined structured type, creating (6056)
  • user-defined temporary table (6017)
  • user-defined temporary tables (6254)
  • userexit configuration parameter (6665), (7758)
  • USERSPACE1 (5612)
  • USERSPACE1 table space (5913)
  • user_exit_status configuration parameter (7827)
  • utilities
  • reorganization (7422)
  • reorganization check (7425)
  • utility parallelism (5405)
  • util_heap_sz configuration parameter (7611)
  • impact on memory (7355)
    • V
  • varchar_no_trailing_blanks column option (7265)
  • varchar_no_trailing_blanks server option (7068)
  • version recovery (5280), (6580)
  • VI Architecture (8680)
  • view
  • access control to table (6468)
  • access privileges, examples of (6473)
  • altering (6263)
  • CHECK OPTION clause, CREATE VIEW statement (6067)
  • column access (6469)
  • creating (6062)
  • data integrity (6064)
  • data security (6063)
  • dropping (6264)
  • dropping implications for system catalogs (6266)
  • for privileges information (6493)
  • inoperative (6273)
  • merging by optimizer (7139)
  • naming rules (8107)
  • overview (5231)
  • predicate pushdown by optimizer (7145)
  • recovering inoperative (6271)
  • restrictions (6265)
  • row access (6470)
  • viewing
  • online information (8740)
  • Virtual Interface (VI) (8683)
  • Virtual Interface (VI) Architecture (8679)
  • virtual telecommunications access method (VTAM) (8465)
  • Visual Explain (7292), (7331)
  • VTAM (8463)
    • W
  • W (Weak Exclusive) mode (6906)
  • warehouse (5434)
  • agent (5439)
  • process (5445)
  • source (5437)
  • target (5438)
  • warehouse step (5443)
  • program (5449)
  • SQL (5447)
  • transformer (5451)
  • user-defined program (5453)
  • warehousing
  • objects (5435)
  • overview (5427)
  • tasks (5455)
  • Windows 2000 Active Directory
  • extending the directory schema (8714)
  • objects (8716)
  • Windows 95 failover
  • Administration Server considerations (8051)
  • Control Center considerations (8052)
  • Windows code pages
  • DB2CODEPAGE registry variable (8591)
  • supported code pages (8592)
  • Windows NT Active Directory
  • object classes and attributes (8720)
  • Windows NT failover
  • communications considerations (8049)
  • considerations for administering DB2 (8042)
  • database considerations (8047)
  • DB2MSCS utility
  • DB2MSCS.CFG parameters (8022)
  • overview (8020)
  • setting up a partitioned database system (8028)
  • setting up a single-partition database system (8024)
  • setting up two single-partition database systems for mutual takeover (8026)
  • fallback considerations (8031)
  • hot standby (8018)
  • limitations (8054)
  • maintaining the MSCS system (8030)
  • mutual takeover (8019)
  • planning (8016)
  • reconciling the database drive mapping (8033)
  • restrictions (8053)
  • running scripts after DB2 resource brought online (8046)
  • running scripts before DB2 resource brought online (8045)
  • running scripts, overview (8044)
  • setting database drive mapping for mutual takeover in a partitioned database environment (8032)
  • setting up partitioned database system for mutual takeover example
  • objectives (8037)
  • preliminary tasks (8038)
  • registering database drive mapping for ClusterA (8040)
  • registering database drive mapping for ClusterB (8041)
  • run DB2MSCS utility (8039)
  • setting up two instances for mutual takeover example
  • objectives (8034)
  • preliminary tasks (8035)
  • run DB2MSCS utility (8036)
  • starting and stopping DB2 resources (8043)
  • system time considerations (8050)
  • types (8017)
  • user and group support (8048)
  • Windows NT Performance Monitor (8651)
  • registering DB2 (8653)
  • Wizard
  • Performance Configuration (6149)
  • Wizards (5753)
  • wizards
  • add database (8750)
  • back up database (8752)
  • completing tasks (8749)
  • configure multisite update (8754)
  • create database (8756)
  • create table (8758)
  • create table space (8760)
  • index (8762)
  • performance configuration (8764)
  • restore database (8766)
  • wrapper, creating (6083)
  • write-ahead logging (WAL) (6818)
    • X
  • X (Exclusive) mode (6905)
  • X/Open transactional manager interface (XA)
  • distributed transaction processing (DTP) (5684)
  • XA transaction managers
  • configuring (5711)
  • xa_open string (5696)
    • Z
  • Z (Superxclusive) mode (6907)

    • [ Top of Page | Previous Page | Next Page ]