DB2 Connect Quick Beginnings for Linux**

Table of Contents

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

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

    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
    Migrating from Previous Versions of DB2 Connect

  • Security Requirements

  • Installing and Configuring DB2 Connect Personal Edition for Linux
    Before You Begin
    Installing DB2 Connect on Red Hat Linux
    Installing DB2 Connect on SuSE Linux
    Installing DB2 Connect on Turbo Linux
    Installing DB2 Connect on Caldera Open Linux
    Installation Steps
    Step 1. Identify and Record Parameter Values
    Step 2. Mount the CD-ROM
    Step 3. Install a DB2 Product

  • DB2 Connect Post-Installation Migration Tasks

    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)
    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

    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. Contents of the DB2 Products for Linux
    Packaging
    Products and Selectable Components

  • Appendix B. Basic Task Knowledge
    Starting the License 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 C. National Language Support (NLS)
    Language and Codeset Support for UNIX Operating Systems
    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. 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 F. List Files, Bind Files, and Packages
    List Files Associated with DRDA Servers

  • Appendix G. 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 H. Notices
    Trademarks

  • Appendix I. Contacting IBM
    Product Information

  • Index