Entering content frame

This graphic is explained in the accompanying text How to Create a New Database Instance (db_create Command) Locate the document in its SAP Library structure

Use

You create the new database instance HOTELDB using the Database Manager CLI.

Procedure

...

       1.      Create the HOTELDB database instance and the first DBM operator DBM with password DBM:

dbmcli db_create HOTELDB DBM,DBM

       2.      For the following steps, create a script called HOTELDB_new.txt with the contents below:

param_startsession
param_init
param_put MAXUSERTASKS 5
param_put MAXSERVERTASKS 15
param_put CACHE_SIZE 3000
param_put MAXDATAVOLUMES 5
param_checkall
param_commitsession
param_addvolume 1 LOG LOG_001 F 2000
param_addvolume 1 DATA DAT_001 F 10000
db_admin
db_activate DBA,DBA
load_systab

Note

Modify the values of the database parameters according to your requirements.

       3.      In the Database Manager, execute the DBM commands defined in the script:

dbmcli -d HOTELDB -u DBM,DBM -i HOTELDB_new.txt

Result

The HOTELDB database instance has been created with one data volume (name DAT_001) of type File and a size of 10000 pages, one log volume (name: LOG_001) with a size of 2000 pages, a maximum of 5 data volumes, a cache size of 3000 pages, 15 server tasks, and 5 user tasks. The name of the database system administrator is DBA with password DBA.

The operational state of the database instance is ONLINE.

 

Leaving content frame