DBMS Service (Database Management System) is a distributed, scalable database engine. It is a core service that manages the persistent storage of SAP J2EE Engine 6.20. It provides for fail-over recovery using replication.
|
|
Server |
|
|
Property Key |
Description |
Default Value |
|
|
|
|
|
DatabaseName
|
This parameter specifies the name of the database. |
InQMyDB |
|
IndexFileBlockSize
|
This parameter specifies the block size of the Index file. |
255 bytes |
|
DataFileBlockSize
|
This parameter specifies the block size of the Data file. |
128 bytes |
|
RecoveryFileBlockSize
|
This parameter specifies the block size of the Recovery file. |
32768 bytes |
|
DataFilePoolSize |
Specifies the size of the pool that contains opened file pointers to the Data file. It denotes the maximum number of threads that can write/read data concurrently to and from the file.
|
30 |
|
RecoveryFilePoolSize |
Specifies the size of the pool that contains opened file pointers to the Recovery file. It denotes the maximum number of threads that can write/read data concurrently to and from the file.
|
30 |
|
IndexFilePoolSize |
Specifies the size of the pool that contains opened file pointers to the Index file. It denotes the maximum number of threads that can write/read data concurrently to and from the file.
|
30 |
|
CacheMinSize
|
Specifies the minimum number of pages in cache. |
1000 |
|
CacheMaxSize |
Specifies the maximum number of pages in cache. If the value is set to –1, all pages are put in cache until Memory Manager notifies that there is not enough memory.
|
2000 |
|
AllowedFragmentation |
Specifies the percentage value of fragmentation allowed.
|
69% |
|
IndexCachePages |
Specifies the number of pages to be stored in the Index cache.
|
50 |
|
IndexBlocksPerPage |
Specifies the number of blocks that an Index page contains.
|
250 |
|
CacheCriticalMemoryLevel
|
Specifies the level of memory usage at which the cache is cleared. |
4 |
|
MachineCapacity |
Specifies the capacity of the particular machine. The greater the value, the more powerful the machine.
|
100 |
|
MemoryOnly |
Specifies if database uses only memory without storing information on the hard disk drive.
|
no |
|
BackupOnStart |
Specifies if database backup is made on server startup.
|
no |
Note:
Whether a server element functions as primary or non-primary server depends on the value of
DependentElement
property of Cluster Manager. For information on this property, refer to
Managers Administration Reference section
of this manual.
DBMS Service can be administered using the Shell commands from the
DBMS
command group as well.
Note: For information on DBMS shell commands, refer to the Shell Commands Reference section.
../cluster/server/services/dbms/properties
DBMS Service properties specified in the
Visual Administrator
section can be set from this property file as well.
The default values for the properties are selected to provide a high-level service. However, different values can be set to improve the performance of the service depending on what the database is used for (that is, reading or writing) and the hardware profile of the machine. For example, if there is enough memory available, CacheMaxSize may be increased so that direct disk usage is reduced.