# empshm

    EMPSHM(1)                                                            EMPSHM(1)

    NAME
           empshm - utility to aid the user in creating parameter files and parti-
           tion files.

    SYNOPSIS
           empshm  |    params    |  outfile
                   |  partitions  |

    DESCRIPTION
           This utility to aid the user in creating parameter files and  partition
           files.   This  is an interactive program which will prompt the user for
           the information needed.

           When invoked with the "params" option empshm will help the user  create
           parameter  files  for  mapping  database  files and locks into specific
           shared memory partitions.

           A parameter file is required for each table that will use  shared  mem-
           ory.  Not all tables however require unique parameter files; tables may
           share the same mapping information for global buffers  and  locks.   If
           mapped  files  are used however unique partition files are required for
           each mapped file because a mapped file  can  associate  only  with  one
           physical database file.

           The  parameter  file  is  made  up  of 5 sections.  These sections are:
           default table, variable-data, index and lock.

           Once all parameter files are created and  the  shared  memory  segments
           have  been  created (with "empadm database shmcreate") and the database
           is not in use, the parameter files can be mapped  to  the  tables  with
           "empadm database params OUTFILE table".  After the mapping is done, the
           parameter file can be discarded (except for the sys_dictionary  parame-
           ter file).

           If  the Empress table sys_dictionary is to reside in shared memory then
           the parameter file produced for  sys_dictionary  must  be  appended  to
           tabzero once the mapping with "empadm database params" is done.

           When  empshm  is  invoked with the "partition" option, it will help the
           user create a partition file setting up shared memory for  a  database.
           The  program  will  prompt  the user for the type of partition required
           (lock manager, global buffer, or mapped  file)  and  depending  on  the
           choice  will  further prompt for details.  The interactive session will
           continue until all partitions are defined.

           "Empshm partitions" can provide defaults and  calculate  size  require-
           ments  for  the user.  It will prompt the user for which partitions are
           needed.

           Please note that the user may create multiple partitions of  each  type
           for  the  database.   A  separate  partition  file is required for each
           database.

           Once the partition file is generated and there  are  no  users  on  the
           database,  locks  should be cleared on the database with "empclrlk" and
           the partition file appended to the tabzero of the  database  that  will
           use  shared memory.  Then the shared memory segment is created with the
           "empadm database shmcreate" utility.

    FILES
           EMPRESS database files

    SEE ALSO
           empadm(1)

           Empress: Database Administrator's Guide

    DIAGNOSTICS
           Error message printed if no outfile specified.

    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.                   EMPSHM(1)