- 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
Creating the Sample Database
This section shows you how to create the sample database provided with DB2 UDB. You can verify the installation of the DB2 UDB product by creating the sample database and connecting to it using the CLP.
You need about 15MB of disk to create the sample database. It can be created by the first steps of the GUI, after installing DB2 (db2fs), or with the db2sampl command:
db2sampl path
path represents the directory where the initial database files are created. Unless specified, the sample database will be created in the path defined by the DFTDBPATH database manager configuration parameter. The default value of the DFTDBPATH database manager configuration parameter is the home directory of the instance owner.
This process will take a few minutes to complete. When the creation process is complete, try to connect to the sample database using the CONNECT command, as shown in Figure 2.40.
Figure 2.40. Connecting to the Sample Database