7. PARAMETERS › 7.3 Unit-Level Parameters › 7.3.4 IMS Processing Options (IMSOPS) › 7.3.4.5 TABLES Statement

7.3.4.5 TABLES Statement

This statement is optional. It is used by the IMS Log Data
Reduction (LDR) programs to calculate the sizes of various
storage pools used during processing.

If you are using Mainview for IMS Online, and if IMF or IMFx
is coded on all OPTIONS statements (see OPTIONS statement
description below), the TABLES statement is required and will
be checked for proper syntax.  However, the information will
not be used.

The IMS Log Data Reduction programs reduce IMS log data to
produce IMS transaction records.  These programs use storage
pools for much of their processing.  The default execution
parameters define tables that should accommodate almost any
standard IMS system's daily volume.  You may elect to alter
the table parameters to increase table sizes for larger
systems, or to decrease table sizes for smaller systems in
order to conserve virtual memory.  If the Analyzer executes
on an z/OS or higher system, the storage for the necessary
tables will be obtained dynamically from above the 16MB line.

Use the TABLES statement to specify table sizes.  The format
of the TABLES statement is as follows.

For IMS Version 6.1 and above:

TABLES ldrrn sdrrn emhb rttbl trpool

where the parameters are:

 ldrrn  -  The number of long message queue records in the
           largest IMS system defined in the IMSOPS member
           with an OPTIONS statement.

           The minimum value for this parameter is 0 and the
           maximum value for this parameter is 999999.

           Notes: Set this parameter to 0 if you are using
                  Mainview for IMS Online.

                  The ldrrn pool is managed in such a way
                  that it will expand to meet increased
                  workload demand.  Therefore, the default
                  value is usually enough.

           DEFAULT: 5000

 sdrrn  -  The number of short message queue records in the
           largest IMS system defined in the IMSOPS member
           with an OPTIONS statement.

           The minimum value for this parameter is 0 and the
           maximum value for this parameter is 999999.

           Notes: Set this parameter to 0 if you are using
                  Mainview for IMS Online.

                  The sdrrn pool is managed in such a way
                  that it will expand to meet increased
                  workload demand.  Therefore, the default
                  value is usually enough.

           DEFAULT: 5000

 emhb   -  The number of EMHBs in the largest IMS system
           defined in the IMSOPS member by an OPTIONS
           statement.

           The minimum value for this parameter is 0 and the
           maximum value for this parameter is 999999.

           Note:  This parameter is no longer used and is
                  kept as a placeholder for compatibility
                  purposes.

           DEFAULT: 0

 rttbl  -  The largest number of fast-path recovery tokens in
           use at any one time by any IMS system defined in
           the IMSOPS member by an OPTIONS statement.

           This value varies based on the number of users and
           regions defined and the degree to which your
           system is tuned.  Consider using 3072 as an
           initial value and adjusting it based on the Normal
           Termination Report's FASTPATH RT TBL MAX USE
           value.

           Note:  When processing IMS Version 6.1 and above,
                  this parameter is no longer used. It should
                  be set to a value of 0 as a placeholder for
                  compatibility purposes.

           DEFAULT: 0

 trpool -  This value defines the number of TRAN cells that
           will be obtained in the primary allocation.  The
           TRAN cells are used for construction of the
           transaction records that are created by the Log
           Data Reduction programs.  It should typically be
           set to the largest number of transactions that can
           be active at any one time by any IMS system
           defined in the IMSOPS member by an OPTIONS
           statement.

           This value varies based on the number of users and
           regions defined and the degree to which your
           system is tuned.  Consider using the default as an
           initial value and adjusting it based on the Normal
           Termination Report's Section 5.3 Transaction
           Pool "High Water Mark" value.

           The minimum value for this parameter is 0 and the
           maximum value for this parameter is 999999.

           Note:  Set this parameter to a number greater than
                  0 for IMS systems operating at IMS 6.1 or
                  higher.

                  The TRAN pool is managed in such a way that
                  it will expand to meet increased workload
                  demand.  Therefore, the default value is
                  usually enough.

                  Caution should be exercised when setting
                  the value of trpool.  An extremely large
                  value could cause GETMAIN failures because
                  it exceeds the data-center-specified limit
                  of above-the-16M-line storage allowed. This
                  limit is set by the data center in the
                  IEFUSI exit.

           DEFAULT: 10000