Entering content frame

Background documentation General Database Parameters Locate the document in its SAP Library structure

The following database parameters in the General group determine the general properties of the database instance:

CACHE_SIZE

Size of the I/O buffer cache in pages

INSTANCE_TYPE

Database instance type

KERNELVERSION

Version of the database software

LOG_MIRRORED

Specifies whether the log area is mirrored, possible values: YES | NO

This parameter is relevant only when you create a mirror volume with the Database Manager CLI.

This value is changed implicitly when you create a mirror volume with the Database Manager GUI.

LOG_SEGMENT_SIZE

Size of a log segment in pages

MAXBACKUPDEVS

Maximum number of files or tape devices in a Group of Parallel Backup Media

The maximum value for MAXBACKUPDEVS is 32.

MAXCPU

Specifies the number of processors across which the user tasks can be distributed

Remember that the operating system resources of your computer must also be free for other processes, not just the database.

If you are using a single processor computer, you should choose a value of 1 for the MAXCPU.

MAXDATAVOLUMES

Maximum number of data volumes

MAXLOCKS

Maximum number of entries in the lock list, in which the locks of all users and their lock requests are stored

MAXLOGVOLUMES

Maximum number of log volumes

MAXUSERTASKS

Specifies the maximum possible number of simultaneous database sessions (user tasks)

If this number has been reached, then no other user can log on to this database instance. For this reason, you must monitor MAXUSERTASKS as a critical operational parameter,

Caution

If you configure this parameter too high, then the space required for addresses rises (particularly the Shared Memory).

RUNDIRECTORY

Run directory of the database instance

Note

You can display more information about the parameters with the Database Manager.

 

Leaving content frame