Tags: appreciate, database, dimension, environment, informix, mysql, oracle, pretty, space, sql
space on informix database
9,500 words with 8 Comments; publish: Tue, 20 May 2008 00:42:00 GMT; (250108.89, « »)
I am having some problems with the dimension of an Informix database and,
as Im 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
http://informix.itags.org/q_informix_64494.html
All Comments
Leave a comment...
- 8 Comments
- > 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.
#1; Tue, 20 May 2008 00:43:00 GMT
- 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
#2; Tue, 20 May 2008 00:44:00 GMT
- 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/ht...divvy.ADM.html, divvy man
page, for details.
The results of ls -l /dev will be useful too.
Best regards,
Valeriy.
#3; Tue, 20 May 2008 00:45:00 GMT
- MACHINE SPECIFIC NOTES FOR INFORMIX-OnLine 7.12.UC1 PRODUCT RELEASE
*DATE: 27 Dec 1995*
#4; Tue, 20 May 2008 00:46:00 GMT
- Hello Valeriy
here there is what you have asked me:
fdisk -p
1 140760 569159 428400 UNIX Inactive /dev/rhd01
3 9945 140759 130815 UNIX Active /dev/rhd00
4 1 9944 9944 DOS (32) Inactive
divvy -N -P /dev/rhd00
0 0 19999 boot EAFS
1 20000 269999 swap NON FS
2 270000 869999 root HTFS
3 870000 1519999 alexold HTFS
4 1520000 1869999 rootdbs NON FS
5 1870000 4112629 dbditte HTFS
6 4112630 4112639 recover NON FS
7 0 4120671 d1057all WHOLE DISK
divvy -N -P /dev/rhd01
0 0 2000000 alex HTFS
7 0 13494599 hd01 WHOLE DISK
> 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.
I know it, bat I need some more space. 10 gb on the partition /dev/rhd01
will be OK.
if you need some more information about my system, please tell me.
Many, many, many thanks
Best regards
Marco Dell'Oca
#5; Tue, 20 May 2008 00:47:00 GMT
- Hi!
> divvy -N -P /dev/rhd01
> 0 0 2000000 alex HTFS
> 7 0 13494599 hd01 WHOLE DISK
> I know it, bat I need some more space. 10 gb on the partition /dev/rhd01
> will be OK.
So, you have a HTFS filesystem mounted on /alex, this physically located on
/dev/rhd01, right? You would like to add 10Gb more to the dbditte dbspace.
You have to add 5 chunks, 2 Gb each (it's Informix size limitation, at
least, in your version).
Let's extend my previous post to add 5 chunks:
As root:
dd if=/dev/zero of=/alex/dbditte2.dat bs=1024 count=2000000
dd if=/dev/zero of=/alex/dbditte3.dat bs=1024 count=2000000
dd if=/dev/zero of=/alex/dbditte4.dat bs=1024 count=2000000
dd if=/dev/zero of=/alex/dbditte5.dat bs=1024 count=2000000
dd if=/dev/zero of=/alex/dbditte6.dat bs=1024 count=2000000
chown informix /alex/dbditte*.dat
chgrp informix /alex/dbditte*.dat
chmod 660 /alex/dbditte*.dat
su - informix
onspaces -a -d dbditte -p /alex/dbditte2.dat -o 0 -s 2000000
onspaces -a -d dbditte -p /alex/dbditte3.dat -o 0 -s 2000000
onspaces -a -d dbditte -p /alex/dbditte4.dat -o 0 -s 2000000
onspaces -a -d dbditte -p /alex/dbditte5.dat -o 0 -s 2000000
onspaces -a -d dbditte -p /alex/dbditte6.dat -o 0 -s 2000000
onstat -d
Looks like that's all you need and can do, because your /alex filesystem is
not empty. There is something useful on it, isn't it?
Best regards,
V.K.
#6; Tue, 20 May 2008 00:48:00 GMT
- Hi Valeriy
I have appreciate your helps
Best Regards,
Marco Dell'Oca
"Valeriy Kravchuk" <openxs.informix.itags.org.ipnet.kiev.ua> ha scritto nel messaggio
news:csrc07$15pf$1.informix.itags.org.news.dg.net.ua...
> Hi!
>
>
/dev/rhd01[vbcol=seagreen]
> So, you have a HTFS filesystem mounted on /alex, this physically located
on
> /dev/rhd01, right? You would like to add 10Gb more to the dbditte dbspace.
> You have to add 5 chunks, 2 Gb each (it's Informix size limitation, at
> least, in your version).
> Let's extend my previous post to add 5 chunks:
> As root:
> dd if=/dev/zero of=/alex/dbditte2.dat bs=1024 count=2000000
> dd if=/dev/zero of=/alex/dbditte3.dat bs=1024 count=2000000
> dd if=/dev/zero of=/alex/dbditte4.dat bs=1024 count=2000000
> dd if=/dev/zero of=/alex/dbditte5.dat bs=1024 count=2000000
> dd if=/dev/zero of=/alex/dbditte6.dat bs=1024 count=2000000
> chown informix /alex/dbditte*.dat
> chgrp informix /alex/dbditte*.dat
> chmod 660 /alex/dbditte*.dat
> su - informix
> onspaces -a -d dbditte -p /alex/dbditte2.dat -o 0 -s 2000000
> onspaces -a -d dbditte -p /alex/dbditte3.dat -o 0 -s 2000000
> onspaces -a -d dbditte -p /alex/dbditte4.dat -o 0 -s 2000000
> onspaces -a -d dbditte -p /alex/dbditte5.dat -o 0 -s 2000000
> onspaces -a -d dbditte -p /alex/dbditte6.dat -o 0 -s 2000000
> onstat -d
> Looks like that's all you need and can do, because your /alex filesystem
is
> not empty. There is something useful on it, isn't it?
> Best regards,
> V.K.
>
>
#7; Tue, 20 May 2008 00:49:00 GMT
- > I have appreciate your helps
I just like Informix, and "good old" Unicies.
V.K.
#8; Tue, 20 May 2008 00:50:00 GMT