Identifying server performance problems

Use the flowchart to diagnose issues with server operations. The table after the flowchart provides more information and links to diagnostic tasks and tools.

Tip: Before you review the flowchart, ensure that you answer all questions and fix any issues that are described in the Checklist for the server hardware and the operating system and the Checklist for IBM Spectrum Protect server configuration.

Flowchart to diagnose and fix server data flow problems. The steps in the table are described in the table of questions and diagnostic tasks. — Figure 1. Flowchart to solve issues with server performance

Table 1. Flowchart questions and tasks to help you diagnose and fix server performance problems
Step	Question	Diagnostic tasks
1	Do operating system tools show a disk bottleneck on the server? For more information, see Identifying disk bottlenecks for IBM Spectrum Protect servers.	Yes Fix any disk issues. If applicable, check the load on the system for applications that are not related to IBM Spectrum Protect. See Tuning disk storage for the server. No Check the servermon component to view diagnostic information for the server. Go to question 2.
2	Does the server monitoring script output show slow disk transfer?	Yes Fix any disk issues. If applicable, check the load on the system for applications that are not related to IBM Spectrum Protect. See Analyzing the basic performance of disk systems. No Go to question 3.
3	Does the server monitoring script output show slow tape I/O rates?	Yes Fix tape issues and check for errors or bad media, if applicable. See Tuning tape drive performance. No Find the thread for the operation in the script output. Go to question 4.
4	Does the thread show that most of time is spent in Db2® operations?	Yes Investigate database error log and database and log I/O issues. See Server database and recovery log configuration and tuning. No IBM® support personnel can help in diagnosing performance problems by requesting certain traces and other information from the environment. The comprehensive analysis of a performance problem is a billable service that is offered to IBM Spectrum Protect customers. For information about IBM Support and gathering data for problems, see the Software Support Handbook See also Collecting and analyzing data for performance problems.