OK, stupid question time.... as I'm new at this and standing in for someone on vacation, I just don't want to trash the existing installation. We cannot wait for the regular guy to return and I need to add some more space to the installation.



The output of my onstat -d looks like ....

Informix Dynamic Server 2000 Version 9.21.HC3 -- On-Line -- Up 50 days 07:39:06 -- 184352 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
c9abe7e0 1 0x1 1 1 N informix rootdbs
c9aeee30 2 0x2001 2 1 N T informix temp
c9abea90 3 0x1 3 1 N informix log
c9abebd8 4 0x1 4 2 N informix ccm
c9abed20 5 0x2001 5 1 N T informix temp2
c9abee68 6 0x2001 6 1 N T informix temp4
ca2c3018 7 0x2001 7 1 N T informix temp5
7 active, 2047 maximum

Chunks
address chk/dbs offset size free bpages flags pathname
c9abe928 1 1 0 29096 23910 PO- /sde/informix_data62/ifx62_root.dbs
c9afd630 2 2 0 58192 54425 PO- /sde/informix_data62/ifx62_temp.dbs
c9afd798 3 3 0 36864 29131 PO- /sde/informix_data62/ifx62_log.dbs
c9afd900 4 4 0 512000 57 PO- /sde/informix_data62/ifx62_ccm.dbs
c9afda68 5 5 0 100000 96797 PO- /sde/informix_data62/ifx62_temp2.dbs
c9afdbd0 6 6 0 60000 57125 PO- /sde/informix_data62/ifx62_temp4.dbs
c9afdd38 7 7 0 60000 57581 PO- /sde/informix_data62/ifx62_temp5.dbs
c9afdea0 9 4 0 500000 338622 PO- /sde/informix_data62/ifx62_ccm3.dbs
8 active, 2047 maximum



I want to add another chunk to the dbspace called ccm and extend it by approx 1GB. I also want to create another temp dbspace with 40K pages (approx same size as existing temp space called temp).
All dbspaces files are cooked files.

I want to check with you guys the syntax, so that I do not blow anything. :-) Thanks.

The command for extending the ccm space (adding another chunk) would be:

onspaces -a -p /sde/informix_data62/ifx62_ccm4.dbs -o 0 -s 1000000

The command for adding another temp dbspace:

onspaces -c -d temp6 -t -p /sde/informix_data62/ifx62_temp6.dbs -o 0 -s 81920


(I know I have to edit the onconfig to add the reference for the extra temp dbspace and restart the engine after it is added).

Are those commands correct? If not, can you correct me? Do I need to 'touch' the files (/sde/informix_data62/ifx62_ccm4.dbs and /sde/informix_data62/ifx62_ccm4.dbs) , to create them with 0 size before issuing the onspaces commands?



Thanks for your help.
Adi.

Hello Adi,

Yes, the commands is correct, you remember what the chunks must exist with owner and group informix and permission 660, before the commands ejecution.
It excuses by my english, I prefer español.

Gustavo.