IBM Books

Quick Beginnings for DB2 Connect

IBM DB2 Connect
Personal Edition
Quick Beginnings for DB2 Connect

Version 6

GC09-2830-00


CT6D9NA

Before using this information and the product it supports, be sure to read the general information under Appendix H. 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
  • Managing Connections to Databases Using the Client Configuration Assistant
  • Developing Applications Using the DB2 Software Developer's Kit
  • Running Your Own Applications

  • DB2 Connect: Planning and Installation

  • Planning for Installation
  • Memory Requirements
  • DB2 Connect Requirements
  • Disk Requirements
  • Estimating Fixed Disk Requirements
  • Software Requirements
  • Product Requirements
  • Installing DB2 Connect on OS/2
  • Before You Begin
  • Performing the Installation
  • Software Registration
  • Installing DB2 Connect on Windows 9x or Windows NT
  • Before You Begin
  • Performing the Installation
  • 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 DB2 Connect to Communicate with Host and AS/400 Databases

  • Configuring DB2 Connect to Host or AS/400 Communications Using the CCA
  • Configuration Steps
  • Adding a Database Using a Profile
  • Adding a Database Using Discovery
  • Adding a Database Manually
  • 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 Communications Server for Windows NT
  • Configuring IBM eNetwork Communications Server for Windows NT SNA API Client
  • Configuring Microsoft SNA Server for Windows NT
  • Configuring Microsoft SNA Client
  • Step 3. Catalog the APPC or APPN 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

  • Configuring DB2 Clients to Use DB2 Connect

  • 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

  • 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

  • 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. 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 C. db2cpic.dll - Extended SNA Security Codes on Windows NT and Windows 95

  • Appendix D. 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 E. National Language Support (NLS)
  • Code Page and Language Support
  • Conversion of Character Data
  • Bidirectional CCSID Support
  • Bidirectional-specific CCSIDs
  • Appendix F. 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 G. List Files, Bind Files, and Packages
  • List Files Associated with DRDA Servers
  • Appendix H. Notices
  • Trademarks
  • Trademarks of Other Companies
  • Appendix I. Contacting IBM

  • Index


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

    [ DB2 List of Books | Search the DB2 Books ]