Adabas Utilities

Utility Function Use to...
ADACDC Produce a file containing the delta of all changes made to the database over the period covered by the input protection logs. You can also use this utility to produce a file that lists each individual insert and delete transaction made to the database over the period covered by the input protection logs (without producing a delta of these changes).
ADACHK ACCHECK Check the address converter for a specific file or range of files or for a specific ISN or range of ISNs.
ADACHK ASSOPRINT Print the contents of any Associator (ASSO) block in the database.
ADACHK CHECK Perform all ADACHK utility check functions.
ADACHK CLOGPRINT Print the contents of any block or range of blocks in the command log (CLOG) data set.
ADACHK DATAPRINT Print the contents of any block or range of blocks in Data Storage.
ADACHK DSCHECK Check Data Storage and the Data Storage space table (DSST) of a specific file (or files) in the database.
ADACHK DSIMPRINT Print the contents of any block or range of blocks in the Delta Save image (DSIM) data set.
ADACHK DSSTPRINT Print the contents of the Data Storage Space Table (DSST).
ADACHK FCBPRINT Print the contents of the file control block (FCB) for any file in the database.
ADACHK FDTPRINT Print the contents of the field definition table (FDT) for any file in the database.
ADACHK FSTPRINT Print the contents of the free space table (FST) for the database.
ADACHK GCBPRINT Print the contents of the general control blocks (GCBs) for the database.
ADACHK ICHECK Check the physical structure of the Associator.
ADACHK NIPRINT Print the contents of the normal index of files or ranges of files in the database.
ADACHK PLOGPRINT Print the contents of any block or range of blocks in the protection log (PLOG) data set.
ADACHK PPTPRINT Print the contents of the parallel participant table (PPT) for the database.
ADACHK RLOGPRINT Print the contents of any block or range of blocks in the recovery log (RLOG) data set.
ADACHK SORTPRINT Print the contents of any block or range of blocks in the sort (SORT) data set.
ADACHK TEMPPRINT Print the contents of any block or range of blocks in the temporary (TEMP) data set.
ADACHK UIPRINT Print the contents of the upper index of files or ranges of files in the database.
ADACHK VALIDATE Validate any or all files within an Adabas database, except the checkpoint and security files.
ADACHK WORKPRINT Print the contents of any block or range of blocks in the work (WORK) data set.
ADACMP COMPRESS Edit and compress data records that are to be loaded into the database.
ADACMP DECOMPRESS Decompress individual files in the Adabas database.
ADACNV CONVERT Convert a database to higher Adabas version.
ADACNV REVERT Revert a database to a lower Adabas version.
ADADBS ADD Add a new data set to the Associator or Data Storage.
ADADBS ADDCLOG Dynamically add a command log (CLOG) data set
ADADBS ADDPLOG Dynamically add a protection log (PLOG) data set
ADADBS ALLOCATE Allocate an extent of a specific size for an address converter, Data Storage, or normal or upper index.
ADADBS CHANGE Change the standard length or format of a field.
ADADBS CVOLSER Print the Adabas file extents on a given volume.
ADADBS DEALLOCATE Deallocate a file extent for an address converter, Data Storage, or normal index or upper index.
ADADBS DECREASE Decrease the size of the last data set currently being used for the Associator or Data Storage.
ADADBS DELCLOG Dynamically delete a command log (CLOG) data set
ADADBS DELCP Delete checkpoint records.
ADADBS DELDE Logically delete descriptors.
ADADBS DELETE Delete a file from a database.
ADADBS DELFN Logically delete fields from a database file.
ADADBS DELPLOG Dynamically delete a protection log (PLOG) data set
ADADBS DEVENTLOG Display the Adabas event log.
ADADBS DSREUSE Activate or deactivate the reuse of Data Storage blocks for a file.
ADADBS ENCODEF Change the file encoding of a file.
ADADBS EXPFILE Insert or remove files in an expanded file chain.
ADADBS INCREASE Increase the size of the last data set currently being used for the Associator or Data Storage.
ADADBS ISNREUSE Reuse ISNs in a database.
ADADBS MODFCB Modify various parameters for a non-system Adabas file.
ADADBS MUPEX Set the maximum count for MU and PE fields in a database.
ADADBS NEWFIELD: Add one or more fields to a file.
ADADBS ONLADD Dynamically add a new Associator or Data Storage data set for the database.
ADADBS ONLINCREASE Dynamically increase the size of the last existing Associator or Data Storage data set for the database.
ADADBS ONLINVERT Start an online invert process.
ADADBS ONLREORFASSO Start an online process to reorder the Associator of specified files.
ADADBS ONLREORFDATA Start an online process to reorder the Data Storage of specified files.
ADADBS ONLREORFILE Start an online process to reorder the Associator and Data Storage of specified files.
ADADBS OPERCOM Issue operator commands to the Adabas nucleus.
ADADBS PRIORITY Set or change the Adabas priority of a user.
ADADBS REACTLOG Reactivate command logging.
ADADBS RECORDSPANNING Enable or disable record spanning for a file.
ADADBS RECOVER Recover allocated space by rebuilding the free space table (FST).
ADADBS REFRESH Set a file to empty status.
ADADBS REFRESHSTATS Reset the statistical values maintained by the Adabas nucleus for its current session.
ADADBS RELEASE Release a descriptor from the descriptor space.
ADADBS RENAME Rename a file or database.
ADADBS RENUMBER Change the number of a file in the database.
ADADBS REPLICATION Activate or deactivate replication for an Adabas database file.
ADADBS REPTOR Activate, deactivate, open, or close an Event Replicator for Adabas resource.
ADADBS RESETDIB Reset entries in the active utility list.
ADADBS RESETPPT Resets the PPT blocks on the Associator data set.
ADADBS SPANCOUNT Count and display the number of records in a file that are spanned.
ADADBS TRANSACTIONS Suspend and resume update transaction processing for the database.
ADADBS UNCOUPLE Uncouple files in the database.
ADADBS UNDELDE Undelete logically deleted descriptors.
ADADBS UNDELFN Logically undelete fields from a database file.
ADADEF DEFINE Define a database and checkpoint file.
ADADEF MODIFY Change field encodings.
ADADEF NEWWORK Define a Work file.
ADADRU SPACEUSAGE Produce summarized and detailed reports about database file space usage.
ADAFRM Format Adabas database components.
ADAINV COUPLE Define one descriptor for each of two files to be coupled.
ADAINV INVERT Create descriptors, subdescriptors, superdescriptors, hyperdescriptors, phonetic descriptors or collation descriptors for existing fields in a file.
ADALOD LOAD Load a file into the database.
ADALOD UPDATE Add or delete a large number of records (ISNs) to or from an existing file.
ADAMER Run the ADAM estimation. This utility produces statistics that indicate the number of Data Storage accesses required to find and read a record when using an ADAM descriptor.
ADAORD REORASSO Reorder the Associator.
ADAORD REORDATA Reorder Data Storage.
ADAORD REORDB Reorder the database.
ADAORD REORFASSO Reorder the Associator for a single file.
ADAORD REORFDATA Reorder Data Storage for a single file.
ADAORD REORFILE Reorder a file.
ADAORD RESTRUCTUREDB Restructure the database.
ADAORD RESTRUCTUREF Restructure single files.
ADAORD STORE: Store Files Load one or more files into an existing database using output produced by the ADAORD RESTRUCTURE functions.
ADAPLP Print data protection records from the protection log (PLOG) or Work data sets.
ADARAI CHKDB Check that the recovery status of the nucleus is the status specified by the CHKDB function (active or inactive).
ADARAI DISABLE Disable recovery logging by setting the RLOG table (control block) to inactive status.
ADARAI LIST View the recovery log contents in table form.
ADARAI PREPARE Initialize and start recovery logging to the recovery log.
ADARAI RECOVER Build a recovery job stream for recovering the Adabas database or selected database files.
ADARAI REMOVE Disable recovery logging by updating the Associator GCBs to indicate that recovery logging (that is, the Recovery Aid) is no longer active in the database, and that information will no longer be recorded in the recover log (RLOG).
ADAREP Request a database status report.
ADARES BACKOUT SIBA Back out updates applied between two specified checkpoints using the sequential protection log (SIBA).
ADARES BACKOUT DPLOG or MPLOG Back out updates applied between two checkpoints contained on the same dual or multiple protection log.
ADARES CLCOPY Copy the dual command log.
ADARES COPY Copy a sequential protection log or save tape.
ADARES MERGE CLOG Merge nucleus cluster command logs.
ADARES PLCOPY Copy protection log data to a sequential data set.
ADARES REGENERATE Reapply all the updates performed between two checkpoints.
ADARES REPAIR Repair one or more Data Storage blocks, using the protection log and the output of the ADASAV utility.
ADASAV RESTONL Restore a database from a database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTONL FILES Restore files to their original RABNs in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTONL FMOVE Restore files to any free space in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTONL GCB Restore the general control blocks (GCBs), Associator RABNs 3-30 of the database, the checkpoint file, the security file (if present), and all specified files. These file structures are restored from a database SAVE data set created while the Adabas nucleus was active.
ADASAV RESTORE Restore a database from a database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTORE FILES Restore files to their original RABNs in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTORE FMOVE Restore files to any free space in an existing database. Files are restored from a file or database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTORE GCB Restore the general control blocks (GCBs), Associator RABNs 3-30 of the database, the checkpoint file, the security file (if present), and all specified files. These file structures are restored from a database SAVE data set created while the Adabas nucleus was inactive.
ADASAV RESTPLOG Restore changes contained in the protection log (PLOG) to the already restored database or files.
ADASAV SAVE Save the contents of the database to a sequential data set.
ADASAV SAVE FILES Save the contents of one or more files to a sequential data set.
ADASEL Select and decompress information in the Adabas sequential (SIBA) or dual/multiple (PLOG) protection log and write it to a print data set (DDDRUCK/ DRUCK) or a user-specified output data set.
ADAULD UNLOAD FILE Unload a specified Adabas file.
ADAWRK Produce reports from records in the autorestart area of Work part 1. This information can be used when the database autostart fails and the database will not come up. It can help you determine how to handle database recovery.
ADAZAP Display (in hexadecimal format) and optionally change the contents of the Associator, Data Storage, or Work data sets.
ADAZIN Print Adabas maintenance and SVC information.
Field Definition Statements Define or modify a field definition. Field definition statements can be specified in various Adabas utility functions.

ADACDC: Capture Delta Changes

graphics/util_adacdc.png

ADACHK ACCHECK: Check Address Converter against Data Storage

graphics/adachk_accheck.png

ADACHK ASSOPRINT: Print/Dump Associator Blocks

graphics/adachk_assoprint.png

ADACHK CHECK: Perform all ADACHK Checks

graphics/adachk_check.png

ADACHK CLOGPRINT: Print/Dump Command Log Blocks

graphics/adachk_clogprint.png

ADACHK DATAPRINT: Print/Dump Data Storage Blocks

graphics/adachk_dataprint.png

ADACHK DSCHECK: Check Data Storage

graphics/adachk_dscheck.png

ADACHK DSIMPRINT: Print Delta Save Image Data Set Blocks

graphics/adachk_dsimprint.png

ADACHK DSSTPRINT: Print Data Storage Space Table Blocks

graphics/adachk_dsstprint.png

ADACHK FCBPRINT: Print/Dump File Control Block (FCB)

graphics/adachk_fcbprint.png

ADACHK FDTPRINT: Print/Dump Field Definition Table (FDT)

graphics/adachk_fdtprint.png

ADACHK FSTPRINT: Print/Dump Free Space Table (FST)

graphics/adachk_fstprint.png

ADACHK GCBPRINT: Print/Dump General Control Blocks (GCB)

graphics/adachk_gcbprint.png

ADACHK ICHECK: Check Associator Physical Structure

graphics/adachk_icheck.png

ADACHK NIPRINT: Print/Dump Normal Index

graphics/adachk_niprint.png

ADACHK PLOGPRINT: Print/Dump Protection Log Blocks

graphics/adachk_plogprint.png

ADACHK PPTPRINT: Print/Dump Parallel Participant Table (PPT)

graphics/adachk_pptprint.png

ADACHK RLOGPRINT: Print/Dump Recovery Log

graphics/adachk_rlogprint.png

ADACHK SORTPRINT: Print/Dump Sort Data Set

graphics/adachk_sortprint.png

ADACHK TEMPPRINT: Print/Dump Temporary Data Set

graphics/adachk_tempprint.png

ADACHK UIPRINT: Print/Dump Upper Index

graphics/adachk_uiprint.png

ADACHK VALIDATE: Validate all Database Files

graphics/adachk_validate.png

ADACHK WORKPRINT: Print/Dump Work Data Set

graphics/adachk_workprint.png

ADACMP COMPRESS: Compress an Adabas File

graphics/util_adacmp_compress.png

ADACMP DECOMPRESS: Decompress Adabas Files

graphics/util_adacmp_decompress.png

Field Definition Statements

The following syntax must be followed when entering field definitions. A minimum of one and a maximum of 3214 definitions may be specified.

Statement Type Syntax
Field and Group

graphics/util_fndef_fld.png

Periodic Group

graphics/util_fndef_grp.png

Collation descriptor

graphics/util_colde.png

Hyperdescriptor

graphics/util_hypde.png

Phonetic descriptor

graphics/util_phonde.png

Subdescriptor

graphics/util_subde.png

Subfield

graphics/util_subfn.png

Superdescriptor

graphics/util_supde.png

Superfield

graphics/util_supfn.png

User comments may be entered to the right of each definition. At least one blank must be present between a definition and any user comments.

ADACNV CONVERT: Convert a Database to Higher Version

graphics/util_adacnv_convert.png

ADACNV REVERT: Revert a Database to Lower Version

graphics/util_adacnv_revert.png

ADADBS ADD: Add Data Set

graphics/util_adadbs_add.png

ADADBS ADDCLOG: Dynamically Add CLOG Data Sets

graphics/util_adadbs_addclog.png

ADADBS ADDPLOG: Dynamically Add PLOG Data Sets

graphics/util_adadbs_addplog.png

ADADBS ALLOCATE: Allocate File Extent

graphics/util_adadbs_allocate.png

ADADBS CHANGE: Change Standard Length or Format of a Field

graphics/util_adadbs_change.png

ADADBS CVOLSER: Print Adabas Extents on Given Volume

graphics/util_adadbs_cvolser.png

ADADBS DEALLOCATE: Deallocate File Extent

graphics/util_adadbs_deallocate.png

ADADBS DECREASE: Decrease Last Associator or Data Storage Data Set Size

graphics/util_adadbs_decrease.png

ADADBS DELCLOG: Dynamically Delete CLOG Data Sets

graphics/util_adadbs_delclog.png

ADADBS DELCP: Delete Checkpoint Records

graphics/util_adadbs_delcp.png

ADADBS DELDE: Logically Delete a Descriptor

graphics/util_adadbs_delde.png

ADADBS DELETE: Delete File

graphics/util_adadbs_delete.png

ADADBS DELFN: Logically Delete Fields

graphics/util_adadbs_delfn.png

ADADBS DELPLOG: Dynamically Delete PLOG Data Sets

graphics/util_adadbs_delplog.png

ADADBS DEVENTLOG: Display Adabas Event Log

graphics/util_adadbs_deventlog.png

ADADBS DSREUSE: Reuse Data Storage Blocks

graphics/util_adadbs_dsreuse.png

ADADBS ENCODEF: Change File Encoding

graphics/util_adadbs_encodef.png

ADADBS EXPFILE: Insert or Remove Files in Expanded File Chains

graphics/util_adadbs_expfile.png

ADADBS INCREASE: Increase Last Associator or Data Storage Data Set Size

graphics/util_adadbs_increase.png

ADADBS ISNREUSE: Reuse ISNs

graphics/util_adadbs_isnreuse.png

ADADBS MODFCB: Modify File Parameters

graphics/util_adadbs_modfcb.png

ADADBS MUPEX: Set Maximum Count for MU and PE Fields

graphics/util_adadbs_mupex.png

ADADBS NEWFIELD: Add New Field

graphics/util_adadbs_newfield.png

ADADBS ONLADD: Dynamically Add an ASSO or DATA Data Set

graphics/adadbs_onladd.png

ADADBS ONLINCREASE: Dynamically Increase the Last Existing ASSO or DATA Data Set

graphics/adadbs_onlincrease.png

ADADBS ONLINVERT: Start Online Invert Process

graphics/util_adadbs_onlinvert.png

ADADBS ONLREORFASSO: Start Online Reorder Associator for Files

graphics/util_adadbs_onlreorfasso.png

ADADBS ONLREORFDATA: Start Online Reorder Data for Files

graphics/util_adadbs_onlreorfdata.png

ADADBS ONLREORFILE: Start Online Reorder Associator and Data for Files

graphics/util_adadbs_onlreorfile.png

ADADBS OPERCOM: Issue Adabas Operator Commands

graphics/util_adadbs_opercom.png

Operator Commands Supported by ADADBS OPERCOM

The following Adabas operator commands can be used in the ADADBS OPERCOM utility function:

ADAEND Command

graphics/util_opercom_adaend.png

This command terminates an Adabas session normally. No new users are accepted after this command has been issued. ET logic updating is continued until the end of the current logical transaction for each user. After all activity has been completed as described above, the Adabas session is terminated.

In nucleus cluster environments, the GLOBAL option can be used to terminate the Adabas session in all active cluster nuclei.

ALOCKF Command

graphics/util_opercom_alockf.png

Lock a file in advance to ensure that an EXU, EXF, or UTI user will have exclusive control of the specified file. The advance-lock prevents new transactions from using the file. Once all current users have stopped using the file, the exclusive-control user has the lock. Until then, the exclusive-control user must wait.

To remove the advance lock without running the utility, see the RALOCKF command.

This command is not available in single user mode or for a read-only nucleus. It is available in cluster and non-cluster environments.

The following key points should be noted about advance-locks on files:

  1. An advance-lock can be set while a file is being used.

  2. A command requesting exclusive control (UTI, EXF, or EXU) over an advance-locked file will wait in the command queue until all other users stop using the file before it starts processing the file.

  3. Advance-locks are automatically removed when a user gets exclusive control over the file. However, if a file is locked (via the LOCKF, LOCKU, or LOCKX commands), the locks are not removed when a user gets exclusive control over the file. (Locks must be explicitly removed, whereas advance-locks are automatically removed.)

  4. Adabas will reject an advance-lock on a file that is already locked (via the LOCKF, LOCKU, LOCKX or ALOCKF commands) but will accept a lock request on an advance-locked file.

  5. To ensure you have uninterrupted exclusive control over a file in a situation where you have multiple steps to run that require uninterrupted exclusive control while all steps have been processed, use a combination of advance-locking the file (ALOCKF), stopping all users of the file (STOPF), and locking the file (LOCKU). An example of this is given later in this section.

  6. In the case of expanded files, an ALOCKF command is applied to the anchor file (representing the entire expanded file chain).

  7. In a cluster environment, advance-locks are effective in all nuclei of the cluster.

Simple Example

In the following example, issuing the ALOCKF request to advance-lock file 32 ensures that file 32 will be available so the ADALOD UPDATE function can take exclusive control (via a UTI request) of the file for its processing:

ADADBS OPERCOM ALOCKF=32
ADALOD UPDATE FILE=32

Adabas processing proceeds in the following manner for these utility functions:

  1. When the ADADBS OPERCOM ALOCKF request is submitted, file 32 is marked as advance-locked.

  2. If there are any active users of file 32, the ADALOD UTI request cannot be granted immediately and will wait for the active users to end their transactions or sessions. Active users continue to issue commands against file 32. However, requests by new users for file 32 are rejected because of the advance-lock on the file.

  3. When all active users of file 32 have ended their transactions or sessions, the ADALOD UTI request for exclusive control can be granted. Once exclusive control is established, ADALOD UPDATE processing can occur.

    As part of the successful execution of the ADALOD UTI request, the advance-lock is removed from the file. However, because ADALOD processing now has exclusive control of file 32, other users still cannot access it.

To accelerate the process and limit the wait time for the ADALOD UTI request, you can simply stop all active users of the file by force using the STOPF operator command:

ADADBS OPERCOM ALOCKF=32
ADADBS OPERCOM STOPF=32
ADALOD UPDATE FILE=32

In this case, the STOPF command will cause the nucleus to back out and stop users of file 32 before the ADALOD UTI request is granted. In addition, the advance-lock request specified by the ALOCKF command will prevent new users from accessing the file until the ADALOD UTI request for exclusive control is processed.

More Complex Example

An advance-lock set by ALOCKF cannot guarantee that multiple job steps in a series get uninterrupted exclusive control over a file, as the advance-lock is removed when the first step obtains exclusive control. Suppose an installation wants to run the following utility sequence:

ADAULD UNLOAD FILE=45
ADADBS REFRESH FILE=45
ADALOD UPDATE FILE=45

An ALOCKF request to advance-lock file 45 in this case would only work for the ADAULD UNLOAD function, because the ADAULD EXU request for exclusive control of file 45 would remove the advance-lock. If there are active users who try to issue commands against file 45, there is a chance that one of them will execute a command between the UNLOAD and REFRESH steps, or between the REFRESH and UPDATE steps. Such a user may also prevent the REFRESH or UPDATE step from obtaining exclusive control of file 45.

To ensure you have uninterrupted exclusive control over the file in this situation, use a combination of advance-locking the file (ALOCKF), stopping all users of the file (STOPF), and locking the file (LOCKU):

ADADBS OPERCOM ALOCKF=45
ADADBS OPERCOM STOPF=45
ADADBS OPERCOM LOCKU=45
ADAULD UNLOAD FILE=45
ADADBS REFRESH FILE=45
ADALOD UPDATE FILE=45
ADADBS OPERCOM UNLOCKU=45

In this example, Adabas processing proceeds in the following manner:

  1. When the ADADBS OPERCOM ALOCKF request is submitted, file 45 is marked as advance-locked.

    The ADADBS OPERCOM STOPF request causes the nucleus to back out and stop users of file 45. (This step is optional.)

    The ADADBS OPERCOM LOCKU request locks the file more permanently than the ALOCKF request since the LOCKU lock will stay in effect until it is explicitly released.

  2. If there are any active users updating file 45, the ADAULD EXU request cannot be granted immediately and will wait for the update users to end their transactions or sessions. Active users may continue to issue commands against file 45. However, requests by new users for file 45 are rejected because of the advance-lock on the file.

  3. When all active users of file 45 have ended their transactions or sessions, the ADAULD request for exclusive-update (EXU) control can be granted. Once exclusive-update control is established, ADAULD UNLOAD processing can occur.

    As part of the successful execution of the ADAULD EXU request, the advance-lock is removed from the file. When ADAULD completes processing, it releases the EXU control of file 45. However, during and after the ADAULD execution, the LOCKU lock ensures that other users still cannot access the file.

  4. The ADADBS utility will issue a UTI request for exclusive control of file 45, which will be granted. ADADBS REFRESH processing will then occur. When it completes, ADADBS will release exclusive control of file 45. However, the LOCKU lock ensures that other users still cannot access it.

  5. The ADALOD utility will issue a UTI request for exclusive control of file 45, which will be granted. ADALOD UPDATE processing will then occur. When it completes, ADALOD will release exclusive control of file 45. However, the LOCKU lock ensures that other users still cannot access it.

  6. The ADADBS OPERCOM UNLOCKU request explicitly unlocks file 45, making it available for other users.

ASSOSPACEWARN Command

graphics/op_assospacewarn.png

Use the ASSOSPACEWARN command to modify the setting of the ASSOSPACEWARN ADARUN parameter while the database is running. ASSOSPACEWARN specifies up to three pairs of threshold percentages and percentage change increments, expressed as percentages of the total Associator (ASSO) portion of the database. When ASSO space use reaches a specified threshold percentage, a space usage message is issued. In addition, when the ASSO space use changes by the increment specified for that threshold, additional space usage messages are issued.

Note:
For the purposes of database space notifications, the space used in the Adabas database comprises all database blocks that have been assigned either to some common purpose (for example, DSST, PPT, DLOG area) or to a file in the database. Only space listed in the free space table (FST) is not calculated as used. In particular, free space allocated for some file but not yet used is calculated as used.

The following specifications can be made in the ASSOSPACEWARN command:

Parameter Description
threshold# A threshold, expressed as a percentage of the total Associator portion of the database. When ASSO space use exceeds or falls below any of the thresholds set, a space usage message is issued. The default is zero (0). If zero is specified for the first threshold setting, no space messages are issued.

When more than one threshold is specified, the second threshold specification must be greater than the first. Likewise, the third threshold specification (if made) must be greater than the second.

inc# An increment percentage, expressed as a percentage of the total ASSO portion of the database. When ASSO space use changes (increases or decreases) from the associated threshold by the amount given in this increment percentage, another space usage message is issued. The default is five percent (5).

Up to three threshold-increment pairs can be specified.

AUDCONNECT Command

graphics/op_audconnect.png

Use this command to dynamically force a connection attempt to either a specific Auditing Server or Adabas database ID, or to all related Auditing Server or Adabas database IDs.

One of the parameters of the AUDCONNECT command must be specified. There is no default. The parameters are described in the following table:

Parameter Description
ALL Forces a reconnection attempt with ALL known Auditing Server or Adabas database IDs.
dbid The specified Auditing Server or Adabas database ID.
AUDITLOG Command

graphics/op_auditlog.png

Use the AUDITLOG command to modify the setting of the AUDITLOG ADARUN parameter while the database is running. Valid option is "CONSOLE". Once AUDITLOG has been activated with "CONSOLE", it cannot be changed to "NO" without cycling the nucleus.

In the following example, issuing the AUDITLOG requests activates the AUDITLOG to start writing all utility, and AOS audit data to the console.

ADADBS OPERCOM AUDITLOG=CONSOLE
AUTOINCASSOSIZE Command

graphics/op_autoincassosize.png

Use the AUTOINCASSOSIZE command to modify the setting of the AUTOINCASSOSIZE ADARUN parameter while the database is running. AUTOINCASSOSIZE specifies the size, in cylinders or blocks, by which the highest-numbered (last-defined) Associator (ASSO) data set will be increased by an automatic database increase process.

This parameter only has an effect if the AUTOINCASSOTHRESHOLD setting has a non-zero value. A numeric value followed by the letter B indicates the value specifies a number of blocks, which is then rounded up to the next highest amount that fills the final track or other platform-dependent minimum space allocation unit. A numeric value without the suffix B indicates the increment is in cylinders.

If an automatic database increase process is started to increase the ASSO component of the database, the last ASSO container data set will be increased by the number of cylinders or blocks specified by AUTOINCASSOSIZE. (The number of cylinders or blocks added may be less, however, if the limit set by the AUTOINCASSOTOTAL parameter is reached.)

If the last ASSO container data set cannot be increased by the specified size, but only by a lesser amount, the automatic increase process will increase the data set by the amount of space that it can get. Note that one data set can span at most 59 volumes with up to 16 extents on each volume. When these limits are reached, the database should be increased manually by adding a new container data set with the ADADBS ONLADD utility function.

When 4-byte RABNs are used, valid values for this parameter range from zero (0) to 2147483647 cylinders or from zero (0) to 2147483647B blocks. When 3-byte RABNs are used, the limits range from zero (0) to 16775215 blocks or the equivalent in cylinders. A value of "0" or "0B" means that no automatic increase will be performed for ASSO space. The default value for this parameter is zero, which functionally disables auto-increase for ASSO space.

If AUTOINCASSOSIZE is set to a small value, the automatic database increase process may be initiated multiple times and cause the container allocation to reach platform-dependent limits on extents and volumes. Once that occurs, there can be no more auto-increases until the container allocations are consolidated, which requires stopping all nuclei using the container. Alternatively, a manual increase can be used to add another container without stopping the Adabas nucleus.

AUTOINCASSOTHRESHOLD Command

graphics/op_autoincassothreshold.png

Use the AUTOINCASSOTHRESHOLD command to modify the setting of the AUTOINCASSOTHRESHOLD ADARUN parameter while the database is running. AUTOINCASSOTHRESHOLD specifies the Associator space threshold at which Adabas automatically initiates a database increase process. This threshold is expressed as a percentage of used Associator (ASSO) space to total Associator space available in the database, ASSO space is considered used if it is not listed as free in the Free Space Table (FST).

If the used Associator space exceeds the percentage defined by the specified AUTOINCASSOTHRESHOLD setting, Adabas automatically initiates a database increase process for ASSO space.

Note that the database increase process may take some time, the length of which is related to the size by which the database is increased (the value of the AUTOINCASSOSIZE setting). The AUTOINCASSOTHRESHOLD setting should be configured so that the increase process is given sufficient time to complete before the database fills up, assuming a reasonable space consumption rate.

Once a database increase process has been initiated, another automatic increase for ASSO space may be started only after the first process has finished and the ASSO space usage again or still exceeds the specified threshold.

Valid values for this command are either zero (0) or integers ranging from 50 through 100. A value of zero means that no automatic increase will be performed for ASSO space. A value of 100 means that an automatic increase process will be initiated only when the ASSO space grows full (i.e., no free space is left at all). The default value is zero, which functionally disables auto-increase processes for ASSO space.

AUTOINCASSOTOTAL Command

graphics/op_autoincassototal.png

Use the AUTOINCASSOTOTAL command to modify the setting of the AUTOINCASSOTOTAL ADARUN parameter while the database is running. AUTOINCASSOTOTAL specifies the maximum total size, in cylinders or blocks, of the entire Associator space of the database that is not to be exceeded by automatic database increase processes.

A numeric value followed by the letter B indicates the value specifies a number of blocks, which is then rounded up to the next highest amount that fills the final track or other platform-dependent minimum space allocation unit. A numeric value without a suffix B indicates the increment is in cylinders.

An automatic database increase process for ASSO space will not exceed the size specified by the AUTOINCASSOTOTAL setting. This setting can be used to limit the total amount of disk space used for the database, in order to protect the disk space remaining available for other databases and other users of the system. Note that this setting limits only automatic increases by Adabas; it does not limit increasing the database manually using the ADADBS ADD, INCREASE, ONLADD or ONLINCREASE utility functions.

AUTOINCASSOTOTAL specifies the number of cylinders or blocks beyond which automatic database increase processes will not extend the ASSO space of the database. If the AUTOINCASSOTOTAL setting is less than the current number of cylinders in the ASSO space plus the AUTOINCASSOSIZE value, an automatic increase will increase the ASSO space only by the difference between the AUTOINCASSOTOTAL value and the current size – that is, by less than the increase requested by the AUTOINCASSOSIZE setting. If AUTOINCASSOTOTAL is not greater than the current number of cylinders in ASSO, no further automatic increases will be performed for ASSO space.

When 4-byte RABNs are used, valid values for this parameter range from zero (0) to 2147483647 cylinders or from zero (0) to 2147483647B blocks. When 3-byte RABNs are used, the limits range from zero (0) to 16775215 blocks or the equivalent in cylinders. A value of "0" or "0B" means that no automatic increase will be performed for ASSO space. The default value for this parameter is zero, which functionally disables auto-increase for ASSO space.

The total size of ASSO space may be constrained to less than the AUTOINCASSOTOTAL value for either of the following reasons.

  • There may not be enough storage resources to extend to the specified limit.

  • When using 4-byte RABNs, a component can have at most 2147483647 blocks, and for 3-byte RABNs the limit is 16777215 blocks.

AUTOINCDATASIZE Command

graphics/op_autoincdatasize.png

Use the AUTOINCDATASIZE command to modify the setting of the AUTOINCDATASIZE ADARUN parameter while the database is running. AUTOINCDATASIZE specifies the size, in cylinders or blocks, by which the highest-numbered (last-defined) Data Storage (DATA) data set will be increased by an automatic database increase process.

This parameter only has an effect if the AUTOINCDATATHRESHOLD has a non-zero value. A numeric value followed by the letter B indicates the value specifies a number of blocks, which is then rounded up to the next highest amount that fills the final track or other platform-dependent minimum space allocation unit. A numeric value without the suffix B indicates the increment is in cylinders.

If an automatic database increase process is started to increase the DATA component of the database, the last DATA container data set will be increased by the number of cylinders or blocks specified by AUTOINCDATASIZE. (The number of cylinders or blocks added may be less, however, if the limit set by the AUTOINCDATATOTAL parameter is reached.)

If the last ASSO container data set cannot be increased by the specified size, but only by a lesser amount, the automatic increase process will increase the data set by the amount of space that it can get. Note that one data set can span at most 59 volumes with up to 16 extents on each volume. When these limits are reached, the database should be increased manually by adding a new container data set with the ADADBS ONLADD utility function.

When 4-byte RABNs are used, valid values for this parameter range from zero (0) to 2147483647 cylinders or from zero (0) to 2147483647B blocks. When 3-byte RABNs are used, the limits range from zero (0) to 16775215 blocks or the equivalent in cylinders. A value of "0" or "0B" means that no automatic increase will be performed for DATA space. The default value for this parameter is zero, which functionally disables auto-increase for DATA space.

If AUTOINCDATASIZE is set to a small value, the automatic database increase process may be initiated multiple times and cause the container allocation to reach platform-dependent limits on extents and volumes. Once that occurs, there can be no more auto-increases until the container allocations are consolidated, which requires stopping all nuclei using the container. Alternatively, a manual increase can be used to add another container without stopping the Adabas nucleus.

AUTOINCDATATHRESHOLD Command

graphics/op_autoincdatathreshold.png

Use the AUTOINCDATATHRESHOLD command to modify the setting of the AUTOINCDATATHRESHOLD ADARUN parameter while the database is running. AUTOINCDATATHRESHOLD specifies the Data Storage space threshold at which Adabas automatically initiates a database increase process. This threshold is expressed as a percentage of used Data Storage space to total Data Storage space available in the database. DATA space is considered used if it is not listed as free in the Free Space Table (FST).

If the used Data Storage space exceeds the percentage defined by the specified AUTOINCDATATHRESHOLD setting, Adabas automatically initiates a database increase process for DATA space.

Note that the database increase process may take some time, the length of which is related to the size by which the database is increased (the value of the AUTOINCDATASIZE setting). The AUTOINCDATATHRESHOLD setting should be configured so that the increase process is given sufficient time to complete before the database fills up, assuming a reasonable space consumption rate.

Once a database increase process has been initiated, another automatic increase for DATA space may be started only after the first process has finished and the DATA space usage again or still exceeds the specified threshold.

Valid values for this command are either zero (0) or integers ranging from 50 through 100. A value of zero means that no automatic increase will be performed for DATA space. A value of 100 means that an automatic increase process will be initiated only when the DATA space grows full (i.e., no free space is left at all). The default value is zero, which functionally disables auto-increase processes for DATA space.

AUTOINCDATATOTAL Command

graphics/op_autoincdatatotal.png

Use the AUTOINCDATATOTAL command to modify the setting of the AUTOINCDATATOTAL ADARUN parameter while the database is running. AUTOINCDATATOTAL specifies the maximum total size, in cylinders or blocks, of the entire Data Storage space of the database that is not to be exceeded by automatic database increase processes.

A numeric value followed by the letter B indicates the value specifies a number of blocks, which is then rounded up to the next highest amount that fills the final track or other platform-dependent minimum space allocation unit. A numeric value without a suffix B indicates the increment is in cylinders.

An automatic database increase process for DATA space will not exceed the size specified by the AUTOINCDATATOTAL setting. This setting can be used to limit the total amount of disk space used for the database, in order to protect the disk space remaining available for other databases and other users of the system. Note that this setting limits only automatic increases by Adabas; it does not limit increasing the database manually using the ADADBS ADD, INCREASE, ONLADD or ONLINCREASE utility functions.

AUTOINCDATATOTAL specifies the number of cylinders or blocks beyond which automatic database increase processes will not extend the DATA space of the database. If AUTOINCDATATOTAL setting is less than the current DATA size plus the AUTOINCDATASIZE value, an automatic increase will increase the DATA space only by the difference between the AUTOINCDATATOTAL value and the current size – that is, by less than the increase requested by the AUTOINCDATASIZE setting. If the AUTOINCDATATOTAL setting is not greater than the current DATA size, no further automatic increases will be performed for DATA space.

When 4-byte RABNs are used, valid values for this parameter range from from zero (0) to 2147483647 blocks or the equivalent in cylinders. When 3-byte RABNs are used, the limits range from zero (0) to 16775215 blocks or the equivalent in cylinders. A value of "0" or "0B" means that no automatic increase will be performed for DATA space. The default value for this parameter is zero, which functionally disables auto-increase for DATA space.

The total size of DATA space may be constrained to less than the AUTOINCDATATOTAL value for either of the following reasons.

  • There may not be enough storage resources to extend to the specified limit.

  • When using 4-byte RABNs, a component can have at most 2147483647 blocks, and for 3-byte RABNs the limit is 16777215 blocks.

CANCEL Command

graphics/util_opercom_cancel.png

Cancel the Adabas session immediately. All command processing is immediately suspended. A pending autorestart is in effect which in turn causes the autorestart routine to be executed during the initialization of the next Adabas session.

In nucleus cluster environments, the GLOBAL option can be used to cancel the Adabas session in all active cluster nuclei.

CLOGMRG Command

graphics/util_opercom_clogmrg.png

Switches automatic command log merging (ADARUN CLOGMRG parameter value) on or off in nucleus cluster environments.

The CLOGMRG command is global by definition and affects all nuclei in the cluster. If a NUCID is specified, it is ignored.

CLUPUBLPROT Command

graphics/op_clupublprot.png

Use the CLUPUBLPROT command to dynamically modify the setting of the ADARUN CLUPUBLPROT parameter. For more information, read CLUPUBLPROT Parameter: Publishing of Protection Data.

The CLUPUBLPROT command is only valid in cluster environments. It is global by definition and affects all nuclei in the cluster. If a NUCID is specified, it is ignored.

CT Command

graphics/util_opercom_ct.png

Dynamically override the ADARUN CT parameter value; that is, the maximum number of seconds that can elapse from the time an Adabas command has been completed until the results are returned to the user through interregion communication (which depends on the particular operating system being used). The minimum setting is 1; the maximum is 16777215.

In nucleus cluster environments, the CT command is global by definition and affects all nuclei in the cluster. If a NUCID is specified, it is ignored.

DATASPACEWARN Command

graphics/op_dataspacewarn.png

Use the DATASPACEWARN command to modify the setting of the DATASPACEWARN ADARUN parameter while the database is running. DATASPACEWARN specifies up to three pairs of threshold percentages and percentage change increments, expressed as percentages of the total Data Storage (DATA) portion of the database. When Data Storage space use reaches a specified threshold percentage, a space usage message is issued. In addition, when the Data Storage space use changes by the increment specified for that threshold, additional space usage messages are issued.

Note:
For the purposes of database space notifications, the space used in the Adabas database comprises all database blocks that have been assigned either to some common purpose (for example, DSST, PPT, DLOG area) or to a file in the database. Only space listed in the free space table (FST) is not calculated as used. In particular, free space allocated for some file but not yet used is calculated as used.

The following specifications can be made in the DATASPACEWARN command:

Parameter Description
threshold# A threshold, expressed as a percentage of the total Data Storage (DATA) portion of the database. When DATA space use exceeds or falls below any of the thresholds set, a space usage message is issued. The default is zero (0). If zero is specified for the first threshold setting, no space messages are issued.

When more than one threshold is specified, the second threshold specification must be greater than the first. Likewise, the third threshold specification (if made) must be greater than the second.

inc# An increment percentage, expressed as a percentage of the total DATA portion of the database. When DATA space use changes (increases or decreases) from the associated threshold by the amount given in this increment percentage, another space usage message is issued. The default is five percent (5).

Up to three threshold-increment pairs can be specified.

DAUQ Command

graphics/op_dauq.png

Display the user queue element (UQE) of each user who has executed at least one Adabas command within the last 15 minutes. Up to 100 user queue elements will be displayed.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DCMDSTAT Command

graphics/op_dcmdstat.png

Display statistics about the usage distribution of commands by command type.

Here is sample output from the DCMDSTAT operator command when run using the ADADBS OPERCOM utility function:

ADADBS OPERCOM DCMDSTAT 

Type              Commands 
 -------------------------- 
 A1/4               527,017
 CL                       3 
 ET                      28 
 HI                 528,086
 L2/5            20,784,748 
 L3/6             9,977,842 
 N1/2                   282 
 OP                       3 
 UC                       3 
 REST                     1 
 -------------------------- 
 Total           31,818,013
DCQ Command

graphics/op_dcq.png

Display all posted command queue elements (CQEs). Each CQE's user ID, job name, and buffer length is displayed.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other. Here is sample output from the DCQ operator command run using the ADADBS OPERCOM utility function:

User/Terminal-ID  Jobname   SECUID    Time      Status  Cmd  File   Length
 --------------------------------------------------------------------------
 'Z007Z007'        ABCTPCTA  ABC       13:36:14  Done    L3     27     1664
 'Z019Z019'        ABCTPCTA  ABC       13:36:14  Ready   A1     21     1388
 C90060C839F60000  ABCDCQ    ABC       13:36:14  Active  LA      0      720
DDIB Command

graphics/op_ddib.png

Display data integrity block (DIB). This block contains entries indicating which Adabas utilities are active and the resources being used by each utility. The DDIB function can be performed with either an active or an inactive nucleus.

In nucleus cluster environments, the information displayed by the DDIB command is global; the command can be run on any nucleus.

DDSF Command

graphics/op_ddsf.png

Display Adabas Delta Save Facility Facility (DSF) status. The Adabas nucleus displays the DSF status on the operator console as well as in the ADADBS job protocol.

This function is only available if the nucleus is run with the parameter ADARUN DSF=YES.

In nucleus cluster environments, the information displayed by the DDSF command is global; the command can be run on any nucleus.

DFILES Command

graphics/op_dfiles.png

Displays the number of access, update, EXU, and UTI users for the specified files. User types are totaled for each file, and are listed by file. Up to five files can be specified in this command. Up to 798 users are displayed.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other. Here is sample output from the DFILES operator command run using the ADADBS OPERCOM utility function:

       U E    U      A
       T X     P      C
 File  I U      D      C    User   User/Terminal-ID Jobname  SECUID   ETID
 -----------------------------------------------------------------------------
   11  1 0      1      1  00008ACB C9108B278FF52000 ABCLOD   ABC
 
   12  0 1      0      1  00008BF3 C9108CF0F4E09000 ABC      ABC
 
   23  0 0     14     17  00008EC7 'Z001Z001'       ABCTPCTA ABC      Z01-ETID
                          00008EC8 'Z002Z002'       ABCTPCTA ABC      Z02-ETID
                          00008EC9 'Z003Z003'       ABCTPCTA ABC      Z03-ETID
                          00008ECA 'Z004Z004'       ABCTPCTA ABC      Z04-ETID
                          00008ECB 'Z005Z005'       ABCTPCTA ABC      Z05-ETID
                          00008ECC 'Z006Z006'       ABCTPCTA ABC      Z06-ETID
                          00008ECE 'Z007Z007'       ABCTPCTA ABC      Z07-ETID
                          00008ECF 'Z008Z008'       ABCTPCTA ABC      Z08-ETID
                          00008ED0 'Z009Z009'       ABCTPCTA ABC      Z09-ETID
                          00008ED1 'Z010Z010'       ABCTPCTA ABC      Z10-ETID
                          00008ED2 'Z011Z011'       ABCTPCTA ABC      Z11-ETID
                          00008ED3 'Z012Z012'       ABCTPCTA ABC      Z12-ETID
                          00008ED5 'Z013Z013'       ABCTPCTA ABC      Z13-ETID
                          00008ED8 'Z014Z014'       ABCTPCTA ABC      Z14-ETID
                          00008ED9 'Z015Z015'       ABCTPCTA ABC      Z15-ETID
                          00008EDA 'Z016Z016'       ABCTPCTA ABC      Z16-ETID
                          00008EDB 'Z017Z017'       ABCTPCTA ABC      Z17-ETID
DFILESTAT Command

graphics/op_dfilestat.png

Display statistics for the number of commands by file.

DFILUSE Command

graphics/util_opercom_dfiluse.png

Displays the count of commands processed for the specified file so far during the current session.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DHQA Command

graphics/op_dhqa.png

Display all hold queue elements (HQEs) and all users of each element.

Here is sample output from the DHQA operator command run using the ADADBS OPERCOM utility function:

 File        ISN  Mode    User   User/Terminal-ID  Jobname   SECUID   ETID
 -----------------------------------------------------------------------------
   10          1  SHR   000072A1 'U001U001'        ABCTXG    ABC
                  SHR   000072A2 'U002U002'        ABCTXG    ABC
                  SHR   000072A3 'U003U003'        ABCTXG    ABC
                  SHR   000072A4 'U004U004'        ABCTXG    ABC
                  SHR   000072A5 'U005U005'        ABCTXG    ABC
                  SHR   000072A6 'U006U006'        ABCTXG    ABC
                  SHR   000072A7 'U007U007'        ABCTXG    ABC
                  SHR   000072A8 'U008U008'        ABCTXG    ABC
   11         10  SHR   000072D6 C90F5F4552580000  SILLYJOB
   22          2  EXCL  000072E8 'Z001Z001'        ABCTPCTA  ABC      Z01-ETID
   22          3  EXCL  000072E2 'Z002Z002'        ABCTPCTA  ABC      Z02-ETID
   22          5  EXCL
   22          7  EXCL  000072E9 'Z005Z005'        ABCTPCTA  ABC      Z05-ETID
   22         10  EXCL  000072F0 'Z008Z008'        ABCTPCTA  ABC      Z08-ETID
   22         12  EXCL  000072E3 'Z003Z003'        ABCTPCTA  ABC      Z03-ETID
   22         15  EXCL  000072ED 'Z009Z009'        ABCTPCTA  ABC      Z09-ETID
   23       4783  EXCL  000072F3 'Z011Z011'        ABCTPCTA  ABC      Z11-ETID
...
   29     108191  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
   29     113431  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
   29     113823  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
   29     129953  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
   29     164217  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
   29     171617  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
   29     181868  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
   29     197793  EXCL  000072E4 'Z004Z004'        ABCTPCTA  ABC      Z04-ETID
DLOCKF Command

graphics/op_dlockf.png

Display locked files. The type of lock appears in parentheses following the file number. Possible file types are:

Type Description
F The file was locked by LOCKF.
U The file was locked by LOCKU.
X The file was locked by LOCKX.
A The file was advance locked by ALOCKF.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DNC Command

graphics/op_dnc.png

Display the number of posted command queue elements (CQEs) waiting to be selected.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DNH Command

graphics/op_dnh.png

Display the number of ISNs currently in the hold queue.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DNU Command

graphics/op_dnu.png

Display the number of current users.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DONLSTAT Command

graphics/op_donlstat.png

Note:
Not currently available for use with Adabas Parallel Services cluster nuclei.

Display status of each active reorder or invert online process together with the process ID.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DPARM Command

graphics/op_dparm.png

Display the Adabas session parameters currently in effect. The parameters are displayed in alphabetic order. In a cluster environment, they are also grouped by nucleus ID (NUCID).

Note:
Additional Adabas add-on products and nucleus components will display additional parameters from those shown for a classic nucleus. A sample of the output produced by an ADADBS OPERCOM DPARM run is shown below:

 ADADBS OPERCOM DPARM

           AOSLOG=YES
           ARNWORKBUFFERS=270
           ASSOSPACEWARN=50,10
           ASYTVS=YES
           AUDITLOG=CONSOLE
           AUTOCQENV=ALL
           AUTOCQTIME=60
           AUTOINCASSOSIZE=500
           AUTOINCASSOTHRESHOLD=80
           AUTOINCASSOTOTAL=10,000
           AUTOINCDATASIZE=1000
           AUTOINCDATATHRESHOLD=80
           AUTOINCDATATOTAL=20,000
           CT=900
           DATASPACEWARN=60,5
           FMXIO=1
           INDEXCROSSCHECK=YES
           INDEXUPDATE=ADVANCED
           INTNAS=3,600
           LARGEPAGE=NO
           LBP= 104,860,416
           LCP=10,000
           LDEUQP=5,000
           LFIOP=1
           LFP=10,240,000
           LI=819,200
           LOGCB=YES
           LOGFB=NO
           LOGGING=NO
           LOGIB=YES
           LOGIO=NO
           LOGMB=NO
           LOGRB=YES
           LOGSB=NO
           LOGUX=YES
           LOGVB=NO
           LOGVOLIO=NO
           LOGWARN=30
           LP=4,000
           LQ=220,000
           LRPL=104,857,600
           LS=29,952
           LU=64,000
           LWP=1,200,000
           MXTNA=7,200
           MXTSX=7,200
           MXTT=900
           NC=2,000
           NH=5,000
           NISNHQ=1,000
           NONDES=YES
           NPLOGBUFFERS=9
           NQCID=10
           NSISN=51
           NT=30
           NU=10,000
           NWORK1BUFFERS=9
           READONLY=NO
           REFSTPRT=YES
           REVIEW=NO
           RIAFTERUPDATE=NO
           SECUID=WARN
           SMF=YES
           SMFDETAIL=NONE
           SMFINTERVAL=5
           SMFRECNO=255
           SMFSUBSYS=CURR
           SMF89=NO
           TLSCMD=900
           TNAA=3,600
           TNAE=3,600
           TNAX=300
           TT=300
           UPDATECONTROL=NODELAY
           UTIONLY=NO
           V64BIT=YES


  A D A D B S  Terminated normally                          2016-02-24  23:17:00
DRES Command

graphics/op_dres.png

Display the allocated pool space and the highest use level ('high water mark') reached so far during the current session by record count and by percent for the following resources:

Resource Name Description Associated Parameter
AB - Pool

Attached buffer table

NAB
CQ - Pool

Command queue

NC
DUQ - Pool

Unique descriptor pool

LDEUQP
FI - Pool

Internal format buffer pool

LFP
HQ - Pool

Hold queue

NH
Plog-IO B

PLOG I/O buffers

NPLOGBUFFERS
REDO - Pool

Cluster redo pool (only with Adabas cluster environments)

LRDP
RPL - Pool

Replication pool (only with Event Replicator for Adabas environments)

LRPL
SC - Pool

Security pool

LCP
TBI - Pool

Pool for the table of ISNs

LI
TBS - Pool

Pool for the table of sequential commands

LQ
UQ - Pool

User queue

NU
UQF - Pool

User queue file list pool

NU
Wrk1 - IO B

Work I/O buffers

NWORK1BUFFERS
WORK - Pool

Work pool (WP)

LWP
Work Prt1

Work part 1 area (WKP1)

Note:
The maximum pool value of Work part 1 is derived from the LP parameter. It corresponds to the maximum number of blocks a transaction can spend on Work Part 1 before Adabas decides to back it out.

LP
Work Prt1b

Work Part 1 extension (only with Adabas cluster environments)

CLUWORK1CACHE
Work Prt2

Work part 2 area (WKP2)

LWKP2
Work Prt3

Work part 3 area (WKP3)

 
XID -Pool

Pool for global transaction IDs (only with Adabas Transaction Manager environments)

NU

The actual values are displayed in nucleus message ADAN28.

DSPACE Command

graphics/op_dspace.png

Display space defined and used in ASSO and DATA.

Here is sample output from the DSPACE operator command run using the ADADBS OPERCOM utility function::

ADADBS OPERCOM DSPACE                  

         Database ASSO usage is 80%    
         16,101KB of 20,079KB in use     
         6,481 of 8,082 blocks in use    
         24 of 30 cylinders in use     
                                       
         Database DATA usage is 71%    
         15,983KB of 22,204KB in use     
         3,232 of 4,490 blocks in use    
         22 of 30 cylinders in use     
DSTAT Command

graphics/op_dstat.png

Display the current Adabas nucleus operating status.

Note:
After issuing a REFRESHSTATS, DSTAT displays the refreshed statistics.

DTH Command

graphics/op_dth.png

Display thread status.

DUQ Command

graphics/op_duq.png

Display all active and inactive user queue elements.

Here is sample output from the DUQ operator command run using the ADADBS OPERCOM utility function:

   User    User/Terminal-ID  Jobname   SECUID   ETID      Typ  State  Active
 -----------------------------------------------------------------------------
 00002BD8  'U001U001'        ABCTXG    ABC                ACC  OK     09:46:03
 00002C20  'Z001Z001'        ABCTPCTA  ABC      Z01-ETID  ET   ET     09:46:19
 00002C27  'Z002Z002'        ABCTPCTA  ABC      Z02-ETID  ET   TRANS  09:46:18
 00002C26  'Z003Z003'        ABCTPCTA  ABC      Z03-ETID  ET   TRANS  09:46:19
 00002C2E  'Z004Z004'        ABCTPCTA  ABC      Z04-ETID  ET   ET     09:46:19
 00002C13  'Z005Z005'        ABCTPCTA  ABC      Z05-ETID  ET   T-OUT  09:40:31
 00002C30  C8F39ABD5A18DE84  ABCDUQ    ABC                UTI  OK     09:46:19
 00000002  'ABC    1'        DAEFCO    ABC                UTI  OK     08:33:56
DUQA Command

graphics/op_duqa.png

Display all user queue elements (UQEs).

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DUQE Command

graphics/util_opercom_duqe.png

Display a user queue element for the specified Adabas-assigned user ID as follows:

DUQE=X'A3CF2'

The user ID must be entered in hexadecimal format. Do not use a job name for the user ID. In nucleus cluster environments, NUCID must always be specified because the user ID is not unique to the cluster. When a user is associated with a time zone this information is displayed.

Here is sample output (when the user is not associated with a time zone) from the DUQE operator command run using the ADADBS OPERCOM utility function:

                                                                        Last    
   User    User/Terminal-ID  Jobname   SECUID   ETID      Typ  State  Active
 -----------------------------------------------------------------------------
 000001A6  'Z001Z001'        AZUTPCTA  AZU                ET   TRANS  13:41:05
 
Communication ID  = 000FA10E20980000 4040404040404040 00FB0800 ...
Session start     = 13:38:42
Transaction start = 13:41:04
 
Number of files   =    8
 
             File =   21 (ACC)
             File =   22 (ACC)
             File =   23 (ACC)
             File =   25 (UPD)
             File =   26 (UPD)
             File =   27 (UPD)
             File =   28 (ACC)
             File =   29 (UPD)

Here is sample output (when the user is associated with a time zone) from the DUQE operator command run using the ADADBS OPERCOM utility function:

                                                                        Last
   User    User/Terminal-ID  Jobname   SECUID   ETID      Typ  State  Active
 -----------------------------------------------------------------------------
 000001A6  'Z001Z001'        AZUTPCTA  AZU                ET   TRANS  13:41:05
 
Time Zone         = AMERICA/DENVER

Communication ID  = 000FA10E20980000 4040404040404040 00FB0800 ...
Session start     = 13:38:42
Transaction start = 13:41:04
 
Number of files   =    8
 
             File =   21 (ACC)
             File =   22 (ACC)
             File =   23 (ACC)
             File =   25 (UPD)
             File =   26 (UPD)
             File =   27 (UPD)
             File =   28 (ACC)
             File =   29 (UPD)

DUUQE Command

graphics/op_duuqe.png

Display utility user queue elements (UQEs). Up to 100 user queue elements will be displayed.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DVOLIO Command

graphics/op_dvolio.png

Display ASSO and DATA I/Os by volume serial (VOLSER) number. The number of reads and writes to each volume is displayed.

In nucleus cluster environments, the NUCID=0 option can be used to display information for all active cluster nuclei. Information is displayed for each nucleus, one after the other.

DXCACHE Command

graphics/op_dxcache.png

Issue the DXCACHE command against cluster nuclei to display the primary cache-related statistics. Statistics are displayed in messages on the console. The kinds of statistics displayed are described in External Cache Statistics (Cluster Nucleus Only), in the Adabas Cluster Services Operations Guide or in Global Cache Statistics (Cluster Nucleus Only) in the Adabas Parallel Services Operations Guide.

The full set of statistics shown in this output is displayed only for users who have the selectable unit Adabas Online System (AOS) installed.

If you have installed only the demo version of AOS delivered with Adabas, only the statistics in the sections Totals, Data Storage, and Normal Index are displayed using this command.

DXFILE Command

graphics/dxfile.png

Issue the DXFILE command against cluster nuclei to display cache-related statistics for files. File numbers can be specified in sequences, separated by commas. Ranges of file numbers can also be specified in the sequence. A maximum of five files can be specified in the command, so if you want to get results for more than five files, specify a range of files instead. The following are valid examples of ADADBS OPERCOM DXFILE specifications:

DXFILE=10-99 
DXFILE=1,2,10-99 
DXFILE=10-99,200 
DXFILE=10-99,200-300 

Statistics are displayed in messages on the console. The kinds of statistics displayed are described in External Cache Statistics (Cluster Nucleus Only), in the Adabas Cluster Services Operations Guide or in Global Cache Statistics (Cluster Nucleus Only), in the Adabas Parallel Services Operations Guide.

DXLOCK Command

graphics/op_dxlock.png

Issue the DXLOCK command against cluster nuclei to display lock-related statistics. Statistics are displayed in messages on the console. The kinds of statistics displayed are described in External Lock Statistics (Cluster Nucleus Only), in the Adabas Cluster Services Operations Guide or in Global Lock Statistics (Cluster Nucleus Only), in the Adabas Parallel Services Operations Guide.

DXMSG Command

graphics/op_dxmsg.png

The DXMSG command can be used to display the messaging performance statistics available for Adabas Cluster Services or Adabas Parallel Services. Statistics are displayed in messages on the console. The kinds of statistics displayed are described in Messaging Statistics, in the Adabas Cluster Services Operations Guide or Adabas Parallel Services Operations Guide.

The statistics produced by the DXMSG command can be used to determine the impact of messaging on system performance and to determine how to set the ADARUN MXMSG parameter.

DXSTAT Command

graphics/op_dxstat.png

Use DXSTAT command against cluster nuclei to display all cache- and lock-related statistics. Statistics are displayed in messages on the console. The kinds of statistics displayed are described in External Cache Statistics (Cluster Nucleus Only), External Lock Statistics (Cluster Nucleus Only) and WORK Data Set I/O Statistics (Cluster Nucleus Only), in the Adabas Cluster Services Operations Guide and in Global Cache Statistics (Cluster Nucleus Only), Global Lock Statistics (Cluster Nucleus Only) and WORK Data Set I/O Statistics (Cluster Nucleus Only), in the Adabas Parallel Services Operations Guide.

The full set of external cache statistics shown in this output is displayed only for users who have the selectable unit Adabas Online System (AOS) installed.

If you have installed only the demo version of AOS delivered with Adabas, only the external cache statistics in the sections Totals, Data Storage, and Normal Index are displayed using this command. All file cache statistics for files and all external lock statistics are displayed.

DXWORK Command

graphics/op_dxwork.png

Use the DXWORK command to display the read and write I/O statistics for the accesses to the WORK datasets of peer nuclei by a particular nucleus in the cluster. The DXWORK command may or may not display I/O statistics for a nucleus’ own WORK dataset.

The DXWORK command is only valid in cluster environments. The kinds of statistics displayed are described in WORK Data Set I/O Statistics (Cluster Nucleus Only), in the Adabas Cluster Services Operations Guide and in the Adabas Parallel Services Operations Guide

DZSTAT Command

graphics/op_dzstat.png

Display ZIIP related statistics.

Optional Parameters

Parameter Description
ALL Extended Statistics and Scheduling by type of work statistics. The ALL keyword may be specified and will include Extended Statistics and Scheduling by type of work statistics.

This function is only available if the nucleus was started with the parameter ADARUN ZIIP=YES.

In nucleus cluster environments, the NUCID parameter can be used to display information only for the specified nucleus. Otherwise, information is displayed for each active nucleus, one after the other.

The statistics displayed by DZSTAT correspond and are equivalent to the zIIP-related statistics at the end of the nucleus session statistics. See Understanding the zIIP-Related Statistics in the Adabas for zIIP documentation for detailed information about the various statistical figures.

FEOFAL Command

graphics/util_opercom_feofal.png

Close the current dual or multiple Audit log and switch to another dual or multiple Audit log. This command is valid only if dual or multiple audit logging is in effect and only for Adabas Audit Servers.

In nucleus cluster environments, use the GLOBAL option to switch the dual or multiple audit log in all cluster nuclei at the same time.

FEOFCL Command

graphics/util_opercom_feofcl.png

Close the current dual or multiple Command log and switch to the other dual or another multiple Command log. This command is valid only if dual or multiple command logging is in effect.

In nucleus cluster environments, the GLOBAL option can be used to switch the dual or multiple command log in all cluster nuclei at the same time.

FEOFPL Command

graphics/util_opercom_feofpl.png

Close the current dual or multiple data Protection log and switch to the other dual or another multiple Protection log. This command is valid only if dual or multiple data protection logging is in effect.

In nucleus cluster environments, the GLOBAL option can be used to switch the dual or multiple protection log in all cluster nuclei at the same time.

HALT Command

graphics/util_opercom_halt.png

Stop Adabas session. A BT (backout transaction) command is issued for each active ET logic user. The Adabas session is then terminated; no dumps are produced.

In nucleus cluster environments, the GLOBAL option can be used to halt the Adabas session in all active cluster nuclei.

INDEXCROSSCHECK Command

graphics/util_opercom_indexcrosscheck.png

Alter the setting of the ADARUN INDEXCROSSCHECK parameter while the nucleus is active. This operator command allows you to dynamically specify whether index crosschecking is turned on or off. Index crosschecking is a process Adabas can complete to ensure that a data storage record it is reading actually matches the descriptor value in the index by which the record was found. For more information, read INDEXCROSSCHECK Parameter: Data Storage Record Validation.

Note:
Attempts to change the INDEXCROSSCHECK setting (via the INDEXCROSSCHECK command) in a cluster environment will be rejected. In a cluster nucleus (CLUSTER=SYSPLEX or CLUSTER=LOCAL), Adabas sets INDEXCROSSCHECK to "YES", overriding any user-specified INDEXCROSSCHECK value, and validates the descriptor value from the index against the corresponding value from the data storage.

LOCKF Command

graphics/util_opercom_lockf.png

Lock the specified file. The specified file will be locked at all security levels.

LOCKU Command

graphics/util_opercom_locku.png

Lock the specified file for all non-utility use. Adabas utilities can use the file normally.

LOCKX Command

graphics/util_opercom_lockx.png

Lock the specified file for all users except EXU or EXF users. EXU and EXF users can use the file normally. The lock is released automatically when an EXU user issues an OP command.

LOGGING Command

graphics/op_logging.png

Start command logging.

LOGxx Command

graphics/util_opercom_logxx.png

Begin logging as indicated by xx for each command logged where xx is one of the following:

  • CB - the Adabas control block

  • FB - the Adabas format buffer

  • IB - the Adabas ISN buffer

  • IO - Adabas I/O activity

  • RB - the Adabas record buffer

  • SB - the Adabas search buffer

  • UX - user data passed in the seventh parameter of the Adabas parameter list

  • VB - the Adabas value buffer

  • VOLIO - the extended I/O list for CLOGLAYOUT=5 and CLOGLAYOUT=8

LOGWARN Command

graphics/op_logwarn.png

Use the LOGWARN command to specify how often the PLOG and CLOG status is checked and resulting alert messages are produced. Valid values range from zero (0) through 2147483647 seconds. The default is 0, indicating that no PLOG or CLOG status checking occurs and no corresponding alert messages are produced. If a non-zero value is specified for LOGWARN, a valid user exit 2 or user exit 12 must also be specified.

MXCANCEL Command

graphics/op_mxcancel.png

The MXCANCEL command can be used against cluster nuclei to dynamically change (while the Adabas nucleus is running) the setting of the MXCANCEL ADARUN parameter for a nucleus. This command can be used to specify the maximum number of seconds for which one cluster nucleus waits for the termination of another nucleus in the cluster that it has canceled for not responding to an internal, intracluster command. Valid values range from 15 through 2147483647.

If the new MXCANCEL value is less than or equal to the current MXCANCELWARN setting, the MXCANCELWARN setting is automatically set to zero (0). (You can then use the MXCANCELWARN command to dynamically set the MXCANCELWARN setting appropriately.)

For more information about the MXCANCEL setting for a nucleus, read about the ADARUN MXCANCEL parameter in the Adabas Operations Manual.

MXCANCELWARN Command

graphics/op_mxcancelwarn.png

The MXCANCELWARN command can be used to dynamically change (while the Adabas nucleus is running) the setting of the MXCANCELWARN ADARUN parameter for a nucleus. This command can be used to specify the number of seconds after an intracluster cancellation request is made when the cluster nucleus requesting the cancellation should issue warnings about the inability of the canceled peer nucleus to terminate. Valid values can be zero (0) or an integer ranging from 4 through the value of MXCANCEL minus 1 (MXCANCEL-1).

The value of the MXCANCELWARN setting must be less than the value of the MXCANCEL setting. If MXCANCELWARN is set to a value greater than or equal to the value specified for MXCANCEL, the value is rejected. If MXCANCELWARN is set to zero, no warnings are issued about canceled cluster nuclei that are slow to terminate.

For more information about the MXCANCELWARN setting for a nucleus, read about the ADARUN MXCANCELWARN parameter in the Adabas Operations Manual.

MXMSG Command

graphics/op_mxmsg.png

The MXMSG command can be used to dynamically change (while the Adabas nucleus is running) the setting of the MXMSG ADARUN parameter for a cluster nucleus. This command can be used to specify the maximum number of seconds in which one cluster nucleus waits for the response of another nucleus in the cluster to an internal, intracluster command. Valid values range from 15 through 32767.

If the new MXMSG value is less than or equal to the current MXMSGWARN setting, the MXMSGWARN setting is automatically set to zero (0). (You can then use the MXMSGWARN command to dynamically set the MXMSGWARN setting appropriately.)

For more information about the MXMSG setting for a nucleus, read about the ADARUN MXMSG parameter in the Adabas Operations Manual.

MXMSGWARN Command

graphics/op_mxmsgwarn.png

The MXMSGWARN command can be used to dynamically change (while the Adabas nucleus is running) the setting of the MXMSGWARN ADARUN parameter for a cluster nucleus. This command can be used to specify the number of seconds after an intracluster request is made when the cluster nucleus issuing the intracluster request should issue warnings about the failure of the target cluster nucleus to respond. Valid values can be zero (0) or an integer ranging from 4 through the value of MXMSG minus 1 (MXMSG-1).

The value of MXMSGWARN must be less than the value of MXMSG. If MXMSGWARN is set to a value greater than or equal to the value specified for MXMSG, the value is rejected. If MXMSGWARN is set to zero, no warnings are issued about cluster nuclei that are slow to respond.

For more information about the MXMSGWARN setting for a nucleus, read about the ADARUN MXMSGWARN parameter in the Adabas Operations Manual.

MXSTATUS Command

graphics/op_mxstatus.png

The MXSTATUS command can be used to dynamically change (while the Adabas nucleus is running) the setting of the MXSTATUS ADARUN parameter for a cluster nucleus. This command can be used to specify the number of seconds between member-level XCF status monitoring heartbeats. Valid values range from 15 through 21474836.

Note:
The MXSTATUS command is only used for Adabas Cluster Services and not for Adabas Parallel Services. Adabas Parallel Services does not use XCF and ignores the setting.

The MXSTATUS command can only be used to change the value of the MXSTATUS parameter if the ADARUN MXSTATUS parameter is not zero (0). This command cannot be used to turn status monitoring on (by specifying a nonzero value if the ADARUN MXSTATUS setting is zero) or to turn it off (by specifying a value of zero when the ADARUN MXSTATUS setting is nonzero). However, setting MXSTATUS to a very high value is effectively the same as turning status monitoring off (monitoring will occur very infrequently at least).

For more information about the MXSTATUS setting for a nucleus, read about the ADARUN MXSTATUS parameter in the Adabas Operations Manual.

MXWTOR Command

graphics/op_mxwtor.png

The optional MXWTOR command can be used to dynamically change (while the Adabas nucleus is running) the setting of the MXWTOR ADARUN parameter for a cluster nucleus. This command can be used to specify the maximum number of seconds that a cluster nucleus should wait for an operator response to a self-terminating operator query. Valid values range from 15 through 64800 or zero (0).

If MXWTOR is set to zero, the operator query does not occur (no ADAX9J messages are written) and no operator intervention is expected.

For more information about the MXWTOR setting for a nucleus, read about the ADARUN MXWTOR parameter in the Adabas Operations Manual.

NOLOGGING Command

graphics/op_nologging.png

Stop or prevent command logging.

NOLOGxx Command

graphics/util_opercom_nologxx.png

Stop or prevent logging of xx where xx is one of the following:

  • CB - the Adabas control block

  • FB - the Adabas format buffer

  • IB - the Adabas ISN buffer

  • IO - Adabas I/O activity

  • RB - the Adabas record buffer

  • SB - the Adabas search buffer

  • UX - user data passed in the seventh parameter of the Adabas parameter list

  • VB - the Adabas value buffer

  • VOLIO - the extended I/O list for CLOGLAYOUT=5 and CLOGLAYOUT=8

ONLRESUME Command

graphics/util_opercom_onlresume.png

Note:
Not currently available for use with Adabas Parallel Services cluster nuclei.

Resume a previously suspended online reorder or invert process.

In a cluster environment, NUCID must always be specified because the online process ID is not unique to the cluster.

ONLSTOP Command

graphics/util_opercom_onlstop.png

Note:
Not currently available for use with Adabas Parallel Services cluster nuclei.

Stop an online reorder or invert process cleanly. The process continues up to its next interrupt point in order to produce a consistent state, and then terminates after performing all necessary cleanup.

In a cluster environment, NUCID must always be specified because the online process ID is not unique to the cluster.

ONLSUSPEND Command

graphics/util_opercom_onlsuspend.png

Note:
Not currently available for use with Adabas Parallel Services cluster nuclei.

Suspend an online reorder or invert process. The process continues up to its next interrupt point in order to produce a consistent state, performs a command throwback, and enters a state where it cannot be selected for processing. This command is useful if the online process is consuming too much of the nucleus resources.

In a cluster environment, NUCID must always be specified because the online process ID is not unique to the cluster.

RALOCKF Command

graphics/util_opercom_ralockf.png

Remove the advance lock on the specified file (see ALOCKF command) without running the utility.

This command is available in cluster and non-cluster environments.

RALOCKFA Command

graphics/op_ralockfa.png

Remove the advance lock on all files for which it has been set (see ALOCKF command) without running the utility.

This command is available in cluster and non-cluster environments.

RDUMPST Command

graphics/op_rdumpst.png

Terminate online dump status. This command is normally used if online execution of the ADASAV utility has terminated abnormally.

READONLY Command

graphics/util_opercom_readonly.png

Note:
Not currently available for use with cluster nuclei.

Switches READONLY status on or off.

REVIEW Command

graphics/util_opercom_review.png

Note:
Not currently available for use with Adabas Parallel Services cluster nuclei.

Deactivate Adabas Review; change from hub mode to local mode; specify or change the Adabas Review hub with which a nucleus communicates.

RPLCHECK Command

graphics/op_rplcheck.png

Note:
Not valid for use with an Adabas nucleus; only valid for use against an Event Replicator Server and only for an Event Replicator Server as of Event Replicator for Adabas 3.4 SP1. If this command is issued against a database that is not an Event Replicator Server, error messages result.

Use this command to perform the replication cross-check function for all active databases known (defined in one or more subscriptions) to the Event Replicator Server. When this command is run using the ADADBS OPERCOM function, the information about the cross-check function is printed to the ADADBS DDDRUCK data set. The information printed by ADADBS is the same as the information printed by the Event Replicator Server during the cross-check process initiated by the RPLCHECK operator command.

SECUID Command

graphics/util_opercom_secuid.png

Use the SECUID command to alter the ADARUN SECUID parameter while the nucleus is active. For complete information about the SECUID ADARUN parameter, read SECUID Parameter: Security System User ID Requirement Level.

STOPF Command

graphics/util_opercom_stopf.png

Stop all users who are using the specified file. Any open transactions of the stopped users are backed out. Unless PURGE is also specified, a stopped user who returns (by sending a command) receives response code 9 (ADARSP009).

If the optional PURGE parameter is specified, the stopped users are also deleted (their user queue elements are removed from the user queue).

This command does not stop EXF or UTI users.

The following is an example of using the PURGE parameter:

ADADBS OPERCOM STOPF=5,PURGE

Caution:
If Adabas is running with ADARUN OPENRQ=NO (specifying that users are not required to issue an OP as the first command of the session), run the STOPF command with PURGE only if you are certain that the users to be deleted are no longer active. If a user with an open transaction is deleted, but then returns (by sending a command), no indication is given about the transaction backout. If the user continues the transaction, logical inconsistencies in the database could occur.

STOPI Command

graphics/util_opercom_stopi.png

Stop all users who have not executed a command during the specified time interval (in seconds). Any open transactions of the stopped users are backed out. Unless PURGE is also specified, a stopped user who returns (by sending a command) receives response code 9 (ADARSP009).

This command does not stop EXF or UTI users.

If the optional PURGE parameter is specified, the stopped users are also deleted (their user queue elements are removed from the user queue).

The following is an example of using the PURGE parameter:

ADADBS OPERCOM STOPI=3600,PURGE

Caution:
If Adabas is running with ADARUN OPENRQ=NO (specifying that users are not required to issue an OP as the first command of the session), run the STOPI command with PURGE only if you are certain that the users to be deleted are no longer active. If a user with an open transaction is deleted, but then returns (by sending a command), no indication is given about the transaction backout. If the user continues the transaction, logical inconsistencies in the database could occur.

STOPSU Command

graphics/util_opercom_stopsu.png

Use the STOPSU command to stop and delete all users with the specified security user ID (secuid). Any open transactions of the stopped users will be backed out. No response code is issued; the next time the stopped user issues a command, a new user queue element (UQE) is created.

Caution:
If Adabas is running with ADARUN OPENRQ=NO (specifying that users are not required to issue an OP as the first command of the session), run the STOPSU command only if you are certain that the users to be deleted are no longer active. If a user with an open transaction is deleted, but then returns (by sending a command), no indication is given about the transaction backout. If the user continues the transaction, logical inconsistencies in the database could occur. If this is a concern, use the STOPSUR command instead.

Note:
The STOPSU=secuid command is not allowed for online reorder or invert processes. Use the ONLSTOP=X'identifier' command instead.

STOPSUR Command

graphics/util_opercom_stopsur.png

Use the STOPSUR command to stop a user with a specified security user ID (secuid). Any open transactions of the stopped user are backed out. The stopped user is only deleted after he or she has issued a subsequent command and response code 22 (ADARSP22), subcode 54 has been issued in response to that command. This response code-subcode combination is used to notify users that their user session resources have been freed. Only after the response code-subcode combination has been issued is the user queue element (UQE) of the stopped user deleted.

Note:
The STOPSUR=secuid command is not allowed for online reorder or invert processes. Use the ONLSTOP=X'identifier' command instead.

STOPU Command

graphics/util_opercom_stopu.png

Use the STOPU command to stop and delete the user with the Adabas-assigned user ID (in the form shown in the display commands), or to stop and delete all users with the specified job name (job-name). Any open transaction by the stopped users will be backed out. No response code is issued; the next time a stopped user issues a command, a new user queue element (UQE) is created.

Caution:
If Adabas is running with ADARUN OPENRQ=NO (specifying that users are not required to issue an OP as the first command of the session), run the STOPU command only if you are certain that the users to be deleted are no longer active. If a user with an open transaction is deleted, but then returns (by sending a command), no indication is given about the transaction backout. If the user continues the transaction, logical inconsistencies in the database could occur. If this is a concern, use the STOPUR command instead.

Note:
The STOPU=X'userid' command is not allowed for online reorder or invert processes. See the ONLSTOP=X'identifier' command instead.

The user ID must be specified in hexadecimal format; for example:

STOPU=X'1CF2' 

In a cluster environment, NUCID must always be specified because the user ID is not unique to the cluster.

STOPUR Command

graphics/util_opercom_stopur.png

Use the STOPUR command to stop a user with the Adabas-assigned user ID (in the form shown in the display command) or to stop a user with the specified job name. Any open transactions of the stopped user are backed out. The stopped user is only deleted after he or she has issued a subsequent command and response code 22 (ADARSP22), subcode 54 has been issued in response to that command. This response code-subcode combination is used to notify users that their user session resources have been freed. Only after the response code-subcode combination has been issued is the user queue element (UQE) of the stopped user deleted.

Note:
The STOPUR=X'userid' command is not allowed for online reorder or invert processes. Use the ONLSTOP=X'identifier' command instead.

The user ID must be specified in hexadecimal format; for example:

STOPUR=X'1CF2'

In a cluster environment, NUCID must always be specified because the user ID is not unique to the cluster.

SYNCC Command

graphics/op_syncc.png

Force resynchronization of all ET users on the nucleus. The nucleus waits for all ET users to reach ET status before continuing.

TNAx Command

graphics/util_opercom_tnau.png

Set non-activity time limit (in seconds) for users where u is one of the following:

  • A - for access-only (ACC) users

  • E - for ET logic users

  • X - for exclusive control (EXF/EXU) users

If specified, time must be a value greater than zero; it overrides the ADARUN value.

In nucleus cluster environments, the TNAu commands are global by definition and affect all nuclei in the cluster. If a NUCID is specified, it is ignored.

TT Command

graphics/util_opercom_tt.png

Set transaction time limit (in seconds) for ET logic users. If specified, this value must be greater than zero; it overrides the ADARUN value. In nucleus cluster environments, the TT command is global by definition and affects all nuclei in the cluster. If a NUCID is specified, it is ignored.

UNLOCKF Command

graphics/util_opercom_unlockf.png

Unlock the specified file and restore its usage to the prelocked status.

UNLOCKU Command

graphics/util_opercom_unlocku.png

Unlock the specified file for utility use and restore it to its prelocked status for non-utility users.

UNLOCKX Command

graphics/util_opercom_unlockx.png

Unlock the specified file and restore its usage to the prelocked status.

UTIONLY Command

graphics/util_opercom_utionly.png

Note:
Not currently available for use with Adabas Parallel Services cluster nuclei.

Switch UTIONLY status on or off.

In nucleus cluster environments, the UTIONLY command is global by definition and affects all nuclei in the cluster. If a NUCID is specified, it is ignored.

ZIIP Command

graphics/op_ziip.png

Use the ZIIP operator command to turn on or off the use of System z Integrated Information Processors (zIIP) in the Adabas nucleus. Issuing ZIIP=YES will tell the Adabas nucleus to run in SRB mode when possible and enable the use of zIIPs.

Issuing ZIIP=NO will tell the Adabas nucleus to stay in TCB mode and disable the use of zIIPs.

The ZIIP operator command may only be used in an Adabas nucleus started with ADARUN ZIIP=YES.

ADADBS PRIORITY: Change User Priority

graphics/util_adadbs_priority.png

ADADBS REACTLOG: Reactivating Command Logging

graphics/util_adadbs_reactlog.png

ADADBS RECORDSPANNING: Enable or Disable Record Spanning

graphics/util_adadbs_recordspanning.png

ADADBS RECOVER: Recover Space

graphics/util_adadbs_recover.png

ADADBS REFRESH: Set File to Empty Status

graphics/util_adadbs_refresh.png

ADADBS REFRESHSTATS: Reset Statistical Values

graphics/util_adadbs_refreshstats.png

ADADBS RELEASE: Release Descriptor

graphics/util_adadbs_release.png

ADADBS RENAME: Rename a File or Database

graphics/util_adadbs_rename.png

ADADBS RENUMBER: Change File Number

graphics/util_adadbs_renumber.png

ADADBS REPLICATION: Activating or Deactivating Replication

graphics/util_adadbs_replication.png

ADADBS REPTOR: Activating, Deactivate, Open or Close an Event Replicator for Adabas Resource

graphics/util_adadbs_reptor.png

ADADBS RESETDIB: Reset Entries in Active Utility List

graphics/util_adadbs_resetdib.png

ADADBS RESETPPT: Reset PPT Blocks

graphics/util_adadbs_resetppt.png

ADADBS SPANCOUNT: Count Spanned Records

graphics/util_adadbs_spancount.png

ADADBS TRANSACTIONS: Suspend and Resume Update Transaction Processing

graphics/util_adadbs_transactions.png

ADADBS UNCOUPLE: Uncouple Files

graphics/util_adadbs_uncouple.png

ADADBS UNDELDE: Undelete a Logically Deleted Descriptor

graphics/util_adadbs_undelde.png

ADADBS UNDELFN: Logically Undelete Fields

graphics/util_adadbs_undelfn.png

ADADEF DEFINE: Define a Database and Checkpoint File

graphics/util_adadef_define.png

ADADEF MODIFY: Change File Encodings

graphics/util_adadef_modify.png

ADADEF NEWWORK: Define a Work File

graphics/util_adadef_newwork.png

ADADRU SPACEUSAGE: Database File Space Usage Report

graphics/adadru_spaceusage.png

ADAFRM: Format Adabas Database Components

To format the Associator (ASSO) or Data Storage (DATA) data sets, use this syntax:

graphics/util_adafrm_assofrm.png

To format the Work (WORK), command log (CLOG), protection log (PLOG), or sort (SORT) data sets, use this syntax:

graphics/util_adafrm_workfrm.png

To format the recovery log (RLOG), use this syntax:

graphics/util_adafrm_rlogfrm.png

To format the Temp (TEMP) data set, use this syntax:

graphics/util_adafrm_tempfrm.png

To reformat blocks of an existing Associator, Data Storage, or Work data set, use this syntax:

graphics/util_adafrm_assoreset.png

ADAINV COUPLE: Define File-Coupling Descriptors

graphics/util_adainv_couple.png

ADAINV INVERT: Create Descriptors

graphics/util_adainv_invert.png

ADALOD LOAD: Load a File

graphics/util_adalod_load.png

ADALOD UPDATE: Add/Delete Records

graphics/util_adalod_update.png

ADAMER Utility: ADAM Estimation

graphics/util_adamer.png

ADAORD REORASSO: Reorder Associator

graphics/util_adaord_reorasso.png

ADAORD REORDATA: Reorder Data Storage

graphics/util_adaord_reordata.png

ADAORD REORDB: Reorder Database

graphics/util_adaord_reordb.png

ADAORD REORFASSO: Reorder Associator for a Single File

graphics/util_adaord_reorfasso.png

ADAORD REORFDATA: Reorder Data Storage for a Single File

graphics/util_adaord_reorfdata.png

ADAORD REORFILE: Reorder File

graphics/util_adaord_reorfile.png

ADAORD RESTRUCTUREDB: Restructure Database

graphics/util_adaord_redb.png

ADAORD RESTRUCTUREF: Restructure Single Files

graphics/util_adaord_ref.png

ADAORD STORE: Store Files

graphics/util_adaord_store.png

ADAPLP: Print Data Protection Records from PLOG/Work

graphics/util_adaplp.png

where type is one of the following:

graphics/util_adaplp_type.png

ADARAI CHKDB: Check the Database Recovery Status

graphics/util_adarai_chkdb.png

ADARAI DISABLE: Deactivate Recovery Logging

graphics/util_adarai_disable.png

ADARAI LIST: Display Current RLOG Generations

graphics/util_adarai_list.png

ADARAI PREPARE: Initialize and Start the RLOG

graphics/util_adarai_prepare.png

ADARAI RECOVER: Build a Recovery Job Stream

graphics/util_adarai_recover.png

ADARAI REMOVE: Remove the Recovery Aid

graphics/util_adarai_remove.png

ADAREP: Request Database Status Report

graphics/util_adarep.png

ADARES BACKOUT SIBA: Back Out Updates Using the Sequential Protection Log (SIBA)

graphics/util_adares_backout_plognum.png

ADARES BACKOUT DPLOG or MPLOG: Back Out Updates Using the Dual or Multiple Protection Log

graphics/util_adares_backout_dplog.png

ADARES CLCOPY: Copy Dual Command Log

graphics/util_adares_clcopy.png

ADARES COPY: Copy a Sequential Protection Log or Save Tape

graphics/util_adares_copy.png

ADARES MERGE CLOG: Merge Nucleus Cluster Command Logs

graphics/util_adares_merge.png

ADARES PLCOPY: Copy Protection Log to Sequential Data Set

graphics/util_adares_plcopy.png

ADARES REGENERATE: Regenerate Updates

graphics/util_adares_regenerate.png

ADARES REPAIR: Repair Data Storage Blocks

graphics/util_adares_repair.png

ADASAV RESTONL: Restore Database from Online Source

graphics/util_adasav_restonl.png

ADASAV RESTONL FILES: Restore Files to Original RABNs from Online Source

graphics/util_adasav_restonl_files.png

ADASAV RESTONL FMOVE: Restore Files to Any RABNs from Online Source

graphics/util_adasav_restonl_fmove.png

ADASAV RESTONL GCB: Restore Database Incremental from Online Source

graphics/util_adasav_restonl_gcb.png

ADASAV RESTORE: Restore Database from Offline Source

graphics/util_adasav_restore.png

ADASAV RESTORE FILES: Restore Files to Original RABNs from Offline Source

graphics/util_adasav_restore_files.png

ADASAV RESTORE FMOVE: Restore Files to Any RABNs from Offline Source

graphics/util_adasav_restore_fmove.png

ADASAV RESTORE GCB: Restore Database Incremental from Offline Source

graphics/util_adasav_restore_gcb.png

ADASAV RESTPLOG: Restore Protection Log Only

graphics/util_adasav_restplog.png

ADASAV SAVE: Save Database

graphics/util_adasav_save.png

ADASAV SAVE FILES: Save Specified Files

graphics/util_adasav_save_files.png

ADASEL Utility: Select Protection Data

graphics/util_adasel.png

Value Criterion

graphics/util_adasel_valcrit.png

Output Instruction

graphics/util_adasel_output_instr.png

IF Processing

graphics/util_adasel_if.png

ADAULD UNLOAD FILE: Unload Specified File

graphics/util_adauld.png

ADAWRK Utility: Work Area Recovery Reports

graphics/util_adawrk.png

ADAZAP Utility: Display or Modify Asso, Data, and Work Data Sets

graphics/util_adazap.png

ADAZIN Utility: Print Adabas Maintenance and SVC Information

graphics/util_adazin.png