News
Abstract
The Performance Data Investigator packages group perspectives (charts and tables) for one collection or purpose.
Content
You are in: IBM i Technology Updates > Performance Tools > Performance on the web > Packages & Perspectives
Use the Search Function to find a perspective by database field or name.
See also Functions & Enhancements
If you have custom packages or perspectives, The way these files are shipped with PDI has changed. See PML Packages for New Navigator
Packages & Perspectives
| Package | Folder or Category | Perspective Names (highlights, not all inclusive) | Requirements |
|---|---|---|---|
| General Health Indicators |
System Resources Health Indicators
|
Base OS | |
| Collection Services | Disk |
Disk Reads and Writes Detail contains the following views:
|
Base OS |
| Storage Allocation |
|
||
| Memory | Memory Pool Activity Levels | ||
| Timeline |
|
||
| Physical System |
|
||
| Workload Group | |||
| Collection Services Database Files | QAPMCONF | ||
| Monitors | System Monitors | 7.2 and later only - Comes with the IBM i base OS | |
| Graph History |
|
7.3 and later only - Comes with the IBM i base OS | |
| Disk Watcher | Requires Performance Tools Licensed Program Product (5770PT1) Option 1 - Manager Feature | ||
| Performance Explorer | |||
| Database | |||
| Job Watcher | Storage Allocation |
|
Requires Performance Tools LPP (5770PT1) Option 3 - Job Watcher |
|
Waits - All Waits by Thread or Task Sorted by Non-idle Waits
|
File Level
The collectors assign file levels to the database files based on release/version.
Some perspectives require a certain file level and will not be available to a collection not at the required level.
This table shows what file level a collector at each release will give to each collection:
| Release | Collection Services | Job Watcher | Disk Watcher | PEX | Historical Data |
|---|---|---|---|---|---|
| 6.1 | 28 | 3 | 1 | 27 | - |
| 7.1 | 36 | 6 | 6 | 29 | - |
| 7.2 | 42 | 8 | 6 | 30 | - |
| 7.3 | 48 | 48 | 48 | 48 | 1 |
| 7.4 | 54 | 54 | 48 | 54 | 2 |
| 7.5 | 60 | 60 | 48 | 60 | 3 |
The perspectives are defined with an XML-derivative called PML.
Perspectives for all releases are defined with one PML file. Within it, there are file level requirements impacted by the releases and files required. Because not all perspectives are valid for all collections. An older collection might not include files or fields required for a newer collection.
When the perspective and collection are not compatible, the Display button is not active. Also, note that a view for a perspective (single chart or table) may be different depending on the collection that is being displayed. See more information in Single Source Packages
Changes in support from Database
A database enhancement affected the PDI queries in Dec 2018. Changes to Db2 support caused some keywords (INNER and OUTER) to not be allowed in places that were previously acceptable.
The correlation name is no longer required after a derived table. Some correlation names are still allowed, but INNER and OUTER cannot be allowed. Both INNER and OUTER are keywords that are valid syntax (that is, for INNER JOIN) at this position in the statement.
- For PDI, we removed the use of INNER in some of our queries to fix this problem.
- Another approach is to change it to "INNER" (with delimiters) or change to some other name.
- To have the query work on a system that doesn't have the enhancement that caused this change, you might need to leave something at this spot in the query. Changing OUTER to simply O works on all releases.
Additional Perspectives (PML):
Download the latest SSD analyzer PML files for use with Performance Data Investigator: SSD_analysis.pml__0.xml
Note: Rename to SSD_analysis.pml before uploading to your IBM i and putting in the PML director.
This version has several updates from the original. The last couple are documented here:
- In March 2020 to fix the drilldowns from the first two perspectives
- In Jan 2020 for the Db2 changes that required the "OUTER" keyword to be changed to "O".
Description of the perspectives:
-
- The SSD Analysis Overview perspective provides a high-level overview of the relative likeliness for SSDs to provide a performance improvement.
- Disk Read Time depicts average read response time for the selected collection.
- Disk Read Time by Job and Task is a table showing a subset of the information available for the jobs running during the collection.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
20 April 2022
UID
ibm11127175