Version 7.4.4
 —  Space Calculation  —

Estimating the Sort Dataset

Option "S" (Sort) displays the Sort Storage menu:

 08:44:07         *****  A D A B A S   BASIC  SERVICES  *****       2005-11-23
                                - SORT STORAGE -                      PSPS002

                            Code  Service
                            ----  -------------
                             I    ADAINV
                             L    ADALOD load
                             U    ADALOD update
                             ?    Help
                             .    Exit
                            ----  -------------

              Code ......... _
              File Number ..
              Database ID .. 105    (RD-MPM105)

The functions on this menu are used to estimate the storage needed on SORT for the utility function chosen.

This document covers the following topics:


ADAINV Sort

The storage needed on SORT for the ADAINV utility function is estimated using the following screen:

08:48:25         *****  A D A B A S   BASIC  SERVICES  *****       2005-11-23
                       -  Sort Storage      - ADAINV -      -         PSPSS02

   File Number .................................. 16
   Number of records ( Default:  TOPISN ) ....... 25649     (reduce number if
   Name of the field to be processed ...........               field is NU)

   Average compressed descr. length (in Bytes)
   of the biggest descriptor ....................
   Occurences of periodic groups ................ 1
   Occurences of multiple fields ................ 1
   SORT device-type ............................. 8391
   LWP-parameter ................................ 1000000
   Database-ID .................................. 105
   Password (if required) .......................

  --------------------------------------------------------------------------

   Required number of blocks (minimum) ..........
   Required number of cyls.  (minimum) ..........

  PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
  Help               Exit      Dis Field                            Menu

PF4 (Dis Field) invokes a Field Selection screen:

08:48:27         *****  A D A B A  +----------------------------------+ 05-03
                       -  Sort Storag |                                  | 02
                                      |  Please mark with 'X':           |
                                      |                                  |
   File Number ...................... |              Field               |
   Number of records ( Default:  TOPI |  Selection   Name      Length    | if
   Name of the field to be processed  |  ---------   ----      ------    |
   Average compressed descr. length ( |     _         LC         250     |
   of the biggest descriptor ........ |     _         LG         65_     |
   Occurences of periodic groups .... |     _         LK         90_     |
   Occurences of multiple fields .... |     _         LM         250     |
   SORT device-type ................. |     _         LQ         8__     |
   LWP-parameter .................... |     _         LR         8__     |
   Database-ID ...................... |     _         LS         8__     |
   Password (if required) ........... |     _         LT         8__     |
  ----------------------------------- |     _         LU         8__     | -
   Required number of blocks (minimum |     _         LV         96_     |
   Required number of cyls.  (minimum |     _         LI         32_     |
                                      |     _         L3         14_     |
                                      |                                  |
                                      |  Enter----PF3------PF7-----PF8-  |
  PF1----- PF2------ PF3------ PF4--- |           Back      <       >    | --
  Help               Exit      Dis Fi +----------------------------------+

Top of page

ADALOD LOAD Sort

For the ADALOD LOAD calculation, the default number of records is MAXISN rather than TOPISN as it is for the ADAINV function:

08:49:51         *****  A D A B A S   BASIC  SERVICES  *****       2005-11-23
                       -  Sort Storage  - ADALOD UPDATE -   -         PSPSS02

   File Number .................................. 16
   Number of records ( Default:  0      ) .......           (reduce number if
                                                               field is NU)

Top of page

ADALOD UPDATE Sort

For the ADALOD UPDATE calculation, the default number of records is 0:

08:50:42         *****  A D A B A S   BASIC  SERVICES  *****       2005-11-23
                                - TEMP STORAGE -                      PSPT002

                            Code  Service
                            ----  ------------------
                             I    ADAINV
                             L    ADALOD load/update
                             U    ADALOD delete
                             ?    Help
                             .    Exit
                            ----  ------------------

              Code ......... _
              File No. ....: 16
              Database ID .. 105    (RD-MPM105)

Top of page