IBM Books

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.


Table of Contents

Part 1. Database Concepts

  • Chapter 1. Introduction to Concepts Within DB2 Universal Database
  • Overview of DB2 Concepts
  • Overview of DB2 Parallelism Concepts
  • Nodegroups and Data Partitioning
  • Types of Parallelism
  • I/O Parallelism
  • Query Parallelism
  • Utility Parallelism
  • Hardware Environments
  • Single Partition on a Single Processor
  • Single Partition with Multiple Processors
  • Multiple Partition Configurations
  • Summary of Parallelism Best Suited To Each Hardware Environment
  • Enabling Parallelism for Queries
  • Enabling Intra-Partition Query Parallelism
  • Enabling Inter-Partition Query Parallelism
  • Enabling Utility Parallelism
  • Load
  • AutoLoader
  • Create Index
  • Backup Database / Table Space
  • Restore Database / Table Space
  • Federated Database System Concepts
  • Enabling a Federated System

  • 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 ]