Spool files

Overview

Adabas Audit Data Retrieval uses spool files to store lists and indexes. Adabas Audit Data Retrieval uses spool files of the following type:

  • SPOOL
  • RELOAD
  • INDEX
  • GLOBAL
  • CACHE

Adabas Audit Data Retrieval requires at least one spool file of each type. When needed, additional spool files can be allocated manually or automatically.

Types of spool files

These are the four types of spool files used by Adabas Audit Data Retrieval:

  1. Type SPOOL contains lists.

    The Adabas Audit Data Retrieval online spool comprises one or several files of this type.

  2. Type RELOAD contains reloaded lists.

    The Adabas Audit Data Retrieval reload spool comprises one or several files of this type.

  3. Type INDEX contains indexes.

    The Adabas Audit Data Retrieval index spool comprises one or several files of this type.

  4. Type GLOBAL contains global indexes.

    The Adabas Audit Data Retrieval global index spool comprises one or several files of this type.

  5. Type CACHE contains 4-MB objects of data of lists that have been reloaded automatically when accessing the hit pages of offline lists.

    The Adabas Audit Data Retrieval cache spool comprises one or several files of this type.

Spool file models

Spool file models enable Adabas Audit Data Retrieval to allocate spool files automatically as required.

Adabas Audit Data Retrieval allocates required spool files when it runs out of storage space in the existing spool files. Adabas Audit Data Retrieval allocates these spool files based on the model spool definitions created using option D.1.

A model spool file does not require any storage space while its status is MODEL.

Important

To prevent the system from running out of storage space, you must ensure that there are always spool file model definitions available for each type of spool file (see "Creating spool model definitions").

By default, Adabas Audit Data Retrieval uses the standard spool files (Type = SP) also for reloaded lists/reports. It is possible to use separate spool datasets for reloaded lists and reports. If you are using separate spool datasets for reloading (B08_RELOAD_ SEPARATE_ SPOOL = YES), you also have to provide model definitions for reload spool files (type = SR).

Spool file size

We recommend that you use a small number of large spool files rather than a large number of small spool files. Using a small number of spool files reduces the time required by batch jobs to allocate the datasets and the amount of memory used by batch jobs.

The first four spool files are allocated by the B97DBFOR job.

Maximum number of open spool files

The maximum number of spool files (cache, global, index, and spool) that can be opened by Adabas Audit Data Retrieval is 32000.

Important: The operating system may have a lower limit for the maximum number of open files. For more information, see the description of the task I/O table (TIOT) in the IBM publication MVS Initialization and Tuning Reference, chapter "ALLOCxx (allocation system defaults)".

Spool files in the Dataset Definition Selection table

The following panel shows the three types of spool files. The status of each spool file is displayed in column Sta:

  • Spool files currently in use have the status OPN (open).
  • Spool files that have been allocated, but do not contain data, have the status EMP (empty).
  • Spool file models have the status MOD (model).
  • Spool files that are currently being formatted have the status FMT (format).
  • Spool files that could not be allocated, formatted, or opened have the status ERR (error).

Dataset Definition Selection table

PEB5DD10 ----------------------------------------------------- Row 1 of 25
 Command ===> ________________________________________________ Scroll ===> PAGE

 Dataset Definition Selection Page 1 of 3
 ( LEFT/RIGHT )
 Databases for Subsystem SSID B92P SYSVAR Support : INACTIVE

 I - Insert Model F - Format Model
 S - Select Dataset Definition or D - Delete Model or Empty
 Update Model or Status R - Reset Model (ERR)
 X - Database Extension RX - Reset Database Extension (FEX)

 Sel Dataset Name X Total Free % Sta
 BETA97.DB.CACHE01 00180000 00164460 008 OPN
 BETA97.DB.CACHE02 000 FMT
 BETA97.DB.CACHE03 000 MOD
 BETA97.DB.GLOBL01 00000180 00358200 001 OPN
 BETA97.DB.INDEX01 00360000 00000180 099 OPN
 BETA97.DB.INDEX02 000 ERR
 BETA97.DB.INDEX02 00360000 00328920 008 OPN
 BETA97.DB.INDEX03 00000180 00358200 001 EMP
 BETA97.DB.INDEX04 000 MOD
 BETA97.DB.SPOOL01 00180000 00164460 008 OPN
 BETA97.DB.SPOOL02 000 MOD