ALPFCOLLREORGSCH - Collection/Reorganization Schemas for PerfDB
Collection/Reorganization Schemas for PerfDB information is stored in SAP table ALPFCOLLREORGSCH.
It is part of development package SMOI in software component BC-CCM-MON. This development package consists of objects that can be grouped under "CCMS: Monitoring Architecture".
It is part of development package SMOI in software component BC-CCM-MON. This development package consists of objects that can be grouped under "CCMS: Monitoring Architecture".
Fields for table ALPFCOLLREORGSCH
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| POLICYID | Name of a CPH Collection and Reorganization Schema | X | ALPFPOLKEY | CHAR | 40 | |
| MIN_DAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| MIN_DAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| MIN_WEEK_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| MIN_WEEK_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| MIN_XDAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| MIN_XDAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| MIN_MONTH_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| MIN_MONTH_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| MIN_QUART_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| MIN_QUART_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| MIN_YEAR_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| MIN_YEAR_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| QTR_DAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| QTR_DAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| QTR_WEEK_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| QTR_WEEK_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| QTR_XDAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| QTR_XDAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| QTR_MONTH_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| QTR_MONTH_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| QTR_QUART_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| QTR_QUART_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| QTR_YEAR_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| QTR_YEAR_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| HR_DAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| HR_DAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| HR_WEEK_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| HR_WEEK_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| HR_XDAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| HR_XDAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| HR_MONTH_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| HR_MONTH_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| HR_QUART_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| HR_QUART_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| HR_YEAR_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| HR_YEAR_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| DAY_DAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| DAY_DAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| DAY_WEEK_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| DAY_WEEK_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| DAY_XDAY_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| DAY_XDAY_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| DAY_MONTH_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| DAY_MONTH_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| DAY_QUART_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| DAY_QUART_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| DAY_YEAR_K | Keep Value for PerfDB Reorganization | ALPFKEEPCNT | INT4 | 4 | ||
| DAY_YEAR_D | Delete Value for PerfDB Reorganization | ALPFDELCNT | INT4 | 4 | ||
| X_VALUE | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| COLLPERIOD | Alert: integer used in performance DB | ALPFDBNUM | INT4 | 4 | ||
| AVGMETHOD | Alert: type of average | ALAVGTYP | CHAR | 4 | ||
| WEIGHTSCHEM | Name of a CPH Collection and Reorganization Schema | ALPFPOLKEY | CHAR | 40 | ||
| SFTNAME | Name of a CPH Collection and Reorganization Schema | ALPFPOLKEY | CHAR | 40 | ||
| COLL_METHOD | Single-Character Flag | CHAR1 | CHAR | 1 | ||
| COLL_TIMEZONE | Time Zone | TIMEZONE | CHAR | 6 | * | |
| REORG_TIMEZONE | Time Zone | TIMEZONE | CHAR | 6 | * |