×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I'm on the latest version of ACS (1.1.7.2) and v7r1. I created the JDBC
connection to the i in the ACS Run SQL Scripts (RSS) with all the default
options except for the "default sql schema" (list of relevant libraries).
Journalling is switched on for all data files, but the "isolation level" in
the JDBC properties is set to "no commit" (the default).
I've noticed that "sometimes" when I do an update to a file using the RSS
screen a SHRRD member lock is HELD after the update has finished and never
goes away unless the RSS JDBC session is ended. This doesn't happen every
time, but regularly enough that a handful of updates will end up keeping
locks on some/all members updated. (The job with the member locks is
specified in the RSS plugin's status bar.)
Has anyone else noticed this? You just need to run the same update a small
handful of times before the lock is then HELD.
It isn't a huge problem, but obviously things like CLRPFM on workfiles
won't work if someone has a lock. Getting rid of the lock requires finding
out whose RSS session is locking it and getting them to
disconnect/reconnect... but it is still slightly inconvenient!
-Paul.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
