Quick Beginnings

Table of Contents

  • Welcome to DB2 Universal Database!
    Conventions

    Planning for Installation

  • Planning for Installation
    Memory Requirements
    Disk Requirements
    DB2 Servers
    DB2 Clients
    Software Requirements
    Server Product Requirements
    Client Product Requirements
    Possible Client-to-Server Connectivity Scenarios
    Migrating from Previous Versions of DB2
    Preparing Databases and Instances for Migration
    NetQuestion Search System
    Your next step

    Installing DB2 Servers

  • Installing DB2 for AIX
    Installing DB2 for AIX Using the db2setup Utility
    Your Next Step
    Manually Installing DB2 for AIX
    DB2 for AIX Post-installation Tasks
    Creating links for DB2 files
    Your Next Step

  • Installing DB2 for HP-UX
    Updating HP-UX Kernel Configuration Parameters
    Installing DB2 for HP-UX Using the db2setup Utility
    Your Next Step
    Manually Installing DB2 for HP-UX
    DBV7HTML fileset post-installation tasks
    DB2 for HP-UX Post-installation tasks
    Creating links for DB2 files
    Your Next Step

  • Installing DB2 for Linux
    Enabling Your Linux Workstation for a DB2 Installation
    Installing DB2 on Red Hat Linux
    Installing DB2 on Caldera Open Linux
    Installing DB2 on Turbo Linux
    Installing DB2 on SuSE Linux
    Installing DB2 for Linux Using the db2setup Utility
    Your Next Step
    Manually Installing DB2 for Linux
    DB2 for Linux Post-Installation Tasks
    Creating Links for DB2 Files
    Your Next Step

  • Installing DB2 for NUMA-Q
    Updating NUMA-Q/PTX Kernel Configuration Parameters
    Installing DB2 for NUMA-Q Using the db2setup Utility
    Your Next Step
    Manually Installing DB2 for NUMA-Q
    Installing DB2 for NUMA-Q Product Messages
    DB2 for NUMA-Q Post-installation tasks
    Creating links for DB2 files
    Your Next Step

  • Installing DB2 for Solaris
    Updating Solaris kernel configuration parameters
    Installing DB2 for Solaris using the db2setup utility
    Your next step
    Manually installing DB2 for Solaris
    Installing the DB2 for Solaris Product Library
    Installing DB2 for Solaris Product Messages
    DB2 for Solaris post-installation tasks
    Creating links for DB2 files
    Your next step

  • Verifying the Installation

  • DB2 Post-installation Migration Tasks
    Migrating Instances
    Possible Migration Error Messages and User Responses
    Migrating Databases
    Optional Post-Migration Tasks

  • Contents of the DB2 Products for UNIX platforms
    Packaging
    Products and Selectable Components

  • Removing DB2 Products
    Stop the Administration Server
    Stop all DB2 instances
    Remove the Administration Server
    Remove DB2 instances (Optional)
    Remove DB2 Products

    Setting Up Server Communications

  • Using the Command Line Processor to Configure Server Communications
    Setting the DB2COMM Registry Parameter
    Configuring TCP/IP on the Server
    1. Identify and Record Parameter Values
    2. Configure the Server
    Configuring IPX/SPX on the Server
    1. Identify and Record Parameter Values
    2. Configure the Server

  • Using the Control Center to Configure Server Communications
    Before You Begin
    About the Control Center and Communications Protocols
    Configuring DB2 Communications for Local Instances
    Configuring DB2 Communications for Remote Instances

    Installing DB2 Clients

  • Installing DB2 Clients on UNIX Operating Systems
    Before You Begin
    About the db2setup utility
    Updating Kernel Configuration Parameters
    HP-UX Kernel Configuration Parameters
    NUMA-Q/PTX Kernel Configuration Parameters
    Solaris Kernel Configuration Parameters
    Installing Your DB2 Client
    Your next step

  • Installing DB2 Clients on Windows 32-Bit Operating Systems
    Before You Begin Installing
    Installing Without Administrator Authority
    Installation Steps

  • Installing DB2 Clients on OS/2 Operating Systems
    Before You Begin Installing
    Installation Steps

    Setting up Client-to-Server Communications

  • 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 Client-to-Server Communications Using the Client Configuration Assistant
    LDAP Directory Support Considerations
    Before You Begin
    Configuration Steps
    Adding a Database Using a Profile
    Adding a Database Using Discovery
    Adding a Database Manually
    Creating and Using Profiles
    Server Profiles
    Client Profiles

  • Control Center Installation and Configuration
    Application versus Applet
    Machine Configurations
    Supported Java Virtual Machines for the Control Center
    Setting Up and Working with the Control Center
    Control Center Services Setup (Applet Mode only)
    Working with the Control Center
    Functional Considerations
    Installation Tips for Control Center Help on UNIX Operating Systems
    Configuring TCP/IP on OS/2
    Enabling Local Loopback
    Enabling Localhost
    Verifying TCP/IP Configuration on OS/2
    Troubleshooting Information
    Administering DB2 for OS/390 and DB2 Connect Enterprise Edition servers with the Control Center
    Preparing DB2 for OS/390 Servers for the Control Center
    Working with the Control Center
    Other Sources of Information

    Appendixes

  • Appendix A. About DB2 Universal Database for UNIX, Windows, and OS/2
    DB2 Products
    DB2 Everywhere
    DB2 Universal Database
    Host Databases
    DB2 Connect
    Related Products
    DB2 Relational Connect
    DB2 Warehouse Manager
    DB2 OLAP Server
    Intelligent Miner
    DB2 Spatial Extender
    DB2 Net Search Extender
    DB2 Data Links Manager
    Tivoli Enterprise
    Working with DB2 Data
    Accessing DB2 Data from Remote Clients
    Accessing Multiple DB2 Servers
    Accessing Host or AS/400 DB2 Data from the Desktop using DB2 Connect Enterprise Edition
    Accessing DB2 Data from the Web using Java
    Accessing DB2 Data from the Web using Net.Data
    Accessing DB2 Data from Host and AS/400 Client Machines
    Administering Instances and Databases with the DB2 Administration Tools
    Managing Instances and Database Objects using the Control Center
    Managing Communications on the Server
    Monitoring Databases using DB2 Performance Monitor
    Viewing SQL Access Plans using Visual Explain
    Managing Connections to Databases using the Client Configuration Assistant
    Managing Warehouses using the Data Warehouse Center
    Understanding the Administration Server
    Developing Applications using the DB2 Application Development Client
    Running Your Own Applications

  • Appendix B. Basic Task Knowledge
    Starting the Client Configuration Assistant
    Starting the DB2 Control Center
    Entering Commands Using the Command Center
    Entering Commands Using the Command Line Processor
    DB2 Command Window
    Interactive Input Mode
    Working with the System Administrative Group
    Working with the Business Intelligence Functions
    Mounting CD-ROMs on UNIX Operating Systems
    Mounting the CD-ROM on AIX
    Mounting the CD-ROM on HP-UX
    Mounting the CD-ROM on Linux
    Mounting the CD-ROM on PTX
    Mounting the CD-ROM on Solaris
    Setting the Number of Licensed Processors
    Upgrading DB2 from Try and Buy Mode

  • Appendix C. Using the DB2 Library
    DB2 PDF Files and Printed Books
    DB2 Information
    Printing the PDF Books
    Ordering the Printed Books
    DB2 Online Documentation
    Accessing Online Help
    Viewing Information Online
    Using DB2 Wizards
    Setting Up a Document Server
    Searching Information Online

  • Appendix D. 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 E. Naming Rules
    General Naming Rules
    Database, Database Alias, and Catalog Node Name Rules
    Object Name Rules
    Username, User ID, Group Name, and Instance Name Rules
    Workstation Name (nname) Rules
    DB2SYSTEM Naming Rules
    Password Rules

  • Appendix F. Notices
    Trademarks

  • Index

  • Contacting IBM
    Product Information