The following are the Performance Data Collection jobs that archive log data frequently to history tables created by DIPPDCR.
|Session||Runs every 10 minutes to archive data about user session duration and session counts|
|Accounting||Runs every hour to archive data about AMP usage|
|Maintenance||Runs once a week to check retention values and clean up Data Dictionary logs if needed|
The following are the Performance Data Collection jobs that archive Data Dictionary log tables once a day to history tables created by DIPPDCR.
|Job||What It Archives|
|Info Tables||User information, including profiles, groups, and space owners|
|Logon/Logoff||Data collected automatically by the system for each user logon or logoff|
|TDWM||Logs for workload management functions:
|DBQL||Database query logs, depending on the type of logging you enable|
|Disk Space||Data collected automatically on space allocation for databases and tables|
|Resource Usage||System-level performance data from the DBC.ResUsage tables|
|Access Log||Security data|
|Statistics||No data; this job refreshes statistics on PDCR tables|