IBM Books

Quick Beginnings for DB2 Connect


Before using this information and the product it supports, be sure to read the general information under Appendix G, 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.

Table of Contents

  • Welcome to DB2 Connect!
  • How This Book is Structured
  • Conventions

    • Introduction to DB2 Connect

  • About DB2 Connect
  • 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
  • Administering Instances and Databases with the DB2 Administration Tools
  • Developing Applications Using the DB2 Software Developer's Kit
  • Running Your Own Applications

    • DB2 Connect: Planning and Installation

  • Planning for Installation
  • Memory Requirements
  • Disk Requirements
  • Estimating Fixed Disk Requirements
  • Software Requirements
  • Product Requirements

  • Possible Client-to-Server Connectivity Scenarios

  • Security Requirements

  • Installing and Configuring DB2 Connect Personal Edition
  • Before You Begin
  • Installation Steps
  • Step 1. Identify and Record Parameter Values
  • Step 2. Mount the CD-ROM
  • Step 3. 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 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

  • Configuring Communications to Host or AS/400-Based Servers Using the Command Line Processor
  • 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

  • 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

    • Using DB2 Connect

  • Running Your Own Applications
  • 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 Client to LAN-Based 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

    • Appendixes

  • Appendix A. Basic Task Knowledge
  • Starting the Software 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

  • Appendix B. National Language Support (NLS)
  • Language and Codeset Support for UNIX Operating Systems
  • Conversion of Character Data
  • Bidirectional CCSID Support
  • Bidirectional-specific CCSIDs

  • Appendix C. 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
  • DB2SYSTEM Naming Rules
  • Password Rules

  • Appendix D. 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 E. List Files, Bind Files, and Packages
  • List Files Associated with DRDA Servers

  • Appendix F. 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 G. Notices
  • Trademarks
  • Trademarks of Other Companies

  • Appendix H. Contacting IBM

  • Index

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

    [ DB2 List of Books | Search the DB2 Books ]