SYBATM_TP_PROF - ATM Template Profiles
ATM Template Profiles information is stored in SAP table SYBATM_TP_PROF.
It is part of development package SMSYB in software component BC-DB-SYB. This development package consists of objects that can be grouped under "SYBASE Database Monitor".
It is part of development package SMSYB in software component BC-DB-SYB. This development package consists of objects that can be grouped under "SYBASE Database Monitor".
Fields for table SYBATM_TP_PROF
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TPL_ID | 4 Byte Signed Integer | X | INT4 | INT4 | 4 | |
| TPL_VERSION | 4 Byte Signed Integer | X | INT4 | INT4 | 4 | |
| PROFILE_ID | 2 Byte Signed Integer | X | INT2 | INT2 | 2 | |
| ATM_TYPE | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| DB_NAME | DBA specific Data Type for Text 30 | DBA_DBH_TEXT30 | CHAR | 60 | ||
| OBJECT_NAME | DBA specific Data Type for Text 30 | DBA_DBH_TEXT30 | CHAR | 60 | ||
| OWNER_NAME | DBA specific Data Type for Text 30 | DBA_DBH_TEXT30 | CHAR | 60 | ||
| EXEC_PRIORITY | Character Field with Length 10 | CHAR10 | CHAR | 20 | ||
| PER_PARTITION | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| PRIORITY | NUMC | 2 | ||||
| PROFILE_DESCR | Work Area Length 128 | TEXT128 | CHAR | 256 | ||
| PROFILE_TYPE | DBA specific Data Type for Text 10 | DBA_DBH_TEXT10 | CHAR | 20 | ||
| RANGE_FROM | DEC | 11 | ||||
| RANGE_TO | DEC | 11 | ||||
| RANGE_TYPE | Char 20 | CHAR20 | CHAR | 40 | ||
| THRESHOLD_TYPE | Char 15 | CHAR15 | CHAR | 30 | ||
| THRESHOLD_VALUE | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| STATS_TYPE | DBA specific Data Type for Text 10 | DBA_DBH_TEXT10 | CHAR | 20 | ||
| NR_HIST_STEPS | 2 Byte Signed Integer | INT2 | INT2 | 2 | ||
| HASHING_TYPE | Text (20 Characters) | TEXT20 | CHAR | 40 | ||
| NR_CONSUMERS | 2 Byte Signed Integer | INT2 | INT2 | 2 | ||
| SAMPL_RATE | 2 Byte Signed Integer | INT2 | INT2 | 2 | ||
| REORG_TYPE | DBA specific Data Type for Text 30 | DBA_DBH_TEXT30 | CHAR | 60 | ||
| HISTOGRAM_TUNING | INT4 | 4 | ||||
| ONLINE_OPT | Replacement for Real Boolean Type: 'X' == True '' == False | WDY_BOOLEAN | CHAR | 2 | ||
| COMPRESS_OPT | Replacement for Real Boolean Type: 'X' == True '' == False | WDY_BOOLEAN | CHAR | 2 | ||
| RESUME_OPT | Replacement for Real Boolean Type: 'X' == True '' == False | WDY_BOOLEAN | CHAR | 2 | ||
| TIMEOUT | INT2 | 2 | ||||
| SKIP_COMPACT_EXTENTS | INT2 | 2 |