MaxDB configuration files
This page gives an overview of the most important configuration files of MaxDB.
dbm.upc/<database name>.upc
dbm.cfg
dbm.mmm
<database name>.dbm.shi/<database name>.dbm.shm
parameter file
dbm.upc/<database name>.upc
This is a configuration file of the database manager - it is called user profile container. This original file is named <database name>.upc and is located in directory <independent_data_path>\config. A copy of this file is called dbm.upc and located in the rundirectory of the database instance. This file contains encrypted information about the DBM and SYSDBA user.
For more information see User concept and User Profile Container.
back to top
dbm.cfg
This is another configuration file of the database manager. In this file database manager parameters are stored, which are set with command dbm_configset.
back to top
dbm.mmm
This file contains the backup media definition. Each backup medium defined in DBMGUI or DBMCLI is stored in this file. You can get a list of all stored media with command medium_getall.
back to top
<database name>.dbm.shi/<database name>.dbm.shm
These binary files are located in <independent_data_path>/wrk and are neeeded for shared memory usage by the dbmserver.
From versions
- 7.6.04.17, 7.6.05.12, 7.6.06 and newer patches
- 7.7.02.22, 7.7.03.26, 7.7.04.30, 7.7.06.07, 7.7.07
onwards the location of the *.dbm-Files has been moved to /var/lib/sdb to overcome problems with <independent_data_path>/wrk being located on a NFS mounted filesystem.
Also the location can be manually configured by modifying the configuration file /etc/opt/sdb, section [Environment] by adding parameter
SDBDBM_IPCLOCATION=<dbmipc_path>
See note 1041650 for details.
The two files serve different purposes and contain (among other) these information:
<dbname>.dbm.shi
- located in <indep_data>/wrk, /var/lib/sdb or configured path (see above)
- platform and version information (ASCII text at start of file)
- PIDs of all DBM Servers that are attached to this
- lock administration of ShM
- layout administration of ShM
<dbname>.dbm.shm
- located in <indep_data>/wrk, /var/lib/sdb or configured path (see above)
- usage data divided into lines of different types
- ShM lets DBM Servers cooperate PER DATABASE only!
- DBM Servers that run without database (inst_reg, db_enum,...) do not use it.
- No communication between DBM Servers from different databases
back to top
parameter file
The parameter file of the database is located in directory <independent_data_path>/config and is called <database name>. When database parameters have been changed and the database instance is re-started into ONLINE mode, a new version of the parameter file is created. These versions are called <database name>.###
The parameter file is a binary file and must only be changed using database manager commands (e.g. using DBMGUI od DBMCLI).
back to top | 
