DB2 Connect Quick Beginnings for UNIX**

Table of Contents

  • Welcome to DB2 Connect!
    Conventions

    Introduction to DB2 Connect on UNIX

  • About DB2 Connect
    The DB2 Connect Products
    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
    Managing Warehouses using the Data Warehouse Center
    Understanding the Administration Server
    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
    DB2 Client Memory Requirements
    Disk Requirements
    Client Components
    Software Requirements
    Server Product Requirements
    Client Product Requirements
    Possible Client-to-Server Connectivity Scenarios
    Migrating from Previous Versions of DB2 Connect
    Preparing Databases and Instances for Migration
    Your Next Step

    Installing DB2 Connect

  • Installing DB2 Connect for AIX
    Installing DB2 Connect for AIX Using the db2setup Utility
    Manually Installing DB2 Connect for AIX
    DB2 Connect for AIX Post-installation Tasks
    Creating links for DB2 Connect files

  • Installing DB2 Connect for HP-UX
    Updating HP-UX Kernel Configuration Parameters
    Installing DB2 Connect for HP-UX Using the db2setup Utility
    Manually Installing DB2 Connect for HP-UX
    DBV7HTML fileset post-installation tasks
    DB2 Connect for HP-UX Post-installation tasks
    Creating links for DB2 Connect files

  • Installing DB2 Connect for Linux
    Enabling Your Linux Workstation for a DB2 Connect Installation
    Installing DB2 Connect on Red Hat Linux
    Installing DB2 Connect on Caldera Open Linux
    Installing DB2 Connect on Turbo Linux
    Installing DB2 Connect on SuSE Linux
    Installing DB2 Connect for Linux Using the db2setup Utility
    Manually Installing DB2 Connect for Linux
    DB2 Connect Post-Installation Tasks
    Creating Links for DB2 Files

  • Installing DB2 Connect for NUMA-Q
    Updating NUMA-Q/PTX Kernel Configuration Parameters
    Installing DB2 Connect for NUMA-Q Using the db2setup Utility
    Manually Installing DB2 Connect for NUMA-Q
    Installing DB2 Connect for NUMA-Q Product Messages
    DB2 Connect for NUMA-Q Post-installation tasks
    Creating links for DB2 Connect files

  • Installing DB2 Connect for Solaris
    Updating Solaris kernel configuration parameters
    Installing DB2 Connect for Solaris using the db2setup utility
    Manually installing DB2 Connect for Solaris
    Installing the DB2 for Solaris Product Library
    Installing DB2 for Solaris Product Messages
    DB2 for Solaris post-installation tasks
    Creating links for DB2 Connect files

  • Contents of the DB2 Products for UNIX platforms
    Packaging
    Products and Selectable Components

  • Removing DB2 Products
    Stop the Administration Server
    Stop all DB2 instances
    Remove the Administration Server
    Remove DB2 instances (Optional)
    Remove DB2 Products

    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 Access to Host and AS/400 Databases

  • Manually Configuring TCP/IP Communications on the DB2 Connect Workstation
    1. Identify and Record Parameter Values
    2. Configure the DB2 Connect Workstation
    A. Resolve the Host's IP Address
    B. Update the Services File
    3. Catalog the TCP/IP 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
    Test the Host Connection

  • 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 Communication Server for AIX
    Configuring Bull SNA for AIX
    Configuring SNAPlus2 for HP-UX
    Configuring SNAP-IX Version 6.0.1 for SPARC Solaris
    Configuring SunLink 9.1 for Solaris
    3. Catalog the APPC 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

  • DB2 Connect SYSPLEX Support
    How DB2 SYSPLEX Exploitation Works
    Priority Information Used for Load Balancing and Fault Tolerance
    How DB2 Connect Uses the Cached Address List
    Configuration Requirements for SYSPLEX
    Considerations for System/390 SYSPLEX Exploitation

    Installing and Configuring DB2 Clients

  • Installing DB2 Clients
    DB2 Run-Time Client
    DB2 Administration Client
    DB2 Application Development Client
    Distributed Installation
    DB2 Thin Client

  • Installing DB2 Clients on Windows 32-Bit Operating Systems
    Before You Begin Installing
    Installing Without Administrator Authority
    Installation Steps

  • Installing DB2 Clients on OS/2 Operating Systems
    Before You Begin Installing
    Installation Steps

  • Installing DB2 Clients on UNIX Operating Systems
    Before You Begin
    About the db2setup utility
    Updating Kernel Configuration Parameters
    HP-UX Kernel Configuration Parameters
    NUMA-Q/PTX Kernel Configuration Parameters
    Solaris Kernel Configuration Parameters
    Installing Your DB2 Client
    Your next step

  • 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

  • Configuring Client-to-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

  • 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
    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 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
    Mounting CD-ROMs on UNIX Operating Systems
    Mounting the CD-ROM on AIX
    Mounting the CD-ROM on HP-UX
    Mounting the CD-ROM on Linux
    Mounting the CD-ROM on PTX
    Mounting the CD-ROM on Solaris
    Upgrading DB2 from Try and Buy Mode

  • 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)
    Language and Codeset Support for UNIX Operating Systems
    Code Page and Language Support for OS/2 and Windows Operating Environments
    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

  • Index

  • Contacting IBM
    Product Information