Adding chunk (space) to same chunk name using offset
Posted in 2000
Hi, How do you add a new chunk to the same chunk name (logchunk1) & same dbspace using offset. I'm trying to increase the llogdbs. Previously someone has add (total of 3 chunk) using offset. I tried to do so with the fourth one but didn't make it. Instead, i adda new chunk name to the same dbspace. INFORMIX-OnLine Version 7.24.UC5 -- On-Line -- Up 01:35:18 -- 67608 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 400380ec 1 1 1 2 N informix rootdbs 40038c14 2 1 2 1 N informix plogdbs 40038c80 3 1 3 4 N informix llogdbs 40038cec 4 1 4 2 N informix iisdbs 40038d58 5 10 9 1 N B informix sidblob 40038dc4 6 2001 11 1 N T informix tempdbs1 6 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 40038158 1 1 0 25000 24483 PO- /dev/rootchunk1 400383cc 2 2 0 8000 7947 PO- /dev/phychunk1 400384a0 3 3 0 6250 572 PO- /dev/logchunk1 40038574 4 4 0 250000 36 PO- /dev/iischunk1 40038648 5 4 0 250000 154085 PO- /dev/iischunk2 4003871c 6 3 6250 1750 497 PO- /dev/logchunk1 400387f0 7 1 0 32000 28067 PO- /dev/rootchunk2 400388c4 8 3 8000 8000 497 PO- /dev/logchunk1 40038998 9 5 0 32768 ~76 32768 POB /dev/sidblob 40038a6c 10 3 0 16000 15997 PO- /dev/logchunk2 40038b40 11 6 0 32000 31947 PO- /dev/tempchunk1 11 active, 2047 maximum Does anyone know how to make use of offset? regards Ameerul