AS400 Isolation Level - How to deal with ...

ccornagg

Well Known Member
Dear JDEList,

OW framework is Xe-SP23-AS400 (DB and UBE server).

I have the feeling OneWorld is not locking records: I'm talking about standard APIs (see SELECT for UPDATE SQL statements) allowing BF to reserve a record between select an update.

I can see COMMIT(*NONE) in the log-file and for my knowledge this should mean no locking is taking place, unfortunately I don't have CNC experience to answer following questions:

1. where AS400 Isolation Level should be setup in OneWorld environment ?

2. which is JDE recommended setup ?

Any help will be much appreciated.

Thanks, ciao.

Carlo
 
Back
Top