sunchenglu7的专栏

以root用户登录useradd -g db2iadm1 -m -d /home/db2inst1 db2inst1改用户密码：passwd 用户名赋权限：grant dbadm on database to user emp_app;grant connect on database to user emp_app;grant createtab on databas

卸载之前先停掉数据库db2stop DB2卸载：1.Remove DB【首先删除数据库】(1)su - db2inst1(2) db2 list db directory(3)db2 drop db NG2_APP52.Remove Instance【删除实例】(1)su - root(2) cd /instance(3) ./db2ilist./db2

reorg是用来整理磁盘碎片即重构表。DB2修改表结构需要做reorgreorg table tabname;http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.doc/doc/rdb2stt.html?cp=SSEPGG_9.7.0%2F2-6-4&lang=zh

1.查询锁表情况，可以获取哪个表被锁，其中agent_id为哪个DB2进程锁了表select * from sysibmadm.locks_held with ur;2.拿到上述的agent_id，查询具体锁表的IP和应用程序db2 list application | grep 51604masadic db2jcc_applica 51604  192.168.210.33.5

按以下1. db2 force application all2. db2stop3. db2stop force4. db2start