How to Install and Drop SAP DB Instances

	SAP DB
	The FREE Enterprise Open Source Database

You Are Here: SAP DB > Documentation > How to Install and Drop SAP DB Instances

SAP DB is now SAP MaxDB! For more information, visit the SAP MaxDB pages in the SAP Developer Network.

How to Install and Drop SAP DB Instances

How to install a database instance

How to drop a database instance

How to produce number generators

How to backup and recover database with the Database Manager CLI

How to install a SAP DB instance

First create a new database instance and specify the First Database Manager Operator:
dbmcli db_create <database_name> <DBM_user>,<DBM_password>

For this step there are several alternatives:

If there are several versions of the database software installed on your computer, specify the version to be used, indicating the option
-R <dependent_path>.
To install a new database instance remotely, use the option
-n <server_node> for specifying the remote computer, and identify yourself towards the operating system of this computer.

dbmcli -n <server_node> db_create <database_name> <DBM_user>,<DBM_password> <OS_userid>,<OS_password>
(to be edited in a single line)
A Unix operating system does not distinguish between remote and local communication. Therefore, you always must identify yourself towards the operating system. If you create a new database locally, you can avoid the identification using the option -s:

dbmcli -s db_create <database_instance> <DBM_user>,<DBM_password>
(to be edited in a single line)

Use a Database Manager CLI script to complete the installation.

dbmcli -d <database_name> -u <DBM_user>,<DBM_password> 
-i <script_file>

(to be edited in a single line)

Sample script:

param_startsession

     param_init

     param_put MAXUSERTASKS 5

     param_checkall

     param_commitsession

     param_addvolume 1 LOG LOG_001 F 2000

     param_addvolume 1 DATA DAT_001 F 10000

     db_admin

     util_connect

     util_execute INIT CONFIG

     util_activate <SYSDBA_userid>,<SYSDBA_password>

	 util_release

     load_systab -ud <DOMAIN_password>

Suit the parameter values to your needs.

The user SYSDBA is the first Database User. He can define other users for working with the newly created database instance.

How to Drop a SAP DB Instance

1. Stop the database instance

dbmcli -d <database_instance> 
-u <DBM_userid>,<DBM_password> db_stop

(to be edited in a single line)

2. Delete the database instance on the database server

dbmcli -d <database_instance> 
-u <DBM_userid>,<DBM_password> db_drop

(to be edited in a single line)

Result: The files of the specified database instance have been deleted.

Search / Contact Info

Questions or comments about the Web site? Contact the webmaster.

This site is sponsored by SAP AG.