Conventions
Conventions
Introduction to DB2 Universal Database
Processing in a Partitioned Database Environment
Cost-Based Query Optimization
Configuration
Machines and Storage
Nodegroups and Data Partitioning
Multiple Logical Nodes
Instances
Fast Communications Manager
High Availability
DB2 Server Installation and Initial Configuration
Memory Requirements
Disk Requirements
DB2 Servers
DB2 Clients
Software Requirements
Server Product Requirements
Client Product Requirements
Possible Client-to-Server Connectivity Scenarios
Migrating from Previous Versions of DB2
Preparing Databases and Instances for Migration
NetQuestion Search System
Your next step
Before You Begin
Performing the Installation
Post Installation Steps
Step 1. Create a DB2 Instance
Step 2. Create the Administration Server
Step 3. Update the Node Configuration File
Step 4. Enable the Fast Communications Manager
Step 5. Modify the Environment to run DB2 Enterprise - Extended Edition
Step 6. Enable the Execution of Remote Commands
Step 7. Create Links for DB2 Files (Optional)
Step 8. Start the Administration Server
Step 9. Create the SAMPLE Database (Optional)
Step 10. Install the License Key
Before You Begin
Performing the Installation
Post Installation Steps
Step 1. Create a DB2 Instance
Step 2. Create the Administration Server
Step 3. Update the Node Configuration File
Step 4. Enable the Fast Communications Manager
Step 5. Enable the Execution of Remote Commands
Step 6. Create Links for DB2 Files (Optional)
Step 7. Start the Administration Server
Step 8. Create the SAMPLE Database (Optional)
Step 9. Install the License Key
Before You Begin
Performing the Installation
Post Installation Steps
Step 1. Create a DB2 Instance
Step 2. Create the Administration Server
Step 3. Update the Node Configuration File
Step 4. Enable the Fast Communications Manager
Step 5. Enable the Execution of Remote Commands
Step 6. Create Links for DB2 Files (Optional)
Step 7. Start the Administration Server
Step 8. Create the SAMPLE Database (Optional)
Step 9. Install the License Key
Before You Begin
Performing the Installation
Post Installation Steps
Step 1. Create a DB2 Instance
Step 2. Create the Administration Server
Step 3. Update the Node Configuration File
Step 4. Enable the Fast Communications Manager
Step 5. Check Available Paging Space
Step 5. Enable the Execution of Remote Commands
Step 6. Create Links for DB2 Files (Optional)
Step 7. Start the Administration Server
Step 8. Create the SAMPLE Database (Optional)
Step 9. Install the License Key
Migrating Instances
Possible Migration Error Messages and User Responses
Migrating Databases
Optional Post-Migration Tasks
DB2 Universal Database Administration Guide
DB2 Universal Database Administration Guide: Planning
DB2 Universal Database Administration Guide: Implementation
DB2 Universal Database Administration Guide: Performance
Task Information in other DB2 Documentation
DB2 Run-Time Client
DB2 Administration Client
DB2 Application Development Client
Distributed Installation
DB2 Thin Client
Before You Begin Installing
Installing Without Administrator Authority
Installation Steps
Before You Begin Installing
Installation Steps
Before You Begin
About the db2setup utility
Updating Kernel Configuration Parameters
HP-UX Kernel Configuration Parameters
NUMA-Q/PTX Kernel Configuration Parameters
Solaris Kernel Configuration Parameters
Installing Your DB2 Client
Your next step
Application versus Applet
Machine Configurations
Supported Java Virtual Machines for the Control Center
Setting Up and Working with the Control Center
Control Center Services Setup (Applet Mode only)
Working with the Control Center
Functional Considerations
Installation Tips for Control Center Help on UNIX Operating Systems
Configuring TCP/IP on OS/2
Enabling Local Loopback
Enabling Localhost
Verifying TCP/IP Configuration on OS/2
Troubleshooting Information
Administering DB2 for OS/390 and DB2 Connect Enterprise Edition servers with the Control Center
Preparing DB2 for OS/390 Servers for the Control Center
Working with the Control Center
Other Sources of Information
Configuring DB2 Communications
LDAP Directory Support Considerations
Before You Begin
Configuration Steps
Adding a Database Using a Profile
Adding a Database Using Discovery
Adding a Database Manually
Creating and Using Profiles
Server Profiles
Client Profiles
Configuring TCP/IP on the Client
Step 1. Identify and Record Parameter Values
Step 2. Configure the Client
Step 3. Test the Client-to-Server Connection
Starting the Client Configuration Assistant
Starting the DB2 Control Center
Entering Commands Using the Command Center
Entering Commands Using the Command Line Processor
DB2 Command Window
Interactive Input Mode
Working with the System Administrative Group
Working with the Business Intelligence Functions
Mounting CD-ROMs on UNIX Operating Systems
Mounting the CD-ROM on AIX
Mounting the CD-ROM on HP-UX
Mounting the CD-ROM on Linux
Mounting the CD-ROM on PTX
Mounting the CD-ROM on Solaris
Setting the Number of Licensed Processors
Upgrading DB2 from Try and Buy Mode
Language and Codeset Support for UNIX Operating Systems
Code Page and Language Support for OS/2 and Windows Operating Environments
General Naming Rules
Database, Database Alias, and Catalog Node Name Rules
Object Name Rules
Username, User ID, Group Name, and Instance Name Rules
Workstation Name (nname) Rules
DB2SYSTEM Naming Rules
Password Rules
DB2 Products
DB2 Everywhere
DB2 Universal Database
Host Databases
DB2 Connect
Related Products
DB2 Relational Connect
DB2 Warehouse Manager
DB2 OLAP Server
Intelligent Miner
DB2 Spatial Extender
DB2 Net Search Extender
DB2 Data Links Manager
Tivoli Enterprise
Working with DB2 Data
Accessing DB2 Data from Remote Clients
Accessing Multiple DB2 Servers
Accessing Host or AS/400 DB2 Data from the Desktop using DB2 Connect Enterprise Edition
Accessing DB2 Data from the Web using Java
Accessing DB2 Data from the Web using Net.Data
Accessing DB2 Data from Host and AS/400 Client Machines
Administering Instances and Databases with the DB2 Administration Tools
Managing Instances and Database Objects using the Control Center
Managing Communications on the Server
Monitoring Databases using DB2 Performance Monitor
Viewing SQL Access Plans using Visual Explain
Managing Connections to Databases using the Client Configuration Assistant
Managing Warehouses using the Data Warehouse Center
Understanding the Administration Server
Developing Applications using the DB2 Application Development Client
Running Your Own Applications
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online
Stop the Administration Server
Stop all DB2 instances
Remove the Administration Server
Remove DB2 instances (Optional)
Remove DB2 Products