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
XML Properties
Port Properties
X-Tension Properties
Displaying and Modifying Database Properties

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 - (2³² -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

To display/modify database properties

Expand the database for which you want to display/modify the properties.
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.
Select a group and choose Modify from the group's context menu. A page containing the group properties appears.
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.
Choose OK to apply the changes.
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.