November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
How do i clear statistics
INPUT; CHAR(10)
The memory area to be cleared or freed. The possible values are:
| *ALL | Clear the monitor data associated with the *ALL monitor (the monitor started against ALL jobs). Memory areas associated with QQQSSDBM started on individual jobs will not be cleared. No storage is freed. |
| *NAMED | Clear the memory handle specified by the job or memory handle name parameter (and matches the name of a memory handle specified on the QQQSSDBM API). No storage is freed. Only the first 6 characters will be used for naming the memory handle. |
| *JOB | Clear the job specific data associated with the job name specified in the job or memory handle name parameter. No storage is freed. |
| *RESET | Clear and free all memory associated with all active or inactive database monitors. The *RESET option cannot be specified on a specific job or memory handle. |
Job or memory handle nameINPUT; CHAR(26)
This parameter depends on the value specified for the memory area to clear parameter. If the value is:
| *ALL | This parameter must be set to blanks. | ||||||||||
| *RESET | This parameter must be set to blanks. | ||||||||||
| *NAMED | The CHAR(10) name of a memory handle whose data is to be cleared. Only the first 6 characters will be used for naming the memory handle, with the remaining characters set to blanks. | ||||||||||
| *JOB | The CHAR(26) qualified job name of a job-specific monitor to dump. The qualified job name has three parts:
|
Mar 10, 2015 11:19
We have EPiServer Statistics Logging turn on for last 3 years ,and now is the database really big.
Is it possible to clear old statistics in the database ?