How This Book is Structured
Conventions
The DB2 Connect Products
Working with DB2 Data
Accessing Host or AS/400 DB2 Data using DB2 Connect Personal Edition
Connections via Communications Gateway
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
Managing Connections to Databases using the Client Configuration Assistant
Managing Warehouses using the Data Warehouse Center
Developing Applications using the Application Development Client
Running Your Own Applications
Typical Steps Required to Install and Configure DB2 Connect
DB2 Connect: Planning and Installation
Memory Requirements
Disk Requirements
Estimating Fixed Disk Requirements
Software Requirements
Product Requirements
Possible Client-to-Server Connectivity Scenarios
Migrating from Previous Versions of DB2 Connect
Before You Begin
Installing DB2 Connect on Red Hat Linux
Installing DB2 Connect on SuSE Linux
Installing DB2 Connect on Turbo Linux
Installing DB2 Connect on Caldera Open Linux
Installation Steps
Step 1. Identify and Record Parameter Values
Step 2. Mount the CD-ROM
Step 3. Install a DB2 Product
Preparing Host and AS/400 Databases for DB2 Connect Communications
Preparing OS/390 for DB2 Connect
Verify that the Correct PTFs Have Been Applied to your OS/390 SystemDB2 Universal Database for OS/390
Configure DB2 Universal Database for OS/390
Configure TCP/IP for DB2 Universal Database for OS/390
Configuring DB2 Connect to Communicate with Host and AS/400 Databases
Step 1. Identify and Record Parameter Values
Step 2. Configure the DB2 Connect Workstation
A. Resolve the Host's IP Address
B. Update the Services File
Step 3. Catalog the TCP/IP Node
Step 4. Catalog the Database as a Database Connection Service (DCS) Database
Step 5. Catalog the Database
Step 6. Bind Utilities and Applications to the Database Server
Step 7. Update the DB2 Connect Configuration
Step 8. Test the Host or AS/400 Connection
Test the Host Connection
Host and AS/400 Multisite Update Scenarios that Require SPM
Using the Control Center to Enable Multisite Updates
Starting the Multisite Update Wizard
Wizard Steps
Testing the Multisite Update Feature
Binding Database Utilities
Binding to Host Databases
Binding to DB2 Universal Databases
Running CLI/ODBC Programs
Platform Specific Details for CLI/ODBC Access
Detailed Configuration Information
Running Java Programs
Configuring the Environment
Java Applications
Java Applets
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
Packaging
Products and Selectable Components
Starting the License Registration Tool
Starting the Control Center
Entering Commands Using the Command Center
Entering Commands Using the Command Line Processor
Command Line Mode
Interactive Input Mode
Working with the System Administrative Group
Language and Codeset Support for UNIX Operating Systems
Conversion of Character Data
Bidirectional CCSID Support
Bidirectional-specific CCSIDs
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
Preparing DB2 for OS/390 Servers for the Control Center
Using the Control Center
List Files Associated with DRDA Servers
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
Trademarks