A major database and application migration effort at Livestock Improvement in Hamilton over Easter has been successful.
The company was moving 130GB of dairy herd records in a DB2 database on IBM’s OS/390 to DB2 on Solaris, Sun’s version of Unix. Hundreds of applications also made the move.
Project manager Neil Gladden says there was a period of an hour-and-a-half or so early in the weekend when he was contemplating having to roll back from the Solaris system to the mainframe because the newly migrated database refused to boot up.
“It caused a few grey hairs. The biggest hassle with these things is trying to identify the problem.”
The bug was found to be a missing file which, once located and copied over, enabled the database to run.
Gladden says a bonus of the migration project is slightly faster performance; the main goal of the exercise is a saving of $1 million on OS/390 licence fees.