Administration Guide
IBM DB2 Universal Database
Administration Guide
Version 6
Before using this information and the product it supports, be sure to read
the general information under Appendix V, Notices.
This document contains proprietary information of IBM. It is
provided under a license agreement and is protected by copyright law.
The information contained in this publication does not include any product
warranties, and any statements provided in this manual should not be
interpreted as such.
Order publications through your IBM representative or the IBM branch office
serving your locality or by calling 1-800-879-2755 in the United
States or 1-800-IBM-4YOU in Canada.
When you send information to IBM, you grant IBM a nonexclusive right to use
or distribute the information in any way it believes appropriate without
incurring any obligation to you.
© Copyright International Business Machines Corporation 1993, 1999. All rights reserved.
Note to U.S. Government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.
Part 1. Database Concepts
Part 2. Database Design and Implementation
Chapter 2. Designing Your Logical Database
Decide What Data to Record in the Database
Define Tables for Each Type of Relationship
One-to-Many and Many-to-One Relationships
Many-to-Many Relationships
One-to-One Relationships
Provide Column Definitions for All Tables
Identify One or More Columns as a Primary Key
Identifying Candidate Key Columns
Be Sure Equal Values Represent the Same Entity
Consider Normalizing Your Tables
First Normal Form
Second Normal Form
Third Normal Form
Fourth Normal Form
Planning for Constraint Enforcement
Unique Constraints
Referential Integrity
Table Check Constraints
Triggers
Other Database Design Considerations
Chapter 3. Designing Your Physical Database
Database Physical Directories
Database Physical Files
Estimating Space Requirements for Tables
System Catalog Tables
User Table Data
Long Field Data
Large Object (LOB) Data
Index Space
Additional Space Requirements
Log File Space
Temporary Work Space
Designing Nodegroups
Nodegroup Design Considerations
Designing and Choosing Table Spaces
System Managed Space Table Space
Database Managed Space Table Space
Adding Containers to DMS Table Spaces
Table Space Design Considerations
Federated Database Design Considerations
Chapter 4. Implementing Your Design
Introductory Concepts for Database Implementation
Starting and Stopping DB2
Starting DB2 UDB on Windows NT
Using Multiple Instances of the Database Manager
Organizing and Grouping Objects by Schema
Enabling Intra-Partition Parallelism
Enabling Data Partitioning
Before Creating a Database
Design Logical and Physical Database Characteristics
Create an Instance
License Management
Establish Environment Variables and the Profile Registry
DB2 Administration Server (DAS)
Create a Node Configuration File
Creation of the Database Configuration File
Replicating Configuration Information Using Response Files
Enable FCM Communications
Creating a Database
Definition of Initial Nodegroups
Definition of Initial Table Spaces
Definition of System Catalog Tables
Definition of Database Directories
DCE Directory Services
Lightweight Directory Access Protocol (LDAP) Directory Services
Creating Nodegroups
Definition of Database Recovery Log
Binding Utilities to the Database
Cataloging a Database
Creating a Table Space
Creating a Schema
Creating and Populating a Table
Creating a Trigger
Creating a User-Defined Function (UDF)
Creating a User-Defined Type (UDT)
Creating a View
Creating a Summary Table
Creating an Alias
Creating a Wrapper
Creating a Server
Creating a Nickname
Creating an Index or an Index Specification
Before Altering a Database
Changing Logical and Physical Design Characteristics
Changing the License Information
Changing Instances
Changing Environment Variables and the Profile Registry Variables
Changing the Node Configuration File
Changing the Database Configuration
Altering a Database
Dropping a Database
Altering a Nodegroup
Altering a Table Space
Dropping a Schema
Modifying a Table in Both Structure and Content
Altering a User-Defined Structured Type
Deleting and Updating Rows of a Typed Table
Renaming an Existing Table
Dropping a Table
Dropping a Trigger
Dropping a User-Defined Function (UDF), Function Template, or Function Mapping
Dropping a User-Defined Type (UDT) or Type Mapping
Altering or Dropping a View
Dropping a Summary Table
Dropping a Wrapper
Altering or Dropping a Server
Altering or Dropping a Nickname
Dropping an Index or an Index Specification
Statement Dependencies When Changing Objects
Chapter 5. Administering DB2 Using GUI Tools
Administration Tools
Common Tool Features
Show SQL and Show Command
Show Related
Generate DDL
Filter
Filtering the Display
Filtering Retrieved Data
Defining a Filter to Retrieve a Specific Set of Data
Help
The Control Center
Main Elements of the Control Center
Using a Customized Control Center in DB2 for OS/390
Systems That Can Be Administered
Objects that can be Administered
Displaying Systems in the Control Center
Managing DB2 for OS/390 Objects
Adding DB2 for OS/390 Subsystems
Managing Gateway Connections
Functions You Can Perform from the Control Center
Creating New Objects
Working with Existing Objects
Locating objects (DB2 for OS/390 only)
The Satellite Administration Center
The Command Center
The Script Center
Using an Existing Script with the Script Center
Scheduling a Saved Command Script to Run
The Journal
Working with Jobs
The License Center
The Alert Center
Client Configuration Assistant
Searching for Databases
Performance Monitor
Event Monitor
Using the Monitor Tools
Monitoring Performance at a Point in Time
Predefined Monitors
Action Required When an Object Appears in the Alert Center
Analyzing an Event for a Period of Time
Event Analyzer
Analyzing SQL Statements
Improving Performance of a Query
Analyzing a Simple Dynamic SQL Statement
Managing Remote Databases
Managing Users
Granting and Revoking Authorities and Privileges
Moving Data
Managing Storage
Estimating Table and Index Size
Checking Space Available in a Table Space
Adding More Space to a Table Space
Troubleshooting
Replicating Data
Using Lightweight Directory Access Protocol
Using a Java Control Center
Running the Control Center as a Java Applet
Using Your Java-based Tools for Administration
Chapter 6. Controlling Database Access
An Overview of DB2 Security
Authentication
Authorization
Federated Database Authentication and Authorization Overview
Selecting User IDs and Groups for Your Installation
Selecting an Authentication Method for Your Server
Authentication Considerations for Remote Clients
Partitioned Database Considerations
Using DCE Security Services to Authenticate Users
How to Setup a DB2 User for DCE
How to Setup a DB2 Server to Use DCE
How to Setup a DB2 Client Instance to Use DCE
DB2 Restrictions Using DCE Security
Federated Database Authentication Processing
Authentication Settings
Passing IDs and Passwords to Data Sources
Federated Database Authentication Example
Privileges, Authorities, and Authorization
System Administration Authority (SYSADM)
System Control Authority (SYSCTRL)
System Maintenance Authority (SYSMAINT)
Database Administration Authority (DBADM)
Database Privileges
Schema Privileges
Table and View Privileges
Nickname Privileges
Server Privileges
Package Privileges
Index Privileges
Controlling Access to Database Objects
Granting Privileges
Revoking Privileges
Managing Implicit Authorizations by Creating and Dropping Objects
Establishing Ownership of a Plan or a Package
Allowing Indirect Privileges through a Package
Allowing Indirect Privileges through a Package Containing Nicknames
Controlling Access to Data with Views
Monitoring Access to Data Using the Audit Facility
Tasks and Required Authorizations
Using the System Catalog
Retrieving Authorization Names with Granted Privileges
Retrieving All Names with DBADM Authority
Retrieving Names Authorized to Access a Table
Retrieving All Privileges Granted to Users
Securing the System Catalog Views
Chapter 7. Auditing DB2 Activities
Audit Facility Behavior
Audit Facility Usage Scenarios
Audit Facility Messages
Audit Facility Record Layouts
Audit Facility Tips and Techniques
Controlling DB2 Audit Facility Activities
Chapter 8. Utilities for Moving Data
Chapter 9. Recovering a Database
Overview of Recovery
Factors Affecting Recovery
Recoverable and Non-Recoverable Databases
Database Logs
Reducing Logging on Work Tables
Point of Recovery
Frequency of Backups and Time Required
Recovery Time Required
Storage Considerations
Keeping Related Data Together
Restrictions on Using Different Operating Systems
Damaged Table Space Recovery
Recovery Performance Considerations
Disaster Recovery Considerations
Reducing the Impact of Media Failure
Protecting Against Disk Failure
Reducing the Impact of Transaction Failure
System Clock Synchronization in a Partitioned Database System
Crash Recovery
Getting to a Consistent Database
Transaction Failure Recovery in a Partitioned Database Environment
Identifying the Failed Database Partition Server
Recovery Method: Version Recovery
Backing Up a Database
Restoring a Database
Recovery Method: Roll-Forward Recovery
Backup Considerations
Restore Considerations
Rolling Forward Changes in a Database
Recovery History File Information
Garbage Collection
DB2 Data Links Manager Considerations
Crash Recovery Considerations
Backup Utility Considerations
Restore and Rollforward Utility Considerations
Restoring Databases from an offline Backup without Rolling Forward
Restoring Databases and Table Spaces and Rolling Forward to the End of the Logs
Restoring Databases and Table Spaces and Rolling Forward to a Point in Time
DB2 Data Links Manager and Recovery Interactions
Removing a Table from the Datalink_Reconcile_Not_Possible State
Reconciling Data Links
ADSTAR Distributed Storage Manager
Setting up an ADSTAR Distributed Storage Manager Client for UNIX-Based Platforms
Setting up an ADSTAR Distributed Storage Manager Client for Other Platforms
Considerations for Using ADSTAR Distributed Storage Manager
Part 3. Distributed Transaction Processing
Chapter 10. Distributed Databases
Using a Single Database in a Transaction
Using Multiple Databases in a Single Transaction
Updating a Single Database
Updating Multiple Databases
Other Configuration Considerations in Any Environment
Host or AS/400 Applications Which Access a DB2 Universal Database Server in a Multisite Update
Understanding the Two-Phase Commit Process
Recovering from Problems During Two-Phase Commit
Manual Recovery of Indoubt Transactions
Resynchronizing Indoubt Transactions if AUTORESTART=OFF
Recovery of Indoubt Transactions on the Host
Recovery when DB2 Connect Has the DB2 Syncpoint Manager Configured
Recovery when DB2 Connect Does Not Use the DB2 Syncpoint Manager
Chapter 11. Using DB2 with an XA-Compliant Transaction Manager
Setting Up a Database as a Resource Manager
Updating Host or AS/400 Database Servers
Database Connection Considerations
Making a Heuristic Decision
Security Considerations
Configuration Considerations
XA Function Supported
XA Interface Problem Determination
Configuring XA Transaction Managers to Use DB2 UDB
Configuring IBM TXSeries CICS
Configuring IBM TXSeries Encina
Configuring BEA Tuxedo
Configuring Microsoft Transaction Server
Part 4. Ensuring the High Availability of Your System
Chapter 12. High Availability Cluster Multi-Processing (HACMP) on AIX
Hot Standby
Examples
Mutual Takeover
Examples
Additional HACMP Resources
Chapter 13. High Availability Cluster Multi-Processing, Enhanced Scalability (HACMP ES) for AIX
Cluster Configuration
Configuration of a DB2 Database Partition
Example of a Mutual Takeover Configuration
Example of a Hot Standby Takeover Configuration
Configuration of a NFS Server Node
Example of a NFS Server Takeover Configuration
Considerations When Configuring the SP Switch
DB2 HACMP Configuration Examples
DB2 HACMP Startup Recommendations
HACMP ES Event Monitoring and User-Defined Events
HACMP ES Script Files
DB2 Recovery Scripts Operations with HACMP ES
Other Script Utilities
Monitoring HACMP Clusters
DB2 SP HACMP ES Installation
DB2 SP HACMP ES New Installation
DB2 SP HACMP ES Migration
DB2 SP HACMP ES Worksheets
Chapter 14. High Availability in the Windows NT Environment
Failover Configurations
Hot Standby Configuration
Mutual Takeover Configuration
Using the DB2MSCS Utility
Specifying the DB2MSCS.CFG File
Setting up Failover for a Single-Partition Database System
Setting up a Mutual Takeover Configuration for Two Single-Partition Database Systems
Setting up Multiple MSCS Clusters for a Partitioned Database System
Maintaining the MSCS System
Fallback Considerations
Registering Database Drive Mapping for Mutual Takeover Configurations in a Partitioned Database Environment
Reconciling Database Drive Mapping
Example - Setting up Two Single-Partition Instances for Mutual Takeover
Preliminary Tasks
Run the DB2MSCS Utility
Example - Setting up a Four-Node Partitioned Database System for Mutual Takeover
Preliminary Tasks
Run the DB2MSCS Utility
Register the Database Drive Mapping for ClusterA
Register the Database Drive Mapping for ClusterB
Administering DB2 in an MSCS Environment
Starting and Stopping DB2 Resources
Running Scripts
Database Considerations
User and Group Support
Communications Considerations
System Time Considerations
Administration Server and Control Center Considerations in a Partitioned Database Environment
Limitations and Restrictions
Chapter 15. High Availability in the Solaris Operating Environment, Single-Partition Database
Cluster Components
Failover Configurations
Hot Standby Configuration
Mutual Takeover Configuration
Setting up Failover Support for a Database System
Choosing a Failover Configuration
Creating a DB2 Instance
Registering the DB2 Resource with Sun Cluster
Enable Failover for an Instance
Starting and Stopping DB2
Running Scripts During a Failover
Unregistering DB2 for Failover
Client Application Considerations
Chapter 16. High Availability in the Solaris Operating Environment, Partitioned Database
Cluster Components
Failover Configurations
Hot Standby Configuration
Mutual Takeover Configuration
Setting Up Failover Support for a Database System
Choosing a Failover Configuration
Preliminary Requirements
Scripts and Programs
Creating a DB2 Instance
Registering the DB2 Resource with Sun Cluster 2.1
Enabling Failover for an Instance
Binding Database Partition Servers to a Logical Host
How Failover Processing Works
Setting Up a Hot Standby Configuration
Setting Up a Mutual Takeover Configuration
Starting and Stopping DB2
Running Scripts During a Failover
Considerations for Table Spaces
Client Application Considerations
Part 5. Introduction to Performance
Chapter 17. Elements of Performance
Tuning Guidelines
Performance Improvement Process
How Much Can a System be Tuned?
A Less Formal Approach
Disk Storage
Putting It All Together
Part 6. Tuning Application Performance
Chapter 18. Application Considerations
Concurrency
Repeatable Read
Read Stability
Cursor Stability
Uncommitted Read
Choosing the Isolation Level
Specifying the Isolation Level
Locking
Attributes of Locks
Locks and Application Performance
Factors Affecting Locking
LOCK TABLE Statement
CLOSE CURSOR WITH RELEASE
Summary of Locking Considerations
Adjusting the Optimization Class
How Do You Set the Optimization Class?
How Much Optimization is Necessary?
Restrictions on Result Sets to Improve Performance
FOR UPDATE Clause
FOR READ or FETCH ONLY Clause
OPTIMIZE FOR n ROWS Clause
FETCH FIRST n ROWS ONLY Clause
DECLARE CURSOR WITH HOLD Statement
Row Blocking
Tuning Queries
Using a SELECT-Statement
Guidelines When Using a SELECT-Statement
Compound SQL
Performance Considerations and Character Conversion
Code Page Conversion
Extended UNIX Code (EUC) Code Page Support
Stored Procedures
Activating a Database
Parallel Processing of Applications
Chapter 19. Environmental Considerations
Configuration Parameters Affecting Query Optimization
Nodegroup Impact on Query Optimization
Table Space Impact on Query Optimization
Indexing Impact on Query Optimization
Indexing versus No Indexing
Using the Index Advisor
Guidelines for Indexing
Performance Tips for Administering Indexes
Server Options Affecting Federated Database Queries
Chapter 20. System Catalog Statistics
Collecting Statistics Using the RUNSTATS Utility
The Database Partition Where RUNSTATS is Executed
Analyzing Statistics
Collecting and Using Distribution Statistics
Understanding Distribution Statistics
When Should You Use Distribution Statistics?
How Many Statistics Should You Keep?
How Does the Optimizer Use Distribution Statistics?
Collecting and Using Detailed Index Statistics
Understanding Detailed Index Statistics
When Should You Use Detailed Index Statistics?
User Update-Capable Catalog Statistics
Rules for Updating Catalog Statistics
Rules for Updating Table and Nickname Statistics
Rules for Updating Column Statistics
Rules for Updating Distribution Statistics for Columns
Rules for Updating Index Statistics
Updating Statistics for User-Defined Functions
Modeling Production Databases
Chapter 21. Understanding the SQL Compiler
Overview of the SQL Compiler
Rewrite Query by the SQL Compiler
Operation Merging
Example - View Merges
Example - Subquery to Join Transformations
Example - Redundant Join Elimination
Example - Shared Aggregation
Example - Summary Tables
Operation Movement
Example - DISTINCT Elimination
Example - General Predicate Pushdown
Example - Decorrelation
Predicate Translation
Example - Addition of Implied Predicates
Example - OR to IN Transformations
Accounting for Column Correlation
Data Access Concepts and Optimization
Index Scan Concepts
Relation Scan versus Index Scan
Summary Table Scan
Predicate Terminology
Join Concepts
Replicated Summary Tables
Join Strategies in a Partitioned Database
Influence of Sorting on the Optimizer
Optimization Strategies for Intra-Partition Parallelism
Parallel Scan Strategies
Parallel Sort Strategies
Parallel Temporary Tables
Parallel Aggregation Strategies
Parallel Join Strategies
Federated Database Query Compiler Phases
Pushdown Analysis
Remote SQL Generation and Global Optimization
Chapter 22. SQL Explain Facility
Choosing an Explain Tool
Using the SQL Explain Facility
Introductory Concepts for Explain
Explain Information for Data Objects
Explain Information for Data Operators
How Explain Information is Organized
Explain Instance Information
Explain Snapshot Information
Explain Table Information
Obtaining Explain Data
Capturing Explain Table Information
Capturing Explain Snapshot Information
Guidelines on Using Explain Output
Visual Explain
SQL Advise Facility
Part 7. Tuning and Configuring Your System
Chapter 23. Operational Performance
How DB2 Uses Memory
Setting Parameters That Affect Memory Usage
FCM Requirements
Managing the Database Buffer Pool
Managing Multiple Database Buffer Pools
Choosing One or Many Buffer Pools
Prefetching Data into the Buffer Pool
Understanding Sequential Prefetching
Understanding List Prefetching
Prefetching and Intra-Partition Parallelism
Configuring I/O Servers for Prefetching and Parallel I/O
Enabling Parallel I/O
Allocating Multiple Pages at a Time
Sorting
Different Types of Sorting
Tuning the Parameters that Affect Sorting
Looking for Indicators of Sorting Performance Problems
Techniques for Managing Sorting Performance
Reorganizing Table Data
Online Index Reorganization
Avoiding the Need to Reorganize Tables
Performance Considerations for DMS Devices
Managing Initialization Overhead
Database Agents
Using the Database System Monitor
Extending Memory
Chapter 24. Using the Governor
Starting and Stopping the Governor
The Governor Daemon
Creating the Governor Configuration File
Governor Log Files
Querying Governor Log Files
Running the Governor and Database Manager Performance
Chapter 25. Scaling Your Configuration
Adding Processors to a Machine
Adding Database Partitions to a Partitioned Database System
Adding Database Partitions to a Running System
Adding Database Partitions to a Stopped System
Dropping a Database Partition from a System
Chapter 26. Redistributing Data Across Database Partitions
How to Partition Data
Adding and Dropping Database Partitions
Specifying a Target Partitioning Map
How Data Is Redistributed Across Database Partitions
How Data Is Redistributed in Tables
Recovering From Redistribution Errors
Data Redistribution and Other Operations
Following Data Redistribution
Chapter 27. Benchmark Testing
Benchmark Testing Methodology
Preparing for Benchmark Testing
Creating a Benchmark Program
Executing the Benchmark Tests
Chapter 28. Configuring DB2
Tuning Configuration Parameters
Database Manager Parameters
Database Manager Configuration Parameter Summary
Database Parameters
Database Configuration Parameter Summary
Parameter Details by Function
Capacity Management
Database Shared Memory
Application Shared Memory
Agent Private Memory
Agent/Application Communication Memory
Database Manager Instance Memory
Locks
I/O and Storage
Agents
Database Application Remote Interface (DARI)
Logging and Recovery
Database Log Files
Database Log Activity
Recovery
Distributed Unit of Work Recovery
Database Management
Attributes
DB2 Data Links Manager
Status
Compiler Settings
Communications
Communication Protocol Setup
Distributed Services
DB2 Discovery
Parallel
Communications
Parallel Processing
Instance Management
Diagnostic
Database System Monitor Parameters
System Management
Instance Administration
Part 8. Appendixes
Appendix A. How the DB2 Library Is Structured
Completing Tasks with SmartGuides
Accessing Online Help
DB2 Information - Hardcopy and Online
Viewing Online Information
Accessing Information with the Information Center
Setting Up a Document Server
Searching Online Information
Printing the PostScript Books
Ordering the Printed Books
Appendix B. Planning Database Migration
Migration Considerations
Migration Restrictions
Security and Authorization
Storage Requirements
Release-to-Release Incompatibilities
Migrating a Database
Appendix C. Incompatibilities Between Releases
DB2 Universal Database Planned Incompatibilities
Read-only Views in a Future Version of DB2 Universal Database
PK_COLNAMES and FK_COLNAMES in a Future Version of DB2 Universal Database
COLNAMES No Longer Available in a Future Version of DB2 Universal Database
DB2 Universal Database Version 6 Incompatibilities
System Catalog Views
Application Programming
SQL
Database Security and Tuning
Utilities and Tools
Connectivity and Coexistence
Configuration Parameters
DB2 Universal Database Version 5 Incompatibilities
System Catalog Views
Application Programming
SQL
Database Security and Tuning
Utilities and Tools
Connectivity and Coexistence
Configuration Parameters
Appendix D. Naming Rules
Database Names
Database and Database Alias Names
User IDs and Passwords
Schema Names
Group and User Names
Object Names
Federated Database Object Names
How Case-Sensitive Values Are Preserved in a Federated System
Appendix E. DB2 Registry and Environment Variables
Appendix F. Using Distributed Computing Environment (DCE) Directory Services
Creating Directory Objects
Database Objects
Database Locator Objects
Routing Information Objects
Attributes of Each Object Class
Details About Each Attribute
Directory Services Security
Configuration Parameters and Registry Variables
CATALOG and ATTACH Commands, and the CONNECT Statement
CATALOG GLOBAL DATABASE Command
CONNECT Statement
ATTACH Command
How a Client Connects to a Database
Connecting to Databases in the Same Cell
Connecting to a Database in a Different Cell
How Directories are Searched
ATTACH Command
CONNECT Statement
Temporarily Overriding DCE Directory Information
Directory Services Tasks
DCE Administrator Tasks
Database Administrator Tasks
Database User Tasks
Directory Services Restrictions
Appendix G. X/Open Distributed Transaction Processing Model
Application Program (AP)
Transaction Manager (TM)
Resource Managers (RM)
Appendix H. Sample Tables
The Sample Database
To Install the Sample Database
To Erase the Sample Database
CL_SCHED Table
DEPARTMENT Table
EMPLOYEE Table
EMP_ACT Table
EMP_PHOTO Table
EMP_RESUME Table
IN_TRAY Table
ORG Table
PROJECT Table
SALES Table
STAFF Table
STAFFG Table
Sample Files with BLOB and CLOB Data Type
Quintana Photo
Quintana Resume
Nicholls Photo
Nicholls Resume
Adamson Photo
Adamson Resume
Walker Photo
Walker Resume
Appendix I. Catalog Views
Updatable Catalog Views
"Roadmap" to Catalog Views
"Roadmap" to Updatable Catalog Views
SYSIBM.SYSDUMMY1
SYSCAT.ATTRIBUTES
SYSCAT.BUFFERPOOLNODES
SYSCAT.BUFFERPOOLS
SYSCAT.CASTFUNCTIONS
SYSCAT.CHECKS
SYSCAT.COLAUTH
SYSCAT.COLCHECKS
SYSCAT.COLDIST
SYSCAT.COLOPTIONS
SYSCAT.COLUMNS
SYSCAT.CONSTDEP
SYSCAT.DATATYPES
SYSCAT.DBAUTH
SYSCAT.EVENTMONITORS
SYSCAT.EVENTS
SYSCAT.FULLHIERARCHIES
SYSCAT.FUNCDEP
SYSCAT.FUNCMAPOPTIONS
SYSCAT.FUNCMAPPARMOPTIONS
SYSCAT.FUNCMAPPINGS
SYSCAT.FUNCPARMS
SYSCAT.FUNCTIONS
SYSCAT.HIERARCHIES
SYSCAT.INDEXAUTH
SYSCAT.INDEXCOLUSE
SYSCAT.INDEXDEP
SYSCAT.INDEXES
SYSCAT.INDEXOPTIONS
SYSCAT.KEYCOLUSE
SYSCAT.NAMEMAPPINGS
SYSCAT.NODEGROUPDEF
SYSCAT.NODEGROUPS
SYSCAT.PACKAGEAUTH
SYSCAT.PACKAGEDEP
SYSCAT.PACKAGES
SYSCAT.PARTITIONMAPS
SYSCAT.PASSTHRUAUTH
SYSCAT.PROCEDURES
SYSCAT.PROCOPTIONS
SYSCAT.PROCPARMOPTIONS
SYSCAT.PROCPARMS
SYSCAT.REFERENCES
SYSCAT.REVTYPEMAPPINGS
SYSCAT.SCHEMAAUTH
SYSCAT.SCHEMATA
SYSCAT.SERVEROPTIONS
SYSCAT.SERVERS
SYSCAT.STATEMENTS
SYSCAT.TABAUTH
SYSCAT.TABCONST
SYSCAT.TABLES
SYSCAT.TABLESPACES
SYSCAT.TABOPTIONS
SYSCAT.TBSPACEAUTH
SYSCAT.TRIGDEP
SYSCAT.TRIGGERS
SYSCAT.TYPEMAPPINGS
SYSCAT.USEROPTIONS
SYSCAT.VIEWDEP
SYSCAT.VIEWS
SYSCAT.WRAPOPTIONS
SYSCAT.WRAPPERS
SYSSTAT.COLDIST
SYSSTAT.COLUMNS
SYSSTAT.FUNCTIONS
SYSSTAT.INDEXES
SYSSTAT.TABLES
Appendix J. User Exit for Database Recovery
Overview for OS/2
Overview for UNIX-Based Operating Systems
Invoking a User Exit Program
Sample User Exit Programs
Sample User Exit Programs for OS/2
Sample User Exit Programs for UNIX-Based Operating Systems
Calling Format
Calling Format for OS/2
Calling Format for UNIX-Based or Windows NT Operating Systems
Archive and Retrieve Considerations
Backup and Restore Considerations (DB2 for OS/2 only)
Error Handling
Appendix K. Explain Tables and Definitions
EXPLAIN_ARGUMENT Table
EXPLAIN_INSTANCE Table
EXPLAIN_OBJECT Table
EXPLAIN_OPERATOR Table
EXPLAIN_PREDICATE Table
EXPLAIN_STATEMENT Table
EXPLAIN_STREAM Table
ADVISE_INDEX Table
ADVISE_WORKLOAD Table
Table Definitions for Explain Tables
EXPLAIN_ARGUMENT Table Definition
EXPLAIN_INSTANCE Table Definition
EXPLAIN_OBJECT Table Definition
EXPLAIN_OPERATOR Table Definition
EXPLAIN_PREDICATE Table Definition
EXPLAIN_STATEMENT Table Definition
EXPLAIN_STREAM Table Definition
ADVISE_INDEX Table Definition
ADVISE_WORKLOAD Table Definition
Appendix L. SQL Explain Tools
Running db2expln and dynexpln
db2expln Syntax and Parameters
Usage Notes for db2expln
dynexpln Syntax and Parameters
Usage Notes for dynexpln
Description of db2expln and dynexpln Output
Table Access
Temporary Tables
Joins
Data Streams
Insert, Update, and Delete
Row Identifier (RID) Preparation
Aggregation
Parallel Processing
Miscellaneous Statements
Examples of db2expln and dynexpln Output
Example One: No Parallelism Plan
Example Two: Single-Partition Database Plan with Intra-Partition Parallelism
Example Three: Multipartition Database Plan with Inter-Partition Parallelism
Example Four: Multipartition Database Plan with Inter-Partition and Intra-Partition Parallelism
Appendix M. db2exfmt - Explain Table Format Tool
Appendix N. National Language Support (NLS)
Deriving Code Page Values
Deriving Locales in Application Programs
How DB2 Derives Locales
Country Code and Code Page Support
Unicode/UCS-2 and UTF-8 Support in DB2 UDB
Introduction
UCS-2/UTF-8 Implementation in DB2 UDB
Character Sets
DBCS Character Sets
Extended UNIX Code (EUC) Character Sets
Character Set for Identifiers
Coding of SQL Statements
Bidirectional CCSID Support
Collating Sequences
Datetime Values
Appendix O. Issuing Commands to Multiple Database Partition Servers
Commands
Command Descriptions
Specifying the Command to Run
Running Commands in Parallel on UNIX-Based Platforms
Monitoring rah Processes on UNIX-Based Platforms
Additional Rah (Run All Hosts) Information (Solaris and AIX only)
Prefix Sequences
Specifying the List of Machines
Eliminating Duplicate Entries from the List of Machines
Controlling the rah Command
$RAHDOTFILES on UNIX-Based Platforms
Setting the Default Environment Profile on Windows NT
Determining Problems with rah on UNIX-Based Platforms
Appendix P. How DB2 for Windows NT Works with Windows NT Security
A Sample Scenario with Server Authentication:
A Sample Scenario with Client Authentication and a Windows NT Client Machine:
A Sample Scenario with Client Authentication and a Windows 95 Client Machine:
Using a Backup Domain Controller with DB2
Appendix Q. Using the Windows NT Performance Monitor
Registering DB2 with the Windows NT Performance Monitor
Enable Remote Access to DB2 Performance Information
Displaying DB2 and DB2 Connect Performance Values
Accessing Remote DB2 Performance Information
Resetting DB2 Performance Values
Appendix R. Configuring Multiple Logical Nodes
Appendix S. Using Virtual Interface (VI) Architecture
Overview of DB2 UDB Extended Enterprise Edition
Running DB2 UDB for Windows NT with GigaNet Interconnect
Setup Procedure for GigaNet Interconnect
Running DB2 UDB for Windows NT with ServerNet Interconnect
Setup Procedure for ServerNet Interconnect
Install DB2 Universal Database Version 5.2 or Later (EEE)
Implement DB2 to Run Using VI
Appendix T. Lightweight Directory Access Protocol (LDAP) Directory Services
Registration of DB2 Servers After Installation
Update the Protocol Information for the DB2 Server
Catalog a Node Alias for ATTACH
Deregistering the DB2 Server
Registration of Databases
Attaching to a Remote Server
Deregistering the Database
Refreshing LDAP Entries in Local Database and Node Directories
Searching
Configure Host Database
Setting DB2 Registry Variables at the User Level
Enable LDAP Support After Installation is Complete
Disable LDAP Support
Security Considerations
Managing Multiple User Accounts
Extending the Directory Schema with DB2 Object Classes and Attributes
Extending the Directory Schema for IBM eNetwork Directory Version 2.1
Object Classes and Attributes Used by DB2
Appendix U. Extending the Control Center
Performance Considerations
Packaging Considerations
Interface Descriptions
CCExtension
CCObject
CCMenuAction
CCToolBarAction
Usage Scenario
MyExtension.java
MySample.java
MyDatabaseActions.java
MyInstance.java
MyDB2.java
MyDatabases.java
MySYSPLAN.java
MyTable.java
MyDBUser.java
MyToolbarAction.java
MyAlterAction.java
MyAction.java
MyDropAction.java
MyCascadeAction.java
MyCreateAction.java
Appendix V. Notices
Trademarks
Trademarks of Other Companies
Index
Contacting IBM
[ Top of Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]