2022 Nov 01 1:17 PM
Hello there! We are having a problem in which we have Time out dumps occurring in several jobs. The frequency in which they occur has raised a lot in the past days, any ideas of what can be happening? Any thoughts are aprreciated. Most of them are right after a Select Statement, the ones I have evaluated are not using the primary key. Any other ideas?
2022 Nov 01 1:33 PM
You stand a much better chance of getting proper help if you include at least the technical information from the dumps. Scrub it of sensitive information if you must but do include the details, otherwise people are gonna reach for the Magic 8 ball or similar tools, which are unfortunately not very precise.
2022 Nov 01 1:35 PM
TIME OUT is a very generic dump that can occur due to many reasons.
1. Is it occuring for same program or for all programs?
2. Is it happening at specific time of the day or at all times?
3. Is it running long due to CPU Time or DB Time as part of total response time. Can be checked in STAD transaction.
4. Any changes to the above programs recently ?
Please share more details.
2022 Nov 01 2:50 PM
Thanks for the help Sri Krishna.
1 - It is occuring for at least 6 different programs
2 - It is happening at specific times, when the jobs run by what I've seen
3 - I'll try to check it out
4 - No recent changes for what I've heard
2022 Nov 01 2:56 PM
2022 Nov 01 3:22 PM
If it happens to atleast 6 programs, then its a system issue either at application server level or database level.
I have few more questions, please share.
1. are those 6 programs, accessing same table ?
2. how many app servers are there for the production instance? are those 6 programs running on same app server at those times?
2022 Nov 01 8:41 PM
Some are accessing the same table, but it varies, we have dumps in different tables.
There are 4 servers in production, but I have to check if they are all running on the same server
2022 Nov 02 8:29 AM
Dear customer,
I recommend creating a customer ticket using the component which is assigned to the errours program.
Kind regards,
Wolfgang