数据库用户tmn登录,dbaccess->databases->info->dBspace
[tmn@linuxserver bin]$ dbaccess
DATABASE INFO: dBspace Nls Routine Databases Exit
Display DBSPACE information for a database.
----------------------- bss_osp@linux_infor ---- Press CTRL-W for Help --------
Number of When
Id Name Chunks Created Mirror
2 authdb 2 01/10/2006 N
退出查看authdb的空间
[tmn@linuxserver tmn]$ onstat -d
IBM Informix Dynamic Server Version 9.40.UC3 -- On-Line -- Up 43 days 14:50:24 -- 56324 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
457027d8 1 0x20001 1 4 N informix rootdbs
45f767c0 2 0x20001 2 1 N informix authdb
45f76910 3 0x20001 3 5 N informix webgis
45f76a60 4 0x20001 4 1 N informix necheck
45f76bb0 5 0x20001 5 2 N informix metataskdbs
45f76d00 6 0x20001 7 4 N informix eoms
45f76e50 7 0x28001 8 3 N S informix emos_integ_sp
46297018 8 0x20001 20 1 N informix resdbspace
8 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
45702928 1 1 0 250000 11257 PO-- /home/data/online_root
45702af0 2 2 0 100000 51 PO-- /home/data/authdb_chunk
45702c78 3 3 0 102400 8 PO-- /home/data/webgis_chunk
45702e00 4 4 0 102400 49671 PO-- /home/data/necheck_chunk
45f75018 5 5 0 153600 77694 PO-- /home/data/metatask_chunk
45f751a0 6 5 0 204800 93781 PO-- /home/data/metatask.1_chunk
45f75328 7 6 0 204800 186 PO-- /home/data/eoms.1
45f754b0 8 7 250 10240 0 8457 POS- /home/informix/sbspaces/emos_integ_sp
Metadata 1730 0 1730
45802d70 9 1 0 307200 217736 PO-- /home/data/online_root.2
45f75638 10 7 0 102400 53226 80122 POS- /home/informix/sbspaces/emos_integ_sp_2
Metadata 22275 1791 22275
45f757c0 11 6 0 102400 144 PO-- /home/data/eoms.2
45f75948 12 1 0 250000 242812 PO-- /home/data/online_root.3
45f75ad0 13 1 0 204800 125648 PO-- /home/data/online_root.4
45f75c58 14 3 0 512000 28 PO-- /home/data/webgis.1
45f75de0 15 6 0 256000 25 PO-- /home/data/eoms.3
45f76018 16 7 0 256000 225262 238741 POS- /home/data/eoms_sp.1
Metadata 17256 13512 17256
45f761a0 17 3 0 250000 0 PO-- /home/informix/sbspaces/webgis_e1
45f76328 18 3 0 500000 163417 PO-- /INFORMIXTMP/webgis_e2
45f764b0 19 3 0 1000000 999997 PO-- /INFORMIXTMP/webgis_e3
45f76638 20 8 0 250000 246642 PO-- /home/data/resdbspace
46b17e80 21 6 0 512000 491073 PO-- /home/data/eoms.4
21 active, 2047 maximum
Expanded chunk capacity mode: disabled
free列值为51
切换到系统用户
[tmn@linuxserver tmn]$ su informix
Password:
[informix@linuxserver tmn]$ cd /home/data/
[informix@linuxserver data]$ ls
authdb_chunk dbalarm.1 eoms.3 metatask.1_chunk online_root online_root.4 webgis.1
bak eoms.1 eoms.4 metatask_chunk online_root.2 readme.txt webgis_chunk
conftrunc.tar eoms.2 eoms_sp.1 necheck_chunk online_root.3 resdbspace wydemo_sp
[informix@linuxserver data]$ touch authdb_chunk.1
切换回数据库用户,绑定空间
[informix@linuxserver data]$ exit
exit
[tmn@linuxserver bin]$ onspaces -a authdb -p /home/data/authdb_chunk.1 -o 0 -s 524288
Verifying physical disk space, please wait ...
Chunk successfully added.