There might be some userid/Plan which used to submit the very high cost sqls those used to take many hours CPU time.
To restrict these for running indefinite time, mainframe is having governor kind of stuff called resource limit specification table DSNRLST01. you need add record for culprit userid/plan to avoid this kind of scenario.
Cheers..
Prakash
IBM Certified DB2 DBA
No comments:
Post a Comment