IBM Books

Quick Beginnings for OS/2 and Windows NT

IBM DB2 Connect
Enterprise Edition
Quick Beginnings for OS/2 and Windows NT

Version 6

GC09-2828-00


CT6DSNA

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 for OS/2 and Windows NT

  • 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 Windows NT
  • Before You Begin
  • Performing the Installation
  • Software Registration
  • Installing DB2 Connect on OS/2
  • 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 Access to 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 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

  • 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
  • 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
  • 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. 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 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. 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 ]