empmkdb
EMPMKDB(1) EMPMKDB(1)
NAME
empmkdb - creates a new EMPRESS database
SYNOPSIS
empmkdb [-b blocksize] [-dfc dfc] [-shmem [shm_key] | -noshmem] [-n]
[-cipher cipher] database
DESCRIPTION
Empmkdb creates a system directory called database if that directory
does not exist. It then creates the necessary files to make that
directory an EMPRESS database.
-b blocksize indicates the block size of the machine in multiples of
512 bytes
-shmem creates a shared memory segment for the database.
-dfc dfc creates a database using a specific Data Format Code
(DFC). dfc describes the characteristics of a system. By
default, empmkdb creates a local database using the
native DFC. For example, a database is designed to be
accessed by a remote host called RH through the Empress
Database Server. If RH has different architecture,
using RH's dfc to create the database will eliminate the
data conversion overhead.
The parameter dfc contains 3 ASCII digits, lse, which
describes the 3 characteristics of a computer:
l the size of a long integer in bytes.
s the size of a short integer in bytes.
e Byte order. Big endian is 0 and little endian is 1.
For example, the dfc of a Sun 4 machine is 420. This
means a long integer is 4 bytes, a short integer is 2
bytes and the byte order is big endian.
-shmem shmkey creates a database and sets up default shared memory
usage. The option requires that a positive numeric key
be passed to it. This value must uniquely identify the
shared memory block. Refer to the Empress: Administra-
tor's Guide for more information on shared memory con-
figuration.
The default configuration will place all locks into
shared memory, the coordinator into shared memory and
create a global buffer for all tables. The configura-
tion file used to define shared memory is found in
$EMPRESSPATH/rdbms/custom/shmzero by default. This file
is appended to tabzero during the database creation.
You can alter this file or specify an alternate file
with the use of the Empress variable MSSHMZERO. By set-
ting this variable to a filename, Empress will append a
different shared memory partition file to tabzero.
If Empress variable MSMKDBSHMEM is set, the database
will be created with shared memory even without -shmem
option specified.
-noshmem When system variable MSMKDBSHMEM is set, empmkdb will
create database with shared memory. If -noshmem is
specified, then the database will be created without
shared emeory.
-n Sets the locking on the data dictionary tables to null.
By default, empmkdb puts record level locking on the
data dictionary tables.
-cipher cipher use cipher to encrypt/decrypt for assigned attributes
value
FILES
EMPRESS database files
SEE ALSO
mkdir(1), empsql(1)
Empress: SQL User's Guide
Empress: Database Administrator's Guide
DIAGNOSTICS
Error diagnostics are printed and no directory or file creation is done
if there is a conflict with existing files or directories.
HISTORY
Written by Empress Software Inc.. All material is copyrighted and
licensed. Use on non-licensed CPUs is prohibited.
Empress 8.62 Empress Software Inc. EMPMKDB(1)