- Installing DB2 UDB Servers
- Prerequisites
- Before You Begin
- Installing DB2 UDB
- Installed Directory Structure
- Considerations in an NIS Environment
- Distributed Installation
- Sample Response Files
- Creating a Response File
- Distributed Installation with a Response File
- Installing DB2 with db2_install
- DB2 UDB Environment Definitions
- DB2 Profile Registry
- Managing the DB2 Profile Registry
- The db2set Command
- Environment Variables
- Hierarchy of the DB2 UDB Environment
- DB2 Administration Server (DAS)
- DAS Process
- DB2 Instances
- Creating the Sample Database
- Using the Command Line Processor (CLP)
- Uninstalling DB2 Products
- Stopping the DAS Instance
- Stopping All DB2 Instances
- Removing the DAS Instance
- Removing DB2 Instances
- Removing DB2 Products
DB2 UDB Environment Definitions
Before we begin creating and working with databases, we need to understand the DB2 UDB environment. The DB2 UDB environment controls many database-related factors, such as what protocols may be used for accessing remote databases, what paths should be used by applications when searching for database-related files, how much memory will be allocated for the various buffers that databases and applications use, and how the system will behave in certain situations. This complex environment is controlled by several different mechanisms, including:
-
DB2 Profile Registry
-
Environment variables
-
Configuration parameters
This section discusses the DB2 Profile Registry and environment variables. Configuration parameters are discussed throughout the remainder of this book.