LawsonGuru Blog

Thought-Provoking Commentary for the Lawson Software Community

Whatever Happened to “Upgrade While Active”??

During the 7.2 -> 8.0 Applications upgrade cycle, Lawson introduced “Upgrade While Active” (at CUE 2003 I think…).  This changed the upgrade process to reduce the downtime required to move the data from between application product lines as part of the upgrade. 

The 8.0 -> 9.0 Applications were rewritten to use the Java-based sqldbcopy, and table data is copied between product lines/databases directly on the database server rather than the previously-used dump/load method.  This, of course, speeds things up dramatically. 

But still, there is significant downtime.  Not all tables are direct copies (and even in that case I’ve seen some cases where these still take 12 hours or more).  For tables which are converted rather than copied, Lawson has re-written those in Java.  However, I’ve seen larger databases requiring an upgrade process that runs for 40+ hours.  Which just begs for the “Upgrade While Active” process if you can’t afford to be down that long.

When I asked Lawson about using “Upgrade While Active” for the 9.0 Applications, their response was that, with the faster sqldbcopy and the re-writing of the upgrade programs in Java, they haven’t had a demand.  However, they do claim that it’s still an available option. 

Is anyone using it?


5 responses to “Whatever Happened to “Upgrade While Active”??

  1. The Creeper November 8, 2007 at 10:37 pm

    I remember our 8.0 upgrade, it was very smooth and quick. I can only hope this remains true for 9.0.

  2. Frito December 2, 2007 at 11:15 am

    OK John… please explain to me why “rewritten in Java” would imply any performance improvement. I mean, how would the language make any difference. I hear this kind of talk from these guys all the time and it just makes me laugh.

  3. John Henley December 2, 2007 at 3:14 pm

    Sorry, I’m just quoting Lawson, as they attributed the “faster upgrade process” as the reason for not needing Upgrade While Active.

    In my opinion, the sole performance improvement is that the copy programs now use sqldbcopy which utilizes the database to do the copying process.

    I agree with you that “rewritten in Java” alone would have zero performance impact. The Java “load” programs still have roughly the same performance as their previous COBOL counterparts.

  4. Frito December 13, 2007 at 11:26 pm

    Thank you John… I was beginning to think it was me.

  5. Rajan March 30, 2008 at 7:53 pm

    Why not? If you can use multi-threading using application program, which I dont think is possible in Cobol, it could speed up the conversion. And cobol has the issue of ‘taking-one-record-process-it-and take-next’ rather than select group of records and mass-update ’em.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: