Reports catalog and samples

 

Database statistics

Files with most transaction activity

Files ranked by index maintenance cost

Database operations per library

Unused indexes

Duplicate indexes

Most used indexes based on physical reads

Most used indexes based on logical reads

Logical versus physical reads

Largest number of records

Change in number of records for members

Unused files since last IPL

 

Database structure

Files with the most indexes over them

Inefficient select/omit logical files

Created members

Deleted members

Files with database triggers

Files with triggers that can change data

Files with Encoded Vector Indexes over them

 

Database query activity

Highest query activity

Indexes created by queries

 

Database and system disk space

Objects ranked by size

Disk space used per ASP

File member disk space

File disk space by member

Largest number of deleted records

Library summary of deleted records

Disk storage per user profile

 

Database and system CPU

CPU used between two dates

System CPU vs. Database CPU

System CPU vs. Interactive CPU

 

Job reports

Jobs summary for all completed jobs

Job summary over time

Elapsed time for jobs

Elapsed time trend for a job

Change in elapsed time for jobs

Concurrent jobs

 

 

Database security

Users with special authority

Failed sign on attempts

New profiles over a time period

Unused user profiles

Changes in special authorities

 

 

Performance

CPU Utilization of OneWorld or

EnterpriseOne jobs

beta

UBE job queue wait time

beta

Job count over a time period

beta

UBE CPU utilization trend

beta

UBE job queue wait time trend

beta

Jobs that ended in error

beta

 

 

Network statistics

IP Addresses unresponsive to PING

beta

Network statistics for an IP address over a time period

beta

 

Graphed network statistics for an IP address over a time period

beta