DB2創(chuàng)建用戶的方法
DB2創(chuàng)建用戶是很常見的操作，下面就為您詳細(xì)介紹DB2創(chuàng)建用戶的方法，如果您在DB2創(chuàng)建用戶方面遇到過(guò)類似的問(wèn)題，不妨一看。
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ù)庫(kù)
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ù)庫(kù)
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
【編輯推薦】
SQL SERVER連接DB2數(shù)據(jù)庫(kù)
