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)