Release Notes

Administration

Partial Table-of-Contents

  • Administration Guide
  • |7.1 Update Available

  • Administration Guide: Planning
  • |8.1 Chapter 8. Physical Database Design
  • |8.1.1 Table Space Design Considerations
  • |8.1.1.1 Optimizing Table Space Performance when Data is Place on Raid
  • |8.1.2 Partitioning Keys
  • 8.2 Appendix D. Incompatibilities Between Releases
  • |8.2.1 Error SQL30081N not Returned when Lost Connection is Detected
  • 8.3 Appendix E. National Language Support (NLS)
  • |8.3.1 Country/Region Code and Code Page Support:
  • |8.3.2 Import/Export/Load Considerations -- Restrictions for Code Pages 1394 and 5488
  • |8.3.3 Datetime Values
  • |8.3.3.1 String Representations of Datetime Values
  • |8.3.3.2 Date Strings
  • |8.3.3.3 Time Strings
  • |8.3.3.4 Time Stamp Strings
  • |8.3.3.5 Character Set Considerations
  • |8.3.3.6 Date and Time Formats

  • |Administration Guide: Implementation
  • |9.1 Chapter 8. Recovering a Database
  • |9.1.1 How to Use Suspended I/O
  • |9.2 New Method for Specifying DMS containers on Windows 2000 and Later Systems
  • |9.3 Example for Extending Control Center

  • |Administration Guide: Performance
  • |10.1 System Temporary Table Schemas
  • |10.2 Chapter 8. Operational Performance
  • |10.2.1 Block- Based Buffer Pool
  • |10.2.1.1 Block-based Buffer Pool Examples
  • |10.3 Chapter 10. Scaling Your Configuration Through Adding Processors
  • |10.3.1 Problems When Adding Nodes to a Partitioned Database
  • |10.4 Chapter 13. Configuring DB2
  • |10.4.1 Log Archive Completion Now Checked More Frequently
  • |10.5 DB2 Registry and Environment Variables
  • |10.5.1 Corrections to Performance Variables
  • |10.5.2 Corrections and Additions to Miscellaneous Registry Variables
  • |10.5.3 Corrections and Additions to General Registry Variables

  • |Administering Satellites Guide and Reference
  • |11.1 Setting up Version 7.2 DB2 Personal Edition and DB2 Workgroup Edition as Satellites
  • |11.1.1 Prerequisites
  • |11.1.1.1 Installation Considerations
  • |11.1.2 Configuring the Version 7.2 System for Synchronization
  • |11.1.3 Installing FixPak 2 or Higher on a Version 6 Enterprise Edition System
  • |11.1.3.1 Upgrading Version 6 DB2 Enterprise Edition for Use as the DB2 Control Server
  • |11.1.4 Upgrading a Version 6 Control Center and Satellite Administration Center

  • |Command Reference
  • |12.1 Update Available
  • |12.2 db2updv7 - Update Database to Version 7 Current Fix Level
  • |12.3 REBIND
  • |Missing value
  • |12.4 db2inidb - Initialize a Mirrored Database
  • |12.4.1 Usage Information
  • |12.5 Additional Option in the GET ROUTINE Command
  • |GET ROUTINE
  • |12.6 CREATE DATABASE

  • |Data Recovery and High Availability Guide and Reference
  • |13.1 Data Recovery and High Availability Guide and Reference Available Online
  • |13.2 New Backup and Restore Behavior When LOGRETAIN=CAPTURE
  • |13.3 NEWLOGPATH2 Now Called DB2_NEWLOGPATH2
  • |13.4 Choosing a Backup Method for DB2 Data Links Manager on AIX or Solaris
  • |13.5 Tivoli Storage Manager -- LAN Free Data Transfer

  • Data Movement Utilities Guide and Reference
  • |14.1 Change to LOB File Handling by Export, Import and Load
  • |14.1.1 IXF considerations
  • |14.2 Code Page Support for Import, Export and Load Utilities
  • |14.3 db2relocatedb (new command)
  • |db2relocatedb - Relocate Database
  • |14.4 db2move -- New Options Available
  • |Moving Data Using the db2move Tool
  • 14.5 Chapter 2. Import
  • 14.5.1 Using Import with Buffered Inserts
  • 14.6 Chapter 3. Load
  • 14.6.1 Pending States After a Load Operation
  • 14.6.2 Load Restrictions and Limitations
  • 14.6.3 totalfreespace File Type Modifier
  • 14.7 Chapter 4. AutoLoader
  • 14.7.1 rexecd Required to Run AutoLoader When Authentication Set to YES
  • 14.8 AutoLoader May Hang During a Fork
  • 14.9 Appendix C. Export/Import/Load Utility File Formats

  • Replication Guide and Reference
  • 15.1 Replication and Non-IBM Servers
  • 15.2 Replication on Windows 2000
  • |15.3 Known Error When Saving SQL Files
  • |15.4 DB2 Maintenance
  • |15.5 Data Difference Utility on the Web
  • 15.6 Chapter 3. Data Replication Scenario
  • 15.6.1 Replication Scenarios
  • 15.7 Chapter 5. Planning for Replication
  • 15.7.1 Table and Column Names
  • 15.7.2 DATALINK Replication
  • 15.7.3 LOB Restrictions
  • 15.7.4 Planning for Replication
  • 15.8 Chapter 6. Setting up Your Replication Environment
  • 15.8.1 Update-anywhere Prerequisite
  • 15.8.2 Setting Up Your Replication Environment
  • 15.9 Chapter 8. Problem Determination
  • 15.10 Chapter 9. Capture and Apply for AS/400
  • 15.11 Chapter 10. Capture and Apply for OS/390
  • |15.11.1 Prerequisites for DB2 DataPropagator for OS/390
  • |15.11.2 UNICODE and ASCII Encoding Schemes on OS/390
  • |15.11.2.1 Choosing an Encoding Scheme
  • |15.11.2.2 Setting Encoding Schemes
  • 15.12 Chapter 11. Capture and Apply for UNIX platforms
  • |15.12.1 Setting Environment Variables for Capture and Apply on UNIX and Windows
  • 15.13 Chapter 14. Table Structures
  • 15.14 Chapter 15. Capture and Apply Messages
  • 15.15 Appendix A. Starting the Capture and Apply Programs from Within an Application

  • System Monitor Guide and Reference
  • 16.1 db2ConvMonStream

  • Troubleshooting Guide
  • 17.1 Starting DB2 on Windows 95, Windows 98, and Windows ME When the User Is Not Logged On
  • |17.2 Chapter 1. Good Troubleshooting Practices
  • |17.2.1 Problem Analysis and Environment Collection Tool
  • |17.2.1.1 Collection Outputs
  • |17.2.1.2 Viewing detailed_system_info.html
  • |17.2.1.3 Viewing DB2 Support Tool Syntax One Page at a Time
  • |17.3 Chapter 2. Troubleshooting the DB2 Universal Database Server
  • |17.4 Chapter 8. Troubleshooting DB2 Data Links Manager

  • Using DB2 Universal Database on 64-bit Platforms
  • 18.1 Chapter 5. Configuration
  • 18.1.1 LOCKLIST
  • 18.1.2 shmsys:shminfo_shmmax
  • 18.2 Chapter 6. Restrictions

  • XML Extender Administration and Programming

  • |MQSeries
  • |20.1 Installation and Configuration for the DB2 MQSeries Functions
  • |20.1.1 Install MQSeries
  • |20.1.2 Install MQSeries AMI
  • |20.1.3 Enable DB2 MQSeries Functions
  • |20.2 MQSeries Messaging Styles
  • |20.3 Message Structure
  • |20.4 MQSeries Functional Overview
  • |20.4.1 Limitations
  • |20.4.2 Error Codes
  • |20.5 Usage Scenarios
  • |20.5.1 Basic Messaging
  • |20.5.2 Sending Messages
  • |20.5.3 Retrieving Messages
  • |20.5.4 Application-to-Application Connectivity
  • |20.5.4.1 Request/Reply Communications
  • |20.5.4.2 Publish/Subscribe
  • |20.6 enable_MQFunctions
  • |enable_MQFunctions
  • |20.7 disable_MQFunctions
  • |disable_MQFunctions

    • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]