IBM Books

Quick Beginnings

Table of Contents

  • Welcome to DB2 Universal Database
  • Conventions
  • Road Map

    • Part 1. Introduction to DB2 Universal Database

  • Chapter 1. Introducing IBM Software Servers
  • IBM Communications Server
  • IBM Directory and Security Server
  • IBM Transaction Series
  • IBM MQSeries
  • Tivoli Management Servers
  • IBM Internet Connection Server
  • IBM DB2 Universal Database
  • Lotus Domino

  • Chapter 2. 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
  • 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 3. What's New in DB2 Version 5?

    • Part 2. 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 (SYSADM) Authority
  • Locating DB2 Universal Database Products on the CD-ROMs
  • Preparing to Install the DB2 Products
  • Selecting Products and Components on UNIX Systems

  • Chapter 5. Installing and Configuring DB2
  • 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 6. Migrating from Previous Versions
  • 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
  • Post Migration

    • Part 3. Installing DB2 Clients

  • Chapter 7. Installing DB2 Clients

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

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

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

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

    • Part 4. Configuring DB2 Communications

  • Chapter 13. Configuring Client to DB2 Server Communications Using the CCA
  • 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-DB2 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 the DB2 Universal Database
  • Logging on to the System
  • Creating the Sample Database
  • Connecting to a Database
  • Changing Default Privileges for Users
  • Counting Concurrent Users
  • Upgrading from a Try-and-Buy License

  • Chapter 16. Working with DB2 Instances
  • Creating Instances
  • Listing Instances
  • Starting and Stopping a DB2 Server Instance
  • Auto-Starting Instances
  • Setting the Operating Environment for Each DB2 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
  • 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 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

    • Part 6. Advanced Installation and Configuration

  • Chapter 21. Other Methods to Install DB2 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 22. Other Methods to Install DB2 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 23. Other Methods to Install DB2 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 24. Configuring DB2 Server Communications Using the Control Center
  • Modifying the DB2 Communication Configuration of DB2 Server Instances

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

  • Chapter 28. Removing DB2 Products
  • Step 1. Stopping the Administration Server
  • Step 2. Stopping All DB2 Instances
  • Step 3. Removing the Administration Server
  • Step 4. Removing DB2 Instances
  • Step 5. Removing DB2 Products
  • Removing DB2 Products on AIX Systems
  • Removing DB2 Products on HP-UX Systems
  • Removing DB2 Products on Solaris Systems

    • Part 7. 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. 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 and Database Alias Names
  • Object Names
  • User IDs, Group Names, and Instance Names
  • Workstation Names (nname)
  • DB2SYSTEM Naming Rules
  • Password Naming 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 ]