We are currently running IDS 9.4 FC6 on AIX 5.3 and we plan to move to
11.5 soon. We will need to do onchecks (during downtime) of all of
our tables before and after the upgrade, according to our software
vendor, who has the Informix support contract with IBM.

They also want to do the onchecks via a single-threaded script, which
is fine, except that we have around 100G of data and one cycle of
onchecks takes around 5-6 hours.

We would like to reduce the downtime if possible, by running 3 oncheck
scripts at the same time. We were thinking of 2 big transaction log
tables that no other tables are dependent upon, plus all of the other
tables. The transaction log tables have indexes that refer to keys of
other tables.

My question is: will the log tables' onchecks need to look at those
other tables and their indexes during their onchecks, or simply at
their own data and indexes? Are parallel onchecks a bad idea, or is
there a way to make them work in order to reduce downtime?

Thanks for any ideas you may have.

--pete link

It should not be a problem.

Art

On Aug 2, 2010 1:00 PM, "pete" <petelink1 (AT) yahoo (DOT) com> wrote:

We are currently running IDS 9.4 FC6 on AIX 5.3 and we plan to move to
11.5 soon. We will need to do onchecks (during downtime) of all of
our tables before and after the upgrade, according to our software
vendor, who has the Informix support contract with IBM.

They also want to do the onchecks via a single-threaded script, which
is fine, except that we have around 100G of data and one cycle of
onchecks takes around 5-6 hours.

We would like to reduce the downtime if possible, by running 3 oncheck
scripts at the same time. We were thinking of 2 big transaction log
tables that no other tables are dependent upon, plus all of the other
tables. The transaction log tables have indexes that refer to keys of
other tables.

My question is: will the log tables' onchecks need to look at those
other tables and their indexes during their onchecks, or simply at
their own data and indexes? Are parallel onchecks a bad idea, or is
there a way to make them work in order to reduce downtime?

Thanks for any ideas you may have.

--pete link





_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list