linux下卸载db2数据库,linux下卸载db2

linux下卸载db2

(1)db2instl实例用户

[root@dockerServer ~]# su - db2instl

Last login: Tue Jan 6 08:47:53 CST 2015 on

pts/0

[db2instl@dockerServer ~]$

(2)查看建立的数据库

[db2instl@dockerServer ~]$ db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database

alias = SAMPLE

Database

name = SAMPLE

Local database

directory = /home/db2instl

Database release

level = f.00

Comment =

Directory entry

type = Indirect

Catalog database partition

number =

0

Alternate server

hostname =

Alternate server port

number =

(3)删除数据库

[db2instl@dockerServer ~]$ db2 drop db SAMPLE

SQL1032N No start database manager command was

issued. SQLSTATE=57019

[db2instl@dockerServer ~]$ db2start

SQL1063N DB2START processing was

successful.

[db2instl@dockerServer ~]$ db2 drop db SAMPLE

DB20000I The DROP DATABASE command completed

successfully.

(4)再查询

[db2instl@dockerServer ~]$ db2 list db directory

SQL1057W The system database directory is

empty. SQLSTATE=01606

(4)root账户

[root@dockerServer ~]#

进入目录

[root@dockerServer instance]# pwd

/opt/ibm/db2/V10.1/instance

(5)用实例账户停掉服务

[root@dockerServer instance]# su - db2instl

Last login: Tue Jan 6 09:52:28 CST 2015 on

pts/0

[db2instl@dockerServer ~]$ db2stop

SQL1064N DB2STOP processing was successful.

(6)用root账户，查询实例列表

[root@dockerServer instance]# ./db2ilist

db2inst1

db2instl

(7)删除所有实例

[root@dockerServer instance]# ./db2idrop db2instl

DBI1446I The db2idrop command is running, please

wait.

DB2 installation is being initialized.

Total number of tasks to be performed: 2

Total estimated time for all tasks to be performed: 305

second(s)

Task #1 start

Description: Initializing instance list

Estimated time 5 second(s)

Task #1 end

Task #2 start

Description: Configuring DB2 instances

Estimated time 300 second(s)

Task #2 end

The execution completed successfully.

For more information see the DB2 installation log at

"/tmp/db2idrop.log.7298".

DBI1070I Program db2idrop completed

successfully.

(8)查看结果

[root@dockerServer instance]# ./db2ilist

(9)删除das,查询dba用户

[root@dockerServer instance]# pwd

/opt/ibm/db2/V10.1/instance

[root@dockerServer instance]# ./daslist

dasusr1

[root@dockerServer instance]# ./dasdrop dasusr1

Failed to determine if instance 'dasusr1' is pureCluster.

DBI1070I Program dasdrop completed

successfully.

(10)卸载

[root@dockerServer install]# pwd

/opt/ibm/db2/V10.1/install

[root@dockerServer install]# ./db2_deinstall -a

DBI1016I Program db2_deinstall is performing

uninstallation. Please

wait.

The execution completed successfully.

For more information see the DB2 uninstallation log at

"/tmp/db2_deinstall.log.41446".

(11)删除用户和组

userdel xxx

groupdel xxx