# 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)