View Full Version: Partial Data Updates?

LawsonTalk > System Admin > Partial Data Updates?



Title: Partial Data Updates?


lawson_guy - March 15, 2006 05:22 PM (GMT)
We know that this is a very small probability, but were wondering what would happen if the server died in the middle of doing an update from an add or update from an entry form? Is it feasible that a partial update would happen? Does Lawson do any kind of transaction submit where it is an all or nothing? Would the logs catch this kind of error?

We don't have any COBOL people so we can't read the code and figure out how the updates occur. Thanks for any help on this.

trezaei - March 15, 2006 08:36 PM (GMT)
I'd like to hear what other have to say about this as well. But from what I know:

To actually do a change in Lawson you need to do a 910-Audit-Begin. And to end this, meaning to actually commit your changes you have to do a 920-Audit-End.

If your process breaks before the Audit-End I believe there are no changes that you have to worry about

If it breaks after the audit end then you probably don't care anyway.

If it breaks during the Audit end, :bonk: Now this is a very slight possibility but I am guessing you might have issues but we're talking about a very unlikely event

Now, with that said, there are transactions that require many different steps. For example, a certain kind of transaction might create a record in one table and then turn around and create a whole different record in another table. And those records could be related. Now you're at the mercy of the programmer and whether he had a group audit on his transactions.

So it really depends on the individual program. There has never really been a good standard for this sort of thing. Especially since this code has been written over twenty something years.

Hope that answers your question.

schroncd - March 16, 2006 02:29 PM (GMT)
In the old system under ladb ( also called lafile) it was possible to end up with a partial updte, as that DB was not transactional or relational - just fast.

Under the currently supports RDBMSs you can make all the changes you want, but none are actually saved until they are COMMITted, which happens after every audit point. So you are safe if you yank the plug outta the UPS - eunless you ar on 8.0.3 env or lower and GEN happens to be updating at that point. :bonk:

Milo - March 17, 2006 05:55 PM (GMT)
lawson_guy:

What DB are you running?




Hosted for free by InvisionFree