The SYSSQL_PROPERTIES system table contains the configuration details of the AUS Maintenance Window.

Here are the details of the SYSSQL_PROPERTIES table.

_Property _Attribute _Value_n _Value_ch Default
AUS_Configuration_version 0 N -
AUS_Enable 0 0/1 - 0
AUS_LOG_Enable 0 1/0 - 0
AUS_Mode 0 1-Maintenance Window - 1
AUS_Mode 2-Continues Mode -
AUS_MWindow 0 StartTime in char 1st Jan 1970 00:00:00
AUS_MWindow 1 Length of Maintenance Window in hrs 1hrs
AUS_MWindow 2 Cycle Length of Maintenance Window (time during two maintenance Window) in hrs. 24hrs
AUS_Throttle 0 n-Throttling level (0-#) 0
AUS_MarkPositive_percentage

(Predicted and Experience cardinality difference)

 0 >1 10%
AUS_Accessed_positive_percentage 0 >1 10%
AUS_Min_table_size 0 0-N 0
AUS_Max_table_size 0 -1-N (-1 infinity) -1
AUS_Columstat_sample_percentage 0 N 100
AUS_TABLE_Level_config 0 TableID
AUS_TABLE_Level_config 1

0 Disable

1 Table Stat

2 Index Stat

4 Column Stat