<Matt>
What deadlock detection and mitigation tools do you use on IBMi DB2?
We are having a hard time narrowing in the reasons for random "Resource
error - SQLSTATE 57014, SQLCODE -1044." Messages which we have recently
found appear to be related to locking contention on DB2.
</Matt>
I'm not aware of special toolsets besides the OS support (WRKCMTDFN,
DSPRCDLCK, Joblogs, QSYSOPR messages...)
SQLSTATE 57014 is cancel request and the message should have additional
information.
SQLCODE -1044 I've never seen and I don't find it in the manuals, what are
you doing?
DB2 running on AS400 has some pitfalls and strange settings (if you are
using the defaults) in a transaction controlled environment, some more
information about your application might be helpfull to discuss your
problems and ways to solve.
D*B
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
