Database Space Management

This document provides the DBA with all pertinent information related to database space management. Information is provided about

  • Adabas physical and logical extents;

  • Adabas relative block number (RABN);

  • the role of the Adabas nucleus and utilities in allocating/deallocating space;

  • using the database status report to monitor database space usage;

  • potential space utilization problems and recommended action.

This information is organized under the following headings:


Adabas Physical Extents

An Adabas physical extent (database container) is a collection of physical blocks assigned to a given database component (Associator, Data Storage, Work) during the definition of the database (see the ADADEF utility, ASSOSIZE, DATASIZE and WORKSIZE parameters).

The space for a physical extent is allocated using the standard allocation procedures of the operating system in use.

An Adabas physical extent may be allocated within a single operating system extent which consists of a primary extent only, or may be allocated as a primary extent together with one or more secondary extents. The secondary extents need not be contiguous to the primary extent or to each other.

An Adabas physical extent may be contained on a single physical volume or may extend across multiple volumes. The Associator and Data Storage components may each contain up to about 99 Adabas physical extents. However, your actual real maximum could be less because the extent descriptions of all Associator, Data Storage, and Data Storage Space Table (DSST) extents must fit into the general control blocks (GCBs). For example, on a standard 3390 device type, there could be more than 75 Associator, Data Storage, and DSST extents each (or there could be more of one extent type if there are less for another).

Adabas Device Type

The block sizes of each Adabas database container are determined by the Adabas device type. Device types are set during container initialization. The device type is typically defined using the ADARUN DEVICE= parameter, but may be overridden during database setup, for example via the DEVICE= subparameter of ASSOFRM/DATAFRM/WORKFRM/etc when formatting the container using the ADAFRM utility, and via the ASSODEV, DATADEV and WORKDEV parameters when defining the database using the ADADEF utility.

The default Adabas device type (ADARUN DEVICE= parameter) is 3390. Many new disk devices have appeared since the original 3390 disk drives and 3990 control units were introduced, but on z/OS, the 3390 has become an architectural standard in recent years, and new disk devices now emulate the 3390. This standard was introduced by IBM to ensure compatibility. When migrating to new disks, users need only to check with IBM that the new disks emulate 3390.

Adabas provides a set of device types which are compatible with 3390. These are 3390, 8390, 8391, 8392 and 8393. There is also a set of device types which are compatible with the older 3380 disk devices. These are becoming obsolete, but will remain available to Adabas as long as z/OS continues to support them.

For more details on the characteristics of the Adabas device types, see Installation for z/OS > Device and File Considerations.

Relative Adabas Block Number (RABN)

Adabas information is stored in space allocated in blocks. A block's size depends on:

  • the physical device on which the block is located; and

  • the Adabas component to which the block is assigned.

When space is allocated for Adabas, it must be designated as Associator (ASSO), Data Storage (DATA), the Work area (WORK), logging area (PLOG, CLOG, RLOG, ALOG), sort area, or temp area. A block allocated to ASSO using device 3390 contains 2544 bytes, but a block allocated to DATA using device 3390 contains 5064 bytes. Block sizes are predefined for each device type and Adabas component. To review a list of block sizes by device type and component, see Installation for z/OS > Device and File Considerations.

Adabas identifies and addresses each physical block within a database component (Associator, Data Storage, Work) by its relative Adabas block number (RABN), which indicates the block's position relative to the beginning of the component. RABNs are assigned in ascending sequence within each database component, starting with "1". If multiple physical extents are used, the RABN assignment continues across the physical extents.

The first track of the first physical extent of the Associator, Data Storage and Work components is not used. The first track of the second and each subsequent physical extent as well as all extents of TEMP, SORT, CLOG, and PLOG are used.

The number of RABNs that can be assigned to ASSO and DATA depends on the RABNSIZE parameter, which is specified when the database is defined. RABNSIZE specifies the length of relative Adabas block numbers in the database (not the length of the block itself).

  • If RABNSIZE=3 (block number is 24 bits or three bytes), the maximum number of RABNs is 16777215.

  • If RABNSIZE=4 (block number is 31 bits or four bytes), the maximum number of RABNs is 2147483646.

The number of Adabas blocks that can be stored on a given physical unit (track/cylinder/volume) of external storage is different for each database component and for each device type.

Using the information provided in Supported Device Types, the number of blocks in the container may be calculated as shown in the following examples. In addition, the RABN ranges stored on each volume can easily be determined using the Adabas Online System report function or the ADAREP utility.

Example 1: Associator database component, device type 3390 comprising 880 cylinders

number of ASSO blocks = blocks/track * tracks/cylinder * number of cylinders
= 18 * 15 * 880 = 237,600 Associator blocks

Eighteen (18) blocks must be subtracted for the first track of the first Associator physical extent; therefore, the Associator volume contains 237,582 blocks.

Example 2: Data Storage database component, device type 8393 comprising 750 cylinders

number of DATA blocks = blocks/track * tracks/cylinder * number of cylinders
= 2 * 15 * 750 = 22,500 Data Storage blocks

Two (2) blocks must be subtracted for the first track of the first Data Storage physical extent; therefore, the Data Storage volume contains 22,498 blocks.

Adabas Logical Extents

An Adabas logical file extent is a group of consecutive RABNs allocated by the Adabas nucleus or an Adabas utility. For each file loaded into the database, a minimum of one of each of the following types of Adabas logical extents is allocated to the file:

Logical extent Allocated from the physical extent . . .
Data Storage Data Storage
address converter Associator
normal index Associator
upper index Associator

Additional logical extents are allocated by the Adabas nucleus or an Adabas utility when additional space is needed as a result of file maintenance.

A maximum of two address converters may be allocated for any file, one for the file itself and one for any spanned records in the file. If spanned records are not used, only one address converter is allocated.

The total number of logical file extents that can be defined is limited only in that the extent information of all address converters, Data Storage, normal index, and upper index extents for the file must fit into the file control block (FCB). (The extent information is stored in a variable section of the FCB.) For example, on a standard 3390 device type, a file could have more than 40 extents of each type (or there could be more of one type if there are less for another).

When the Adabas nucleus starts up, the FCBs are checked. If there is insufficient FCB space for four further extents, the Adabas nucleus prints messages suggesting that the files should be reordered. In addition, if the last file extent of each type has only five or less free ISNs or blocks left, the nucleus locks the file for utility use only. Normal users trying to access the file will then get response code 17 (ADARSP017) or 48 (ADARSP048).

The "Contents of the Database" section of an ADAREP utility report flags files that may have insufficient FCB space for ten further extents. In the "File Information" section of the report, ADAREP prints a conservative estimate for how many further file extents can possibly be built for each file.

Adabas Space Allocation and Deallocation

This section provides an overview of Adabas space allocation and deallocation procedures. A full understanding of these procedures will help ensure correct and efficient database space management.

Free Space Table

All space available for allocation is stored in the free space table (FST). This table contains all RABN extents that are currently available for an allocation to any file.

Adabas Nucleus Space Allocation Rules

When processing an add or update record command, the Adabas nucleus may need to allocate an additional extent to any of the following file components:

  • address converter

  • normal index

  • upper index

  • Data Storage

This section describes the rules used for the allocation.

Address Converter (AC)

The size of the address converter is initially defined by the MAXISN parameter in the ADALOD utility. The actual highest expected ISN is slightly higher because the address converter is stored in entire blocks. For example:

  • If RABNSIZE=3, MAXISN=5000 on a model 3380 with 668 entries per block (2004/3) results in 8 blocks. The highest ISN expected (before further expansion) is therefore 5343 (668 * 8 - 1).

  • If RABNSIZE=4, MAXISN=5000 on a model 3380 with 501 entries per block (2004/4) results in 10 blocks. The highest ISN expected is therefore 5009 (501 * 10 - 1).

If the Adabas nucleus requires an additional extent for a file when executing N1 commands, the allocation routine attempts to locate a new extent of 25% of the current size:

  • If an unused extent between 25% and 28% can be found using the free space table (FST), that space is taken immediately;

  • If only longer extents are available in the FST, a new extent of exactly 25% is taken;

  • If only smaller extents are available in the FST, the longest available extent is taken;

  • If an additional AC extent is required, and the maximum has already been assigned, Adabas will return an appropriate response code to the calling program;

  • If a file has the attribute "one AC extent only" (e.g., if the file is an expanded file), an attempt to allocate a second AC extent will cause a response code.

Normal Index (NI), Upper Index (UI), Data Storage (DS)

For the purpose of allocating a new extent, the following formulas are used:

graphics/ni_ui_ds.png

where

B number of blocks currently allocated.
E highest ISN expected.
U highest ISN currently allocated.

If an extent found in the FST is contiguous with the end of a previous extent, it is allocated for a maximum of Z blocks.

If no such extent can be found in the FST

  • but an extent between Z and 9 * Z/8 is found, it is allocated.

  • but an extent with more than 9 * Z/8 blocks is found, then a new extent is allocated with exactly Z blocks.

  • the longest extent in the FST is allocated as the new extent.

Additionally, if the MAXNI, MAXUI, or MAXDS parameter is specified for the current file, the nucleus allocates no more than the specified maximum number of blocks for the NI, UI, or DS, respectively.

Space Allocation with the ADADBS Utility

ADD/INCREASE Associator, Data Storage

If the physical extent for the Associator or Data Storage has been exhausted, the ADD or INCREASE function (using Adabas Online System or the ADADBS utility) may be used to provide additional physical space.

The ADD function requires the allocation of an additional data set to the Associator or Data Storage. The new data set may be located on the same or a different device type than those currently in use. Both the Associator and Data Storage may consist of no more than 99 data sets each. However, your actual real maximum will be less because the maximum number of physical extents that you can define is derived from the block size of the first Associator data set (DDASSOR1). For example, on a standard 3390 device type, there could be more than 75 Associator, Data Storage, and DSST extents each (or there could be more of one extent type if there are less for another).

The INCREASE function results in the physical extension of an existing data set. The new space must, however, first be formatted using the ADAFRM utility. There is no restriction on the number of times the INCREASE function may be used.

Following an ADD function, the new data set must be formatted using the ADAFRM utility before it can be used, and the appropriate changes must be made to all Adabas job control as described in the Adabas Operations documentation.

After increasing Data Storage, it may be necessary to run the REORASSO function of the ADAORD utility to reorder the Data Storage space table (DSST) to a single extent to allow additional increases in Data Storage.

To permit formatting or reordering, the nucleus session terminates automatically following an ADADBS ADD or INCREASE operation.

ALLOCATE Function

The ALLOCATE function (Adabas Online System or ADADBS utility) may be used to allocate an extent of a specific size for any of the following file components:

  • Data Storage

  • address converter

  • normal index

  • upper index

It is also possible to specify where the extent is to be allocated by specifying a starting RABN.

Using this function, the DBA may, based on knowledge of the projected size of a file, allocate extents of a specific size, rather than having Adabas perform the assignment. This may avoid having Adabas allocate an extent which is too small or too large (see ADALOD utility). MAXNI/MAXUI and MAXDS values in effect for the accessed file are not checked.

DEALLOCATE Function

The DEALLOCATE function (Adabas Online System or ADADBS utility) may be used to deallocate an extent allocated for any of the following file components:

  • Data Storage

  • address converter

  • normal index

  • upper index

It is also possible to specify where deallocation is to begin by specifying a starting RABN. The deallocated space is returned to the free space table (FST).

DELETE Function

The DELETE function (Adabas Online System or ADADBS utility) causes an existing file to be deleted from the database. All space which was assigned to the file is returned to the free space table and is available for reuse. DELETE can delete complete expanded files only.

RECOVER Function

The RECOVER function (Adabas Online System or ADADBS utility) may be used to recover space which was allocated during an execution of the ADAINV or ADALOD utility which terminated abnormally. The recovered space is returned to the free space table and is available for reuse.

REFRESH Function

The REFRESH function (Adabas Online System or ADADBS utility) results in the setting of a file status to 0 records loaded and 1 extent allocated to each file component. Any additional extents other than the first extent are returned to the free space table.

RELEASE and UNCOUPLE Functions

The RELEASE and UNCOUPLE functions (Adabas Online System or ADADBS utility) results in the deletion of an inverted list or physical coupling lists. The space used for the list can be recovered only by using ADAORD. When releasing a descriptor for an expanded file, each component file must be released individually. ADADBS displays a message whenever a descriptor of an expanded file is being released.

Space Allocation with the ADAINV Utility

COUPLE/INVERT Functions

The COUPLE and INVERT functions (Adabas Online System or ADAINV utility) may result in the assignment of additional blocks for the NISIZE file component (but not DSSIZE or MAXISN). This occurs if the available space becomes full during processing of the input data.

In such a case, if there are any index blocks freed during deletion by the nucleus, these blocks are reused. Then, if available, a range of blocks in the free space table whose size is within the range M1 through M2 will be taken.

M1 and M2 are computed as follows:

M2 = M1 + M1/8
M1 = MAX (A2, NIB/4 + KZ)

where

KZ zap-able value (default = 10)
NIB number of NI blocks in use

and

A2 = MIN (A1, NIB * 2)
A1 = IUN * NIB/IUS

where

IUN number of unused ISNs
IUS number of used ISNs

When inverting a descriptor for an expanded file, each component file must be individually inverted. ADAINV displays a message whenever a descriptor of an expanded file is being inverted.

Space Allocation with the ADALOD Utility

LOAD Function

The LOAD function of the ADALOD utility is used to load a file into a database.

DSSIZE Parameter

The number of blocks or cylinders specified with the DSSIZE parameter is allocated and assigned to the first DS extent at the beginning of ADALOD execution.

The DSRABN or DSDEV parameters may be used to force the allocation to a specific RABN or device.

If during processing of the input data, this first allocated extent becomes full, a search is made for a range of free blocks in the free space table whose size is within the range M1 through M2.

M1 and M2 are computed as follows:

M2 = M1 + M1/8
M1 = MAX (A2, DSB/4 + KZ)

where

KZ zap-able value (default = 10)
DSB number of DS blocks in use

and

A2 = MIN (A1, DSB * 2)
A1 = IUN * DSB/IUS

where

IUN number of unused ISNs
IUS number of used ISNs

If enough space is found in the free space table and that space follows immediately an already allocated extent, this space is added to the end of the extent. In this case no new extent is allocated.

If a new extent is needed, the free space table is scanned and the number of blocks needed to satisfy the size of M1 through M2 is taken for the new extent. Up to 99 extents are possible. However, your actual real maximum will be less because the maximum number of physical extents that you can define is derived from the block size of the first Associator data set (DDASSOR1). If space is not available, ADALOD ends with an error message.

The maximum number of logical file extents that you can now define is derived from the block size of the first Associator data set (DDASSOR1). The extent information is stored in a variable section of the FCB. New extents can be added now until the used FCB size reaches the block size of the Associator data set.

MAXISN Parameter

The MAXISN value is converted into a number of blocks and rounded up to a full block boundary. This range of blocks is allocated at the beginning of ADALOD execution and is assigned to the first address converter extent for the file.

The ACRABN parameter may be used to force the allocation to begin at a specific location.

If during processing of the input data, this first allocated extent becomes full, ADALOD tries to allocate another AC extent whose size is 25% of the sum of all currently existing AC extent sizes.

  • If an unused range of blocks is available in the free space table in the range of 25% through 28% of the size currently in use, this range is immediately allocated as a new AC extent for the file;

  • If only longer free ranges are available, a new AC extent of 25% is taken from the smallest free range of blocks;

  • If only smaller free ranges are available, the largest available is taken.

NISIZE/UISIZE Parameters

At the beginning of its execution, ADALOD allocates and assigns the blocks or cylinders specified by the NISIZE and UISIZE parameters to the first NI and UI extents, respectively.

The NIRABN and UIRABN parameters can be used to force extent allocation to begin at a specific RABN.

If you omit the NISIZE or UISIZE parameters, ADALOD does not initially allocate NI and UI space. Instead, ADALOD waits until all incoming descriptor values have been written to the Temp data set, and then estimates NISIZE and UISIZE values as follows:

  • If no input records were processed:

    NISIZE = Number of descriptors +1
    UISIZE = 2 blocks
  • If input records were processed:

    For each descriptor in the file, up to 16 temp data set blocks are selected and read. The contents of these blocks are sorted and estimated to the total amount of temp blocks used for this descriptor.

    The chosen algorithm returns the NISIZE and UISIZE values for each descriptor, which ADALOD adds together and then multiplies by the factor K, which is

    K = (MAXISN - MINISN + 1) / number of records loaded

    If, during operation, ADALOD determines that the resulting value is not enough, ADALOD allocates subsequent extents during its run. The sizes of these extents are computed in the same way as for additional DSSIZE extents, as described above.

UPDATE Function

The UPDATE function of the ADALOD utility performs a mass add/delete of records to/from an existing file, reorganizes and (if necessary) expands the Associator and/or Data Storage space.

The ADALOD UPDATE functions allocates additional AC space if the MAXISN parameter specifies a new, higher maximum ISN value-even if the restructuring of the AC, NI and UI performed by UPDATE results in more unused current space. ADALOD UPDATE adds Data Storage space if the current Data Storage space cannot hold the new records.

MAXISN Parameter

If a MAXISN value is specified for the UPDATE operation that is greater than the current value for the file, the difference between the old and the new MAXISN setting is computed. The number of AC blocks to satisfy this amount is then allocated from the free space table as an additional extent. The ACRABN parameter may be used to force the allocation to begin at a specific location.

If during processing of the input data the current AC and/or Data Storage extent becomes full, ADALOD tries to allocate another AC and/or Data Storage extent whose size is 25% of the sum of all currently existing AC and/or Data Storage extent sizes.

  • If an unused range of blocks is available in the free space table in the range of 25% through 28% of the size currently in use, this range is immediately allocated as a new AC extent for the file;

  • If only longer free ranges are available a new AC extent of 25% is taken from the smallest free range of blocks;

  • If only smaller free ranges are available, the largest available is taken.

Space Allocation by the ADAORD Utility

ADAORD reorders the respective Adabas Associator component (AC, NI/UI, DSST) and Data Storage to reclaim unusable space for reuse. Although ADAORD functions affect only the selected component files of an Adabas expanded file, there is no change to the logical consistency of an expanded file; therefore, ADAORD does not have to be performed on each component file of an expanded file, unless desired.

Function Accessed Table Types
REORFASSO AC, NI, UI
REORASSO AC, NI, UI, DSST
REORFDATA, REORDATA DS
REORFILE, REORDB AC, NI, UI, DS

For each accessed file and for each accessed table type (depending on the function), the following action is taken:

  • All used space is returned to the free space table.

  • All tables with a specific location (ACRABN, DSRABN, NIRABN, UIRABN) are allocated and assigned as a first extent. The sizes used are either supplied (MAXISN, DSSIZE, NISIZE, UISIZE) or taken from the original file.

  • All tables without a specific location are allocated and assigned as a first extent.

If one of the extents become full, the same action is taken as described for the ADALOD (UPDATE) utility (see the previous section).

Space Allocation by ADASAV (RESTORE FILES Function)

If a file to be restored is already present in the database (OVERWRITE parameter must be specified) the space used by all these files is returned to the free space table. If a component file of an expanded file is specified, then all related component files must also be specified.

  • RESTORE FILE=...

    For each file to be restored, the original RABNs must be available. ADASAV tries to allocate the required extents at their original position with their original size. If one of these allocations fails, ADASAV will terminate with ERROR-060.

  • RESTORE FMOVE=...

    For each file to be restored, at least the amount of original space used will be allocated. The allocation of the first extent for each file table can be forced to a specific location by using one of the optional parameters ACRABN, DSRABN, NIRABN, UIRABN. The sizes of these tables may be increased using MAXISN, DSSIZE, NISIZE, UISIZE.

If space is available, multiple input extents may be compressed in a new single extent. If there is not enough contiguous free space available, ADASAV will split the tables over several new extents (up to 99 for each table). If such space is not available, ADASAV will terminate with ERROR-060.

Using the Database Status Report to Control Space Use

Database space utilization information can be obtained directly from the database status report produced by executing the ADAREP utility or using Adabas Online System.

In addition to a file allocation map and a block allocation map, this report lists the number of blocks

  • used (and unused) for the Associator physical extent (or extents);

  • used (and unused) for the Data Storage physical extent (or extents);

  • allocated for the Work physical extent;

  • used (and unused) for each file for the address converter, normal index, upper index, and Data Storage logical extent (or extents).

See the ADAREP chapter in the Adabas Utilities documentation for a detailed explanation of the information provided on this report.

The DBA should frequently review this report to identify potential space utilization problems.

The next section contains guidelines on problems which may be detected using the status report, and recommendations as to what action should be taken to prevent and/or resolve each problem.

Potential Space Use Problems and Recommended Actions

This section provides a summary of the problems most often encountered concerning database space utilization, and the recommended corrective action to be taken to prevent and/or correct problems.

Full Physical Extents

  1. The Associator physical extent is nearly or completely full.

    • The physical extent may be increased (see ADADBS utility, INCREASE function);

    • A new physical extent may be added (see ADADBS utility, ADD function);

    • The Associator may be reordered using the ADAORD utility. This will be of benefit only if a large amount of Associator space fragmentation exists;

    • Unused file extents can be release using the ADADBS DEALLOCATE function;

    • Any Adabas files no longer required may be deleted (see the ADADBS utility; DELETE function);

    • Any file coupling lists no longer needed may be deleted (see the ADADBS utility, UNCOUPLE function);

  2. The Data Storage physical extent is nearly or completely full.

    • The physical extent may be extended (see the ADADBS utility, INCREASE function);

    • A new physical extent may be added (see the ADADBS utility, ADD function); this is recommended only when the new extent is on a new device type.

    • Data Storage may be reordered (see the ADAORD utility, REORDATA function). This will be of benefit only if a large amount of Data Storage space fragmentation exists, or the Data Storage padding factor is decreased;

    • A given file may be reordered (see the ADAORD utility, REORFILE function);

    • Any Adabas files no longer required may be deleted (see the ADADBS utility, DELETE function).

Maximum Physical Extents Reached

  1. The maximum number of Associator physical extents (about 99) has been reached.

    • The last extent can be increased using the ADADBS INCREASE function;

    • The Associator can be reordered by executing the ADAORD REORASSO function;

    • All files can be unloaded using the ADAORD RESTRUCTURE function and then reloaded into a larger database using ADAORD STORE.

  2. The maximum number of Data Storage physical extents (about 99) has been reached.

    • The last extent can be increased using the ADADBS INCREASE function;

    • Data Storage can be reordered (see the ADAORD utility, REORDATA function). This will result in the elimination of Data Storage space fragmentation;

    • All files can be unloaded using the ADAULD utility and then reloaded into a larger database.

Maximum Logical Extents Reached

  1. The maximum logical extents for the address converter, normal index, or upper index for a file has been reached.

    • The REORFILE or REORFASSO function of the ADAORD utility can be executed to reorder all Associator entries for the file.

    • ISN reusage can be invoked using the ADADBS utility.

    • The file can be unloaded, deleted, and reloaded.

  2. The maximum logical extents limit for either Data Storage or the Data Storage space table for a file has been reached.

    • The file (and all other files) can be reordered using the REORFDATA or REORFILE function of the ADAORD utility. This condenses multiple Data Storage extents into fewer extents.

    • The file can be unloaded, deleted, and reloaded.

Receiving Associator and Data Storage Space Usage Notifications

You can set up your Adabas database so that you receive space usage messages as Associator (ASSO) and Data Storage (DATA) space use exceeds or falls below set thresholds. With this information, you can adjust the use or size of your database as needed.

Two new ADARUN parameters are provided to specify ASSO and DATA space threshold levels. When free space becomes critically low, space usage messages can be useful triggers for operators to determine the cause of the limited space. If the cause is a rogue application, you can cancel the rogue application. If the cause is insufficient database space allocations, you can provide additional space while the database remains active (as described in this document).

  • ASSOSPACEWARN can be used to specify the space usage thresholds and the increments above the thresholds at which warning messages should be triggered for Associator space.

  • DATASPACEWARN can be used to specify the space usage thresholds and the increments above the thresholds at which warning messages should be triggered for Data Storage space.

When space use exceeds the specified thresholds, space usage messages are issued to the console. Thereafter, when space use increases or decreases by the specified increments, additional space usage messages are issued to the console. When space use drops below the lowest threshold specification, a space usage message is issued when it first falls below the threshold, but incremental space usage messages are no longer issued unless space use increases above the lowest threshold again.

In addition, two new operator commands, ASSOSPACEWARN and DATASPACEWARN, can be used to alter the comparable ADARUN parameter settings while the nucleus is active.

Increasing Associator and Data Storage Space

On z/OS systems, you can automatically and dynamically increase the size of your Associator (ASSO) or Data Storage (DATA) space. This makes it possible to increase the size of the database without incurring a database outage, which can be critical if your database needs to run 24x7 (24 hours a day, 7 days a week). You can do this in several ways:

  1. You can request that Adabas automatically increase the size of your ASSO or DATA space using a series of AUTOINC* ADARUN parameters in the nucleus startup job.

  2. You can dynamically alter the AUTOINC* ADARUN parameters using a series of AUTOINC* operator commands.

  3. You can dynamically increase the size of the last existing ASSO or DATA data set for the database by extending the data set and formatting the appended space, and then allocating it to the database.

  4. You can dynamically add a new ASSO or DATA data set to the database by allocating the data set to the operating system, formatting the data set, and then allocating it to the database.

The last three methods can be accomplished without restarting the Adabas nucleus. However, if you change the nucleus startup job to include the AUTOINC* ADARUN parameters, the nucleus must be stopped and restarted to pick up the changes. Once restarted, however, the automatic increases occur without restarting the nucleus again.

Note:
You can also request that space usage messages be issued as Associator (ASSO) and Data Storage (DATA) space use exceeds or falls below set thresholds. This request is specified by the ASSOSPACEWARN and DATASPACEWARN ADARUN parameters. The settings for these parameters can then be altered while the nucleus is active using the ASSOSPACEWARN and DATASPACEWARN operator commands. For more information about these ADARUN parameters and operator commands, read Adabas Initialization (ADARUN Statement) and Operator Commands.

The remainder of this section provides procedures for each of these methods:

Automatically Increasing Associator or Data Storage Data Set Space

You can request that Adabas automatically increase the size of your Associator (ASSO) or Data Storage (DATA) space when usage reaches a set threshold. This makes it possible to increase the size of the database without incurring a database outage, which can be critical if your database needs to run 24x7 (24 hours a day, 7 days a week). This support is implemented using the following ADARUN parameters:

  • The AUTOINCASSOSIZE and AUTOINCDATASIZE parameters can be used to specify the size, in cylinders or blocks, by which the highest-numbered (last-defined) Associator (ASSO) and Data Storage (DATA) data sets (respectively) will be increased by an automatic database increase process.

  • The AUTOINCASSOTHRESHOLD and AUTOINCDATATHRESHOLD parameters can be used to specify the Associator and Data Storage (respectively) space thresholds at which Adabas automatically initiates a database increase process. These thresholds are expressed as the percentage of used Associator or Data Storage space to total Associator or Data Storage space available in the database.

    For AUTOINCASSOTHRESHOLD and AUTOINCDATATHRESHOLD parameters to be checked, it does require MODE=MULTI to be specified. If MODE=SINGLE is in effect, then the threshold parameters are ignored, due to the amount of time that may be required to perform the increase.

  • The AUTOINCASSOTOTAL and AUTOINCDATATOTAL parameters can be used to specify the maximum total size, in cylinders or blocks, of the entire Associator or Data Storage space (respectively) of the database that is not to be exceeded by automatic database increase processes.

For complete information about ADARUN parameters, read Adabas Initialization (ADARUN Statement).

Dynamically Adjusting the Automatic Increase Settings

The AUTOINC* ADARUN parameters can be used to request that Adabas automatically increase the size of your Associator (ASSO) or Data Storage (DATA) space when usage reaches a set threshold. These ADARUN parameter settings can also be altered dynamically by the following operator commands, which can be entered on the console as well as using the ADADBS OPERCOM utility function and using Adabas Online System's Modify Parameters screen.

  • The AUTOINCASSOSIZE and AUTOINCDATASIZE commands can be used to specify the size, in cylinders or blocks, by which the highest-numbered (last-defined) Associator (ASSO) and Data Storage (DATA) data sets (respectively) will be increased by an automatic database increase process.

  • The AUTOINCASSOTHRESHOLD and AUTOINCDATATHRESHOLD parameters can be used to specify the Associator and Data Storage (respectively) space thresholds at which Adabas automatically initiates a database increase process. These thresholds are expressed as the percentage of used Associator or Data Storage space to total Associator or Data Storage space available in the database.

    For AUTOINCASSOTHRESHOLD and AUTOINCDATATHRESHOLD parameters to be checked, it does require MODE=MULTI to be specified. If MODE=SINGLE is in effect, then the threshold parameters are ignored, due to the amount of time that may be required to perform the increase.

  • The AUTOINCASSOTOTAL and AUTOINCDATATOTAL commands can be used to specify the maximum total size, in cylinders or blocks, of the entire Associator or Data Storage space (respectively) of the database that is not to be exceeded by automatic database increase processes.

For complete information about Adabas operator commands, read Operator Commands. For complete information about the ADADBS OPERCOM utility, read OPERCOM: Issue Adabas Operator Commands.

Dynamically Increasing Existing Associator or Data Storage Data Set Space

To increase the last existing data set of the Associator or Data Storage of the database without shutting down the Adabas nucleus, use the ADADBS ONLINCREASE utility function to dynamically increase the size of the last existing ASSO or DATA data set for the database. Running this utility function will trigger Adabas to extend the data set, format the appended space, and allocate the space to the database.

For more information, read ONLINCREASE: Allocating Appended ASSO or DATA Space Dynamically. Pay special attention to the restrictions listed for this utility function.

Dynamically Adding New Associator or Data Storage Data Sets

Start of instruction setTo add a data set to the available Associator or Data Storage space without shutting down your Adabas database, complete the following steps:

  1. Use the ADAFRM ASSOFRM or ADAFRM DATAFRM utility functions to create and format the data set.

    Only the data set specified by the function name and the NUMBER parameter is accessed and formatted. The FROMRABN parameter cannot be specified when formatting a new data set. For complete information about the ADAFRM utility, read ADAFRM Utility: Format Adabas Database Components.

  2. Add appropriate JCL statements for the new data set to the nucleus startup job and to any Adabas utility procedures you have defined.

  3. Use the ADADBS ONLADD utility function to dynamically allocate the added ASSO or DATA data set to the database, without restarting the nucleus. Specify the JCL statement for the new data set in that utility job.

    Note:
    The ADADBS ONLADD function must be performed in a different job than the preceding ADAFRM function.

    For complete information about the ADADBS ONLADD utility function, read ONLADD: Allocating New ASSO or DATA Space Dynamically. Pay special attention to the restrictions listed for this utility function.

Secondary Space Considerations when Defining and Extending Adabas Data Sets

In this section, "extent" refers to the space allocated to a data set by z/OS on a disk volume.

When defining and formatting Adabas data sets via ADAFRM, the JCL SPACE parameter allows for a secondary space allocation size to be defined.

The Adabas utilities used subsequently when extending data sets typically do not take account of the original secondary space allocation set up when the file was defined. Instead, Adabas attempts to satisfy the extend request with a single secondary extent. This is done in order to minimize the number of extents getting allocated, as the allocation is limited by z/OS to 16 extents per volume for a single data set. It also allows support for extending data sets which were originally defined with a secondary space allocation of zero.

Note that multiple extents might still get used when processing a single request to extend a data set. For example, a request to add another 4000 cylinders to a data set might result in two disk extents, one of 3000 cylinders and one of 1000 cylinders. This is done by z/OS, according to its own internal space allocation algorithms.

When extending data sets, there must be enough space on a single volume to satisfy the request. Therefore, if a large amount of additional space is requested, the secondary space size might get limited by Adabas. For a basic format data set, the size is limited to 4369 cylinders. For a large format data set, the size is limited to 65520 cylinders. When Adabas limits the extent size, the increase request will still be honored, but will result in multiple extents being allocated.

There is an exception to the handling of secondary extents described above. The ADACHK utility can dynamically extend SORT data sets. If the ADACHK utility detects that the SORT data set is fully formatted with the expected block size, Adabas will use the original secondary space allocation. This is done in order to prevent a pre-formatted SORT data set from occupying more disk space than originally planned.