DB2 Connect Quick Beginnings PE

Table of Contents

  • Welcome to DB2 Connect!
    Conventions

    An Introduction to DB2 Connect

  • About DB2 Connect
    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 DB2 Application Development Client
    Running Your Own Applications
    Typical Steps Required to Install and Configure DB2 Connect

    Planning and Installation

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

  • Installing DB2 Connect on OS/2
    Before You Begin
    Performing the Installation

  • Installing DB2 Connect on Windows
    Before You Begin
    Performing the Installation

    Preparing Host and AS/400 Databases for DB2 Connect Communications

  • Configuring Host and AS/400 Databases for DB2 Connect
    Preparing OS/390 (or MVS/ESA) 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
    Using the CCA
    Configuration Steps
    Adding a Database Using a Profile
    Adding a Database Using Discovery
    Adding a Database Manually
    Binding DB2 Utilities and Applications

  • Manually Configuring APPC Communications on the DB2 Connect Workstation
    1. Identify and Record Parameter Values
    2. Update the APPC Profiles on the DB2 Connect Workstation
    Configuring IBM eNetwork Communications Server for Windows
    Configuring IBM eNetwork Communications Server for Windows NT SNA API Client
    Configuring Microsoft SNA Server for Windows
    Configuring Microsoft SNA Client
    3. Catalog the APPC or APPN Node
    4. Catalog the Database as a Database Connection Service (DCS) Database
    5. Catalog the Database
    6. Bind Utilities and Applications to the Database Server
    7. Test the Host or AS/400 Connection

  • Enabling Multisite Updates (Two-Phase Commit)
    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

    Configuring DB2 Clients to Use DB2 Connect

  • Configuring Client-to-Server Communications Using the Client Configuration Assistant
    LDAP Directory Support Considerations
    Before You Begin
    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

  • Control Center Installation and Configuration
    Application versus Applet
    Machine Configurations
    Supported Java Virtual Machines for the Control Center
    Setting Up and Working with the Control Center
    Control Center Services Setup (Applet Mode only)
    Working with the Control Center
    Functional Considerations
    Installation Tips for Control Center Help on UNIX Operating Systems
    Configuring TCP/IP on OS/2
    Enabling Local Loopback
    Enabling Localhost
    Verifying TCP/IP Configuration on OS/2
    Troubleshooting Information
    Administering DB2 for OS/390 and DB2 Connect Enterprise Edition servers with the Control Center
    Preparing DB2 for OS/390 Servers for the Control Center
    Working with the Control Center
    Other Sources of Information

    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

    Appendixes

  • Appendix A. Basic Task Knowledge
    Starting the Client Configuration Assistant
    Starting the DB2 Control Center
    Entering Commands Using the Command Center
    Entering Commands Using the Command Line Processor
    DB2 Command Window
    Interactive Input Mode
    Working with the System Administrative Group
    Granting Advanced User Rights on Windows
    Windows NT
    Windows 2000
    Upgrading DB2 from Try and Buy Mode
    Uninstalling DB2 Connect

  • Appendix B. Using the DB2 Library
    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

  • Appendix C. National Language Support (NLS)
    Code Page and Language Support
    Conversion of Character Data
    Bidirectional CCSID Support
    Bidirectional-specific CCSIDs

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

  • Appendix F. Notices
    Trademarks

  • Appendix G. Contacting IBM
    Product Information

  • Index