Administration Guide
Part 1. Database Design and Implementation
Chapter 1. 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 2. 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
Chapter 3. 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
Establish Environment Variables and the Profile Registry
DB2 Administration Server (DAS)
Create a Node Configuration File
Creation of the Database Configuration File
Enable FCM Communications
Creating a Database
Definition of Initial Nodegroups
Definition of Initial Table Spaces
Definition of System Catalog Tables
Definition of Database Directories
Definition of Database Recovery Log
Binding Utilities to the Database
Cataloging a Database
Creating Nodegroups
Creating a Table Space
Creating a Schema
Creating 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 an Index
Before Altering a Database
Changing Logical and Physical Design Characteristics
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
Altering a Table
Dropping a Trigger
Dropping a User-Defined Function (UDF)
Dropping a User-Defined Type (UDT)
Altering or Dropping a View
Dropping an Index
Dropping a Summary Table
Statement Dependencies When Changing Objects
Chapter 4. Controlling Database Access
An Overview of DB2 Security
Authentication
Authorization
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
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
Package Privileges
Index Privileges
Controlling Access to Database Objects
Granting Privileges
Revoking Privileges
Managing Implicit Authorizations by Creating and Dropping Objects
Allowing Indirect Privileges through a Package
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 5. 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 6. Utilities for Moving Data
Using the LOAD Utility
Overview of the LOAD Process
Details About LOAD
LOAD Performance Considerations
LOAD Parameter Hints and Tips
LOAD Temporary Files
Using LOAD QUERY
Running Concurrent LOAD Jobs
Restarting LOAD and Database Recovery
LOAD Exception Table
Checking For Constraint Violations
Using the AutoLoader Utility
Modes of Operation
Planning to Use the AutoLoader Utility
Running the AutoLoader Utility
AutoLoader Hints and Tips
AutoLoader Sample Job
Loading into Multiple Database Partitions
AutoLoader Troubleshooting
Migration and Backward Compatibility
Moving DB2 File Manager Data
Load Utility Considerations
Export Utility Considerations
Import Utility Considerations
Using the IMPORT Utility
Using IMPORT with Buffered Inserts
Import in a Client/Server Environment
Differences Between the IMPORT and LOAD Utilities
Using the EXPORT Utility
LOAD, IMPORT, and EXPORT File Formats
Delimited ASCII (DEL) File Format
Nondelimited ASCII (ASC) File Format
WSF File Format
PC/IXF File Format
Moving Data Between Systems
Moving Data Between DB2 Databases
Moving Data Using the db2move Tool
Moving Data With DB2 Connect
Moving Data Between Typed Tables
Using Replication to Move Your Data
Chapter 7. 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
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
DB2 File Manager Considerations
Backup Utility Considerations
Restore and Rollforward Utility Considerations
DB2 File Manager and Recovery Interactions
Removing a Table from the Reconcile_Not_Possible State
Reconciling DB2 File Manager
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 2. Distributed Transaction Processing
Chapter 8. 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
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 9. 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 3. Tuning Application Performance
Chapter 10. 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?
Quickly Retrieving the First Few Rows Using OPTIMIZE FOR n ROWS
Row Blocking
Tuning Queries
Using a select-statement
Compound SQL
Performance Considerations and Character Conversion
Extended UNIX Code (EUC) Code Page Support
Stored Procedures
Activating a Database
Parallel Processing of Applications
Chapter 11. 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
Guidelines for Indexing
Performance Tips for Administering Indexes
Chapter 12. 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 Statistics
Rules for Updating Column Statistics
Rules for Updating Distribution Statistics for Columns
Rules for Updating Index Statistics
Updating Statistics for User-Defined Functions
Modelling Production Databases
Chapter 13. Understanding the SQL Compiler
Overview of the SQL Compiler
Query Rewrite 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
Chapter 14. 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
Part 4. Tuning and Configuring Your System
Chapter 15. 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
Avoiding the Need to Reorganize Tables
Performance Considerations for DMS Devices
Managing Initialization Overhead
Database Agents
Using the Database System Monitor
Extending Memory
Chapter 16. 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 17. 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 18. 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 19. Benchmark Testing
Benchmark Testing Methodology
Preparing for Benchmark Testing
Creating a Benchmark Program
Executing the Benchmark Tests
Chapter 20. 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
Status
Compiler Settings
Communications
Communication Protocol Setup
Distributed Services
DB2 Discovery
Parallel
Connection Elapse Time (conn_elapse)
Number of FCM Message Anchors (fcm_num_anchors)
Number of FCM Buffers (fcm_num_buffers)
Number of FCM Connection Entries (fcm_num_connect)
Number of FCM Request Blocks (fcm_num_rqb)
Node Connection Retries (max_connretries)
Maximum Query Degree of Parallelism (max_querydegree)
Maximum Time Difference Among Nodes (max_time_diff)
Enable Intra-Partition Parallelism (intra_parallel)
Start and Stop Timeout (start_stop_time)
Instance Management
Diagnostic
Database System Monitor Parameters
System Management
Instance Administration
DB2 File Manager
DataLink Access Token Expiry Interval (dl_expint)
DataLink Number of Backups (dl_num_backup)
DataLink Number of Copies (dl_num_copies)
DataLink Time After Drop (dl_time_drop)
Part 5. Ensuring the High Availability of Your System
Chapter 21. High Availability Cluster Multi-Processing (HACMP) on AIX
Hot Standby
Examples
Mutual Takeover
Examples
Additional HACMP Resources
Chapter 22. 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 23. 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 24. 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 25. 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 6. Appendixes
Appendix A. How the DB2 Library Is Structured
SmartGuides
Online Help
DB2 Books
Viewing Online Books
Searching Online Books
Printing the PostScript Books
Ordering the Printed DB2 Books
Information Center
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
System Catalog Tables/Views
System Catalog Views
System Catalog Tables
Unique Table Identification
Application Programming
NS, NW and NX Locks
CREATE TABLE NOT LOGGED INITIALLY
DB2 Call Level Interface (DB2 CLI) Defaults
Obsolete DB2 CLI Keywords
DB2 CLI SQLSTATEs
DB2 CLI Mixing Embedded SQL, Without CONNECT RESET
DB2 CLI Use of VARCHAR FOR BIT DATA
DB2 CLI Data Conversion Values for SQLGetInfo
DB2 CLI/ODBC Configuration Keyword Defaults
Obsolete DB2 CLI/ODBC Configuration Keywords
DB2 CLI SQLSTATEs
Stored Procedure Catalog Table
PREP Command - LANGLEVEL
Change to SMALLINT Constants
Down-level Client and Distinct Types Sourced on BIGINT
Error Handling
Maximum Number of Sections in a Package
Bind Warnings
Bind Options
PREP with BINDFILE
Varchar Structures in COBOL
Incompatible APIs
Supported Level of JDBC
Calling Convention for Java Stored Procedures and UDFs
Java Runtime Environment
Obsolete System Monitor Requests for DB2 PE Version 1.2
SQL
Updating Partitioning Key Columns
Column NGNAME
Node Number Temporary Space Usage
Authorities for Create and Drop Nodegroups
Target Map in REDISTRIBUTE NODEGROUP
Node Group for Create Table
Revoking CONTROL on Tables or Views
High Level Qualifiers for Objects in DB2 Version 5
Inoperative VIEWs
Unusable VIEWs
SQLCODE Changes
WITH CHECK OPTION on CREATE VIEW
SQLSTATE Changes
FOR BIT DATA Comparisons
Code Page Conversion
Isolation Levels and Blocking All
ORDER BY Temporary Space Usage
Using Quotes in SQL Statements
Database Security and Tuning
GROUP Authorizations
Authentication Type
SYSADM Groups
Security Enhancements
Obsolete Profile Registry and Environment Variables
Utilities and Tools
Executable Name Changes
Backup and Restore - BUFF_SIZE Parameter
Backup and Restore - Changes Only Option
Backup and Restore - User Exits
Backup and Restore - Authority
Import - IMPORT REPLACE Option
LOAD TERMINATE
REORG - Alternate Path Option
Connectivity and Coexistence
Distributed Transaction Processing - Connect Type
Distributed Transaction Processing - SQLERRD Changes
DDCS - SQLJSETP
DDCS - DDCSSETP
DDCS - SQLJTRC.CMD
DDCS - SQLJBIND.CMD
APPC and APPN Nodes
Configuration Parameters
ADSM_PASSWORD
Agent Pool Size (NUM_POOLAGENTS)
MAXDARI and MAXCAGENTS
LOGFILSIZ
PCKCACHEFILSIZ
APPLHEAPSZ and APP_CTL_HEAP_SZ
BUFFPAGE and Multiple Buffer Pools
NEWLOGPATH
MULTIPAGE_ALLOC
EXTENTSIZE vs SEGPAGES
LOCKLIST
BUFFPAGE and SORTHEAP
Numeric Values for Database Manager Configuration Tokens
Numeric Values for Database Manager Configuration Tokens
New Generic Out-of-Range Return Codes
Segments versus 4KB Pages
Obsolete Database Configuration Parameters
Obsolete Database Manager Configuration Parameters
DB2_MMAP_READ and DB2_MMAP_WRITE
Appendix D. Memory Usage for DB2 Universal Database Version 5
Appendix E. Naming Rules
Database Names
Database and Database Alias Names
User IDs and Passwords
Schema Names
Group and User Names
Object Names
Appendix F. DB2 Registry and Environment Variables
Appendix G. 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 H. X/Open Distributed Transaction Processing Model
Application Program (AP)
Transaction Manager (TM)
Resource Managers (RM)
Appendix I. 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 J. Catalog Views
Updatable Catalog Views
"Roadmap" to Catalog Views
"Roadmap" to Updatable Catalog Views
SYSCAT.BUFFERPOOLS
SYSCAT.BUFFERPOOLNODES
SYSCAT.CHECKS
SYSCAT.COLAUTH
SYSCAT.COLCHECKS
SYSCAT.COLDIST
SYSCAT.COLUMNS
SYSCAT.CONSTDEP
SYSCAT.DATATYPES
SYSCAT.DBAUTH
SYSCAT.EVENTMONITORS
SYSCAT.EVENTS
SYSCAT.FUNCPARMS
SYSCAT.FUNCTIONS
SYSCAT.INDEXAUTH
SYSCAT.INDEXES
SYSCAT.KEYCOLUSE
SYSCAT.NODEGROUPDEF
SYSCAT.NODEGROUPS
SYSCAT.PACKAGEAUTH
SYSCAT.PACKAGEDEP
SYSCAT.PACKAGES
SYSCAT.PARTITIONMAPS
SYSCAT.PROCEDURES
SYSCAT.PROCPARMS
SYSCAT.REFERENCES
SYSCAT.SCHEMAAUTH
SYSCAT.SCHEMATA
SYSCAT.STATEMENTS
SYSCAT.TABAUTH
SYSCAT.TABCONST
SYSCAT.TABLES
SYSCAT.TABLESPACES
SYSCAT.TRIGDEP
SYSCAT.TRIGGERS
SYSCAT.VIEWDEP
SYSCAT.VIEWS
SYSSTAT.COLDIST
SYSSTAT.COLUMNS
SYSSTAT.FUNCTIONS
SYSSTAT.INDEXES
SYSSTAT.TABLES
Appendix K. Catalog Views For Use With Structured Types
Updatable Catalog Views For Use With Structured Types
"Roadmap" to Catalog Views for Structured Types
"Roadmap" to Updatable Catalog Views For Structured Types
OBJCAT.ATTRIBUTES
OBJCAT.CHECKS
OBJCAT.COLCHECKS
OBJCAT.COLUMNS
OBJCAT.CONSTDEP
OBJCAT.DATATYPES
OBJCAT.FUNCPARMS
OBJCAT.FUNCTIONS
OBJCAT.HIERARCHIES
OBJCAT.INDEXES
OBJCAT.KEYCOLUSE
OBJCAT.PACKAGEDEP
OBJCAT.REFERENCES
OBJCAT.TABCONST
OBJCAT.TABLES
OBJCAT.TRIGDEP
OBJCAT.TRIGGERS
OBJCAT.VIEWDEP
OBJSTAT.TABLES
Appendix L. 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 M. 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
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
Appendix N. 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
db2exfmt - Explain Table Format Tool
Appendix O. National Language Support (NLS)
Deriving Code Page Values
Deriving Locales in Application Programs
How DB2 Derives Locales
Country Code and Code Page Support
Character Sets
DBCS Character Sets
Extended UNIX Code (EUC) Character Sets
Character Set for Identifiers
Coding of SQL Statements
Bidirectional CCSID Support
Collating Sequences
Specifying a Collating Sequence
Datetime Values
Date
Time
Timestamp
String Representations of Datetime Values
Date Strings
Time Strings
Timestamp Strings
MBCS Considerations
Appendix P. Splitting Data with db2split
Using db2split
Populating a Table in a New Table Space
Populating a Table in an Existing Table Space
db2split Parameters
Example Data File for db2split
Getting a Partitioning Map with db2gpmap
Running db2split
db2split Header Information
Appendix Q. 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
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 R. 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 S. Configuring Multiple Logical Nodes
Appendix T. Using Virtual Interface Architecture (VIA)
Appendix U. Notices
Trademarks
Trademarks of Other Companies
Index
Appendix V. Contacting IBM
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]