Planning of Periodic Processes on the Server

602SQL Server

602SQL Server Limits

Server Properties

The so-called properties serve for saving runtime parameters, selections and flags on a 602SQL server. Each property has:

• an owner - an object that is concerned with this property and that can be affected by the property;
• a name - a verbal mark of the property;
• a value - usually a number or a character string.

E.g. the "@SQLSERVER" owner has the property "TraceLogCacheSize" that can have a value of 5000. This property affects the cache size for the server log and will be set on 5000 bytes by this value. Another owner name than the "@SQLSERVER" isn't used in the current version.

The property owner and name are character strings and may contain any characters including blank spaces. They're not case-sensitive.

Property values can be set and read in two ways:

• By using the Runtime parameters dialog and certain tools from the System / Tools section or in the Monitor window.
• By using the API functions Set_property_value and Get_property_value.

List of topics:

• An Overview of Server Properties

Planning of Periodic Processes on the Server

602SQL Server

602SQL Server Limits