The properties are usually set interactively using the client developer interface dialogs. Some less important properties can be set only in this way.
A change in a property value usually takes effect after the server is restarted.
The owner of these properties is always the "@SQLSERVER" entity.
| IPCCommunication |
Basic server-client communication on a single computer on Windows; 1 = enabled |
| TCPIPCommunication |
TCP/IP network communication; 1 = enabled |
| IPPort |
The default port number that the 602SQL Server listens on (5001 by default). The property can be set (not changed) in the Windows registry or in the /etc/602sql file on Linux. This can be used when creating a new database if you need to specify a port other than the 5001 default. |
| ServerIPAddr |
The IP address that the 602SQL Server listens on. It must be one of the IP addresses of the computer that runs 602SQL Server. If not specified, the 602SQL Server listens on all addresses. |
| HTTPTunnel |
Enables HTTP tunneling between client and server on the specified port (usually 80). Disabled by default. |
| HTTPTunnelPort |
Number of port for the HTTP tunnel. 80 by default. |
| WebServerEmulation |
602SQL server will emulate a web server; 1 = enabled |
| WebPort |
The port number for the web emulation; default is 80. |
| ExtWebServerPort |
The port number that an external web server listens on. |
| KillTimeNotLogged |
Time in seconds when a client that has not logged in is disconnected by the server. |
| KillTimeLogged |
Time in seconds when an idle logged in client is disconnected by the server. |
| SecureTransactions |
If set to 1, secure transactions are enabled.
|
| FlushOnCommit |
If set to 1, data changes are written to disk after each commit.
|
| LockWaitingTimeout |
The maximum time that a user will wait for another user's lock (in tenths of a second).
|
| Frame Space |
The size of the internal cache for accessing the database file (in KB). |
| Server Memory |
Initial value of the server operating memory (in multiples of 64 KB). |
| Sort Space |
The maximum size of memory space allocated for sorting (in KB). |
| Total Sort Space |
The maximum size of memory space allocated for simultaneous sortings (in KB). |
| CloseFileWhenIdle |
If set to 1, the 602SQL Server will unlock the database file when no user is connected and no user thread is running. |
| TraceLogCacheSize |
The size of the cache in bytes for each server log. The contents of this cache is accessible to all clients. |
| DailyBasicLog |
If set to 1, the date is appended to the log filename and the log for each day will be stored in a different file. |
| DailyUserLogs |
If set to 1, the date is appended to all user-definded log files and the logs for each day will be stored in a different file. |
| ExtFulltextDir |
The location of files containing fulltext indexes (if the fulltext system is defined this way). Not specified by default (the folder containing the database file is used). |
| DisableAnonymous |
If set to 1, the anonymous user account is disabled. |
| UnlimitedPasswords |
If set to 1, the user password can be used forever. This will reduce the overall security of the system. |
| MinPasswordLen |
Minimum user password length.
|
| PasswordExpiration |
Maximum number of days a user password is valid (0 = unlimited).
|
| DisableFastLogin |
If set to 1, each new client must login, even when connecting from the same IP address as an already connected client. |
| TrustedDomain |
The name of the Windows domain that allows users to login to the 602SQL Server.
|
| CreateDomainUsers |
If set to 1, a user logged into a TrustedDomain domain is created on the 602SQL Server on the first connection.
|
| ReqCommEnc |
If set to 1, encrypted communication is required from network clients.
|
| ConfAdmsOwnGroups |
If set to 1 (default), the configuration administrator (member of the Config_admin group) may assign other users to this group.
|
| ConfAdmsUserGroups |
If set to 1 (default), the configuration administrator (member of the Config_admin group) may assign users to groups.
|
| HTTPUser |
Specifies the only user that can connect to the 602SQL Server using HTTP-tunneling. Not specified by default. |
| DisableHTTPAnonymous |
Enable or disable anonymous server access through HTTP. Enabled by default, neccesary to disable for secure operation. |
| Dir[N] |
A folder that can be used for calling external DLL/SO libraries. Delimit folders with a comma (Dir1, Dir2, etc.). |
| IP_enabled_addr[N] |
List of IP addresses or groups of address that allow client access to the server (TCP/IP). Delimit addresses with a comma (IP_enabled_addr1, IP_enabled_addr2, etc.). |
| IP_enabled_mask[N] |
List of network masks that allow client access to the server (TCP/IP). Delimit addresses with a comma (IP_enabled_mask1, IP_enabled_mask2, etc.). |
| IP_disabled_addr[N] |
List of IP addresses or groups of address that deny client access to the server (TCP/IP). Delimit with a comma (IP_disabled_addr1, IP_disabled_addr2, etc.). |
| IP_disabled_mask[N] |
List of network masks that deny client access to the server (TCP/IP). Delimit addresses with a comma (IP_disabled_mask1, IP_disabled_mask2, etc.). |
| IP1_enabled_addr[N] |
List of IP addresses or groups of address that allow client access to the server (HTTP tunnelling). Delimit addresses with a comma (IP1_enabled_addr1, IP1_enabled_addr2, etc.). |
| IP1_enabled_mask[N] |
List of network masks that allow client access to the server (HTTP tunnelling). Delimit addresses with a comma (IP1_enabled_mask1, IP1_enabled_mask2 etc.). |
| IP1_disabled_addr[N] |
List of IP addresses or groups of address that deny client access to the server (HTTP tunnelling). Delimit addresses with a comma (IP1_disabled_addr1, IP1_disabled_addr2 etc.). |
| IP1_disabled_mask[N] |
List of network masks that deny client access to the server (HTTP tunnelling). Delimit addresses with a comma (IP1_disabled_mask1, IP1_disabled_mask2 etc.). |
| IP2_enabled_addr[N] |
List of IP addresses or groups of address that allow client access to the server (Web Access - web server emulation only). Delimit addresses with a comma (IP2_enabled_addr1, IP2_enabled_addr2, etc.). |
| IP2_enabled_mask[N] |
List of network masks that allow client access to the server (Web Access - web server emulation only). Delimit addresses with a comma (IP2_enabled_mask1, IP2_enabled_mask2 etc.). |
| IP2_disabled_addr[N] |
List of IP addresses or groups of address that deny client access to the server (Web Access - web server emulation only). Delimit addresses with a comma (IP2_disabled_addr1, IP2_disabled_addr2 etc.). |
| IP1_disabled_mask[N] |
List of network masks that deny client access to the server (Web Access - web server emulation only). Delimit addresses with a comma (IP1_disabled_mask1, IP1_disabled_mask2 etc.). |
| Backup... |
Properties for automatic database backups. |
| BackupZip... |
Properties relating to the backup compression. |
| NonblockingBackups |
Blocking (=0) x nonblocking (=1) backup. |
| Monitor ... |
Will log certain events into the basic server log. |
| IntegrCheckInterv |
The number of seconds between automatic database consistency checks. If set to 0, automatic checks are disabled.
|
| DefaultSQLOptions |
Default values of compatibility flags for each new connected client. The number set here is the sum of all compatibility flags.
|
| FilEncrypt |
Encrypt the database file.
|
| DecimalSeparator |
The character used to separate decimals when converting the number to a string by the CAST or Real2str functions.
|
