OPERCOM: Issue Adabas Operator Commands

The OPERCOM function issues operator commands to the Adabas nucleus.

In an Adabas cluster environment, OPERCOM commands can be directed to a single cluster nucleus or to all active nuclei in the cluster. If a particular nucleus is not specified, the command defaults to the local nucleus.

Adabas issues a message to the operator, confirming command execution.

graphics/util_adadbs_opercom.png

In this section, the discussion of the individual operator commands follows the discussion of the optional parameters, since some of the operator commands behave differently when issued in an Adabas cluster environment.

This document covers the following topics:


Using OPERCOM Commands in Cluster Environments

Some ADARUN parameters are global parameters; that is, they must have the same values for all nuclei in a cluster. Of these, some are set at session initialization and cannot be changed. Others can be modified on a running system. OPERCOM commands that change these modifiable global parameter values are handled in a special way in cluster environments.

If an Adabas cluster nucleus changes one or more global parameters, that nucleus acquires a parameter change lock, makes the changes in its local parameter area, informs the other cluster nuclei of the changes and waits for a reply. The other cluster nuclei make the changes in their own local parameter areas and send an acknowledgment message.

Optional Parameters

GLOBAL: Operate Across All Active Cluster Nuclei

Five OPERCOM commands use the GLOBAL option to operate across all active nuclei in a cluster: ADAEND, CANCEL, FEOFCL, FEOFPL, and HALT. For example:

ADADBS OPERCOM ADAEND, GLOBAL

All other OPERCOM commands use the NUCID=0 option to operate across all active nuclei in a cluster.

NOUSERABEND: Termination without Abend

When a parameter error or a functional error occurs while this utility function is running, the utility ordinarily prints an error message and terminates with user abend 34 (with a dump) or user abend 35 (without a dump). If NOUSERABEND is specified, the utility will not abend after printing the error message. Instead, the message "utility TERMINATED DUE TO ERROR CONDITION" is displayed and the utility terminates with condition code 20.

Note:
When NOUSERABEND is specified, we recommend that it be specified as the first parameter of the utility function (before all other parameters). This is necessary to ensure that its parameter error processing occurs properly.

NUCID: Cluster Nucleus ID

Any nucleus running in an Adabas nucleus cluster is allowed to run Adabas utilities such as ADADBS.

With certain exceptions, the NUCID parameter allows you to direct the ADADBS OPERCOM commands to a particular nucleus in the cluster for execution, just as though the command had been issued by a locally run ADADBS OPERCOM operation. You can route most OPERCOM commands to all nuclei in a cluster by specifying NUCID=0.

If NUCID is not specified in a cluster environment, the command is routed to the local nucleus.

Note:
For ADADBS OPERCOM and Adabas Online System (AOS), a zero value for the NUCID parameter indicates that the command applies to all nuclei in the cluster (global). A nonzero value for the NUCID parameter indicates that the command applies only to the cluster nucleus specified.

TEST: Test Syntax

This parameter tests the operation syntax without actually performing the operation. Only the syntax of the specified parameters can be tested; nor the validity of values and variables. See Syntax Checking with the TEST Parameter for more information on using the TEST parameter in ADADBS functions.

Operator Commands

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

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.

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.

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.