You create and save a script file containing all DBM commands you want to execute.
You then call Database Manager, specifying this script file.
You want to create a new database using a script file.
The new database is to have the name DEMODB and be created on the local computer.
You define the first DBM operator with the name DBM and password DBM, as well as the database system administrator DBADMIN with password SECRET.
You want to change the values for the database parameters SessionTimeout, CacheMemorySize, UseExtendedOracleSQLMode, MaxDataVolumes, and MaxUserTasks.
You want to create a data volume named DISKD0001 of type File with 32768 pages and a log volume named DISKL0001 of type File with 6400 pages.
You also want the system to
Automatically update the statistics of the database
Automatically expand the data area when the fill level reaches 90% (default value)
Load the system tables
Load the demo data
Switch on overwrite mode for the log area
Create the script file demoscript.txt and save it here:
C:\test\DBM
Copy the following template to the script file and save your entries:
db_create DEMODB DBM,DBM
param_startsession
param_init OLTP
param_put SessionTimeout 0
param_put CacheMemorySize 1000
param_put MaxDataVolumes 64
param_put MaxUserTasks 10
param_checkall
param_commitsession
param_addvolume 1 DATA DISKD0001 F 32768
param_addvolume 1 LOG DISKL0001 F 6400
db_admin
db_activate DBADMIN,SECRET
load_systab
auto_update_statistics ON
auto_extend ON
load_tutorial
db_execute SET LOG AUTO OVERWRITE ON
Call Database Manager CLI with the option for executing the script file:
>dbmcli -i "C:\test\DBM\demoscript.txt"
>db_create DEMODB DBM,DBM
OK
---
>param_startsession
OK
---
>param_init OLTP
OK
---
>param_put SessionTimeout 0
OK
---
>param_put CacheMemorySize 2500
OK
---
>param_put UseExtendedOracleSQLMode NO
OK
---
>param_put MaxDataVolumes 64
OK
---
>param_put MaxUserTasks 10
OK
---
>param_checkall
OK
---
>param_commitsession
OK
---
>param_addvolume 1 DATA DISKD0001 F 32768
OK
---
>param_addvolume 1 LOG DISKL0001 F 6400
OK
---
>db_admin
OK
---
>db_activate DBADMIN,SECRET
OK
---
>auto_update_statistics ON
OK
---
>auto_extend ON
OK
---
>load_systab
OK
0,OK: everything works fine
0,""c:\program files\sdb\maxdb1\bin\x_python" "c:\program files\sdb\maxdb1\env\lsystab.py" -R "c:\program files\sdb\maxdb1" -d DEMODB -u DBADMIN,*"
Removing obsolete objects
Installing Loader tables
Installing messages and help
Installing SYSDBA tables
Installing comments for SYSDBA tables
Installing precompiler tables
Installing system tables for R3 backup information
Installing ODBC tables
Installing system tables for ORACLE (V7) mode
Installing data dictionary tables and views
Installing synonyms for oracle system tables
Installing comments on oracle system tables
Installing tables for WebAgent
Installing tables for Repository
Installing DOMAIN tables
Installing comments for DOMAIN tables
Installing Views as replacement for SHOWs
Installing Database Manager tables
Installing SYSINFO tables
Installing comments for SYSINFO tables
Installing support for UDE (User Defined Extensions)
Installing tables for JDBC Database Metadata
Installing tables for SQLDBC Database Metadata
Installing additional triggers
==================================
Installation successfully finished
==================================
---
>load_tutorial
OK
0,OK: everything works fine
0,""c:\program files\sdb\maxdb1\bin\x_python" "c:\program files\sdb\maxdb1\env\../demo/ltutorial.py" -R "c:\program files\sdb\maxdb1" -d DEMODB -u DBADMIN,*"
HOTEL
==================================
Installation successfully finished
==================================
---
>db_execute SET LOG AUTO OVERWRITE ON
OK
---
Creating and Configuring a Database
Database Manager CLI, -i, -ic, -is, -ics: Name of the Input Script