How to work with SAP DB

	SAP DB
	The FREE Enterprise Open Source Database

You Are Here: SAP DB > 7.3 > Documentation > How To

On this page you can find some notes and instructions on how to administer databases.
New articles will be published from time to time as a response to frequently asked questions in the community.

How to install a database instance

How to drop a database instance

How to produce number generators

How to install a database 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_adddevspace 1 SYS sys_001 F

     param_adddevspace 1 LOG LOG_001 F 2000

     param_adddevspace 1 DATA DAT_001 F 10000

     db_cold

     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 database 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

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

This site is sponsored by SAP AG.