几个有用的工具sql

查看各个数据空间使用量及剩余量：

select name dbspace,sum(chksize) allocated,sum(nfree) free,round(((sum(chksize)-sum(nfree))/sum(chksize))*100)||"%" pcused from sysdbspaces d,syschunks c where d.dbsnum=c.dbsnum group by name order by 4 desc

 

查看各数据库表大小（单位:M）

select dbsname,tabname,sum(size)*2048/1024/1024 from sysextents where dbsname in ('jcsjk','sjysjk','khsjk')  group by 1,2 order by 3 desc

 

数据库备份批量表：

UNLOAD TO /usr/bsum/zqq/tmp/unload.sql DELIMITER ';' SELECT tabid  ||"   unload to /usr/yxkh/zqq/tmp/"||trim(tabname)||".txt delimiter '$' select * from "||trim(tabname)  FROM systables WHERE tabid >99