IBM Books

Quick Beginnings

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?

  • Chapter 3. How to Use DB2 Connect in Your Network
  • Direct Connection to a DRDA Host
  • 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
  • Client Product Requirements
  • Possible Client-to-DB2 Connect Gateway Connectivity Scenarios
  • Security Requirements

  • Chapter 5. Installing DB2 Connect on OS/2 Systems
  • Before You Begin Installing on OS/2
  • 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. Identifying and Recording Parameter Values
  • Step 2. Updating Kernel Configuration Parameters
  • Recommended Values for HP-UX
  • Recommended Values for Solaris
  • Step 3. Mounting the CD-ROM
  • Mounting on AIX Systems
  • Mounting on HP-UX Systems
  • Mounting on Solaris Systems
  • Step 4. Installing the DB2 Products
  • Installing Additional Products and Creating Additional Instances

  • Chapter 8. Migrating from Previous Versions on UNIX Systems
  • Migrating Instances
  • Prepare the DB2 Instance for Migration
  • Migration Considerations for the User Exit Program
  • Migrate the DB2 Instance

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

  • Chapter 9. Configuring DRDA Host Connections on OS/2 or Windows NT Workstations

  • Chapter 10. Changing Your MVS Password
  • Configuring the Host for Password Expiration Management
  • Configuring the DB2 Connect Workstation for Password Expiration Management

    • 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 Wall Data Rumba Manually on Windows Workstations
  • Step 1. Start the APPC Configuration Utility
  • Step 2. Add a Connection
  • Step 3. Add a Mode
  • Step 4. Add a Remote LU
  • Step 5. Add a Local LU
  • Step 6. Define Side Information
  • Step 7. Save the Configuration
  • Step 8. Update the DB2 Directories
  • Step 9. Test the Connection

  • Chapter 14. 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
  • Step 3. Update the DB2 Directories
  • Step 4. Test the Connection
  • Step 5. 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 for DB2 Connect for Windows NT
  • Step 1. Fill In the Worksheet
  • Step 2. Define SNA Properties
  • Setting Server Properties
  • Setting APPC Local LU Properties
  • Setting APPC Mode Properties
  • Step 3. Define Server Connection Properties
  • Setting Connection Properties
  • Setting APPC Remote LU Properties
  • Setting CPI-C Symbolic Destination Name Properties
  • 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 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 19. Configuring Bull SNA for DB2 Connect for AIX
  • Example Bull SNA Configuration
  • Configuring the Bull DPX/20 SNA/20 Server
  • Starting and Stopping SNA/20

  • Chapter 20. Configuring SNAPlus for DB2 Connect for 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 21. 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 22. Setting Up Two-phase Commit Using SNA
  • What is the Syncpoint Manager?
  • SPM Scenarios
  • Participation in the Two-Phase Commit Process
  • Application Requester
  • Transaction Manager
  • Syncpoint Manager
  • Two-phase Commit Scenario
  • Planning to Use SPM
  • Software Prerequisites for SPM
  • Database Manager Configuration Parameters for SPM
  • Other Requirements
  • Installing the SPM
  • Summary of Steps
  • Summary of Steps for DB2 Clients Connecting to a Host
  • Setting up Communications for the SPM
  • Configuring SNA Server for AIX
  • Configuring Communications Server for OS/2
  • 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 23. Setting up Two-phase Commit using TCP/IP
  • Overview
  • What to Do
  • Limitations
  • Migration

  • Chapter 24. Configuring DB2 Connect Server Communications Using the Control Center
  • Modifying the DB2 Communication Configuration of DB2 Connect Server Instances

  • Chapter 25. Using the Command Line Processor to Configure the DB2 Connect Server to Accept Clients
  • Setting the DB2COMM Registry Value
  • Configuring Named Pipes on the DB2 Connect 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 26. Installing DB2 Clients

  • Chapter 27. Installing DB2 Clients on OS/2 Workstations

  • Chapter 28. Installing DB2 Clients on Windows 95 or Windows NT Workstations
  • Before You Begin
  • Creating a Username for Installing DB2 Products
  • Performing the Installation

  • Chapter 29. Installing DB2 Clients on Windows 3.x Workstations

  • Chapter 30. Installing DB2 Clients on UNIX Workstations
  • Before You Begin
  • Installing on AIX, HP-UX and Solaris Systems
  • Step 1. Updating Kernel Configuration Parameters
  • Step 2. Mounting the DB2 Client Pack CD-ROM
  • Step 3. Performing the Installation
  • Installing on Other UNIX Systems
  • Installing on a SINIX System
  • Installing on an SCO OpenServer System
  • Installing on a Silicon Graphics IRIX System
  • Creating or Assigning Groups and Users
  • Creating an Instance of the Product
  • Setting the DB2 Operating Environment
  • Creating Links for DB2 Files

  • Chapter 31. Installing DB2 Clients on Macintosh Workstations

  • Chapter 32. Configuring Client to DB2 Connect Server Communications Using the CCA

  • Chapter 33. 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-DB2 Connect 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-DB2 Connect 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-DB2 Connect 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 34. Sending Accounting Information to a DB2 for OS/390 Server
  • Setting the Accounting String

  • Chapter 35. Getting Started with the DB2 Universal Database
  • Logging on to the System
  • Connecting to a Database
  • Changing Default Privileges for Users
  • Counting Concurrent Users
  • Upgrading from a Try-and-Buy License

  • Chapter 36. Working with DB2 Instances
  • At Install Time
  • Creating Instances
  • Listing Instances
  • Selecting an Instance on OS/2 or Windows NT Systems
  • Auto-Starting Instances on UNIX Systems
  • Setting the Operating Environment for Each DB2 Instance User on UNIX Systems
  • Setting the DB2 Environment Automatically
  • Setting the DB2 Environment Manually
  • Updating Instances on UNIX Systems
  • Removing Instances

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

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

  • Chapter 39. Controlling Your DB2 Environment
  • Controlling the DB2 Profile Registry
  • Setting Your Environment on OS/2
  • Setting Your Environment on Windows 95 and Windows NT
  • Setting Your Environment on UNIX Systems
  • Setting Your Environment on Windows 3.1
  • DB2 Registry Values and Environment Variables
  • Configuration Parameters
  • Setting Database Manager Configuration Parameters on a Client Instance

  • Chapter 40. 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 41. Unattended DB2 Installation on OS/2 Workstations
  • Installing DB2 Products from a Code Server 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 SystemView LAN
  • 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 42. Unattended DB2 Installation on Windows 95 or Windows NT Workstations
  • Installing DB2 Products from a Code Server 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 Products 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 43. Other Methods to Install DB2 Connect for AIX
  • Installation Steps
  • Step 1. Installing DB2 Products
  • Installing Software Bundles Using SMIT
  • Installing Products or Filesets Using SMIT
  • Installing the DB2 Product Library (Optional)
  • Installing DB2 Product Messages (Optional)
  • Step 2. Creating or Assigning Groups and User IDs
  • Step 3. Creating a DB2 Instance
  • Step 4. Creating an Administration Server
  • Step 5. Creating Links for DB2 Files (Optional)

  • Chapter 44. Other Methods to Install DB2 Connect for HP-UX
  • Installation Steps
  • Step 1. Installing DB2 Products
  • Installing the DB2 Product Library (Optional)
  • Installing DB2 Product Messages (Optional)
  • Step 2. Updating HP-UX Kernel Configuration Parameters
  • Step 3. Creating or Assigning Groups and User IDs
  • Step 4. Creating a DB2 Instance
  • Step 5. Creating an Administration Server
  • Step 6. Creating Links for DB2 Files (Optional)

  • Chapter 45. Other Methods to Install DB2 Connect for Solaris
  • Installation Steps
  • Step 1. Installing DB2 Products
  • Installing the DB2 Product Library (Optional)
  • Installing DB2 Product Messages (Optional)
  • Step 2. Updating Solaris Kernel Configuration Parameters
  • Step 3. Creating or Assigning Groups and User IDs
  • Step 4. Creating a DB2 Instance
  • Step 5. Creating an Administration Server
  • Step 6. Creating Links for DB2 Files (Optional)

  • Chapter 46. Administering Clients Using the CCA
  • 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 47. 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. Obtaining Information
  • How the DB2 Library Is Structured
  • SmartGuides
  • Online Help
  • DB2 Books
  • About the Information Center
  • Ordering the Printed DB2 Books
  • Printing the PostScript Books
  • Viewing Online Books
  • Installing the Netscape Browser

  • Appendix B. National Language Support (NLS)
  • Language and Codeset Support for UNIX Operating Systems
  • Code Page and Language Support for OS/2 and Windows Operating Environments
  • Date and Time Formats
  • Conversion of Character Data
  • Customizing Language Support
  • Summary
  • How to Determine your Workstation Code Page
  • Database Configuration
  • Customizing Your DRDA Host
  • MVS
  • OS/400
  • VM and VSE

  • Appendix C. Contents of the DB2 Products
  • Packaging
  • Products and Selectable Components
  • Prerequisites

  • Appendix D. Naming Rules
  • General Naming Rules
  • Database and Database Alias Names
  • Object Names
  • User IDs, Group Names, and Instance Names
  • Additional Considerations for Usernames in Windows NT
  • Workstation Names (nname)
  • DB2SYSTEM Naming Rules
  • Password Naming Rules

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

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

  • Appendix G. Contacting IBM

  • Index

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

    [ DB2 List of Books | Search the DB2 Books ]