Quick Beginnings for UNIX
IBM DB2 Connect
Enterprise Edition
Quick Beginnings for
UNIX
Version 6
GC09-2829-00
CT6DTNA
Before using this information and the product it supports, be sure to read
the general information under Appendix I. Notices.
This document contains proprietary information of IBM. It is
provided under a license agreement and is protected by copyright law.
The information contained in this publication does not include any product
warranties, and any statements provided in this manual should not be
interpreted as such.
Order publications through your IBM representative or the IBM branch office
serving your locality or by calling 1-800-879-2755 in the United
States or 1-800-IBM-4YOU in Canada.
When you send information to IBM, you grant IBM a nonexclusive right to use
or distribute the information in any way it believes appropriate without
incurring any obligation to you.
© Copyright International Business Machines Corporation 1993, 1999. All rights reserved.
Note to U.S. Government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.
Introduction to DB2 Connect on UNIX Systems
About DB2 Connect
Working with DB2 Data
Accessing DB2 Data from Remote Clients
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
Administering Instances and Databases with the DB2 Administration Tools
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
Understanding the Administration Server
Developing Applications Using the DB2 Software Developer's Kit
Running Your Own Applications
DB2 Connect Installation
Planning for Installation
Memory Requirements
DB2 Connect Requirements
DB2 Client Requirements
Disk Requirements
Estimating Fixed Disk Requirements
Software Requirements
Server Product Requirements
Client Product Requirements
Possible Client-to-Server Connectivity Scenarios
Security Requirements
Installing DB2 Connect on UNIX Systems
Before You Begin
Installation Steps
Step 1. Identify and Record Parameter Values
Step 2. Update Kernel Configuration Parameters
Step 3. Mount the CD-ROM
Step 4. Install the DB2 Products
Software Registration
Preparing Host and AS/400 Databases for DB2 Connect Communications
Configuring Host and AS/400 Databases for DB2 Connect
Preparing MVS/ESA or OS/390 for DB2 Connect
Summary of Steps
Configuring VTAM
Configuring DB2 Universal Database for OS/390
Configuring DB2 for MVS/ESA
Configuring TCP/IP for DB2 Universal Database for OS/390
Preparing DB2 Universal Database for AS/400 for DB2 Connect
Preparing DB2 for VSE & VM
Configuring Access to Host and AS/400 Databases
Configuring TCP/IP Communications on the DB2 Connect Workstation
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. Test the Host or AS/400 Connection
Test the Host Connection
Configuring APPC Communications on the DB2 Connect Workstation
Step 1. Identify and Record Parameter Values
Step 2. Update the APPC Profiles on the DB2 Connect Workstation
Configuring IBM eNetwork Communication Server for AIX
Configuring Bull SNA for AIX
Configuring SNAPlus2 for HP-UX
Configuring SunLink SNA for Solaris
Step 3. Catalog the APPC 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. Test the Host or AS/400 Connection
Enabling Multisite Updates (Two-Phase Commit)
Enabling Multisite Updates Using the Control Center
Starting the Multisite Update Smartguide
Smartguide Steps
Testing the Multisite Update Feature
Installing and Configuring Clients
Installing DB2 Clients
Installing DB2 Clients on Windows 32-Bit Operating Systems
Before You Begin
Installation Steps
Installing DB2 Clients on OS/2 Operating Systems
Before You Begin
Installation Steps
Installing DB2 Clients on UNIX Operating Systems
Before You Begin
Installation Steps
Step 1. Update Kernel Configuration Parameters
Step 2. Mount the CD-ROM
Step 3. Perform the Installation
Configuring Client-to-Server Communications Using the Client Configuration Assistant
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 Client-to-Server Communications Using the Command Line Processor
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
Using DB2 Connect
Running Your Own Applications
Binding Database Utilities
Binding to Host 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
Appendixes
Appendix A. Basic Task Knowledge
Starting the Software Registration Tool
Starting the Client Configuration Assistant
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
Appendix B. Migrating from Previous Versions and Releases
Migrating from Previous Versions of DB2
Migrating Instances
Step 1. Prepare the DB2 Instance for Migration
Step 3. Migrate the DB2 Instance
Migrating the DB2 Syncpoint Manager to Version 6.0
Migrating from HP-UX Version 10 to Version 11
Appendix C. Using the Control Center to Administer DB2 for OS/390 and DB2 Connect Enterprise Edition servers
Preparing DB2 for OS/390 Servers for the Control Center
Using the Control Center
Appendix D. db2cpic.dll - Extended SNA Security Codes on Windows NT and Windows 95
Appendix E. How the DB2 Library Is Structured
Completing Tasks with SmartGuides
Accessing Online Help
DB2 Information - Hardcopy and Online
Viewing Online Information
Accessing Information with the Information Center
Setting Up a Document Server
Searching Online Information
Printing the PostScript Books
Ordering the Printed Books
Appendix F. National Language Support (NLS)
Language and Codeset Support for UNIX Operating Systems
Code Page and Language Support for OS/2 and Windows Operating Environments
Conversion of Character Data
Bidirectional CCSID Support
Bidirectional-specific CCSIDs
Appendix G. Naming Rules
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
Appendix H. List Files, Bind Files, and Packages
List Files Associated with DRDA Servers
Appendix I. Notices
Trademarks
Trademarks of Other Companies
Appendix J. Contacting IBM
Index
[ Top of Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]