Informix 9.40 ... how to enable the expanded chunk facility

Group: I have just installed Informix 9.40 on AIX 5.1 The onstat -d output says expanded chunk option is disabled. Please let me know how we can enable this facility so that I can add achunk of size more than 2 GB.. thanking you regards... __________________________________________________ Rulesh Felix Rebello Informix DBA Off # 1-(876)-927-1125 X 3831 Cell # 1-(876)-853-5702

Hi Rulesh - Big chunks is disabled after install to allow you to test other IDS 9.4 features prior to committing to the upgrade. This is because, once fully enabled, the only to revert is with a level 0 restore of your backup prior to install. To enable big chunks, issue onmode -BC 1 This will allow you to create a new big chunk and all pages written to this chunk will be in the new page format. If you desire, you can still revert at this point by dropping the objects in the big chunk and then the big chunk itself. If you wish to fully commit to big chunks, issue onmode -BC 2 (-BC 1 must have already been done). This will cause all pages written to the database from that point forward to be written in the new format. Onmode -BC 2 does not rewrite any data, it just sets a switch that tells the database to start writing pages in the new format. More information on onmode -bc can be found in our fine Administrator's Reference for 9.4 and Administrator's Guide for 9.4. Christine Normile I/T Specialist, Informix Solutions Data Management Worldwide Sales Support Telephone: 877-252-5399 T/L 273-0981 "Rulesh Feli...." <rrebello@fsl.org.jm> Sent by: forum.subscriber@iiug.org 08/14/2003 12:57 PM To: ids@iiug.org cc: Subject: Informix 9.40 ... how to enable the expanded chunk facility [1701] Group: I have just installed Informix 9.40 on AIX 5.1 The onstat -d output says expanded chunk option is disabled. Please let me know how we can enable this facility so that I can add achunk of size more than 2 GB.. thanking you regards... __________________________________________________ Rulesh Felix Rebello Informix DBA Off # 1-(876)-927-1125 X 3831 Cell # 1-(876)-853-5702

After executing "onmode -BC 1", all subsequent dbspaces created will have large chunk capacity. To put the server completely in large-chunk-only mode, run "onmode -BC 2", remember you will not be able to revert to previous version of server from this point onwards. Thanks, Dattatreya |---------+----------------------------> | | "Rulesh Feli...."| | | <rrebello@fsl.org| | | .jm> | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 08/14/2003 12:57 | | | PM | |---------+----------------------------> >------------------------------------------------------------------------------- ----------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: Informix 9.40 ... how to enable the expanded chunk facility [1701] | >------------------------------------------------------------------------------- ----------------------------------------------------------------| Group: I have just installed Informix 9.40 on AIX 5.1 The onstat -d output says expanded chunk option is disabled. Please let me know how we can enable this facility so that I can add achunk of size more than 2 GB.. thanking you regards... __________________________________________________ Rulesh Felix Rebello Informix DBA Off # 1-(876)-927-1125 X 3831 Cell # 1-(876)-853-5702

Check out the Admin Reference Manual 9.40 onmode -BC {something} depending upon which option you want - the instanceor dbspace. MW > -----Original Message----- > From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On > Behalf Of Rulesh Feli.... > Sent: Friday, 15 August 2003 5:58 a.m. > To: ids@iiug.org > Subject: Informix 9.40 ... how to enable the expanded chunk facility > [1701] > > > > Group: > I have just installed Informix 9.40 on AIX 5.1 > The onstat -d output says expanded chunk option is disabled. > Please let me know how we can enable this facility so that I > can add achunk > of size more than 2 GB.. > > thanking you > regards... > __________________________________________________ > Rulesh Felix Rebello > Informix DBA > Off # 1-(876)-927-1125 X 3831 > Cell # 1-(876)-853-5702 > > > > > >

read about "onmode -BC" Also read the release notes about how reversion to prior versions have to be done. M.P. "Rulesh Feli...." <rrebello@fsl.org To: ids@iiug.org .jm> cc: Sent by: Subject: Informix 9.40 ... how to enable the expanded chunk facility [1701] forum.subscriber@ iiug.org 08/14/2003 12:57 PM Group: I have just installed Informix 9.40 on AIX 5.1 The onstat -d output says expanded chunk option is disabled. Please let me know how we can enable this facility so that I can add achunk of size more than 2 GB.. thanking you regards... __________________________________________________ Rulesh Felix Rebello Informix DBA Off # 1-(876)-927-1125 X 3831 Cell # 1-(876)-853-5702