IBM Books

Quick Beginnings for DB2 Extended Enterprise Edition for UNIX

IBM DB2 Universal Database
Extended Enterprise Edition
for UNIX**

Version 5

S99H-8314-00


99H8314

Before using this information and the product it supports, be sure to read the general information under Appendix G. "Notices".

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1993, 1997. All rights reserved.
Note to U.S. Government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.

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

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

  • Chapter 3. Introduction to DB2 Extended Enterprise Edition
  • Processing in the Partitioned Database Environment
  • Cost-Based Query Optimization
  • Configuration
  • Machines and Storage
  • Nodegroups and Data Partitioning
  • Multiple Logical Nodes
  • Instances
  • Fast Communication Manager
  • Agents

    • Part 2. DB2 Server Installation and Initial Configuration

  • Chapter 4. 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-DB2 Server Connectivity Scenarios
  • Understanding System Administrative Authority
  • Preparing to Install the DB2 Products
  • Selecting Products and Components

  • Chapter 5. Installing and Configuring DB2 Universal Database Extended Enterprise Edition for AIX
  • Installation Steps
  • Step 1. Prepare for Installation
  • Step 2. Install DB2
  • Install the Product or Filesets Using the dsh Command
  • Install Products or Filesets Using SMIT
  • Install Software Bundles Using SMIT
  • Install the DB2 Product Library (Optional)
  • Install the DB2 Product Messages (Optional)
  • Step 3. Enable the Fast Communication Manager
  • Step 4. Create a DB2 Instance
  • Step 5. Create the Node Configuration File
  • Step 6. Make DB2 Extended Enterprise Edition Available
  • Step 7. Create the Administration Server
  • Step 8. Set up Discovery
  • Step 9. Create Links for DB2 Files (Optional)
  • Step 10. Set up the Instance Environment

  • Chapter 6. Installing and Configuring DB2 Universal Database Extended Enterprise Edition 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. Share the Instance Home Directory
  • Step 5. Enable the Fast Communication Manager
  • Step 6. Create a DB2 Instance
  • Step 7. Create the Administration Server
  • Step 8. Create the Node Configuration File
  • Step 9. Make DB2 Extended Enterprise Edition Available
  • Step 10. Set up Discovery
  • Step 11. Create Links for DB2 Files (Optional)
  • Step 12. Set up the Instance Environment

  • Chapter 7. Migrating from Previous Versions
  • Overview of the Migration Process
  • Migrating Single-Partition Databases
  • Migrating Partitioned Databases
  • 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
  • Specifying Table Spaces when Migrating DB2 Parallel Edition Version 1.x
  • Post Migration

    • Part 3. Installing DB2 Clients

  • Chapter 8. Installing DB2 Clients

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

  • Chapter 10. Installing DB2 Clients on Windows 95 or Windows NT Workstations
  • Before You Begin
  • Performing the Installation

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

  • Chapter 12. Installing DB2 Clients on UNIX Workstations
  • Before You Begin
  • Installing on AIX, HP-UX and Solaris Systems
  • Step 1. Update Kernel Configuration Parameters
  • Step 2. Mount the DB2 Client Application Enablers CD-ROM
  • Step 3. Perform 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
  • Create or Assign Groups and Users
  • Create an Instance of the Product
  • Set Up the DB2 Operating Environment
  • Create Links for DB2 Files

  • Chapter 13. Installing DB2 Clients on Macintosh Workstations

    • Part 4. Configuring DB2 Communications

  • Chapter 14. Configuring Client-to-Server Communications Using the CCA
  • Verifying the Connection

  • Chapter 15. 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 16. 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
  • Upgrading from a Try-and-Buy License

  • Chapter 17. 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
  • Updating Version 5 Single-Partition to Multipartition Instances
  • Removing Instances

  • Chapter 18. 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 19. 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 20. Entering DB2 Commands and SQL Statements
  • Using the Command Center
  • Using the Command Line Processor
  • Interactive Input Mode
  • Command Line Mode
  • Connecting to a Logical Node

  • Chapter 21. Controlling Your DB2 Environment
  • Setting Environment Variables
  • 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.x
  • DB2 Registry Values and Environment Variables
  • Configuration Parameters
  • Setting Database Manager Configuration Parameters on a Client Instance

    • Part 6. Advanced Configuration and Deinstallation

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

  • Chapter 23. 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 24. 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

  • Chapter 25. Using the DB2 Workstation as a Server for Host Applications
  • Application Requesters Supported
  • PTFs Required for DRDA Application Servers
  • DRDA-AS Setup for the DRDA Application Requester
  • Setting Up DRDA-AS Functionality
  • Using the Application Server
  • Authentication
  • Troubleshooting
  • DRDA Functions Supported
  • Security and Auditability
  • Configuration Considerations

  • Chapter 26. 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 the Products
  • Remove DB2 Products on AIX Systems
  • Remove DB2 Products on Solaris Systems

    • Part 7. Appendixes

  • Appendix A. Obtaining Information
  • How the DB2 Library Is Structured
  • Online Help
  • DB2 Books
  • About the Information Center
  • Ordering the Printed DB2 Books
  • Printing the PostScript Books
  • Viewing Online Books
  • Installing the Netscape Browser
  • Setting up a Document Server

  • Appendix B. Issuing Commands to Multiple Database Partition Servers
  • Commands
  • Command Descriptions
  • Specifying the Command to Run
  • Running Commands in Parallel
  • Monitoring rah Processes
  • Prefix Sequences
  • Specifying the List of Machines
  • Eliminating Duplicate Entries from the List of Machines
  • Controlling the rah Command
  • $RAHDOTFILES
  • Determining Problems with rah

  • Appendix C. Implementing Failover Support in the Solaris Operating Environment
  • Solstice HA 1.3 Components
  • Failover Configurations
  • Hot Standby Configuration
  • Mutual Takeover Configuration
  • Setting up Solstice HA on DB2 for Solaris
  • Step 1. Choose an HA Configuration
  • Step 2. Select a Logical Host for Use as the HA-NFS Server for the HA Instance Home Directory
  • Step 3. Mount the Logical Host's Home Directory
  • Step 4. Create a DB2 Instance
  • Step 5. Run the HA-DB2 Extended Enterprise Edition Setup Program
  • Adding or Removing a DB2 Database Partition Server

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

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

  • Appendix H. Contacting IBM

  • Index

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

    [ DB2 List of Books | Search the DB2 Books ]