First, the preparation of pre-installation work:
1. For Linux systems, the following packages need to be installed:
2. Linux kernel settings:
Edit the/etc/sysctl.conf file to add the following:
3. Create the appropriate users and groups:
The official documentation gives you the need to create three user users and the appropriate groups:
This can be created during the subsequent installation process, or it may be created before installation.
4, create the corresponding directory for storing DB2 data files and log files:
Here, create a DB2 total directory below the root, then create a 15G-size logical Volume mount/DB2 below, and then create the appropriate folder underneath it.
Database directory holds DB instance
DB2LOG1 storing DB2 's main log file
Db2log2 Storing image log files
Db2temp storing DB2 temporary table space
DB2 the location of the user's home directory
Second, the installation process:
Installation can be installed using root user or non-root user installation, which is installed directly using root user.
To execute db2setup as root, the following screen will pop up:
Select Install the Enterprise version here and click Install New:
After the next step, the Create User screen appears:
Next ask whether to create an instance, I am a beginner, so create an instance:
Finally click Finish to begin the installation process.
Third, create the database:
If you do not create a database during Setup, you can subsequently use the DB2CC command to create the database. This is a graphical interface based management tool, it is also very convenient to use. After performing the db2cc, the following screen will pop up:
Click on the Create New database on the right, creating the databases:
Specify the database name and location, select let DB2 manage my storage, Next:
Click Finish to start creating. The default DB2 creates the following three table spaces:
(1), catalog table space is used for storing catalog tables.
(2), user table space holds all table and index data.
(3), temporary table space temporary data storage location.
Once created, you will see the following screen:
You are not connected to the XZXJDB1 at this point, click Connect on the right. After connecting, you will see a lot more information on the right side:
To view table space information in the current database using the command line:
Iv. Simple management of DB2:
1. View tablespace information:
2. View table information:
3. View all database information under the current instance:
4. Stop the database:
5. Start the database:
6. Set the instance to start automatically:
I beginner DB2, this article there is wrong place, also please the heroes to put forward valuable advice, younger brother greatly grateful!!
IBM DB2 for Linux Installation Guide (GO)