onmode -BC 1

All, I need to allocate a very large smart blobspace to a client's instance (11.50.FC8 AIX ) that has expanded chunks disabled. Since the size of this blobspace needs to be 512 gigs, I need to have expanded chunks enabled since I don't want to allocate a whole bunch of 2 gig chunks. It's been a long time since I last dealt with this type of situation which is to run onmode -BC 1 (to enable expanded chunks for newly created dbspaces only ). Is there is anything else I would need to do other than take a level 0 archive afterwards ? I probably will have to do this without shutting down the application so there will be transcation activity on the lighter side . All advice is welcomed... Thanks, Mark

Why 2 GB chnuks? Not able to have 10, 20 or 50 GB... chunks? On Fri, Nov 15, 2013 at 9:53 AM, MARK JALKIEWICZ < mark.jalkiewicz@verizon.net> wrote: > All, > > I need to allocate a very large smart blobspace to a client's instance > (11.50.FC8 AIX ) that has expanded chunks disabled. Since the size of this > blobspace needs to be 512 gigs, I need to have expanded chunks enabled > since I > don't want to allocate a whole bunch of 2 gig chunks. It's been a long time > since I last dealt with this type of situation which is to run onmode -BC 1 > (to enable expanded chunks for newly created dbspaces only ). > > Is there is anything else I would need to do other than take a level 0 > archive > afterwards ? I probably will have to do this without shutting down the > application so there will be transcation activity on the lighter side . > > All advice is welcomed... > > Thanks, > > Mark > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c25ee62906d004eb3dda3e

Remember that while have onmode -BC 1 that each I/O operation is doing extra work to maintain backward compatibility. You really want to run onmode -BC 2 as soon as possible. To verify this has been done look at the bottom of the onstat -d command and you should see a line with the expand chunk mode set to "always". "Expanded chunk capacity mode: always" John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 11/15/2013 01:26:37 PM: > From: "FRANK" <yunyaoqu@gmail.com> > To: ids@iiug.org, > Date: 11/15/2013 01:27 PM > Subject: Re: onmode -BC 1 [31957] > Sent by: ids-bounces@iiug.org > > Why 2 GB chnuks? Not able to have 10, 20 or 50 GB... chunks? > > On Fri, Nov 15, 2013 at 9:53 AM, MARK JALKIEWICZ < > mark.jalkiewicz@verizon.net> wrote: > > > All, > > > > I need to allocate a very large smart blobspace to a client's instance > > (11.50.FC8 AIX ) that has expanded chunks disabled. Since the size of this > > blobspace needs to be 512 gigs, I need to have expanded chunks enabled > > since I > > don't want to allocate a whole bunch of 2 gig chunks. It's been a long time > > since I last dealt with this type of situation which is to run onmode -BC 1 > > (to enable expanded chunks for newly created dbspaces only ). > > > > Is there is anything else I would need to do other than take a level 0 > > archive > > afterwards ? I probably will have to do this without shutting down the > > application so there will be transcation activity on the lighter side . > > > > All advice is welcomed... > > > > Thanks, > > > > Mark > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11c25ee62906d004eb3dda3e > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Yeah... the missing piece. Thanks John ! Mark