Re: Informix database creation
Seweryn:
When you run "onstat -d" - it gives size in terms of blocks (pagesize). It
can be 2K or 4 K depending upon OS.
You can find out the page size using "onstat -b | grep 'buffer' | awk
'{print $10}' " - this will return page size in BYTES .
When you create the dbspace using onspaces - you need to mention the size
of the dbspace interms of "KBytes"
example: In your OS, if you have Page size 2K - then you need to start the
offset from 1200000, you can go only upto
800000 KB size of dbspace due to 2GB size limitation.
try this .. let us know if you have any questions.
Have a great time working with Informix Products.
Thank You
Ramesh Vasudevan
."Never, ever, ever, ever, ever, ever, ever, give up. Never give up. Never
give up. Never give up." - Winston Churchill
Seweryn
<pietruszewski@at To: informix-list@iiug.org
t.com> cc:
Sent by: Subject: Informix database creation
owner-informix-li
st@iiug.org
08/06/03 03:56 PM
Please respond to
Seweryn
Hi all,
I'm new to Informix db (as you can probably deduct from my post).
I'm trying to add multiple dbspaces on one raw partition on Solaris 8
Here is the what I currently have:
$ onstat -d
Informix Dynamic Server Version 7.31.FD6 -- On-Line -- Up 6 days
00:23:01 -- 41984 KbytesDbspaces
address number flags fchunk nchunks flags owner name
b07a1c0 1 1 1 1 N informix
rootdbs
1 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
b07a2a8 1 1 500 600000 18903 PO-
/dev/rdsk/c0t1d0s7
1 active, 2047 maximum
Here is what I'm trying to do and its result:
When I try to create additional dbspace on that partition
(/dev/rdsk/c0t1d0s7 is a raw partition), I type:
$ onspaces -c -d mydbs -p /dev/rdsk/c0t1d0s7 -o 600500 -s 2000000Chunk size + offset (2600500k) greater than 2097151k limit.
So I lower the size of the chunk
$ onspaces -c -d mydbs -p /dev/rdsk/c0t1d0s7 -o 600500 -s 1400000The chunk specified already exists.
Is there anything else that I'm missing?
What is the command/procedure to add dbspace and/or chunk to raw partition
that has already one dbspace and one chunk defined?
FYI: /dev/rdsk/c0t1d0s7 is a 17GB raw partition.
Any suggestions greatly appreciated.
--
Regards,
Seweryn Pietruszewski
pietruszewski@att.com
sending to informix-list