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 | * |