We have identified a long running job - around 10 hrs of elapsed time with 1.5 hrs CPU.
Running strobe showed that the maximum wait time is in
DSNECP00 DSN START-UP CSECT - 98%.
I found some strange messages in the Jes
"<pgmname> <step name> WAIT TIME EXPIRED-REPLY CANCEL OR WAIT"
I tried to run EXPLAIN on the SQL Statement, it showed error message
"DBG55160W SQL wait time limit exceeded.You can either increase
the SQL-WAIT-INTERVAL in SYSPARMS, or create shadow tables and/or
catalog indexes (DB2 V4 or higher) in order to make the query run
Is it refering to SYSIBM.SYSPARMS table? If yes, which column I need to set to increase the wait interval.
I need to run this query before tuning it. ( Am sure the SQL is inefficient)