Manually install DB2 on Linux2

Iii. Update the SVCENAME parameter in DBM configuration file. You must specify the service name or port number.

Sample is as follows:

 
 

     db2 update dbm cfg using SVCENAME db2c_db2inst1

 
 

You can use the following command to check the SVCENAME:

 
 

  db2 get dbm cfg | grep SVC

 
 

C. set the tcpip to DB2COMM registry parameter. With the DB2 instance user, enter the following command:

 
 

 
 

db2set DB2COMM=tcpip

D. restart DB2:

db2stop

db2start

 
 

7. Install license (this step can be ignored if the db2start has no problem)

Must be installed at each of the computers in the DB2 server license, use db2licm command

A. as root or DB2 instance user login.

B. Enter the following command

 
 

/opt/ibm/db2/V10.1/adm/db2licm -a

 
 

 
 

Among them, the filename is the absolute path to the DB2 server license file, this file generally in CD Mount plate/db2 / license directory, if the CD under the mount MNT, command format is as follows:

/opt/ibm/db2/V10.1/adm/db2licm -a /mnt/db2/license/db2ese.lic

 
 

After the installation, DB2 licenses in the/var/lum nodelock  directory.

 
 

8. Create the DB2 administration Server (DAS).

A. to have root privileges user login

B. Perform the following command to create the DAS:

 
 

opt/ibm/db2/V10.1/instance/dascrt -u DASuser

 
 

Including DASuser is created in the DAS user name of the machine

 
 

Commonly used commands:

1.    create the database

#su – db2inst1

$db2 create database test —- Create a database instance

DB20000I The CREATE DATABASE command completed successfully.

2.    Connect to the database we just created

#su – db2inst1

$db2

db2 => Connect to test user db2inst1

Enter current password for db2inst1:

Database Connection Information

Database server = DB2/LINUX 9.7.5

SQLauthorization ID = DB2INST1

Local database alias = TEST

db2 =>

3.    See the DB2 database maximum number of connections

 
 

[db2inst1@localhost ~]$ db2 get dbm cfg

 
 

          Database Manager Configuration

 
 

     Node type = Database Server with local and remote clients

 
 

 Database manager configuration release level            = 0x0a00

 
 

 CPU speed (millisec/instruction)             (CPUSPEED) = 2.834065e-07

 
 

 Max number of concurrently active databases     (NUMDB) = 8

 Data Links support                          (DATALINKS) = NO

 Federated Database System Support           (FEDERATED) = NO

 Transaction processor monitor name        (TP_MON_NAME) =

 
 

 Default charge-back account           (DFT_ACCOUNT_STR) =

 
 

 Java Development Kit installation path       (JDK_PATH) = /opt/IBMJava2-142

 
 

 Diagnostic error capture level              (DIAGLEVEL) = 3

 Notify Level                              (NOTIFYLEVEL) = 3

 Diagnostic data directory path               (DIAGPATH) = /home/db2inst1/sqllib/db2dump

 
 

 Default database monitor switches

   Buffer pool                         (DFT_MON_BUFPOOL) = OFF

   Lock                                   (DFT_MON_LOCK) = OFF

   Sort                                   (DFT_MON_SORT) = OFF

   Statement                              (DFT_MON_STMT) = OFF

   Table                                 (DFT_MON_TABLE) = OFF

   Timestamp                         (DFT_MON_TIMESTAMP) = ON

   Unit of work                            (DFT_MON_UOW) = OFF

 Monitor health of instance and databases   (HEALTH_MON) = ON

 
 

以下文章点击率最高

Loading…


发表评论

电子邮件地址不会被公开。 必填项已用*标注