HELP Upgrade from 5 to 7
Posted in 1996
HELP, 02-Apr-1996
I am trying to upgrade from 5.06.uc2 OnLine to version 7.11.uc1 on
a Sun running Solaris 2.4.
Informix delivered the "INFORMIX-OnLine Dynamic Server Migration Guide
Version 7.1" and I tryed to do the upgrade as described in this manual.
One of the steps is to upgrade the indexes in the existing version 5 database
after the installation of version 7 software. This upgrade of indexes can
be done using the oncheck -cI.
As you can see, it does not work. The other way with update statistics is also
filled with bugs.
(I have tryed many different tables.)
Must I unload/load on ascii format ?
Is this just the beginning of a time with more and worse bugs than in version
5 of OnLine ?
------------------------------------
Some of the output from oncheck -cI:
------------------------------------
Validating indexes for kundedb:ale.ks_htnadr...
Index temp_1
ERROR: Bad key information in TBLspace description.
Not owner
Not owner
Validating indexes for kundedb:ale.ks_ukonto...
Error reading from network
Abnormal end !!!
---------------------------------------
And the lines from the OnLine log file:
---------------------------------------
15:46:20 Dataskip is now OFF for all dbspaces
15:46:20 On-Line Mode
15:46:20 Checkpoint Completed: duration was 0 seconds.
15:57:17 Assert Failed: Internal Error - Segmentation Violation
15:57:17 Who: Session(3, informix@ra, 23013, 7)
Thread(144, oncheckm, ac86690, 1)
15:57:17 Results: OnLine must abort
15:57:17 Action: Reinitialize shared memory
15:57:17 See Also: /tmp/af.3f95f50
15:57:17 rsdebug.c, line 3650, thread 144, proc id 23004, Segmentation Violation.
15:57:17 PANIC: Attempting to bring system down
Regards from
-----------------------------------------------------------------
Databaseadministrator Poul Pedersen
Kuwait Petroleum (Danmark) A/S
Hummeltoftevej 49 Mail: pp@q8.dk
2830 Virum Voice: +45 45 98 45 94
Denmark Fax: +45 45 83 16 95
-----------------------------------------------------------------