DB2創(chuàng)建用戶是很常見的操作，下面就為您詳細(xì)介紹DB2創(chuàng)建用戶的方法，如果您在DB2創(chuàng)建用戶方面遇到過類似的問題，不妨一看。

1.創(chuàng)建實(shí)例用戶
mkdir /db2/db2test 創(chuàng)建實(shí)例用戶目錄
smitty user
選擇Add a User
* User NAME                                          [db2test]                                                            
User ID                                                   []                                                                   
ADMINISTRATIVE USER?                       false                                                              
Primary GROUP                                     [db2iadm1]                                                          
Group SET                                           [staff]                                                             
ADMINISTRATIVE GROUPS                   []                                                                  
ROLES                                                         []                                                                  
Another user can SU TO USER?            true                                                               
SU GROUPS                                          [ALL]                                                               
HOME directory                                     [/db2/db2test]
Initial PROGRAM                                    [/usr/bin/ksh]

2.創(chuàng)建實(shí)例 DB2_install=/usr/opt/db2_08_01/instance
./db2icrt -u db2test db2test

3.創(chuàng)建數(shù)據(jù)庫
su - db2test
db2start     #此處不執(zhí)行啟動(dòng)實(shí)例將報(bào):SQL1032N No start database manager command was issued. SQLSTATE=57019
db2 create db db2test

4.刪除數(shù)據(jù)庫
db2 drop db db2test
db2stop

5.刪除實(shí)例
cd DB2_install
./db2idrop -f db2test # -f參數(shù)一定要添加否則刪除完了會(huì)報(bào)錯(cuò)！

6.刪除用戶
smitty user
選擇Remove a User
* User NAME                                          [db2test]                                                           +
Remove AUTHENTICATION information?                  yes     

刪除用戶目錄
rm -rf db2test
 

【編輯推薦】

DB2性能優(yōu)化的十大注意事項(xiàng)

SQL SERVER連接DB2數(shù)據(jù)庫

DB2循環(huán)查詢的實(shí)現(xiàn)方法

DB2分區(qū)數(shù)據(jù)庫的前滾操作

兩種DB2分區(qū)數(shù)據(jù)庫恢復(fù)方式