RE: Informix database creation

RE: Informix database creation

This is a discussion on RE: Informix database creation within the Informix forums, part of the Database Server Software category; --> The Raw device of 17Gb will not be useful to you on 7.31.FD6. You need to create then at ...

		Unix Technical Forum > Database Server Software > Informix
RE: Informix database creation

#1 (permalink)

04-19-2008, 06:21 PM

Murray Wood $IList$

Posts: n/a

RE: Informix database creation

The Raw device of 17Gb will not be useful to you on 7.31.FD6. You need to
create then at 2Gb (maximum sizes are listed in your release notes), or
upgrade to 9.40.

Check onstat -d again...it suggests you have successfully created that
dbspace and are trying to create it again.

MW

> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto

wner-informix-list@iiug.org]On Behalf Of Seweryn
> Sent: Thursday, 7 August 2003 7:57 a.m.
> To: informix-list@iiug.org
> Subject: Informix database creation
>
>
> 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 Kbytes
> Dbspaces
> 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 2000000
> Chunk 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 1400000
> The 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

« Replication traffic on the network has spiked up !!! | Re: onbar hangs »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 11:24 PM.