INFORMIX增加表空间及动态查询

onstat -d  查看表空间文件名字及大小，剩余空间等
onspaces -a dmsdbs -p /ifmx.links/datachunk62 -o 0 -s 5242000
  增加空间

 

select tabname from systables where owner='informix' into temp tmp_systables with no log;

select * from tmp_systables

drop table tmp_systables

update tmp_systables  set tabname  = 'select '||"'"||tabname||"'"||',count(*) from '||tabname||' union all ' where 1=1