Skip Top Menu Navigation
Skip Top Menu Navigation

The FREE Enterprise Open Source Database

  Software Tools Interfaces Development Documentation
 

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

How to work with SAP DB

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.