If User Complain For Long Running Request's, Do The Following.
- Check the Statistics,History Runs of that program & Based on this timelines we need to decide the long running Request.
- Check The load on DB node to ensure that High Resource Usage is not the Main cause.i troubleshoot
- Check DB locks in The Databse To Ensure that This Session is not blocked by any other session.
- Check the CM status and ICM status.
- Check any Locks on DB particularly related to that program.
- Check any INVALID objects related to that program.
- Check any incompatible requests/programs are running for that program.
-Login as system administrator responsibility and query the long running request /program. Navigate to concurrent program define query that long running request in the same form select incompatible requests .
-If any incompatible request is running then find the user name who is running that program inform them regarding the incompatibilities
No comments:
Post a Comment