The following are the Performance Data Collection jobs that archive log data frequently to history tables created by DIPPDCR.
| Job | Description |
|---|---|
| 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 |