Re: Ideas on how to spot problems of table conflicts -- MIDRANGE-L

Subject: Re: Ideas on how to spot problems of table conflicts
From: "D*B" <dieter.bender@xxxxxxxxxxxx>
Date: Wed, 25 Apr 2018 09:59:48 +0200
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

<Thomas>
We have a mainframe that is sending data over. We are getting some SQL
errors 911 and 913's.

Any ideas how to spot these issues on the iSeries?

Would help if we had the job names that are running on the iSeries.
</Thomas>

If you have a dedicated user for the Connections, you will find the database server jobs by WRKOBJLCK MYUSER *USRPRF.
Another way would be STRDBMON and looking for the SQLCODES and it's jobs, they are occurring.

D*B

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Ideas on how to spot problems of table conflicts , Bryan Dietz

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.