Copying the Parameter File from Another Database Instance


You can use a copy of the parameter file of an existing database instance (source database instance) when you create a database instance (target database instance). The source database and target database must be located on the same computer.

You absolutely must change the parameter value for the run directory of the new database instance. Otherwise the source database and the target database will overwrite each other’s data in the run directory.

You also have to define the paths for the data and log volumes for the new database instance.

To read the prerequisites, see Database Manager CLI, param_copy

See also:

Creating and Configuring a Database Instance

Changing the Values of Database Parameters

Concepts of the Database System, Configuration Files, Database Parameters

Glossary, Run Directory, Volume


You want to create a database instance TESTDB on the local computer. It should have a nearly identical configuration to that of the database instance DEMODB on the same computer. However, you do want to change the parameter CACHE_SIZE to 1000.

The run directory of TESTDB should be created under the path C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\TESTDB.

You want to define a data volume (type: File; name: DISKD0001; size: 32768 pages) and a log volume (type: file; name DISKL0001; size: 6400 pages).

The database system administrator should have the user name DBADMIN and the password SECRET.



       1.      Call the Database Manager CLI, create the new database instance TESTDB, define the first DBM operator with user name DBM and password DBM:

>dbmcli db_create TESTDB DBM,DBM


       2.      Call the Database Manager CLI in session mode, log on as operator DBM with the password DBM, connect to the database instance TESTDB:

>dbmcli -u DBM,DBM -d TESTDB

dbmcli on TESTDB>

       3.      Open a parameter session:

dbmcli on TESTDB>param_startsession


       4.      Copy the parameter file from DEMODB:

dbmcli on TESTDB>param_copy DEMODB


       5.      Change the database parameter CACHE_SIZE to the value 1000:

dbmcli on TESTDB>param_put CACHE_SIZE 1000


       6.      Change the database parameter RUNDIRECTORY to the value C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\TESTDB:

dbmcli on TESTDB>param_put RUNDIRECTORY "C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\TESTDB"


       7.      Check all database parameters:

dbmcli on TESTDB>param_checkall


       8.      Confirm changes to the database parameter file:

dbmcli on TESTDB>param_commitsession


       9.      Create data volume No. 1 with name DISKD0001, type FILE, size 32768 pages:

dbmcli on TESTDB>param_addvolume 1 DATA DISKD0001 F 32768


   10.      Create log volume no. 1 with name DISKL0001, type FILE, size 6400 pages:

dbmcli on TESTDB>param_addvolume 1 LOG DISKL0001 F 6400


   11.      Transfer the database instance to the ADMIN operational state:

dbmcli on TESTDB>db_admin


   12.      Initialize the new database instance and create the database system administrator with user name DBADMIN and password SECRET:

dbmcli on TESTDB>db_activate DBADMIN,SECRET


Load the system tables:

dbmcli on TESTDB>load_systab


0,OK: everything works fine

0,""c:\program files\sdb\maxdb1\bin\x_python" "c:\program files\sdb\maxdb1\env\" -R "c:\program files\sdb\maxdb1" -d DEMODB -u DBADMIN,*"

Removing obsolete objects

Installing Loader tables

Installing messages and help


Installation successfully finished



The database instance TESTDB has been created on the basis of the parameter file of DEMODB and the values of the parameters named in the scenario have been changed.

TESTDB is in the ONLINE operational state.