Thursday, December 21, 2017

If User Complain For Long Running Request's, Do The Following.

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