www.mimer.com/developer

Generating System Databanks and SYSADM

---

You generate the Mimer SQL system databanks SYSDB, TRANSDB, LOGDB and SQLDB by running the SDBGEN program.

When you run SDBGEN, it also generates the system administration ident SYSADM.

SDBGEN loads the system tables and defines the data dictionary views detailed in the Mimer SQL Reference Manual.

Note: A databank created for one SYSDB cannot be accessed by using a different SYSDB even if identical data dictionary definitions are created in it.

SDBGEN

The SDBGEN command has two purposes. Either to create a new set of system databank files, or to upgrade database files created in an earlier version of Mimer SQL to version 8.2.4. Upgrade can be done for databank files created by Mimer SQL version 7.1 and later.

For more information on upgrading, see Upgrading a Database.

SDBGEN Syntax

Assuming that SET COMMAND MIMLIB8:MIMER is done, you run SDBGEN from the command line, using arguments.

The syntax for creating databank files is as follows:

SDBGEN [/PASSWORD=passw] [dbase] [syssz] [tfn] [tsz] [lfn] [lsz] [sfn] [ssz]

sdbgen Command-line Arguments

Argument	Function
/PASSWORD=password	Password for SYSADM
dbase	Database name
syssz	Size of SYSDB
tfn	Filename for TRANSDB
tsz	Size of TRANSDB
lfn	Filename for LOGDB
lsz	Size of LOGDB
sfn	Filename for SQLDB
ssz	Size of SQLDB

Generating the System Databanks

For example, the following SDBGEN call:

 $ SDBGEN /PASSWORD=ooops my_database
 

will generate a database named my_database and the database administration ident SYSADM will be assigned the password ooops.

If you do not enter the password parameter, SDBGEN will prompt you for all parameters that are missing, including the password for SYSADM.

If you enter the password parameter, SDBGEN will not prompt for any missing parameters, it will use default values.

If you do not enter the dbase parameter, the environment variable MIMER_DATABASE is used to determine which database the databank files should be created for.

Note: When establishing Mimer SQL databases on an OpenVMS node, you must have write access to the file pointed to by the logical name MIMER_SQLHOSTS.

Setting the Initial Size

You can specify the initial size for each of the Mimer SQL system databanks.

The size for the databanks is specified in Mimer SQL pages. The size of a Mimer SQL page is 2 kilobytes.

SYSADM Password

When you run SDBGEN, the database administration ident SYSADM is created and you must specify a password (passwords are case-sensitive) for this ident.

SYSADM Password Case

DCL converts all VMS-style commands to uppercase and all UNIX-style commands to lowercase. To control the case used in your password, you may have use quotes.

The following table shows how to use quotes to set the password case.

Entering:	Sets the password to:
SDBGEN/PASS=oops	OOPS
SDBGEN/PASS="oops"	oops
SDBGEN -p OOPS	oops
SDBGEN -p "OOPS"	OOPS

SYSADM Password Security

For security reasons, the password specified for SYSADM is not echoed on the screen when you enter it.

You should change the password at appropriate intervals using Mimer SQL with the ALTER IDENT statement.

Caution: Take care to safeguard the SYSADM password, because if it is lost, it cannot be retrieved from the system and it is not possible to set a new one.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se