space on informix database

I am having some problems with the dimension of an Informix database and, as I'm pretty new to this environment, I would appreciate any help. some information: informix online 7.1 on Unix 5.0.4 Sco Open Server Informix database on /dev/dbditte htfs filesystem Now, the space on dbditte filesystem is becoming low and I need to increment the space. How can I do? have I to create a new partition and after copy the complete database into the new partition? how? or have I to increment the space of the old file? Thanks in advance. Marco Dell'Oca

> informix online 7.1 > on Unix 5.0.4 Sco Open Server > Informix database on /dev/dbditte htfs filesystem Please, send some more information. At least, the results of onstat -d and df -k for your OpenServer etc. You may have to add new chunk to some dbspace(s), it is easy if you have root permissions, but we here can not guess anything for sure without the information. Best regards, V.K.

Thanks Valeriy > Please, send some more information. > > At least, the results of onstat -d and df -k for your OpenServer etc. > df -v Mount Dir Filesystem blocks used free %used / /dev/root 1200000 868506 331494 73% /stand /dev/boot 40000 18918 21082 48% /alex /dev/alex 4000002 2019426 1980576 51% onstat -d INFORMIX-OnLine Version 7.12.UC2 -- On-Line -- Up 10:49:40 -- 27936 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 80c320d4 1 1 1 1 N informix rootdbs 80c322e0 2 1 2 1 N informix dbditte 2 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 80c32138 1 1 0 171500 73025 PO- /dev/rrootdbs 80c3220c 2 2 0 1048575 406136 PO- /dev/rdbditte 2 active, 2047 maximum > You may have to add new chunk to some dbspace(s), it is easy if you have > root permissions, Yes, I have root permission and I will made all the modifications on a clone disk (same dimensions) still made with g4u utility http://www.feyrer.de/g4u/ Best regards, Marco Dell'Oca

Hello, Marco! > df -v > Mount Dir Filesystem blocks used free %used > / /dev/root 1200000 868506 331494 73% > /stand /dev/boot 40000 18918 21082 48% > /alex /dev/alex 4000002 2019426 1980576 51% > > onstat -d> > INFORMIX-OnLine Version 7.12.UC2 -- On-Line -- Up 10:49:40 -- 27936 Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > 80c320d4 1 1 1 1 N informix rootdbs > 80c322e0 2 1 2 1 N informix dbditte > 2 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > 80c32138 1 1 0 171500 73025 PO- /dev/rrootdbs > 80c3220c 2 2 0 1048575 406136 PO- /dev/rdbditte > 2 active, 2047 maximum So, why do you think that your dbditte Informix DBspace "is becoming low"? I see that there are 406136 free pages (slightly less than a half), that is, given the 2K page size, you have more that 800 MB of free space in it. In any case, if you would like to add chunks, you may use the onspaces command with the -a option. onspaces -- will give you all the rest details, but first of all, you have to deside, where the chunk will be located, and create the appropriate file or device node. The decision is up to you. If you would like to add chunk in the UNIX filesystem (with some performance penalty), you can do something like the following (adds 500MB chunk in the /alex directory, for example) as root: dd if=/dev/zero of=/alex/dbditte2.dat bs=1024 count=500000 chown informix /alex/dbditte2.dat chgrp informix /alex/dbditte2.dat chmod 660 /alex/dbditte2.dat su - informix onspaces -a -d dbditte -p /alex/dbditte2.dat -o 0 -s 500000 onstat -d If you would like (and can) to use raw devices, I need some more info about your disks current layout, that can be provided by divvy utility (I do not remember SCO well, last time it was in 2000 or so...). Looks like you have to provide the results of divvy -N -P command, or the division table it outputs when no options are given. See http://docsrv.sco.com:507/en/man/html.ADM/divvy.ADM.html, divvy man page, for details. The results of ls -l /dev will be useful too. Best regards, Valeriy.

MACHINE SPECIFIC NOTES FOR INFORMIX-OnLine 7.12.UC1 PRODUCT RELEASE *DATE: 27 Dec 1995*