An Outstanding Value

An iSeries status/trending analysis tool to help IT professionals:

• Explain quickly why application performance has slowed, or their system has crashed
• Archive BEFORE and AFTER metrics surrounding hardware, OS, and application upgrades or code deployments automatically
• Communicate accomplishments and operating realities to upper management
• Document the facts to support their business/budget justifications for IT capacities and resources
• Surface and fix areas of concern BEFORE they become problems
• Spread IT knowledge and expertise to a growing community of delta/TRACKER users
• Comply with the tracking/auditing/reporting requirements of Sarbanes-Oxley (SOX), HIPAA, GLBA, FDA 21 CFR Part 11, UCCnet, COBIT, NIST800, and other state/federal regulations
• Watch their areas of responsibility with 'another set of eyes'

delta/TRACKER is configured as a plug-in to iSeries Navigator (formerly known as Operations Navigator) and currently has 50 distinct data collection/reporting features. Click here to be taken immediately to a sample set of delta/TRACKER reports

Here are a few of the 50 reports currently included in delta/TRACKER:

• Unused Indexes
• Indexes Created Over Time
• Change in Elapsed Time for Jobs
• CPU Used Between Two Dates
• System CPU vs. Interactive CPU
• Disk Space Used per ASP

Background

Monitoring the health of your database and iSeries system has always been important. Today, there are ever-growing management reporting requirements for the purposes of Sarbanes-Oxley (SOX), HIPAA, GLBA, FDA 21 CFR Part 11, UCCnet, COBIT, NIST800, etc. As a result, increasing pressure is put on the IT personnel to provide critical database and system information in a quick, summarized and transparent fashion to support internal IT monitoring and control as well as these new regulatory requirements.

Although IBM iSeries server is well known for its flexibility, stability and integration; reporting on the health of the database, administrative metrics, database/system changes, and important trends is not something that is provided "out of the box".

Description

delta/TRACKER is a tool that offers a growing set of data collection and reporting features to help IT personnel analyze needed information without having to write their own tools to collect, manage, and query that data. Built-in data collection, data management, analysis, and reporting functions of the product are intended to help IT administrators and management to monitor, control, and communicate about iSeries operational status in new and better ways. Most importantly, each report is intended to be actionable. In other words, the information delta/TRACKER makes available provides not only status/trending statistics, but also can be acted upon as necessary.

delta/TRACKER is not intended to be a real-time product but instead provide trending information or status at a point in time. Report features currently included in delta/TRACKER provide information about database statistics, database structure, query activity indicators, disk space management, system performance, jobs reporting and database security (including SOX compliance).

Prerequisites for delta/TRACKER

• V5R1M0 or higher of OS/400
• IBM iSeries Navigator (Ops Nav) version V5R1
• You must have the latest service pack installed that corresponds to your iSeries Access for Windows Release Level. Latest Service Pack PTF Number
• Microsoft Excel 2000, or higher
• English language support only. delta/TRACKER may not work correctly on systems with non-English language support.
• No SSL Encryption. delta/TRACKER does not presently support SSL (Secure Socket Layer) encrypted communication between iSeries Navigator and the iSeries server.
• In order to correctly report last used date in the reports on SQL index statistics, consider applying following PTFs:
  

  V5R3 - SI12938, SI15255, SI13432, SI13245, and SI14782

  V5R2 - SI14275, SI16313, SI16311, SI16269, SI16348, SI16307, MF34224, and MF34225

  V5R1 - not supported

  For additional PTFs required by the Network Statistics data collection see APAR SE18991

Choose your delta/TRACKER links below

	Product preview
	Sample sets of reports
	Report selection form
	User guide
	Installation program