SYBATM_TP_PROF

ATM Template Profiles | #template | Component: Business Suite on Adaptive Server Enterprise
Column Name Description
TPL_ID 4 Byte Signed Integer
TPL_VERSION 4 Byte Signed Integer
PROFILE_ID 2 Byte Signed Integer
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ONLINE_OPT Replacement for Real Boolean Type: 'X' == True '' == False Show values
COMPRESS_OPT Replacement for Real Boolean Type: 'X' == True '' == False Show values
RESUME_OPT Replacement for Real Boolean Type: 'X' == True '' == False Show values
Column Name Description Domain name
ATM_TYPE Single-Character Flag CHAR1
DB_NAME DBA specific Data Type for Text 30 TEXT30
OBJECT_NAME DBA specific Data Type for Text 30 TEXT30
OWNER_NAME DBA specific Data Type for Text 30 TEXT30
EXEC_PRIORITY Character Field with Length 10 CHAR10
PER_PARTITION Single-Character Flag CHAR1
PRIORITY null
PROFILE_DESCR Work Area Length 128 TEXT128
PROFILE_TYPE DBA specific Data Type for Text 10 TEXT10
RANGE_FROM null
RANGE_TO null
RANGE_TYPE Char 20 CHAR20
THRESHOLD_TYPE Char 15 CHAR15
THRESHOLD_VALUE 4 Byte Signed Integer INT4
STATS_TYPE DBA specific Data Type for Text 10 TEXT10
NR_HIST_STEPS 2 Byte Signed Integer INT2
HASHING_TYPE Text (20 Characters) TEXT20
NR_CONSUMERS 2 Byte Signed Integer INT2
SAMPL_RATE 2 Byte Signed Integer INT2
REORG_TYPE DBA specific Data Type for Text 30 TEXT30
HISTOGRAM_TUNING null
TIMEOUT null
SKIP_COMPACT_EXTENTS null