- PM62476 – QRep APAR for many issues including long running readers
There are several different issues addressed by this APAR. The one I wanted to point out deals with DB2 and long running readers.
In the Zparm values for DB2 10 LRDRTHLD is set to 10 minutes by default. So we will issue a message to the log, DSNB260I, to identifying the offending reader.
I have seen messages in customer joblogs indicating there was a long running reader that had been running for over 3 weeks, without a commit.
This APAR helps address this issue if it reports on a Q Apply agent....
"Q Apply Admin thread will commit appropriately avoiding long running reader warnings."