IBM Books

Quick Beginnings for DB2 Universal Database for UNIX

Table of Contents

  • Welcome to DB2 Universal Database
  • Conventions
  • Road Map

    • Part 1. Introduction to DB2 Universal Database

  • Chapter 1. About DB2 Universal Database
  • Working with Data Using DB2 Universal Database
  • Accessing DB2 Data from Remote Clients
  • Accessing Multiple DB2 Servers
  • Administering Databases with DB2 Tools
  • Managing Databases Using the Control Center
  • Understanding the Administration Server
  • Monitoring Databases Using DB2 Performance Monitor
  • Viewing SQL Access Plans Using Visual Explain
  • Managing Communications on the Server
  • Managing Connections to Databases Using the Client Configuration Assistant
  • Developing Applications Using the DB2 Software Developer's Kit
  • Accessing Host Data from the Desktop Using DB2 Connect Enterprise Edition
  • Accessing DB2 Data from the Web

    • Part 2. Installation and Initial Configuration

  • Chapter 2. Planning for Installation
  • Memory Requirements
  • Configuration for Accessing DB2 Servers on the LAN
  • Configuration for Accessing LAN and Host Data
  • Configuration for Accessing from the Web
  • Disk Requirements
  • Estimating Fixed Disk Requirements
  • Software Requirements
  • Server Product Requirements
  • Client Product Requirements
  • Possible Client-to-Server Connectivity Scenarios
  • Understanding System Administrative Authority
  • Preparing to Install the DB2 Products
  • Selecting Products and Components

  • Chapter 3. Installing and Configuring DB2
  • 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 4. Installing Additional Products and Creating Additional Instances

  • Chapter 5. Setup for Developing Applications with Micro Focus COBOL

  • Chapter 6. Migrating from Previous Versions and Releases
  • Migrating from Previous Versions of DB2
  • Upgrading from DB2 Release 5.0 to Release 5.2
  • Pre-Migration
  • Migrating Instances
  • Prepare the DB2 Instance for Migration
  • Verify that Databases Can Be Migrated
  • Migration Considerations for the User Exit Program
  • Migrate the DB2 Instance
  • Migrating Databases
  • Trouble-Shooting Database Migration Errors
  • Post Migration
  • Updating Catalog Table Data
  • Migrating from HP-UX Version 10 to Version 11
  • Migrating from SCO OpenServer to SCO UnixWare 7

    • Part 3. Installing DB2 Clients

  • Chapter 7. Installing DB2 Clients

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

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

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

  • Chapter 11. 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 12. Installing DB2 Clients on Macintosh Operating Systems

    • Part 4. Configuring DB2 Communications

  • Chapter 13. Configuring Client-to-Server Communications Using the Client Configuration Assistant
  • Verifying the Connection

  • Chapter 14. 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
  • 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 5. Using DB2 Universal Database

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

  • Chapter 16. Working with Instances
  • Instance Directory
  • Creating Instances
  • Listing Instances
  • Starting and Stopping an Instance
  • Auto-Starting Instances
  • Setting the Operating Environment for Each Instance User
  • Setting the DB2 Environment Automatically
  • Setting the DB2 Environment Manually
  • Updating Instances
  • Removing Instances

  • Chapter 17. 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 18. Running Your Own Applications
  • Binding Database Utilities
  • 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 19. Entering DB2 Commands and SQL Statements
  • Using the Command Center
  • Using the Command Line Processor
  • Interactive Input Mode
  • Command Line Mode

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

    • Part 6. Advanced Installation and Configuration

  • Chapter 21. Other Methods to Install DB2 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
  • Step 5. Install the License Key
  • Step 6. Create Links for DB2 Files (Optional)

  • Chapter 22. Other Methods to Install DB2 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 23. Other Methods to Install DB2 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 6. Install the License Key
  • Step 7. Create Links for DB2 Files (Optional)

  • Chapter 24. Other Methods to Install SCO UnixWare 7
  • 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 an Administration Server
  • Step 6. Install the License Key
  • Step 7. Create Links for DB2 Files (Optional)

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

  • Chapter 26. Setting up Communications on the Server Using the Command Line Processor
  • Setting the DB2COMM Registry Value
  • Configuring TCP/IP on the Server
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the Server
  • Configuring IPX/SPX on the Server
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the Server
  • Configuring APPC on the Server
  • Step 1. Identify and Record Parameter Values
  • Step 2. Configure the Server

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

  • Chapter 28. Accessing DB2 Universal Database Servers from Host and AS/400 Applications
  • Supported Clients
  • PTFs Required
  • Configuration Steps for DB2 Universal Database Server
  • Configuring DB2 Universal Database Servers for Host or AS/400 Client Access
  • Using the DB2 Universal Database Server from Host or AS/400 Clients
  • Authentication
  • Troubleshooting
  • DRDA Functions Supported
  • Security and Auditability
  • Configuration Considerations

  • Chapter 29. Removing DB2 Products
  • Step 1. Stop the Administration Server
  • Step 2. Stop All DB2 Instances
  • Step 3. Remove the Administration Server
  • Step 4. Remove DB2 Instances
  • Step 5. Remove DB2 Products
  • Remove DB2 Products on AIX Systems
  • Remove DB2 Products on HP-UX Systems
  • Remove DB2 Products on SCO UnixWare 7 Systems
  • Remove DB2 Products on Solaris Systems

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

  • 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

  • Appendix D. 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 E. Notices
  • Trademarks
  • Trademarks of Other Companies

  • Appendix F. Contacting IBM

  • Index

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

    [ DB2 List of Books | Search the DB2 Books ]