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 |