Informix upgrade advice
Someone asked for pitfalls when migrating a customer from IDS 9.20 on Solaris 2.6 to IDS 10.0 (with HDR, plus newer 4GL/ISQL) on Solaris 2.9. No single fix was needed; respondents offered advice: tune the B-tree scanner/cleaner, which changed behaviour after 9.30.UC5 and can hurt performance on heavy deletes against large tables; thoroughly test HDR initialisation, the backup method used to build the secondary, and primary/secondary switchover on a small database; plan the data move (unload/load or insert-select) and test it; and retest the 4GL application for behaviour changes. No definitive outcome is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We're planning to migrate a customer's system from IDS 9.20 on Solaris 2.6 to IDS 10.0 FC3 (latest 4FL and ISQL FCx also) on Solaris 2.9 (and using HDR). Anything I should be wary of ...? thanks -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com
if io load is an issue: btree cleaner tuning Neil Truby wrote: > We're planning to migrate a customer's system from IDS 9.20 on Solaris 2.6 > to IDS 10.0 FC3 (latest 4FL and ISQL FCx also) on Solaris 2.9 (and using > HDR). Anything I should be wary of ...? > > thanks >
Neil, I would strongly recommend you : 1- to test the initialitation process for HDR with ids 10 and solaris9 2- to test the backup method that you are going to use to re-create hdr servers. 3- to test switching server from primary to secondary with a small db. I found a bug in 9.3 one year ago just switching the servers over using a very small db. You will need to move all your data from the db with solaris 6 to the db with solaris 10 using unload, load or insert select or something like that. I would test that process as well, just in case. esteban.-
Testing, testing, testing ! As Michael Mueller wrote, check the new "feature" btree scanner. (<=9.30.UC5: btree cleaner, that means, the cleaner cleanse the pages; > 9.30.UC5: btree scanner, that means, the scanner scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans, scans <some billion lines stripped-down> and scans) But ok, this may only a bad thing for the performance, when you have massively deletes (on big tables)... Regards, try_and_err Neil Truby schrieb: > We're planning to migrate a customer's system from IDS 9.20 on Solaris 2.6 > to IDS 10.0 FC3 (latest 4FL and ISQL FCx also) on Solaris 2.9 (and using > HDR). Anything I should be wary of ...? > > thanks > > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com
I guess you are upgrading the application as well. I'd do some testing of that in case there are any changes of behaviour in the 4GL
I guess you are upgrading the application as well. I'd do some testing of that in case there are any changes of behaviour in the 4GL