Reporting framework

The reporting framework provides the infrastructure for the reporting feature.

The diagram shows the reporting framework architecture that includes the following components:
Reporting framework architecture
Database
IBM® Spectrum Symphony includes the Derby database, a JDBC-based relational database system, for reporting. Derby is a small-footprint database and is appropriate only for demo clusters. If you want to produce regular reports for a production cluster, you must use a supported commercial database.
Data sources
Data sources are files that store cluster operation and workload information such as host status changes, session, and task status, and so on. IBM Spectrum Symphony uses several files as data sources. These include daemon status files, and event files.
Data loaders
Data loaders collect the operational data from the data sources and load the data into tables in a relational database. The data loaders connect to the database using a JDBC driver. The data loaders handle daylight savings automatically by using GMT time when collecting data.
Loader controller
The loader controller service (plc) controls the data loaders that collect data from the system and writes the data into the database.
Data purger
The data purger service (purger) maintains the size of the database by purging old records from the database and archiving them. By default, the data purger purges all data that is older than 14 days, and purges data every day at 12:30 AM.
Reports
IBM Spectrum Symphony provides a set of report templates called standard reports. These report templates allow you to produce a report to analyze your cluster. The standard reports capture the most common and useful data to analyze your cluster.

You may also create custom reports from advanced queries to capture data beyond what is displayed in the standard reports.