DB2工具类SQL及常用命令

查看表load锁状态
SELECT DISTINCT tabname from sysibmadm.admintabinfo WHERE LOAD_STATUS=‘PENDING’ WITH UR

—查看表数据在dpf分区数据库节点分布情况
select ‘select dbpartitionnum(’ || c.colname || ‘), count(1) from ’ || rtrim(c.tabschema) || ‘.’ || rtrim(c.tabname) || ’ group by dbpartitionnum(’ || c.colname || ‘) order by dbpartitionnum(’ || c.colname || ‘) with ur;’
from syscat.columns c where c.tabname in (select tabname as tabname from syscat.tables
where tbspaceid = ‘22’) and partkeyseq > 0 with ur

释放表空间
db2 “alter tablespace TABLESPACENAME reduce max”

–重启数据库
db2 force applications all --杀除所有进程
db2stop --停止数据库
db2start --启动数据库
db2 activate db hrpams --激活实例

给用户赋权限
db2 “grant dbadm on database to user czams”

–激活数据库
db2 activate db ahnxods

–查看数据库回滚信息
db2pd -utilities -alldbpartitionnums

–询盘命令
cfgmgr -v

ftp启停命令
startsrc -t ftp
stopsrc -t ftp