Button Program locking the File

[atulmengane]

Button Programs having Insert/Update/Delete Queries are locking the entire files even after the process is completed with commit or rollback. This has been happening after July Upgrade.

[robert.swanson]

Isn't that just an open data path? Valence has no control over those... It's the SQL engine doing that for improved efficiency when a file is hit multiple times. So totally normal. And certainly nothing to do with any changes introduced in the July build.

If those open data paths are somehow causing a problem, you can adjust the activation group reclaim in Portal Admin > Settings. But that really shouldn't be necessary. And IBM does not recommend reclaiming activation groups frequently, as it can negatively impact SQL performance.

[richard.milone]

https://www.ibm.com/support/pages/pseudo-closed-cursor-faq

[atulmengane]

But our AS400 schedule job which uses this file in exclusive mode has been failing for the last few days. it was not happening earlier. Our job uses ALCOBJ command with lock state *EXCL

[robert.swanson]

Try adding CONFLICT(*RQSRLS) to your job's ALCOBJ command.