IBM Books

Quick Beginnings for DB2 Extended Enterprise Edition 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

  • 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 | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]