为何 no space？
创建一 表提示no space但下面好象有很多空间onstat -d
IBM Informix Dynamic Server Version 10.00.FC4 -- On-Line -- Up 46 days 15:04:29 -- 5015136 Kbytes
Dbspaces
address number flags fchunk nchunkspgsize flags owner name
7000000f01ace781 0x40001 1 1 4096 NB informix rootdbs
7000000f14775082 0x40001 2 1 4096 NB informix phydbs
7000000f14776a03 0x40001 3 2 4096 NB informix logdbs
7000000f14778384 0x42001 5 1 4096 N TB informix tmpdbs1
7000000f14779d05 0x42001 6 1 4096 N TB informix tmpdbs2
7000000f1477b686 0x40001 7 21 4096 NB informix datadbs0a
7000000f1477d007 0x40001 15 5 4096 NB informix iodbs01
7000000f14780288 0x40001 18 3 4096 NB informix iodbs03
7000000f14781c09 0x40001 20 4 4096 NB informix idxdbs01
7000000f147835810 0x40001 22 16 4096 NB informix datadbs0b
7000000f14784f011 0x40001 30 6 4096 NB informix iodbs02
7000000f147868812 0x40001 33 3 4096 NB informix iodbs04
7000000f147882013 0x40001 35 5 4096 NB informix idxdbs02
7000000f14789b814 0x40001 46 2 4096 NB informix datadbsat
14 active, 2047 maximum
Chunks
address chunk/dbsoffset size free bpages flags pathname
7000000f01ae0281 1 0 500000 471471 PO-B/informix/inst_datachk/lq_rootchk
7000000f150b8482 2 250 512000 255947 PO-B/informix/inst_datachk/lq_phychk
7000000f150b9e83 3 250 512000 11947 PO-B/informix/inst_datachk/lq_log1chk
7000000f150bb884 3 250 512000 511997 PO-B/informix/inst_datachk/lq_log2chk
7000000f150bd285 4 250 512000 457678 PO-B/informix/inst_datachk/lq_tmp1chk
7000000f150c0286 5 250 512000 450913 PO-B/informix/inst_datachk/lq_tmp2chk
7000000f150c1c87 6 250 1024000 117 PO-B/informix/inst_datachk/lq_datachk1
7000000f150c3688 6 250 1024000 169 PO-B/informix/inst_datachk/lq_datachk2
7000000f150c5089 6 250 1024000 35 PO-B/informix/inst_datachk/lq_datachk3
7000000f150c6a810 6 250 1024000 97 PO-B/informix/inst_datachk/lq_datachk4
7000000f150c84811 6 250 1024000 224 PO-B/informix/inst_datachk/lq_datachk5
7000000f150c9e812 6 250 1024000 568 PO-B/informix/inst_datachk/lq_datachk6
7000000f150cb8813 6 250 1024000 189 PO-B/informix/inst_datachk/lq_datachk7
7000000f150cd2814 6 250 1024000 375 PO-B/informix/inst_datachk/lq_datachk8
7000000f11aa02815 7 250 1024000 23947 PO-B/informix/inst_datachk/lq_datachk9
7000000f11aa1c816 7 250 1024000 23997 PO-B/informix/inst_datachk/lq_datachk10
7000000f11aa36817 7 250 1024000 23997 PO-B/informix/inst_datachk/lq_datachk11
7000000f11aa50818 8 250 1024000 4392 PO-B/informix/inst_datachk/lq_datachk12
7000000f11aa6a819 8 250 1024000 12919 PO-B/informix/inst_datachk/lq_datachk13
7000000f11aa84820 9 250 1024000 3884 PO-B/informix/inst_datachk/lq_datachk14
7000000f11aa9e821 9 250 1024000 117467 PO-B/informix/inst_datachk/lq_datachk15
7000000f11aab8822 10 250 1024000 640 PO-B/informix/inst_datachk/lq_datachk16
7000000f11aad2823 10 250 1024000 226 PO-B/informix/inst_datachk/lq_datachk17
7000000f11ab02824 10 250 1024000 20400 PO-B/informix/inst_datachk/lq_datachk18
7000000f11ab1c825 10 250 1024000 830827 PO-B/informix/inst_datachk/lq_datachk19
7000000f11ab36826 10 250 1024000 940165 PO-B/informix/inst_datachk/lq_datachk20
7000000f11ab50827 10 250 1024000 907159 PO-B/informix/inst_datachk/lq_datachk21
7000000f11ab6a828 10 250 1024000 896497 PO-B/informix/inst_datachk/lq_datachk22
7000000f11ab84829 10 250 1024000 828068 PO-B/informix/inst_datachk/lq_datachk23
7000000f11ab9e830 11 250 1024000 23947 PO-B/informix/inst_datachk/lq_datachk24
7000000f11abb8831 11 250 1024000 23997 PO-B/informix/inst_datachk/lq_datachk25
7000000f11abd2832 11 250 1024000 23997 PO-B/informix/inst_datachk/lq_datachk26
7000000f146e02833 12 250 1024000 3621 PO-B/informix/inst_datachk/lq_datachk27
7000000f146e1c834 12 250 1024000 7526 PO-B/informix/inst_datachk/lq_datachk28
7000000f146e36835 13 250 1024000 0 PO-B/informix/inst_datachk/lq_datachk29
7000000f146e50836 13 250 1024000 217 PO-B/informix/inst_datachk/lq_datachk30
7000000f146e6a837 9 250 1024000 343232 PO-B/informix/inst_datachk/lq_datachk31
7000000f146e84838 13 250 1024000 981 PO-B/informix/inst_datachk/lq_datachk32
7000000f146e9e839 6 250 1024000 228 PO-B/informix/inst_datachk/lq_datachk33
7000000f146eb8840 6 250 1024000 166 PO-B/informix/inst_datachk/lq_datachk34
7000000f146ed2841 6 250 1024000 160 PO-B/informix/inst_datachk/lq_datachk35
7000000f146f02842 8 250 1024000 893521 PO-B/informix/inst_datachk/lq_datachk36
7000000f146f1c843 12 250 1024000 823997 PO-B/informix/inst_datachk/lq_datachk37
7000000f146f36844 9 250 1024000 1023997 PO-B/informix/inst_datachk/lq_datachk38
7000000f146f50845 13 250 1024000 943 PO-B/informix/inst_datachk/lq_datachk39
7000000f146f6a846 14 250 1024000 991947 PO-B/informix/inst_datachk/lq_datachk40
7000000f146f84847 14 250 1024000 1023997 PO-B/informix/inst_datachk/lq_datachk41
7000000f146f9e848 7 250 1024000 48997 PO-B/informix/inst_datachk/lq_datachk42
7000000f146fb8849 11 250 1024000 273997 PO-B/informix/inst_datachk/lq_datachk43
7000000f146fd2850 6 250 1024000 112 PO-B/informix/inst_datachk/lq_datachk44
7000000f147002851 13 250 1024000 664915 PO-B/informix/inst_datachk/lq_datachk45
7000000f14701c852 10 250 1024000 885667 PO-B/informix/inst_datachk/lq_datachk46
7000000f147036853 6 250 1024000 115 PO-B/informix/inst_datachk/lq_datachk47
7000000f147050854 10 250 1024000 828669 PO-B/informix/inst_datachk/lq_datachk48
7000000f14706a855 6 250 1024000 62 PO-B/informix/inst_datachk/lq_datachk49
7000000f147084856 10 250 1024000 826005 PO-B/informix/inst_datachk/lq_datachk50
7000000f14709e857 6 250 1024000 44 PO-B/informix/inst_datachk/lq_datachk51
7000000f1470b8858 6 250 1024000 39 PO-B/informix/inst_datachk/lq_datachk52
7000000f1470d2859 10 250 1024000 785036 PO-B/informix/inst_datachk/lq_datachk53
7000000f147102860 10 250 1024000 898997 PO-B/informix/inst_datachk/lq_datachk54
7000000f14711c861 7 250 1024000 973997 PO-B/informix/inst_datachk/lq_datachk55
7000000f147136862 6 250 1024000 23 PO-B/informix/inst_datachk/lq_datachk56
7000000f147150863 6 250 1024000 27 PO-B/informix/inst_datachk/lq_datachk57
7000000f14716a864 6 250 1024000 18 PO-B/informix/inst_datachk/lq_datachk58
7000000f147184865 11 250 1024000 1023997 PO-B/informix/inst_datachk/lq_datachk59
7000000f14719e866 10 250 1024000 998997 PO-B/informix/inst_datachk/lq_datachk60
7000000f1471b8867 6 250 1024000 11 PO-B/informix/inst_datachk/lq_datachk61
7000000f1471d2868 6 250 1024000 2 PO-B/informix/inst_datachk/lq_datachk62
7000000f147702869 11 250 1024000 1023997 PO-B/informix/inst_datachk/lq_datachk63
7000000f14771c870 10 250 1024000 1023997 PO-B/informix/inst_datachk/lq_datachk64
7000000f147736871 10 250 1024000 1023997 PO-B/informix/inst_datachk/lq_datachk65
71 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
onstat -D
IBM Informix Dynamic Server Version 10.00.FC4 -- On-Line -- Up 46 days 15:04:36 -- 5015136 Kbytes
Dbspaces
address number flags fchunk nchunkspgsize flags owner name
7000000f01ace781 0x40001 1 1 4096 NB informix rootdbs
7000000f14775082 0x40001 2 1 4096 NB informix phydbs
7000000f14776a03 0x40001 3 2 4096 NB informix logdbs
7000000f14778384 0x42001 5 1 4096 N TB informix tmpdbs1
7000000f14779d05 0x42001 6 1 4096 N TB informix tmpdbs2
7000000f1477b686 0x40001 7 21 4096 NB informix datadbs0a
7000000f1477d007 0x40001 15 5 4096 NB informix iodbs01
7000000f14780288 0x40001 18 3 4096 NB informix iodbs03
7000000f14781c09 0x40001 20 4 4096 NB informix idxdbs01
7000000f147835810 0x40001 22 16 4096 NB informix datadbs0b
7000000f14784f011 0x40001 30 6 4096 NB informix iodbs02
7000000f147868812 0x40001 33 3 4096 NB informix iodbs04
7000000f147882013 0x40001 35 5 4096 NB informix idxdbs02
7000000f14789b814 0x40001 46 2 4096 NB informix datadbsat
14 active, 2047 maximum
Chunks
address chunk/dbsoffset page Rdpage Wrpathname
7000000f01ae0281 1 0 1309181120877 /informix/inst_datachk/lq_rootchk
7000000f150b8482 2 250 279 58097421 /informix/inst_datachk/lq_phychk
7000000f150b9e83 3 250 1821097127388873 /informix/inst_datachk/lq_log1chk
7000000f150bb884 3 250 92 0 /informix/inst_datachk/lq_log2chk
7000000f150bd285 4 250 74788117 105984455 /informix/inst_datachk/lq_tmp1chk
7000000f150c0286 5 250 79215469 110595442 /informix/inst_datachk/lq_tmp2chk
7000000f150c1c87 6 250 288361056 2051120/informix/inst_datachk/lq_datachk1
7000000f150c3688 6 250 121729956 847490 /informix/inst_datachk/lq_datachk2
7000000f150c5089 6 250 67274272 2598429/informix/inst_datachk/lq_datachk3
7000000f150c6a810 6 250 142085110 3011181/informix/inst_datachk/lq_datachk4
7000000f150c84811 6 250 135456791 2355557/informix/inst_datachk/lq_datachk5
7000000f150c9e812 6 250 134290062 2532909/informix/inst_datachk/lq_datachk6
7000000f150cb8813 6 250 110807018 1738177/informix/inst_datachk/lq_datachk7
7000000f150cd2814 6 250 140731001 3692892/informix/inst_datachk/lq_datachk8
7000000f11aa02815 7 250 214998555 5806647/informix/inst_datachk/lq_datachk9
7000000f11aa1c816 7 250 58633326 0 /informix/inst_datachk/lq_datachk10
7000000f11aa36817 7 250 58782475 0 /informix/inst_datachk/lq_datachk11
7000000f11aa50818 8 250 65317933 15041 /informix/inst_datachk/lq_datachk12
7000000f11aa6a819 8 250 86314348 315965 /informix/inst_datachk/lq_datachk13
7000000f11aa84820 9 250 175256993 6861162/informix/inst_datachk/lq_datachk14
7000000f11aa9e821 9 250 76502836 2361300/informix/inst_datachk/lq_datachk15
7000000f11aab8822 10 250 128993694 25427 /informix/inst_datachk/lq_datachk16
7000000f11aad2823 10 250 63771461 6 /informix/inst_datachk/lq_datachk17
7000000f11ab02824 10 250 144526720 1833807/informix/inst_datachk/lq_datachk18
7000000f11ab1c825 10 250 15205699 101579 /informix/inst_datachk/lq_datachk19
7000000f11ab36826 10 250 64280732 /informix/inst_datachk/lq_datachk20
7000000f11ab50827 10 250 20901141 109208 /informix/inst_datachk/lq_datachk21
7000000f11ab6a828 10 250 12646510 9 /informix/inst_datachk/lq_datachk22
7000000f11ab84829 10 250 19912431 105255 /informix/inst_datachk/lq_datachk23
7000000f11ab9e830 11 250 631581534 616308 /informix/inst_datachk/lq_datachk24
7000000f11abb8831 11 250 341205882 72298 /informix/inst_datachk/lq_datachk25
7000000f11abd2832 11 250 379902415 34583 /informix/inst_datachk/lq_datachk26
7000000f146e02833 12 250 84253999 44463 /informix/inst_datachk/lq_datachk27
7000000f146e1c834 12 250 63926648 242506 /informix/inst_datachk/lq_datachk28
7000000f146e36835 13 250 185852151 872081 /informix/inst_datachk/lq_datachk29
7000000f146e50836 13 250 263749363 699270 /informix/inst_datachk/lq_datachk30
7000000f146e6a837 9 250 133915581 7588802/informix/inst_datachk/lq_datachk31
7000000f146e84838 13 250 408494841 67608 /informix/inst_datachk/lq_datachk32
7000000f146e9e839 6 250 179479348 2816190/informix/inst_datachk/lq_datachk33
7000000f146eb8840 6 250 176801852 886580 /informix/inst_datachk/lq_datachk34
7000000f146ed2841 6 250 98096181 3314230/informix/inst_datachk/lq_datachk35
7000000f146f02842 8 250 172381075071 /informix/inst_datachk/lq_datachk36
7000000f146f1c843 12 250 10617982 91729 /informix/inst_datachk/lq_datachk37
7000000f146f36844 9 250 92 0 /informix/inst_datachk/lq_datachk38
7000000f146f50845 13 250 394972881 755186 /informix/inst_datachk/lq_datachk39
7000000f146f6a846 14 250 158872 1099 /informix/inst_datachk/lq_datachk40
7000000f146f84847 14 250 92 0 /informix/inst_datachk/lq_datachk41
7000000f146f9e848 7 250 79026362 291453 /informix/inst_datachk/lq_datachk42
7000000f146fb8849 11 250 356145640 322755 /informix/inst_datachk/lq_datachk43
7000000f146fd2850 6 250 115579178 2670506/informix/inst_datachk/lq_datachk44
7000000f147002851 13 250 310030029 586336 /informix/inst_datachk/lq_datachk45
7000000f14701c852 10 250 14240550 0 /informix/inst_datachk/lq_datachk46
7000000f147036853 6 250 117007213 2142217/informix/inst_datachk/lq_datachk47
7000000f147050854 10 250 39677964 380999 /informix/inst_datachk/lq_datachk48
7000000f14706a855 6 250 117555387 1549082/informix/inst_datachk/lq_datachk49
7000000f147084856 10 250 17689706 180 /informix/inst_datachk/lq_datachk50
7000000f14709e857 6 250 103019819 1619896/informix/inst_datachk/lq_datachk51
7000000f1470b8858 6 250 106581030 2724598/informix/inst_datachk/lq_datachk52
7000000f1470d2859 10 250 49770527 883752 /informix/inst_datachk/lq_datachk53
7000000f147102860 10 250 17341616 54474 /informix/inst_datachk/lq_datachk54
7000000f14711c861 7 250 32391 4889 /informix/inst_datachk/lq_datachk55
7000000f147136862 6 250 94950137 1382578/informix/inst_datachk/lq_datachk56
7000000f147150863 6 250 98269460 2173566/informix/inst_datachk/lq_datachk57
7000000f14716a864 6 250 99533563 2494064/informix/inst_datachk/lq_datachk58
7000000f147184865 11 250 92 0 /informix/inst_datachk/lq_datachk59
7000000f14719e866 10 250 793523737803 /informix/inst_datachk/lq_datachk60
7000000f1471b8867 6 250 71373138 3886827/informix/inst_datachk/lq_datachk61
7000000f1471d2868 6 250 25237606 3404593/informix/inst_datachk/lq_datachk62
7000000f147702869 11 250 92 0 /informix/inst_datachk/lq_datachk63
7000000f14771c870 10 250 876683 87186 /informix/inst_datachk/lq_datachk64
7000000f147736871 10 250 92 0 /informix/inst_datachk/lq_datachk65
71 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
页:
[1]