Tuesday, 4 September 2012

Users are reporting long response time delays in transactions that previously would run with sunscald response. The system administrator knows these transactions are RPG IV-SQL based programs. Which of the following would be the first set in determining the problems.

A. Use Management Central to start a job monitor for system and select the SQL submonitor display.
B. Use iSeries Navigator, SQL Performance Monitor to conllect and analyze the SQL performance of the jobs.
C. Start debug on one of the on-line jobs and use Performance Explorer to analyze the jobs database access plan.
D. Use iSeries Navigator to create a database map of the tables used in the transactions and watch for high I/O rates.

Ans : B


No comments: