Creating a Mimer SQL Database
Once the Mimer SQL software is installed, the database environment must be created. This involves the following activities:
- registering the name of the database on each node in the network from which it is to be accessed.
A database must be set up as a local database on the node it resides on. The local definition for a database involves specifying parameters that configure the database server that is started for it. A database must also be identified as a remote database on each other node in the network from which it is to be accessed. The remote definition for a database involves specifying network communication parameters.
- generating the Mimer SQL system databanks SYSDB, TRANSDB, LOGDB and SQLDB as well as the database administration ident called SYSADM.
- creating idents and data objects in the database using the data definition statements in Mimer SQL.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40