storage pool configuration.

Posted in 2013

Topics: Storage & Space Management, Server Administration, Migration, Import/Export & Data Conversion

Cesar Martins — Tue, 17 Dec 2013 12:32:14 — source: IIUG Forums & Mailing Lists

Hi, ifx 11.70 FC7 . AIX 6.1 I'm studying the best way to use the storage pool at v11.70 . Today we use v11.50 , I'm planning our migration to 11.70 and my desire is allow informix automatically admin my chunks growing and try start with "best" way already configured... I have no experience with storage pool yet... First I'm trying figure out if is possible to configure it for the way I consider more organized and flexible. which is : * all dbspaces will be created first manually with onspaces (old way), with just one chunk. * configure the storage pool pointing to directory * It should create automatically chunks for each dbspaces as need... * all chunks will start with 500 Mb of size. * all chunks will be expandable * all chunk should have a limit of 4G or 8G as max size... when reach this size, new one should be added to dbspace instead keep growing... I don't want just one chunk expandable "indefinable" because later I won't able to shrunk it... Is this possible? (using a directory) Regards Cesar --e89a8f50355cfdbb8d04edba1d25

↪ replying to Cesar Martins

Paul Watson — Tue, 17 Dec 2013 14:30:59 — source: IIUG Forums & Mailing Lists

AFAIK you can't do this automagically - you can get parts of it but the rest you will have to script Also be careful on larger chunks and a large % increase as the system will 'hang' while the chunk grows Cheers Paul > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Cesar Martins > Sent: Tuesday, December 17, 2013 6:32 AM > To: ids@iiug.org > Subject: storage pool configuration. [32144] > > Hi, > > ifx 11.70 FC7 . > AIX 6.1 > > I'm studying the best way to use the storage pool at v11.70 . > Today we use v11.50 , I'm planning our migration to 11.70 and my desire is > allow informix automatically admin my chunks growing and try start with > "best" way already configured... > I have no experience with storage pool yet... > > First I'm trying figure out if is possible to configure it for the way I > consider more organized and flexible. > which is : > * all dbspaces will be created first manually with onspaces (old way), > with just one chunk. > * configure the storage pool pointing to directory > * It should create automatically chunks for each dbspaces as need... > * all chunks will start with 500 Mb of size. > * all chunks will be expandable > * all chunk should have a limit of 4G or 8G as max size... when reach this > size, new one should be added to dbspace instead keep growing... > > I don't want just one chunk expandable "indefinable" because later I won't > able to shrunk it... > > Is this possible? > (using a directory) > > Regards > Cesar > > --e89a8f50355cfdbb8d04edba1d25 > > > ********************************************************** > ********************* > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Paul Watson

Cesar Martins — Tue, 17 Dec 2013 19:12:35 — source: IIUG Forums & Mailing Lists

Hi Paul, Thanks for the tip, I need keep this in mind since the allocation of cooked file is much slower then raw... Best Regards Cesar 2013/12/17 Paul Watson <paul@oninit.com> > AFAIK you can't do this automagically - you can get parts of it but the > rest > you will have to script > > Also be careful on larger chunks and a large % increase as the system will > 'hang' while the chunk grows > > Cheers > Paul > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > Cesar Martins > > Sent: Tuesday, December 17, 2013 6:32 AM > > To: ids@iiug.org > > Subject: storage pool configuration. [32144] > > > > Hi, > > > > ifx 11.70 FC7 . > > AIX 6.1 > > > > I'm studying the best way to use the storage pool at v11.70 . > > Today we use v11.50 , I'm planning our migration to 11.70 and my desire > is > > allow informix automatically admin my chunks growing and try start with > > "best" way already configured... > > I have no experience with storage pool yet... > > > > First I'm trying figure out if is possible to configure it for the way I > > consider more organized and flexible. > > which is : > > * all dbspaces will be created first manually with onspaces (old way), > > with just one chunk. > > * configure the storage pool pointing to directory > > * It should create automatically chunks for each dbspaces as need... > > * all chunks will start with 500 Mb of size. > > * all chunks will be expandable > > * all chunk should have a limit of 4G or 8G as max size... when reach > this > > size, new one should be added to dbspace instead keep growing... > > > > I don't want just one chunk expandable "indefinable" because later I > won't > > able to shrunk it... > > > > Is this possible? > > (using a directory) > > > > Regards > > Cesar > > > > --e89a8f50355cfdbb8d04edba1d25 > > > > > > ********************************************************** > > ********************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c28aca55eae704edbfb53b

storage pool configuration.

Glossary

Your privacy choices