db2 实用操作

1 创建数据库

 db2 list applications    

 db2 quiesce database immediate force connections 将数据库置于 QUIESCE 模式以防止新的连接：db2 unquiesce database 解除QUIESCE 模式

 db2 force applications all 终止所有数据库链接

 db2 terminate 终止所有当前连接的数据库会话，使你能够创建新的数据库

 db2 CREATE DATABASE db01 USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM

2 导数据

db2move db01 EXPORT db2move your_database_name EXPORT -t table_name
db2move db01 IMPORT db2move new_database_name IMPORT -t table_name

3 权限

CREATE USER your_user WITH PASSWORD 'your_password';
GRANT DBADM ON DATABASE TO USER your_user;
GRANT CREATEIN, CONNECT ON DATABASE db01 TO USER your_user;
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE your_table_name TO USER your_user;