install db2
db2licm -a db2license.lic
./db2icrt -p ikabusr1 -u kabusr1 kabusr1
db2start
db2set db2codepage=1386
db2 "create db kabusr on /home/kabusr1/kabusr using codeset GBK territory CN"
create bufferpool
create tablespace
create table
db2 grant connect on database to user kevin
db2 grant select,delete,insert,update on table_name to user_name
...
db2 update db cfg using SORTHEAP 8192
...
db2 update dbm cfg using MAXAGENTS 800
...
./db2icrt -s client kevin
db2 catalog tcpip node NOKABUSR remote 192.168.1.1 server 50000
db2 catalog db kabusr at node NOKABUSR
db2 connect to kabusr user kevin using passwd
db2 "create table test(ABC varchar(10))"
db2 "select * from kevin.test"
db2 terminate
阅读(691) | 评论(0) | 转发(0) |
