API Management 10.4 | Administering CentraSite | Configuring CentraSite | Maintaining the CentraSite Internal Database | Database Configuration Parameters
 
Database Configuration Parameters
You can configure various properties of CentraSite's internal database. The available properties are:
Property
Description
buffer pool size
This defines the size of the buffer pool that is used for storing intermediate results during normal processing.
maximum transaction duration
This defines the maximum time, in seconds, that a transaction is allowed to exist.
non-activity timeout
This defines the maximum time, in seconds, that a transaction is allowed to be inactive.
XML work threads
This defines the number of XML-processing threads that be active concurrently in the internal processing engine.
XML maximum sessions
This defines the maximum number of user sessions that CentraSite can process concurrently.
number of backup generations
The number of full backups that CentraSite keeps in parallel. When this number is exceeded, the oldest backup and the corresponding log spaces are deleted.
write_limit
The amount of the modified buffer pool space that triggers a flush (disk write) of the modifications present in the buffer pool. The default for the buffer pool size is 60MB. If this property is set to 0, CentraSite adjusts the flush limit automatically.
replication delay
The time interval (in seconds) after which a replication server is updated. This property is set for a master server and it applies to all replication servers that are defined for the master server.
For each property, the following information is available:
Property
Description
handle
A unique identifier used for internal purposes.
minimum
The minimum allowed value that can be configured for this property.
maximum
The maximum allowed value that can be configured for this property.
default
The value of the property that is to be used if not set explicitly to a specific value.
configured
The value of the property that is to be used when the server is restarted.
current
The value of the property currently used by the active server.
type
The data type of the property. For example, string, numeric, and so on.
unit
The unit of measurement for the property's value. For example, megabytes or seconds.
state
The state of the server. For example, active or inactive.
To examine or modify the database properties, you can run one of the following inoadmin commands in the bin folder in the <CentraSiteInstall_Directory>.
Command
Description
listproperties
Show a list of all of the available database properties and their values.
The information displayed includes (where appropriate) the property name, the maximum and minimum allowed values, the current value, the configured value, and the high water mark.
getproperty <server> <PropertyName>
Show the value of the given property.
If the property name contains one or more spaces, enclose the name in quotes.
setproperty <server> <PropertyName> <PropertyValue> [no]restart
Modify the value of the given property to the given value.
If the property name or property value contains one or more spaces, enclose the name or value in quotes.
The changed value takes effect at the next restart of the CentraSite Registry or Repository. You can cause an automatic restart by specifying restart, otherwise specify norestart.
setproperties <server> <XMLInputFile> [no]restart
Modify the values of several properties to the values specified in the supplied XML file. The XML file must use the same element structure as the XML file created by the listproperties command.
The modified values takes effect at the next restart of the CentraSite Registry or Repository. You can cause an automatic restart by specifying restart, otherwise specify norestart.

Copyright © 2015- 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release