Saturday, November 15, 2008

Resource Limit Specification Table DSNRLST01

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: