SAP DB2_VIEW_COL_PROFILE table - DB2 View Data for SAP Collector Profile details in SAP

SAP DB2_VIEW_COL_PROFILE table summary

Object Name: DB2_VIEW_COL_PROFILE
Dictionary Type: Structure
Description: DB2 View Data for SAP Collector Profile

Field list for DB2_VIEW_COL_PROFILE table on an S/4 SAP system

Details

DB2_VIEW_COL_PROFILE-COL_PROFILE table field - ▼

Description:
Field Name: COL_PROFILE
Data Element: DB2_COL_PROFILE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COL_PROFILE

DB2_VIEW_COL_PROFILE-DSC_HIST_EVAL table field - Statement Cache Hist Interval in minutes ▼

Description: Statement Cache Hist Interval in minutes
Field Name: DSC_HIST_EVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSC_HIST_EVAL

DB2_VIEW_COL_PROFILE-DSC_HIST_STMT_NO table field - Retain Top n Stetements in Statement Cache History ▼

Description: Retain Top n Stetements in Statement Cache History
Field Name: DSC_HIST_STMT_NO
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSC_HIST_STMT_NO

DB2_VIEW_COL_PROFILE-DSC_OFFSET_STATSTIME table field - Offeset in minutes to Start Statement Cache History ▼

Description: Offeset in minutes to Start Statement Cache History
Field Name: DSC_OFFSET_STATSTIME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSC_OFFSET_STATSTIME

DB2_VIEW_COL_PROFILE-DSCHIST_CLEAN_INTERVAL table field - Retain n Days in Statement Cache History ▼

Description: Retain n Days in Statement Cache History
Field Name: DSCHIST_CLEAN_INTERVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSCHIST_CLEAN_INTERVAL

DB2_VIEW_COL_PROFILE-ACC_TIME_EVAL table field - Global Times Interval in minutes ▼

Description: Global Times Interval in minutes
Field Name: ACC_TIME_EVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACC_TIME_EVAL

DB2_VIEW_COL_PROFILE-GLOTIME_CLEAN_INTERVAL table field - Retain n Days of Global Times ▼

Description: Retain n Days of Global Times
Field Name: GLOTIME_CLEAN_INTERVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field GLOTIME_CLEAN_INTERVAL

DB2_VIEW_COL_PROFILE-DB02_KEEP_DAYS table field - Number of entries to retain in DB02 day history per object ▼

Description: Number of entries to retain in DB02 day history per object
Field Name: DB02_KEEP_DAYS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB02_KEEP_DAYS

DB2_VIEW_COL_PROFILE-DB02_KEEP_WEEKS table field - Number of entries to retain in DB02 week history per object ▼

Description: Number of entries to retain in DB02 week history per object
Field Name: DB02_KEEP_WEEKS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB02_KEEP_WEEKS

DB2_VIEW_COL_PROFILE-DB02_KEEP_MONTHS table field - Number of entries to retain in DB02 month history per object ▼

Description: Number of entries to retain in DB02 month history per object
Field Name: DB02_KEEP_MONTHS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB02_KEEP_MONTHS

DB2_VIEW_COL_PROFILE-DB02_COLLECT table field - 0=DB02 history OFF, 1=DB02 history ON ▼

Description: 0=DB02 history OFF, 1=DB02 history ON
Field Name: DB02_COLLECT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB02_COLLECT

DB2_VIEW_COL_PROFILE-DB02_OFFSET table field - ▼

Description:
Field Name: DB02_OFFSET
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB02_OFFSET

DB2_VIEW_COL_PROFILE-ALERTS_CLEAN_INTERVAL table field - Retain n Days in Alert History ▼

Description: Retain n Days in Alert History
Field Name: ALERTS_CLEAN_INTERVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ALERTS_CLEAN_INTERVAL

DB2_VIEW_COL_PROFILE-DBM1_TIME_EVAL table field - DBM1 Strg Hist Times Interval in minutes ▼

Description: DBM1 Strg Hist Times Interval in minutes
Field Name: DBM1_TIME_EVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBM1_TIME_EVAL

DB2_VIEW_COL_PROFILE-STRG_CLEAN_INTERVAL table field - Retain n Days in DBM1 storage History ▼

Description: Retain n Days in DBM1 storage History
Field Name: STRG_CLEAN_INTERVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STRG_CLEAN_INTERVAL

DB2_VIEW_COL_PROFILE-DB02_THRESHOLD_YELLOW table field - DB02 Space Alert Limit for yellow traffic light in % ▼

Description: DB02 Space Alert Limit for yellow traffic light in %
Field Name: DB02_THRESHOLD_YELLOW
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB02_THRESHOLD_YELLOW

DB2_VIEW_COL_PROFILE-DB02_THRESHOLD_RED table field - DB02 Space Alert Limit for redaffic light in % ▼

Description: DB02 Space Alert Limit for redaffic light in %
Field Name: DB02_THRESHOLD_RED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DB02_THRESHOLD_RED

DB2_VIEW_COL_PROFILE-STOP_AT_DB2_SHUTDOWN table field - ALR behavior when DB2 stops: 0=ALR disconnects, 1=ALR stops ▼

Description: ALR behavior when DB2 stops: 0=ALR disconnects, 1=ALR stops
Field Name: STOP_AT_DB2_SHUTDOWN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STOP_AT_DB2_SHUTDOWN

DB2_VIEW_COL_PROFILE-ACL_TIME_EVAL table field - Accelerator Statistics History Times Interval in minutes ▼

Description: Accelerator Statistics History Times Interval in minutes
Field Name: ACL_TIME_EVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACL_TIME_EVAL

DB2_VIEW_COL_PROFILE-ACCEL_CLEAN_INTERVAL table field - Retain n Days in Accelerator Statistics History ▼

Description: Retain n Days in Accelerator Statistics History
Field Name: ACCEL_CLEAN_INTERVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCEL_CLEAN_INTERVAL

DB2_VIEW_COL_PROFILE-SAP_THREAD_TIME_EVAL table field - Check Intervall for AR standy support ▼

Description: Check Intervall for AR standy support
Field Name: SAP_THREAD_TIME_EVAL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAP_THREAD_TIME_EVAL

DB2_VIEW_COL_PROFILE-SAP_THREAD_THRESHOLD table field - Min. no SAP DB2 Threads to be considered active ▼

Description: Min. no SAP DB2 Threads to be considered active
Field Name: SAP_THREAD_THRESHOLD
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAP_THREAD_THRESHOLD

DB2_VIEW_COL_PROFILE-START_DB_TRACE table field - 0=DB02 Traces OFF, 1=DB02 Traces ON ▼

Description: 0=DB02 Traces OFF, 1=DB02 Traces ON
Field Name: START_DB_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_DB_TRACE

DB2_VIEW_COL_PROFILE-START_ACC_TRACE table field - 0=DB02 Accounting Traces OFF, 1=DB02 Accounting Traces ON ▼

Description: 0=DB02 Accounting Traces OFF, 1=DB02 Accounting Traces ON
Field Name: START_ACC_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_ACC_TRACE

DB2_VIEW_COL_PROFILE-START_DSC_TRACE table field - 0=DB02 Statment cache Trace OFF, 1=DB02 DCS Trace ON ▼

Description: 0=DB02 Statment cache Trace OFF, 1=DB02 DCS Trace ON
Field Name: START_DSC_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_DSC_TRACE

DB2_VIEW_COL_PROFILE-START_400_TRACE table field - 0=DB02 static sql trace OFF, 1=DB02 static sql trace ON ▼

Description: 0=DB02 static sql trace OFF, 1=DB02 static sql trace ON
Field Name: START_400_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_400_TRACE

DB2_VIEW_COL_PROFILE-START_501_TRACE table field - 0=DB02 Trace Stop Real Storagecounters OFF, 1=DB02 Trace ON ▼

Description: 0=DB02 Trace Stop Real Storagecounters OFF, 1=DB02 Trace ON
Field Name: START_501_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_501_TRACE

DB2_VIEW_COL_PROFILE-CB_DB02_COL_ON_OFF table field - Checkbox to turn on/off DB02 collection ▼

Description: Checkbox to turn on/off DB02 collection
Field Name: CB_DB02_COL_ON_OFF
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CB_DB02_COL_ON_OFF

DB2_VIEW_COL_PROFILE-RB_ALR_DISCON_AT_DB2STOP table field - Radio Button to control ALR behavior when DB2 shutdown ▼

Description: Radio Button to control ALR behavior when DB2 shutdown
Field Name: RB_ALR_DISCON_AT_DB2STOP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RB_ALR_DISCON_AT_DB2STOP

DB2_VIEW_COL_PROFILE-RB_ALR_STOP_AT_DB2STOP table field - Radio Button to control ALR behavior when DB2 shutdown ▼

Description: Radio Button to control ALR behavior when DB2 shutdown
Field Name: RB_ALR_STOP_AT_DB2STOP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RB_ALR_STOP_AT_DB2STOP

DB2_VIEW_COL_PROFILE-DSC_INTERVAL_UNIT table field - Unit of Statement Cache History Collection interval ▼

Description: Unit of Statement Cache History Collection interval
Field Name: DSC_INTERVAL_UNIT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DSC_INTERVAL_UNIT

DB2_VIEW_COL_PROFILE-ACC_INTERVAL_UNIT table field - Unit of Global Times History Collection Interval ▼

Description: Unit of Global Times History Collection Interval
Field Name: ACC_INTERVAL_UNIT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACC_INTERVAL_UNIT

DB2_VIEW_COL_PROFILE-DBM1_INTERVAL_UNIT table field - Unit of DBM1 Storage History Collection Interval ▼

Description: Unit of DBM1 Storage History Collection Interval
Field Name: DBM1_INTERVAL_UNIT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBM1_INTERVAL_UNIT

DB2_VIEW_COL_PROFILE-CB_DB02_START_DB_TRACES table field - Checkbox to turn on/off DB2 Traces ▼

Description: Checkbox to turn on/off DB2 Traces
Field Name: CB_DB02_START_DB_TRACES
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CB_DB02_START_DB_TRACES

DB2_VIEW_COL_PROFILE-CB_DB02_START_ACC_TRACE table field - Checkbox to turn on/off DB2 Accounting Traces ▼

Description: Checkbox to turn on/off DB2 Accounting Traces
Field Name: CB_DB02_START_ACC_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CB_DB02_START_ACC_TRACE

DB2_VIEW_COL_PROFILE-CB_DB02_START_DSC_TRACE table field - Checkbox to turn on/off DB2 Trace for Statment cache ▼

Description: Checkbox to turn on/off DB2 Trace for Statment cache
Field Name: CB_DB02_START_DSC_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CB_DB02_START_DSC_TRACE

DB2_VIEW_COL_PROFILE-CB_DB02_START_400_TRACE table field - Checkbox to turn on/off DB2 static trace ▼

Description: Checkbox to turn on/off DB2 static trace
Field Name: CB_DB02_START_400_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CB_DB02_START_400_TRACE

DB2_VIEW_COL_PROFILE-CB_DB02_START_501_TRACE table field - Checkbox to turn on/off DB2 Trc to Stop Real Storagecounters ▼

Description: Checkbox to turn on/off DB2 Trc to Stop Real Storagecounters
Field Name: CB_DB02_START_501_TRACE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CB_DB02_START_501_TRACE

View list of all SAP tables(S4H/ECC)

Select data from SAP table