You create the new database instance HOTELDB using the Database Manager CLI.
...
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
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
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.