IBM Books

Administration Guide

Table of Contents

  • About This Book
  • Who Should Use This book
  • How This Book is Structured
  • Introduction to Parallelism in DB2 Universal Database
  • Overview of DB2 Concepts
  • Overview of DB2 Parallelism Concepts
  • Types of Parallelism
  • Hardware Environments
  • Enabling Parallelism for Queries
  • Enabling Utility Parallelism

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