Display/Modify Database Properties

You can use the Tamino Manager to display information about and modify database properties. These properties are divided into 4 groups:

Server properties
XML properties
Port properties
X-Tension

The following sections provide information about the properties in each group and give instructions on how to display and modify.

Note:
The word "yes" in the column "Dynamic" in the following tables indicates that changes to the property value become effective immediately, even if the Tamino server is active. The word "no" indicates a non-dynamic property, which means that the changes only become effective if you stop and restart the database. After changing a non-dynamic property and if the database is online, a confirmation screen with the option to stop and restart the database is displayed. If you choose the Restart button on this screen, the database will be stopped and restarted immediately for the changed property to become effective.


Server Properties

Name Dynamic Allowed Values Default Value Description Additional Information
auto expand yes yes, no yes This switch controls whether the Tamino server is allowed to allocate or extend database spaces (data, journal or index) on its own.
  • Tamino first tries to expand an existing space. If this fails, new space will be allocated in the defined reserved location

  • If no free space is available, an error will be returned, depending on the operation performed

autostart no yes, no no If this switch is set to "yes", the database will be started automatically when the computer starts as well as after its creation.  
buffer pool size no

5 - 65536

Computed on the basis of the database profile

This is the size of the buffer pool of the Tamino server in MB. The maximum value that you can specify for this property is 65536 MB). However, in practice, the usable buffer pool size reduces to a lower amount, depending on the machine configuration and the Tamino version used.

  • Recommendation: as big as the biggest index

  • Should not be bigger than the physical memory in order to avoid swapping

flush limit yes

0 - 45875

0 The size in MB of the modified buffer pool space that triggers a flush (disk write) of the modifications present in the buffer pool. Minimum for flush limit is 1 MB. Setting the flush limit to 0 is also allowed: If this value is set to 0, Tamino will adjust the flush limit itself. If a value higher than 70 % of the buffer pool size is configured, the server will internally recalculate the flush limit to 70 % of the buffer pool size, and a warning will be issued during each server startup.
dynamic pool size no 500 - 61440 500 This is the size in KB of the Tamino server's internal dynamic working pool.
  • Keeps result sets

  • Support for sorting

  • If this value is too small, swapping will occur which leads to increased I/O

maximum transaction duration yes 20 - 2592000 300 This is the maximum transaction duration in seconds. This time includes the time for all command processing, including query. Tamino will terminate and roll back transactions that last longer.
non-activity timeout yes 20 - 2592000 900 The maximum timespan (in seconds) that a user is allowed to be inactive before the Tamino server rolls back pending user transactions. The non-activity timeout is also used as a communications timeout to the Tamino client. For this purpose, the timeout value used is never greater than 600 seconds.
replication delay yes 1 - 65535 5 The interval (in seconds) at which the replication databases defined for a master database are updated. The property is set for the master database and applies to all replication databases that are defined for that master database. Decreasing the value of this property increases the processing overheads associated with more frequent calls for log space data by the replication databases.
flush group size yes 0 - 5000 0 This property specifies the number of I/Os issued in parallel in a buffer flush. If 0 is specified, the system default is used.  
number of backup generations yes 1 - (232 -1) 5

The number of full backups that Tamino will keep in parallel. When this number is exceeded, the oldest backup and the corresponding log spaces will be deleted.

Backup generations refer to full backups only, not incremental backups.

 
read only no yes, no no The database is read only. No insert, update or delete operations are possible. Database cannot be deleted when this property is set to "yes".
tolerate autorepair errors no yes, no yes If this is set to yes, errors that occur during the autorepair of the Tamino server after an abnormal termination will be tolerated rather than leading to a refusal to start. The indexes or doctypes concerned will be disabled. A disabled index can be fixed using the Check and Repair command in the Tamino Manager
server host name no   none This defines the host name part for the Tamino Server's registration with XTS.
  • The Tamino server cannot be contacted from other nodes via XTS. Instead, applications on other nodes will look for the server on their node.

  • This setting can be used on portable devices to ensure that an interruption of network connections does not cause any problems with administrating and communicating with the Tamino server.

  • Max. length=255

communication method no SSL and TCP/IP, SSL, XTS and TCP/IP, XTS, TCP/IP, HTTP, HTTPS XTS and TCP/IP This defines which standard method Tamino uses for communication.

If TCP/IP is used in combination with XTS or SSL, XML requests can be sent to the server via XTS and TCP/IP. (Note that using SSL requires a special certificate)

If XTS or SSL are used, the XML port is not allocated and XML requests can only be sent via XTS.

If TCP/IP is used, the XML XTS port is not allocated and XML requests can only be sent via TCP/IP.

If HTTP or HTTPS is used, property HTTP port must be set.

SSL certificate file no max. length 1023 none Specifies the file name of the server's certificate.  
SSL key file no max. length 1023 none Specifies the file name of the server's key. Optional. The key can also be included in the certificate file.
SSL password no max. length 1023 none Holds the pass phrase of the server's SSL key. Optional. Used to decrypt the file specified in SSL key file, if this file is encrypted.
SSL CA file no max. length 1023 none Specifes the file name of the trust file To be used for certificate base authentication and encryption
SSL certificate chain verification depth no 1023 1 Specifes the maximum depth of chained certificate evaluation  
SSL verify_client no yes, no no Indicates whether the client is to be authenticated by the Tamino server via SSL  
deprecated features yes tolerate, log, log and reject log Specifies how Tamino reacts to the usage of deprecated features. It can react by executing the request and writing an error to the session's job log (log), by additionally rejecting the request which uses the deprecated feature (log and reject), or by silently executing the request (tolerate).  
unbuffered no none, all, database, journal none This property specifies which parts of a Tamino database are handled with unbuffered I/O. The property usually increases I/O times but removes the need for synchronization on devices. value database: means data spaces and index spaces in this context
overwrite XTS registration no yes, no no This switch controls whether the Tamino server should remove existing XTS directory service entries for the server and create new entries during startup. Before setting this value to "yes", check that no database with the same name is active on another node, using the same XTS directory server. You would disable any client communication with such a database.
incremental backup yes yes, no no This switch controls whether an incremental backup can be made for the database.  

XML Properties

Name Dynamic Allowed Values Default Value Description Additional Information
XQuery document cache size yes   20 Specifies the capacity of the document cache that is used for XQuery processing. Document caching improves the performance of certain queries like join queries where the sorting is done via an index. Also certain XQuery update statements can benefit from a big document cache. The capacity of the XQuery document cache is specified in MB.
word fragment index no yes, no no If this is set to yes, a word fragment index is maintained.

Maintaining a word fragment index can be very time- and resource-intensive, but will increase performance for certain query types.

For read-only databases (e.g. replication databases), the word fragment index parameter is displayed, but cannot be modified.

XML maximum sessions no 0 - 100000 100 The maximum number of XML sessions that can be open at the same time. A sessionless request counts as a session for the execution time.
XML max simultaneous requests no 150 - 10000 0 Specifies the size of the queue of free XML request entries and therefore limits the maximum numbers of simultaneous requests that can be accepted by the Tamino Server. The default value (0) means that the actual value of the property is computed by Tamino at startup time. The value for a database with default settings is 157 (100 + XML work threads + XML dynamic work threads + 2).
XML work threads no 1 - 1024 5 The number of threads used to process XML commands. Requests are queued if there are no XML work threads available.
X-Node default encoding no supported encoding ISO-8859-1 The encoding that external data sources which are accessed by Tamino use for their data. Can be overwritten within the schema definition where the mapping is specified.
X-Node default password no Character string (max. 128 characters) guest The password used for ODBC connections if no other password is specified. Can be overwritten within the schema definition where the mapping is specified.
X-Node default user no Character string (max. 128 characters) guest The user-ID used for ODBC connections if no other user ID is specified. Can be overwritten within the schema definition where the mapping is specified.
default tokenizer no white space-separated, Japanese white space-separated Specifies the component that is used to break strings into words.  
default encoding no Encoding names (see list box)specified in the IANA registry ISO-8859-1 Specifies the encoding used for responses from Tamino if no explicit encoding is requested.  
XML document default encoding no UTF-8 and ISO-8859-1 UTF-8 Specifies the encoding that is assumed for a received document if the encoding is not specified otherwise.  
stemming index no yes, no no Specifies whether or not a stemming index is maintained. A stemming index speeds up text retrieval operations that use stemming functionality. For read-only databases, the stemming index parameter is displayed, but cannot be modified.
markup as delimiter no yes, no, mixed no Specifies how markup is treated. If set to "yes", markup is treated as a delimiter for text (i.e. markup is handled like white space). If set to "mixed", markup is not treated as a delimiter in mixed-content elements. If you change this property, it is necessary to recreate all text indexes.
authentication no web server, tamino, none web server Specifies whether authentication is performed by the web server, by Tamino, or not at all. Please refer to the section Tamino Authentication for further information about this property.
XML maximum request duration yes 20 - 2592000 300 The maximum duration of each request is limited to the specified number of seconds. After this period, the request terminates with an error, but the transaction is not rolled back.
queue next request yes yes, no yes Specifies whether a subsequent request in a session is allowed even if the result of the previous request has not been completely processed. If set to "yes", a subsequent request in a session is allowed while the previous request is still active. If set to "no", a subsequent request in a session is not allowed if the previous request is still active.  
reject xsi:type no yes, no yes Rejects xsi:type attribute in element validation.  
text index word length no 32-250 64 Specifies the maximum length for text index entries.  
XML text index type no single word, double word double word Specifies if a text query may contain one or two words (single-word index or double-word index). Usage of three or more word queries cannot be an indexed search, thus resulting in low performance.
request log folder no - - This is the folder/directory where XML request log files are stored. The default folder for the request log is the reserved location, if no request log folder is specified.
request log yes off, full, requests off This property specifies whether requests to Tamino are logged to a file. Logging can be restricted to the pure request (requests), or the requests with all data sent to Tamino (full). The default is that no logging is performed (off).  
request log file count no 0 - 999 2 This is the maximum number of XML request log files written. If 0 is specified, XML request logging is turned off.  
request log file maximum size no 0 - 2997152 1 This is the maximum size of an XML request log file (in MB). If this size is reached, Tamino switches to a new request log file. If the last log file is full, Tamino switches to the first one.  

Port Properties

Port numbers should only be changed if there is a special reason to do so. Otherwise, it is recommended to take the default, as Tamino handles port allocation dynamically. For further information, see section Set the Range of Port Numbers.

Name Dynamic Allowed Values Default Value Description Additional Information
replication port no 0 or 1024 - 65535 0 (dynamic allocation) The number of the port used for access to the Tamino server for replication databases

Only used by replication databases.

A value of 0 means that the port number is allocated dynamically at database startup. If you do not use the value 0, the number

  • should be taken from the range of static port numbers defined during installation or with the Port Range option

  • should be changed if there are conflicts with other applications

XML port no 0 or 1024 - 65535 default from static port range The number of the port used for XML access to the Tamino server via pure TCP/IP

A value of 0 means that the port number is allocated automatically. If you do not use the value 0, the number

  • should be taken from the range of static port numbers defined during installation or with the Port Range option

  • should be changed if there are conflicts with other applications

administration port no 0 or 1024 - 65535 0 (dynamic allocation) The number of the port used for access to the Tamino server for all administration actions

A value of 0 means that the port number is allocated dynamically at database startup. If you do not use the value 0, the number

  • should be taken from the range of static port numbers defined during installation or with the Port Range option

  • should be changed if there are conflicts with other applications

XML XTS port no 0 or 1024 - 65535 0 (dynamic allocation) The number of the port used for XML access to the Tamino server when using Software AG's extended transport service for XML access, including encrypted communication via SSL.

A value of 0 means that the port number is allocated dynamically at database startup. If you do not use the value 0, the number

  • should be taken from the range of static port numbers defined during installation or with the Port Range option

  • should be changed if there are conflicts with other applications

HTTP port no 0 or 1024 - 65535 default from static port range The number of the port used for XML access to the Tamino server when using native HTTP or HTTPS communication.

A value of 0 means that the port number is allocated automatically. If you do not use the value 0, the number

  • • should be taken from the range of static port numbers defined during installation or with the Port Range option

  • • should be changed if there are conflicts with other applications

X-Tension Properties

Name Dynamic Allowed Values Default Value Description Additional Information
X-Tension Java Options no Character string (max. 255 characters) none This is used to specify optional properties for the JVM that is started when X-Tension Java usage is turned on. The syntax of the string is as follows: The first character of the string serves as the delimiter for the options that follow. For example: ?opt1?opt2?opt3 results in the options opt1, opt2 and opt3.
X-Tension Java usage no yes, no yes If this switch is set to yes, the X-Tension Java infrastructure is enabled. If this switch is set to no, Java-based X-Tensions cannot be installed, modified, upgraded or executed, even if they were installed before the switch was set to no.  
X-Tension COM usage no yes, no yes If this switch is set to yes, the X-Tension COM infrastructure is enabled. If this switch is set to no, COM X-Tensions cannot be installed, modified, upgraded or executed, even if they were installed before the switch was set to no.  
X-Tension direct usage no yes, no yes If this switch is set to yes, the X-Tension Direct infrastructure is enabled. If this switch is set to no, Direct X-Tensions cannot be installed, modified, upgraded or executed, even if they were installed before the switch was set to no.  

Displaying and Modifying Database Properties

Start of instruction setTo display/modify database properties

  1. Expand the database for which you want to display/modify the properties.

  2. Select the Properties object to display information about all of the database properties, or expand the Properties object and select a group (Server, X-Tension, XML or Ports) to display specific information.

    The information displayed includes (where appropriate) the property name, the effective value, the configured value, units, high water mark and the time it occurred (useful for database tuning), and information about whether a property is dynamic or not. A property is dynamic if the new value becomes immediately effective when the database is running. New values for non-dynamic properties become effective after the next restart of the database. If the value displayed under high water marks approaches the maximum configured value for a property, it may be advisable to specify a new maximum value to ensure continued good performance.

  3. Select a group and choose Modify from the group's context menu. A page containing the group properties appears.

    graphics/modprops.png

  4. Enter new values for properties you want to change in the Configured Value column or select settings from the drop-down list boxes. Placing the cursor over the question mark icon in the Details column displays a tool tip that includes a brief description of the property together with its minimum, maximum and default values. If you choose All Defaults, all of the properties are reset to their default values/settings.

  5. Choose OK to apply the changes.

  6. If you have changed a non-dynamic property, a confirmation screen with the option to stop and restart the database is displayed. You can either choose Restart to change the property and initiate the stop and restart, or choose Do not Restart to skip the stop and restart process.