How to create dbspace
hello
I am working on informix 9.3 on win2k with ArcSDE
when i am loading data the dbspace exhuasted after restarting the servis i am able to run the service but unable to connect
Plz find the below the details of onstat -d
d:\\PROGRA~1\\Informix\\bin\\onstat -d:
Informix Dynamic Server Version 9.30.TC1 -- Fast Recovery -- Up 00:00:11 -- 25472 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
c9e27d0 1 0x1 1 1 N informix rootdbs
cd57018 2 0x1 2 1 N informix inf_sde
cd57160 3 0x8001 3 1 N S informix sbspace
cd572a8 4 0x1 4 1 N informix dbspace
cd573f0 5 0x1 5 3 N informix sdedbs
cd57538 6 0x8001 6 1 N S informix sblobspace
6 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
c9e2918 1 1 0 12800 312 PO- E:\\IFMXDATA\\inf_sde\\rootdbs_dat.000
cd56638 2 2 0 128000 86947 PO- E:\\IFMXDATA\\inf_sde\\inf_sde_dat.000
cd567a0 3 3 0 128000 -1 -1 POS E:\\IFMXDATA\\inf_sde\\sbspace_dat.000
cd56908 4 4 250 5000 4947 PO- e:\\IFMXDATA\\sdedbs_dat.000
cd56a70 5 5 250 50000 4 PO- e:\\IFMXDATA\\sde1_dat.000
cd56bd8 6 6 250 5000 -1 -1 POS e:\\ifmxdata\\SBLOBspace_dat.000
cd56d40 7 5 500 50000 3 PO- E:\\IFMXDATA\\sdeadddbs_dat.000
cd56ea8 8 5 500 500000 33 PO- E:\\IFMXDATA\\sdeadd2dbs_dat.000
8 active, 2047 maximum
d:\\PROGRA~1\\Informix\\bin\\onstat -l:
Informix Dynamic Server Version 9.30.TC1 -- Fast Recovery -- Up 00:00:11 -- 25472 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 7 8 0 0 0.00
phybegin physize phypos phyused %used
100107 500 450 15 3.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 2 8 0 0 0 0.0 0.0
Subsystem numrecs Log Space used
address number flags uniqid begin size used %used
ca376a8 1 U-B---- 22218 1002fb 500 500 100.00
ca376e0 16 U-B---- 22219 102548 500 500 100.00
ca37718 17 U-B---- 22220 10273c 500 500 100.00
ca37750 18 U-B---- 22221 102930 500 500 100.00
ca37788 19 U-B---- 22222 102b24 500 500 100.00
ca377c0 2 U-B---- 22223 1004ef 500 500 100.00
ca377f8 20 U-B---- 22224 102d18 500 500 100.00
ca37830 21 U-B---- 22225 102f0c 500 500 100.00
ca37868 22 U-B---- 22226 200035 500 500 100.00
ca378a0 23 U-B---- 22227 200229 500 500 100.00
ca378d8 24 U-B---- 22228 20041d 500 500 100.00
ca37910 27 U-B---- 22229 2009f9 500 500 100.00
ca37948 28 U-B---- 22230 200bed 500 500 100.00
ca37980 29 U-B---- 22231 200de1 500 500 100.00
ca379b8 42 U-B---- 22232 202745 500 500 100.00
ca379f0 30 U-B---- 22233 200fd5 500 500 100.00
ca37a28 31 U-B---- 22234 2011c9 500 500 100.00
ca37a60 32 U-B---- 22235 2013bd 500 500 100.00
ca37a98 33 U-B---- 22236 2015b1 500 500 100.00
ca37ad0 36 U-B---- 22237 201b8d 500 500 100.00
ca37b08 37 U-B---- 22238 201d81 500 500 100.00
ca37b40 38 U-B---- 22239 201f75 500 500 100.00
ca37b78 39 U-B---- 22240 202169 500 500 100.00
ca37bb0 40 U-B---- 22241 20235d 500 500 100.00
ca37be8 41 U-B---- 22242 202551 500 500 100.00
ca37c20 34 U-B---- 22243 2017a5 500 500 100.00
ca37c58 35 U-B---- 22244 201999 500 500 100.00
ca37c90 25 U-B---- 22245 200611 500 500 100.00
ca37cc8 26 U-B---- 22246 200805 500 500 100.00
ca37d00 3 U-B---- 22247 1006e3 500 500 100.00
ca37d38 4 U-B---- 22248 1008d7 500 500 100.00
ca37d70 9 U-B---- 22249 10179c 500 500 100.00
ca37da8 10 U-B---- 22250 101990 500 500 100.00
ca37de0 11 U-B---- 22251 101b84 500 500 100.00
ca37e18 12 U-B---- 22252 101d78 500 500 100.00
ca37e50 13 U-B---- 22253 101f6c 500 500 100.00
ca37e88 43 U-B---- 22254 202939 500 500 100.00
ca37ec0 44 U-B---- 22255 202b2d 500 500 100.00
ca37ef8 45 U-B---- 22256 202d21 500 500 100.00
ca37f30 46 U-B---- 22257 202f15 500 500 100.00
ca37f68 47 U-B---- 22258 203109 500 500 100.00
ca37fa0 48 U-B---- 22259 2032fd 500 500 100.00
ca37fd8 49 U-B---- 22260 2034f1 500 500 100.00
ca28e30 50 U-B---- 22261 2036e5 500 500 100.00
ca28e68 51 U-B---- 22262 2038d9 500 500 100.00
ca28ea0 52 U-B---- 22263 203acd 500 500 100.00
ca28ed8 53 U-B---- 22264 203cc1 500 500 100.00
ca28f10 54 U-B---- 22265 203eb5 500 500 100.00
ca28f48 55 U-B---- 22266 2040a9 500 500 100.00
ca28f80 56 U-B---- 22267 20429d 500 500 100.00
ca28fb8 57 U-B---- 22268 204491 500 500 100.00
c9e2ab8 58 U-B---- 22269 204685 500 500 100.00
c9e2af0 59 U-B---- 22270 204879 500 500 100.00
c9e2b28 60 U-B---- 22271 204a6d 500 500 100.00
c9e2b60 61 U-B---- 22272 204c61 500 500 100.00
c9e2b98 62 U-B---- 22273 204e55 500 500 100.00
c9e2bd0 63 U-B---- 22274 205049 500 500 100.00
c9e2c08 64 U-B---- 22275 20523d 500 500 100.00
c9e2c40 65 U-B---- 22276 205431 500 500 100.00
c9e2c78 66 U-B---- 22277 205625 500 500 100.00
c9e2cb0 67 U-B---- 22278 205819 500 500 100.00
c9e2ce8 68 U-B---- 22279 205a0d 500 500 100.00
c9e2d20 69 U-B---- 22280 205c01 500 500 100.00
c9e2d58 70 U-B---- 22281 205df5 500 500 100.00
c9e2d90 71 U-B---- 22282 205fe9 500 500 100.00
c9e2dc8 72 U-B---- 22283 2061dd 500 500 100.00
c9e2e00 73 U-B---- 22284 2063d1 500 500 100.00
c9e2e38 74 U-B---- 22285 2065c5 500 500 100.00
c9e2e70 75 U-B---- 22286 2067b9 500 500 100.0