Informix 9.40 ... how to enable the expanded chunk facility
Rulesh Felix Rebello installed Informix 9.40 on AIX 5.1 and found the expanded (big) chunk option disabled in onstat -d. Christine Normile and Dattatreya Govindappanavar explained onmode -BC 1 enables big chunks for newly created ones, and onmode -BC 2 fully commits, after which reversion is no longer possible. Murray Wood and Madison Pruet pointed to the manuals. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape