DB2 has some query options in so called QAQQINI table.
I've found out that I can make my custom QAQQINI... here is the
And I made it in my library. And made the modifications:
-1 means: A value of -1 will force SQL to not reuse ODPs (forces
full close and full open), but this must be set at the start of
the session before the first open.
QAQQINI query options are here:
So after that I modified my jdbc connection url (added qaqqinilib
AS400 JDBC url properties are here:
What was done to ensure\verify that the property was even in
effect, such that the query options library was established and the
INI options were both read & established? Note that the CHGQRYA has
restrictions; i.e. the special authority *JOBCTL is required to
effect changing the query options library, and that would be true
irrespective of interface [unless the properties interface adopts
the authority to perform the CHGQRYA; hmmm, that sure would be a
conundrum for design point].
The database monitor can confirm the job was established with
that file [see later for specific values] using QQC102:
After all that, the locks are still there after two sql queries.
So was the ALCOBJ for *EXCL with CONFLICT(*RQSRLS) requested from
some job to verify that the locks were for pseudo-closed cursors?
Other locks, not those from the ODP to implement the pseudo-closed
cursor, will *not* be affected by the INI nor the ALCOBJ
CONFLICT(*RQSRLS). At least verify that the locks are from opens,
by review of WRKJOB OPTION(*OPNF) for the job holding the locks.
I've tried changing OPEN_CURSOR_THRESHOLD to 1 and
OPEN_CURSOR_CLOSE_COUNT to 1, but the locks are always there.
I did not refresh my memory on the threshold setting, but I think
the value 1 would be questionable. I believe that value would ask
to be extremely aggressively in establishing pseudo-closed cursors,
such that for every open versus only after one additional\repeated
open of the same cursor, a pseudo-closed cursor should be effected.?
Nothing worked, am I missing something?
Was the DB monitor run to review the values associated with those
settings, QVP153 & QVP154, for either variation of the run?
Of possible additional interest are the following monitor
information for ODP & LOCK.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2022 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
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.