HolderAndrew
Well Known Member
Hello all,
I have also posted on iseries forum but will repeat here - I hope somebody can help! We are on E1 9.1 TR 9.1.5.5 using iseries V7R2 with latest PTFs
If in 5250 sql session we use commitment control (any of *UR, *RR, *CS, *RS) and do an update, for example "update testdta/f03012 set aitxa1 = '205' where aian8 = 12345" then this updated value can be seen immediately within E1 web session (in our JDV910 environment) within P03013 AR master inquiry. If we perform ROLLBACK back in sql session then the E1 P03013 session will see then see the original value when we refresh the inquiry.
Does anybody know how we can prevent the E1 session from seeing uncommitted data - ie. dirty reads?
The f03012 is being journalled with *BOTH images and I have also tried with journaling on the F03012 access paths (F03012_1 etc)
I have looked at JDE.INI, JAS,INI settings and googled around - but haven't been able to understand how to control this.
It seems that despite commitment control being active, and not yet committed, the updates are always immediately visible inside E1.
Our actual production problem is based on this question. We have BSSV running with manual commitment active within order creation MBF - the End Doc is therefore called but the COMMIT is not yet performed. But we see other E1 processes running and selecting the F4211 data based on the uncommitted values which is causing a lot of problems.
Any help would be greatly appreciated.
Best regards
Andrew
I have also posted on iseries forum but will repeat here - I hope somebody can help! We are on E1 9.1 TR 9.1.5.5 using iseries V7R2 with latest PTFs
If in 5250 sql session we use commitment control (any of *UR, *RR, *CS, *RS) and do an update, for example "update testdta/f03012 set aitxa1 = '205' where aian8 = 12345" then this updated value can be seen immediately within E1 web session (in our JDV910 environment) within P03013 AR master inquiry. If we perform ROLLBACK back in sql session then the E1 P03013 session will see then see the original value when we refresh the inquiry.
Does anybody know how we can prevent the E1 session from seeing uncommitted data - ie. dirty reads?
The f03012 is being journalled with *BOTH images and I have also tried with journaling on the F03012 access paths (F03012_1 etc)
I have looked at JDE.INI, JAS,INI settings and googled around - but haven't been able to understand how to control this.
It seems that despite commitment control being active, and not yet committed, the updates are always immediately visible inside E1.
Our actual production problem is based on this question. We have BSSV running with manual commitment active within order creation MBF - the End Doc is therefore called but the COMMIT is not yet performed. But we see other E1 processes running and selecting the F4211 data based on the uncommitted values which is causing a lot of problems.
Any help would be greatly appreciated.
Best regards
Andrew