- 论坛徽章:
- 0
|
抱歉,我写错了,我是实验drop database, 请看下面的操作,我的问题是为什么drop之后size (1749999) 和free(1100541)的数值差很多?谢谢。我看了手册,但是没有什么明确的说明。
echo "drop database omc_db" | dbaccess
Database dropped.
onstat -d
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 00:04:04 -- 1756160 Kbytes
Dbspaces
address number flags fchunk nchunks pgsize flags owner name
6f0207e0 1 0x61001 1 1 2048 N B informix rootdbs
6f1b9ec0 2 0x60001 2 1 2048 N B informix omc_db_plog
6f92a7e8 3 0x60001 3 1 2048 N B informix omc_db_llog
6f92a940 4 0x61001 4 1 8192 N B informix omc_db_sp1
6f92aa98 5 0x61001 5 1 8192 N B informix omc_db_sp2
6f92abf0 6 0x61001 6 1 8192 N B informix omc_db_sp3
6f92ad48 7 0x61001 7 1 8192 N B informix omc_db_sp4
6f92aea0 8 0x61001 8 1 8192 N B informix omc_db_sp5
6f92c018 9 0x61001 9 1 8192 N B informix omc_db_sp6
6f92c170 10 0x61001 10 1 8192 N B informix omc_db_sp7
6f92c2c8 11 0x61001 11 1 8192 N B informix omc_db_sp8
6f92c420 12 0x61001 12 1 8192 N B informix omc_db_sp9
6f92c578 13 0x61001 13 1 8192 N B informix omc_db_sp10
6f92c6d0 14 0x61001 14 1 8192 N B informix omc_db_sp11
6f92c828 15 0x61001 15 1 8192 N B informix omc_db_sp12
6f92c980 16 0x42001 16 1 8192 N TB informix omc_db_temp
16 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
6f020938 1 1 2 1023998 1011055 PO-B /dev/omc_db_root
6f1b9ba0 2 2 2 256000 129000 PO-B /dev/omc_db_logs
6f1b9d30 3 3 256004 767990 383937 PO-B /dev/omc_db_logs
6f020ca0 4 4 4 1749999 1100541 PO-B /dev/omc_db1
6f020e30 5 5 4 1749999 1100541 PO-B /dev/omc_db2
6f1a8630 6 6 4 1749999 1100541 PO-B /dev/omc_db3
6f1a87c0 7 7 4 1749999 1100541 PO-B /dev/omc_db4
6f1a8950 8 8 4 1749999 1121343 PO-B /dev/omc_db5
6f1a8ae0 9 9 4 1749999 1121343 PO-B /dev/omc_db6
6f1a8c70 10 10 4 1749999 1121343 PO-B /dev/omc_db7
6f1a8e00 11 11 4 1749999 1121343 PO-B /dev/omc_db8
6f92a018 12 12 4 1749999 1121343 PO-B /dev/omc_db9
6f92a1a8 13 13 4 1749999 1121343 PO-B /dev/omc_db10
6f92a338 14 14 4 1749999 1121343 PO-B /dev/omc_db11
6f92a4c8 15 15 4 1749999 1130219 PO-B /dev/omc_db12
6f92a658 16 16 4 255999 255946 PO-B /dev/omc_db_temp
16 active, 32766 maximum
NOTE: The values in the "size" and "free" columns for DBspace chunks are
displayed in terms of "pgsize" of the DBspace to which they belong.
Expanded chunk capacity mode: always |
|