IBM Books

Quick Beginnings for DB2 Connect Enterprise Edition

Table of Contents

  • Welcome to DB2 Connect
  • Conventions
  • Road Map to DB2 Connect Information

    • Part 1. Introduction to DB2 Connect

  • Chapter 1. About DB2 Connect
  • Managing Connections to Databases Using the Client Configuration Assistant
  • Developing Applications Using the DB2 Software Developer's Kit
  • Accessing DB2 Data from the Web

  • Chapter 2. What's New in DB2 Connect Version 5.2?
  • DB2 Connect Version 5

  • Chapter 3. How to Use DB2 Connect in Your Network
  • Direct Connection to a Host or AS/400 Server
  • Connections via Communications Gateway
  • Connections via a DB2 Connect Enterprise Edition Server
  • Connections to DB2 Universal Database Servers

    • Part 2. DB2 Connect: Planning and Installation

  • Chapter 4. Planning for Installation
  • Memory Requirements
  • Disk Requirements
  • Estimating Fixed Disk Requirements
  • Software Requirements
  • Software Requirements for OS/2 Users
  • Software Requirements for Windows NT Users
  • Software Requirements for AIX Users
  • Software Requirements for HP-UX Users
  • Software Requirements for Solaris Users
  • Software Requirements for SCO UnixWare 7 Users
  • Client Product Requirements
  • Possible Client-to-Server Connectivity Scenarios
  • Security Requirements

  • Chapter 5. Installing DB2 Connect on OS/2 Systems
  • Before You Begin Installing on OS/2 Operating Systems
  • Selecting Products and Components
  • Performing the Installation on OS/2

  • Chapter 6. Installing DB2 Connect on Windows NT Systems
  • Before You Begin Installing on Windows NT
  • Creating Usernames for DB2 Installation and Operation
  • Selecting Products and Components
  • Performing the Installation

  • Chapter 7. Installing DB2 Connect on UNIX Systems
  • Before You Begin
  • Installation Steps
  • Step 1. Identify and Record Parameter Values
  • Step 2. Updating Kernel Configuration Parameters
  • Recommended Values for HP-UX Version 10 and Version 11
  • Recommended Values for SCO UnixWare 7
  • Recommended Values for Solaris
  • Step 3. Mount the CD-ROM
  • Mounting on AIX Systems
  • Mounting on HP-UX Systems
  • Mounting on SCO UnixWare 7 Systems
  • Mounting on Solaris Systems
  • Step 4. Install the DB2 Products

  • Chapter 8. Installing Additional Products and Creating Additional Instances

  • Chapter 9. Migrating from Previous Versions and Releases on UNIX Systems
  • Migrating from Previous Versions of DB2
  • Upgrading from DB2 Release 5.0 to Release 5.2
  • Migrating Instances
  • Prepare the DB2 Instance for Migration
  • Migration Considerations for the User Exit Program
  • Migrate the DB2 Instance
  • Updating Catalog Table Data
  • Migrating the DB2 Syncpoint Manager to V5.2
  • Migrating from HP-UX Version 10 to Version 11
  • Migrating from SCO OpenServer to SCO UnixWare 7

    • Part 3. Configuring Access to Host and AS/400 Databases

  • Chapter 10. Configuring Host and AS/400 Connections on OS/2 or Windows NT Workstations

    • Part 4. Configuring Other Connectivity Options

  • Chapter 11. Configuring Communications to Host and AS/400 Databases Manually

  • Chapter 12. Configuring Communications Server for OS/2 for DB2 Connect for OS/2
  • Fill in the Worksheet
  • Configuring APPC Using Communications Server
  • Preparing the LAN DLC Profile
  • Updating the SNA Local Node Characteristics
  • Preparing the SNA Connection Profiles
  • Setting the SNA Features
  • Save Your Configuration
  • Update the DB2 Directories
  • Test the Connection
  • Complete the Configuration

  • Chapter 13. Configuring IBM Communications Server for Windows NT
  • Step 1. Fill In the Worksheet
  • Step 2. Configure the SNA Node
  • Configure Node
  • Configure Devices
  • Configure the Gateway
  • Configure Connections
  • Configure Partner LU 6.2
  • Configure Modes
  • Configure Local LU 6.2
  • Configure CPI-C Side Information
  • Configure Transaction Programs
  • Save the Configuration
  • Update the Environment
  • Step 3. Start SNA Node Operations
  • Step 4. Update the DB2 Directories
  • Step 5. Test the Connection
  • Step 6. Bind the Utilities and Applications

  • Chapter 14. Configuring IBM Personal Communications for Windows 32-Bit Operating Systems
  • Step 1. Fill In the Worksheet
  • Step 2. Configure the SNA Node
  • Configure Node
  • Configure Devices
  • Configure Connections
  • Configure Partner LU 6.2
  • Configure Modes
  • Configure Local LU 6.2
  • Configure CPI-C Side Information
  • Configure Transaction Programs
  • Save the Configuration
  • Update the Environment
  • Step 3. Start SNA Node Operations
  • Step 4. Update the DB2 Directories
  • Step 5. Test the Connection
  • Step 6. Bind the Utilities and Applications

  • Chapter 15. Configuring IBM Communications Server for Windows NT SNA Client
  • Step 1. Fill In the Worksheet
  • Step 2. Create a User Name on the Communications Server for Windows NT Server
  • Step 3. Configure the SNA Client
  • Configure Global Data
  • Configure APPC Server List
  • Configure CPI-C Side Information
  • Configure Transaction Programs
  • Save the Configuration
  • Step 4. Update the DB2 Directories
  • Step 5. Test the Connection
  • Step 6. Bind the Utilities and Applications

  • Chapter 16. Configuring Microsoft SNA Server Version 4.0 for Windows NT
  • Step 1. Fill in the Worksheet
  • Step 2. Define Server Properties
  • Define Control Point Name
  • Define Link Service (802.2)
  • Define Connection Properties
  • Define Local LU
  • Define Remote LU
  • Define Mode
  • Define the CPIC Name Properties
  • Step 3. Save the Configuration
  • Step 4. Update the DB2 Directories
  • Step 5. Test the Connection
  • Step 6. Bind the Utilities and Applications

  • Chapter 17. Configuring Microsoft SNA Client
  • Assumptions
  • Step 1. Obtain Required Information
  • Step 2. Install SNA Client on the DB2 Connect Workstation
  • Step 3. Install DB2 Connect for Windows
  • Update the DB2 Directories
  • Test the Connection

  • Chapter 18. Configuring SNA Server for DB2 Connect on AIX
  • Step 1. Fill in the Worksheet
  • Completing the Worksheet
  • Step 2. Configure Your DB2 Connect System
  • Configuring Each Server Connection
  • Configuring DB2 Connect for Remote Clients
  • Step 3. Complete the Configuration
  • APPC Security Considerations for Connections from Clients
  • Configuring for APPC Security Type NONE
  • Configuring for APPC Security Type PROGRAM
  • Configuring for APPC Security Type SAME

  • Chapter 19. Configuring Bull SNA for DB2 Connect on AIX
  • Example Bull SNA Configuration
  • Configuring the Bull DPX/20 SNA/20 Server
  • Starting and Stopping SNA/20

  • Chapter 20. Configuring IBM eNetwork Communications Server for AIX
  • Step 1. Fill in the Worksheet
  • Completing the Worksheet
  • Step 2. Configure Your DB2 Connect System
  • Configuring Each Server Connection
  • Configuring DB2 Connect for Remote Clients
  • Step 3. Complete the Configuration
  • APPC Security Considerations for Connections from Clients
  • Configuring for APPC Security Type NONE
  • Configuring for APPC Security Type PROGRAM
  • Configuring for APPC Security Type SAME

  • Chapter 21. Configuring SNAPlus for DB2 Connect on HP-UX
  • Configuring Your DRDA Servers
  • Sample Network Scenario
  • Example Worksheets
  • Planning to Configure Your DB2 Connect System
  • Planning for Each Server Connection
  • Configuring Your DB2 Connect System
  • Configuring SNAplus
  • Starting the SNAplus Subsystem
  • Completing the Configuration

  • Chapter 22. Configuring SunLink SNA for DB2 Connect for Solaris
  • Configuring Your DRDA Servers
  • Planning to Configure Your DB2 Connect for Solaris System
  • Planning for Each Server Connection
  • Planning for Inbound APPC Client Connections
  • Configuring SunLink SNA for Solaris
  • Completing the Configuration

  • Chapter 23. Enabling Multisite Updates (Two-Phase Commit)

  • Chapter 24. Configuring the DB2 Syncpoint Manager
  • Planning to Use the SPM
  • Software Prerequisites for the SPM
  • Database Manager Configuration Parameters for SPM
  • Other Requirements
  • Configuring the SPM
  • Summary of Steps
  • Setting up SNA Communications for the DB2 Syncpoint Manager (SPM)
  • Configuring SNA Server for AIX
  • Configuring Communications Server for OS/2 and Windows NT
  • Registering CS/NT as a Windows NT Service
  • Support for SERVER Authentication
  • SPM Migration Considerations
  • Migrating from the Encina PPC Gateway
  • Additional PPC Gateway Migration Steps for CICS for AIX
  • Encina PPC Gateway and SPM Coexistence
  • SPM Processes
  • EDU Process Names
  • SPM Logging
  • SPM Log File Size
  • Changing the SPM Log File Size
  • Performance Characteristics
  • Memory Utilization
  • SPM Protocol Violation Records

  • Chapter 25. Using the Control Center to Configure Server Communications
  • Configuring DB2 Communications for Local Instances
  • Configuring DB2 Communications for Remote Instances

  • Chapter 26. Using the Command Line Processor to Configure the DB2 Connect Server to Accept Clients
  • Setting the DB2COMM Registry Value
  • Configuring Named Pipes on the Server
  • Configuring TCP/IP on the DB2 Connect Server to Accept Clients
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the DB2 Connect Server
  • Configuring NetBIOS on the DB2 Connect Server
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the DB2 Connect Server
  • Autostarting DB2 with NetBIOS (for Windows NT only)
  • Configuring IPX/SPX on the DB2 Connect Server
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the DB2 Connect Server
  • Configuring APPC on the DB2 Connect Server to Accept Clients
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the DB2 Connect Server

    • Part 5. Installing and Configuring DB2 Clients

  • Chapter 27. Installing DB2 Clients

  • Chapter 28. Installing DB2 Clients on OS/2 Operating Systems

  • Chapter 29. Installing DB2 Clients on Windows 32-Bit Operating Systems

  • Chapter 30. Installing DB2 Clients on Windows 3.x Operating Systems

  • Chapter 31. Installing DB2 Clients on UNIX Operating Systems
  • Before You Begin
  • Installing DB2 Version 5 Clients
  • Step 1. Update Kernel Configuration Parameters
  • Step 2. Mount the DB2 Client Application Enablers CD-ROM
  • Step 3. Perform the Installation
  • Installing DB2 Version 2 Clients
  • Installing DB2 Version 2 Clients on SINIX
  • Installing DB2 Version 2 Clients on SCO OpenServer
  • Create or Assign Groups and Users
  • Create an Instance of the Product
  • Set Up the DB2 Operating Environment
  • Create Links for DB2 Files

  • Chapter 32. Installing DB2 Clients on Macintosh Operating Systems

  • Chapter 33. Configuring Client-to-Server Communications Using the Client Configuration Assistant

  • Chapter 34. Configuring Client-to-Server Communications Using the Command Line Processor
  • Configuring Named Pipes on the Client
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the Client
  • Step 3. Test the Client-to-Server Connection
  • 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
  • Configuring NetBIOS on the Client
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the Client
  • Step 3. Test the Client-to-Server Connection
  • Configuring IPX/SPX on the Client
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the Client
  • Step 3. Test the Client-to-Server Connection
  • Configuring APPC on the Client
  • Using the Client Setup Tool to Configure a Windows 3.x Client

    • Part 6. Using DB2 Universal Database

  • Chapter 35. Sending Accounting Information to a DB2 for OS/390 Server
  • Setting the Accounting String

  • Chapter 36. Getting Started with DB2 Universal Database
  • Logging on to the System
  • Connecting to a Database
  • Working with the System Administrative Group
  • Granting Users Authorization
  • Counting Concurrent Users
  • Upgrading from a Try-and-Buy License

  • Chapter 37. Working with Instances
  • The Default Instance
  • Instance Directory
  • Creating Instances
  • Listing Instances
  • Setting the Current Instance
  • Auto-Starting Instances on UNIX Systems
  • Setting the Operating Environment for Each Instance User on UNIX Systems
  • Setting the DB2 Environment Automatically
  • Setting the DB2 Environment Manually
  • Updating Instances on UNIX Systems
  • Removing Instances

  • Chapter 38. Using the Administration Server
  • Creating the Administration Server
  • Starting the Administration Server
  • Stopping the Administration Server
  • Listing the Administration Server
  • Updating the Administration Server
  • Removing the Administration Server

  • Chapter 39. 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

  • Chapter 40. Entering DB2 Commands and SQL Statements
  • Using the Command Center
  • Using the Command Line Processor
  • Interactive Input Mode
  • Command Line Mode

  • Chapter 41. Controlling Your DB2 Environment
  • Controlling the DB2 Profile Registry
  • Setting Your Environment on OS/2
  • Setting Your Environment on Windows 32-Bit Operating Systems
  • Setting Your Environment on UNIX Systems
  • Setting Your Environment on Windows 3.x
  • DB2 Registry Values and Environment Variables
  • Configuration Parameters
  • Setting Database Manager Configuration Parameters on a Client Instance

  • Chapter 42. Administering and Using OS/2 User Profile Management on OS/2 Systems
  • Special Note for Users of Warp Connect and Warp Server
  • Using UPM for the First Time
  • Using UPM Every Day
  • Logging on to UPM
  • Logging on to UPM with Multiple IDs
  • Logging On at the Command Prompt
  • Adding a New User ID and Password
  • Changing or Deleting a User ID
  • Logging Off
  • Managing UPM Groups
  • Naming Rules
  • User Profile Management Passwords

    • Part 7. Advanced Installation and Configuration

  • Chapter 43. Unattended DB2 Installation on OS/2 Operating Systems
  • Installing DB2 Products from a Hard Disk or CD-ROM
  • Step 1. Make DB2 Files Available for Installation
  • Step 2. Create a Response File for Unattended Installation
  • Step 3. Run the CMD File from the Remote Workstation
  • Installing DB2 Products Remotely Using TME Netfinity Server
  • Step 1. Copy the DB2 Install Files to the Code Server
  • Step 2. Add the DB2 Product to the Software Library
  • Step 3. Configure the DB2 Product
  • Step 4. Install DB2 Products on the Remote Workstation

  • Chapter 44. Unattended DB2 Installation on Windows 32-bit Operating Systems
  • Installing DB2 Products from a Hard Disk or CD-ROM
  • Before You Begin
  • Step 1. Make DB2 Files Available for Installation
  • Step 2. Create a Response File for Unattended Installation
  • Step 3. Run Setup from the Workstation
  • Installing DB2 Remotely Using SMS
  • Before You Begin
  • Step 1. Make DB2 Files Available for Installation
  • Step 2. Create a Response File for Unattended Installation
  • Step 3. Import the DB2 Install Files into SMS
  • Step 4. Distribute the DB2 Installation Package Using SMS
  • Step 5. Run the Installation on the SMS Client

  • Chapter 45. Other Methods to Install DB2 Connect for AIX
  • Installation Steps
  • Step 1. Install DB2
  • Install Products or Filesets Using SMIT
  • Install Software Bundles Using SMIT
  • Install the DB2 Product Library (Optional)
  • Install the DB2 Product Messages (Optional)
  • Step 2. Create or Assign a Group and User ID
  • Step 3. Create a DB2 Instance
  • Step 4. Create the Administration Server
  • Install the License Key
  • Step 6. Create Links for DB2 Files (Optional)

  • Chapter 46. Other Methods to Install DB2 Connect for HP-UX
  • Installation Steps
  • Step 1. Install DB2
  • Install the DB2 Product Library (Optional)
  • Install DB2 Product Messages (Optional)
  • Step 2. Update the Kernel Configuration Parameters
  • Step 3. Create or Assign Groups and User IDs
  • Step 4. Create a DB2 Instance
  • Step 5. Create an Administration Server
  • Step 6. Install the License Key
  • Step 7. Create Links for DB2 Files (Optional)

  • Chapter 47. Other Methods to Install DB2 Connect for Solaris
  • Installation Steps
  • Step 1. Install DB2
  • Installing the DB2 Product Library (Optional)
  • Installing the DB2 Product Messages (Optional)
  • Step 2. Update the Kernel Configuration Parameters
  • Step 3. Create or Assign Groups and User IDs
  • Step 4. Create a DB2 Instance
  • Step 5. Create the Administration Server
  • Step Install the License Key
  • Step 7. Create Links for DB2 Files (Optional)

  • Chapter 48. Using the Client Configuration Assistant
  • Configuring Database Connections
  • Using an Access Profile
  • Searching the Network for Databases
  • Manually Configure a Connection to a DB2 Database

    • Part 8. Configuring DRDA Hosts

  • Chapter 49. Configuring DRDA Hosts for DB2 Connect
  • Preparing MVS/ESA or OS/390 for DB2 Connect
  • Summary of Steps
  • Configuring VTAM
  • Configuring DB2 for OS/390
  • Configuring DB2 for MVS/ESA
  • Configuring TCP/IP for DB2 for OS/390
  • Preparing DB2 for AS/400 for DB2 Connect
  • Preparing DB2 for VSE & VM

    • Part 9. Appendixes

  • Appendix A. How the DB2 Library Is Structured
  • SmartGuides
  • Online Help
  • DB2 Books
  • Viewing Online Books
  • Searching Online Books
  • Printing the PostScript Books
  • Ordering the Printed DB2 Books
  • Information Center

  • Appendix B. Changing Your MVS Password
  • Configuring the Host for Password Expiration Management
  • Configuring the DB2 Connect Workstation for Password Expiration Management
  • Step 1. Define Symbolic Destination Name
  • Step 2. Record Symbolic Destination Name in the DCS Directory

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

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

  • Appendix F. Microsoft Transaction Server (MTS) Support
  • Enabling MTS Support in DB2
  • MTS Software Prerequisites
  • Installation and Configuration
  • Verifying the Installation
  • Using Two-Phase Commit with DB2
  • Set up MTS and DB2 for OS/390 to support the MTS "Bank" sample application
  • Testing DB2 With The MTS "BANK" Sample Application

  • Appendix G. Naming Rules
  • General Naming Rules
  • Database, Database Alias, and Catalog Node Names
  • Object Names
  • Usernames, Group Names, and Instance Names
  • Workstation Names (nname)
  • DB2SYSTEM Naming Rules
  • Password Rules

  • Appendix H. List Files, Bind Files, and Packages
  • List Files Associated with DRDA Servers

  • Appendix I. Notices
  • Trademarks
  • Trademarks of Other Companies

  • Appendix J. Contacting IBM

  • Index

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

    [ DB2 List of Books | Search the DB2 Books ]