Adabas Manager System Status provides a comprehensive overview of Adabas operation.
This document covers the following topics:
To review the general system status of an
Adabas database:
Select an Adabas database in tree-view and expand it.
Select System Status in tree-view.
The system status information for the database is displayed in tables on the System Status panel in detail-view.
Read about Database Monitoring and Tuning in the Adabas DBA Tasks documentation for detailed information about system status statistics.
The system status information for a database is provided in three tables, as described in this section:
The physical I/O table is the first table on the System Status panel. It displays the number of physical reads and writes executed during the session to the Associator (ASSO), Data Storage (DATA), and Work (WORK) data sets. In addition, it displays the number of physical writes during the session to the data protection log (PLOG).
The general statistics table is the second table from the top of the System Status panel. It lists the following information about the database:
| Property | Explanation |
|---|---|
| Logical Reads | The number of logical reads issued for the buffer pool. |
| Buffer Efficiency | The number of logical reads divided by the number of ASSO and DATA reads. The higher the value for buffer efficiency, the more efficient is buffer pool usage. If the value is less than 10, you may want to increase the size of the Adabas buffer pool (see the ADARUN LBP parameter). |
| Format Translations | Adabas read and update commands require a format buffer that specifies the fields to be read or updated. Adabas interprets the format buffer and translates it into an internal form and stores it in an internal format buffer pool. The internal format buffer is identified by a combination of user ID/ command ID. Format buffer translation is CPU-intensive. |
| Format Overwrites | When the internal format buffer pool becomes full, an existing entry must be overwritten to accommodate a new entry. If you have an excessive number of format overwrites, you may need to increase the size of the internal format buffer pool (see the ADARUN LFP parameter). |
| Throwbacks | The number of times a command could not be executed because the Adabas nucleus was waiting for an available ISN or Adabas work pool space. In these cases, the command is thrown back into the command queue for processing at a later point in time. |
| Thread Switches | The number of times in this session that a thread was automatically switched by Adabas during the processing of a single command. A thread switch occurs if I/O activity suspends command processing in an active thread. Ideally, each command should be processed to completion without a thread switch. The count of thread switches is thus an indication of the balance between the size of the I/O buffer and the number of threads allocated. |
| Number of Calls | Total number of calls issued to Adabas during the session. |
| Internal Autorestarts | The number of autorestarts performed during the session. |
| PLOG Switches | Applies only when dual protection logging is in effect; when one dataset is full, Adabas switches automatically to a second dataset and continues writing protection log records. In the meantime, data in the first dataset is copied off using ADARES PLCOPY to a sequential file, either manually or under the control of user exit 2, so that the dataset can be safely overwritten when the second dataset becomes full and Adabas switches automatically back to the first dataset. The system is most efficient when sufficient time is available to copy a full protection log off to the sequential dataset before the other protection log dataset becomes full. Protection logs are sized using the DUALPLD parameter to specify the device and thus the block size and the DUALPLS parameter to specify the number of blocks allowed in a log. |
| Buffer Flushes | The number of times the buffer pool has been flushed to Data Storage during the session. The buffer pool contains the most frequently used ASSO and DATA blocks and its purpose is to minimize physical I/O activity. The buffer pool should be as large as possible without causing undue paging by the operating system. |
The pool and queue statistics table is a high-water mark display. It is the third table from the top of the System Status panel. It shows the usage statistics and graphs the highest percentage used of selected pools and queues in the current session, as well as the date and time when the high point was reached. Values are displayed for the:
user, command, and hold queues
ISN list and sequential command tables
format, redo, replication, security, user file list, DTP transaction ID, unique descriptor, and work pools
attached buffers.
In addition, the units and defined settings of the ADARUN parameters associated with establishing the sizes of these queues and pools is also listed in the table.
The high-water values are a good starting point when looking for a problem with limited buffer, pool, or queue space, or if you are looking for unused storage resources.
You have the following options for resetting the system status:
To reset the pool and queue statistics display:
Select an Adabas database in tree-view and expand it.
Select System Status in tree-view and right-click on it.
Select on the drop-down menu.
The counters in the pool and queue statistics table are reset to zero.
To reset the counter:
Select an Adabas database in tree-view and expand it.
Select System Status in tree-view and right-click on it.
Select on the drop-down menu.
The counters in the general statistics table are reset to zero.
To reset all:
Select an Adabas database in tree-view and expand it.
Select System Status in tree-view and right-click on it.
Select on the drop-down menu.
All counters in the System Status tree are reset to zero.
To review the CLOG/PLOG statistics:
Select an Adabas database in tree-view and expand it.
Select CLOG/PLOG Statistics in tree-view under the expanded System Status.
Two tables are displayed in the detail-view panel; in the first table the following command log properties are shown:
the name of the CLOG that the nucleus is currently writing
the size of a CLOG area in blocks
the number of the last block written
the percentage of the last block that was written (in graph form)
the number of dual log switches since the nucleus started; and
the date and time of the last CLOG switch
In the second table the following protection log properties are shown:
the name of the PLOG that the nucleus is currently writing
the size of a PLOG area in blocks
the number of the last block written
the percentage of the last block that was written (in graph form)
the number of dual log switches since the nucleus started; and
the date and time of the last PLOG switch
Using this option, you can immediately switch (by forcing an end-of-file) between dual or multiple command log (CLOG) or protection log (PLOG) files. Switching (that is, "toggling") changes from one CLOG or PLOG file to another.
To force a CLOG/PLOG switch:
Select an Adabas database in tree-view and expand it.
Select CLOG/PLOG Statistics in tree-view under the expanded System Status.
Two tables are displayed in the detail-view panel, showing the command/protection log properties. If dual logging is active, and buttons are displayed.
Click the action you want to perform.
To review the command queue:
Select an Adabas database in tree-view and expand it.
Select Command Queue in tree-view under the expanded System Status.
A list of the current commands in the queue and their status are listed.
To review command usage:
Select an Adabas database in tree-view and expand it.
Select Command Usage in tree-view under the expanded System Status.
A table is displayed in detail-view showing the total and average execution time of each Adabas command type issued during the current session and processed by the Adabas nucleus, and the total of all Adabas commands issued.
The following commands are listed:
| Command | Description |
|---|---|
| A1/4 | Update Existing Records |
| BT | Backout Transactions |
| CL | Close User Session |
| ET | End Transaction |
| E1/2 | Delete Records |
| L1/4 | Read by ISN |
| L2/5 | Read Physical |
| L3/6 | Read by Descriptor |
| L9 | Read Descriptor |
| LF | Read Field Definition |
| N1/2 | Add Records |
| OP | Open User Session |
| UC | Utility Commands |
| RC | Release Command id's |
| RE | Read ET User Data |
| REST | Other Commands |
| S1/4 | Find Records |
| S2 | Find records sorted |
| S5 | Find Coupled ISN |
| S8 | Process ISN List |
| S9 | Sort ISN List |
| YCAL | Internal Communication |
| V1 to V4 | Internal Communication |
| UCAL | Utility Commands |
To reset the command usage status display:
Right-click on Command Usage under System Status.
Select on the drop-down menu.
The counters in the command usage status table are reset to zero.
Note:
Selecting on the drop-down menu
will reset all counters in the System Status tree to
zero.
To review file usage:
Select an Adabas database in tree-view and expand it.
Select File Usage in tree-view under the expanded System Status.
A table is displayed in detail-view showing the total number of accesses for all files of the database used during the current session is displayed.
To reset the file usage status display:
Right-click on File Usage under System Status.
Select on the drop-down menu.
The counters in the file usage status table are reset to zero.
Note:
Selecting on the drop-down menu
will reset all counters in the System Status tree to
zero.
To review high water marks:
Select an Adabas database in tree-view and expand it.
Select High Water Marks in tree-view under the expanded System Status.
A table is displayed in detail-view showing the maximum percent of use of selected pools and queues in the current session, and the date and time when the high point was reached.
Values are displayed for the user, command, and hold queues; the ISN list and sequential command tables; the format, security, and work pools; and the attached buffers (NAB).
These values are a good starting point when looking for a problem with limited buffer, pool, or queue space, or if you are looking for unused storage resources.
To review the hold queue:
Select an Adabas database in tree-view and expand it.
Select Hold Queue in tree-view under the expanded System Status.
A list of ISNs currently in hold status is displayed along with the file in which it occurs, the related TID, CPU-ID, VM-ID and OPSYS-ID.
To stop a user:
Click in the check box for the user you want to stop until a check mark appears.
Click the button to confirm your selection.
You can filter the hold queue display by file number or name and User ID.
Once you have specified a filter for the hold queue display, it remains in effect for all databases registered until you turn it off.
To filter the hold queue display:
Access the hold queue display and in the upper left corner of the
display, click on the button (
).
The Hold Queue filter panel appears.
Enter the file name or number and/or the TID you want to filter the hold queue for. You can use an asterisk (*) as a wildcard character.
Verify that the Turn Off Filter check box does not have a check mark in it. If it does, click in the check box until the check mark is gone.
When all filters have been specified, click on the button to save the filters or click on the button to cancel the filter settings and revert to the prior settings (if any).
When you refresh the hold queue display, the filters are applied to the hold queue display.
To stop a user:
Select the user you want to stop from the resulting list and click the button.
To clear all filters on the hold queue display:
Access the hold queue display and in the upper left corner of the
display, click on the button ().
The Hold Queue filter panel appears.
Click in the Turn Off Filter check box until a check mark appears.
Click on the button to save the filters or click on the button to cancel the filter settings and revert to the prior settings (if any).
To review the installed products associated with the database:
Select an Adabas database in tree-view and expand it.
Select Installed Products in tree-view under the expanded System Status.
The products associated with the database are displayed in detail-view.
To review the nucleus file status of the database:
Select an Adabas database in tree-view and expand it.
Select Nucleus File Status in tree-view under the expanded System Status.
The nucleus file status of the database is displayed in a table in detail-view.
The following information is listed:
| Property | Explanation |
|---|---|
| File Number | The Adabas file number. |
| Locking Nucleus ID | In an Adabas cluster environment, the file may be locked for exclusive use by another cluster nucleus. If this is the case and the file is in the nucleus file status table, this column for the file shows the ID of the nucleus that has exclusive control. |
| Access Count | Display the number of access users, respectively, that refer to the specified file in their user queue elements (UQEs). These users either have specified the file in an OP command with R-option or are using the file in an as yet incomplete transaction. |
| Update Count | Display the number of update users, respectively, that refer to the specified file in their user queue elements (UQEs). These users either have specified the file in an OP command with R-option or are using the file in an as yet incomplete transaction. |
| Status | Indicates when the file is used for access only or for access and update. The Status column field indicates to what extent a nucleus can use a file on its own. If the requested use exceeds the given state, the nucleus must first communicate with the other nuclei in the cluster in order to upgrade the state. |
The Online Status panel displays the online utility processes (inverting files, reordering files) currently in the database nucleus. For details on how to start the online utilities, see sections Inverting Files and Reordering Files.
To review the online status of the database:
Select an Adabas database in tree-view and expand it.
Select Online Status in tree-view under the expanded System Status.
The online status of the database is displayed in a table in detail-view.
The following information is listed:
| Property | Explanation |
|---|---|
| ET-ID | The logical user ID assigned by the ADALOD LOAD parameter ETID (which defines owner IDs to all records being loaded into a multiclient file). |
| Process Type | The current process type. |
| Status | The current status. |
| File Number | The Adabas file number. |
| Reorder Type | The reorder type set for the file. |
| Current RABN | The RABN assigned for the file. |
| Current ISN | The ISN allocated for the file. |
| Number of Throwbacks | The number of commands in the command queue for processing at a later point in time. |
The parallel participant table (PPT) located in a database's Associator tracks all active Adabas nuclei in the cluster and displays additional information about a nucleus.
The information about each Adabas nucleus maintained in the PPT is used when ADARES PLCOPY is copying and merging all active protection logs in the cluster. It is also used during nucleus initialization to ensure that the dataset information required for autorestart and PLOG merge is available:
If the previously used Work dataset and PLOG datasets are already in use by another nucleus, the nucleus will not start.
If a different Work dataset is provided and the previously used Work dataset contains autorestart information, the nucleus will start but a warning will be printed.
If different PLOGs or no PLOGs are provided and the previous session had PLOGs still to be copied, the nucleus will not start until those PLOGs have been copied/merged if PLOGRQ=FORCE is specified. If PLOGRQ=FORCE is not specified, the nucleus will start but a warning will be printed.
To review the PPT:
Select an Adabas database in tree-view and expand it.
Select PPT in tree-view under the expanded System Status.
The table in detail-view displays a list of nuclei participating in the cluster and information about the current status of each nucleus.
Click on a nucleus ID in the table to display additional information about a nucleus.
For an Adabas cluster nucleus that has a nonzero nucleus ID, its entry in the PPT is displayed in the detail-view panel.
Resource statistics provide information about file and command use either for all currently active users (general statistics) or for a single user (user statistics). The statistics are collected by starting a sampling period for which you have specified a time period in seconds (duration).
To obtain statistics for all currently active users:
Select an Adabas database in tree-view and expand it.
Select Resource Statistics in tree-view under the expanded System Status.
The Resource Statistics panel is displayed in detail-view.
Specify the duration period in seconds (default is 60 seconds) and click on the button.
The General Statistics collection is started.
After the specified duration, click on the button.
The following command usage information for all currently active users is displayed in the detail-view panel:
the total number of commands
the command type
the number of commands
the number of commands (%)
the average duration (milliseconds)
The following commands are listed:
| Command | Description |
|---|---|
| A1/4 | Update Existing Records |
| BT | Backout Transactions |
| CL | Close User Session |
| ET | End Transaction |
| E1/2 | Delete Records |
| L1/4 | Read by ISN |
| L2/5 | Read Physical |
| L3/6 | Read by Descriptor |
| L9 | Read Descriptor |
| LF | Read Field Definition |
| N1/2 | Add Records |
| OP | Open User Session |
| UC | Utility Commands |
| RC | Release Command id's |
| RE | Read ET User Data |
| REST | Other Commands |
| S1/4 | Find Records |
| S2 | Find records sorted |
| S5 | Find Coupled ISN |
| S8 | Process ISN List |
| S9 | Sort ISN List |
| YCAL | Internal Communication |
| V1 to V4 | Internal Communication |
| UCAL | Utility Commands |
Choose in the selection box in this panel to display the file usage information for all currently active users.
The resulting table provides the following file usage details:
the file number
the number of commands
the number of commands (%)
Click on the button to return to the Resource Statistics panel.
To obtain statistics for a single user:
Select an Adabas database in tree-view and expand it.
Select Resource Statistics in tree-view under the expanded System Status.
The Resource Statistics panel is displayed in detail-view.
Click on the button.
The User Queue panel is displayed in detail-view.
Select a user ID to retrieve statistics for that user. This will return you to the Resource Statistics panel.
Specify the duration period in seconds (default is 60 seconds) and click on the button.
After the specified duration, click on the button.
The following command usage information for the user you selected is displayed in the detail-view panel:
the total number of commands
the command type
the number of commands
the number of commands (%)
the average duration (milliseconds)
The following commands are listed:
| Command | Description |
|---|---|
| A1/4 | Update Existing Records |
| BT | Backout Transactions |
| CL | Close User Session |
| ET | End Transaction |
| E1/2 | Delete Records |
| L1/4 | Read by ISN |
| L2/5 | Read Physical |
| L3/6 | Read by Descriptor |
| L9 | Read Descriptor |
| LF | Read Field Definition |
| N1/2 | Add Records |
| OP | Open User Session |
| UC | Utility Commands |
| RC | Release Command id's |
| RE | Read ET User Data |
| REST | Other Commands |
| S1/4 | Find Records |
| S2 | Find records sorted |
| S5 | Find Coupled ISN |
| S8 | Process ISN List |
| S9 | Sort ISN List |
| YCAL | Internal Communication |
| V1 to V4 | Internal Communication |
| UCAL | Utility Commands |
Choose in the selection box in this panel to display the file usage information for this user.
The resulting table provides the following file usage details:
the file number
the number of commands
the number of commands (%)
Click on the button to return to the Resource Statistics panel.
To review threads:
Select an Adabas database in tree-view and expand it.
Select Threads in tree-view under the expanded System Status.
The threads are listed along with their status (active or not active), the command type currently in process in each active thread, and the number of commands processed by each thread in the current session.
To reset the thread status display:
Right-click on Threads under System Status.
Select on the drop-down menu.
The counters in the thread status table are reset to zero.
Note:
Selecting on the drop-down menu
will reset all counters in the System Status tree to
zero.
Adabas allows you to retain user-related information from session to session in a user profile table. For each user, you can maintain
a user priority to add "weight" to the normal, built-in priorities of Adabas commands issued by a specific user when they contend with other commands for Adabas database priority. The effect is to change the user's database access priority.
nonactivity timeout values for access-only users (TNAA), ET logic users (TNAE), and EXU users (TNAX).
transaction time limits for ET Logic users (TT).
a time limit for executing a database query (Sx) command (TLSCMD).
the number of ISNs allowed per TBI element (NSISN).
the number of records that can be placed in hold status at one time (NISNHQ).
the number of active command IDs allowed (NOCID).
an owner ID for multiclient support.
To review the user profiles:
Select an Adabas database in tree-view and expand it.
Select User Profiles in tree-view under the expanded System Status.
The user profiles are displayed in a table.
To modify a user profile:
In the User Profiles table displayed in detail-view, click on the user ID for which you want to modify the profile.
The profile table for the user is displayed.
In the resulting profile table, enter the values you require in the text boxes.
Click on the button to confirm your changes or to return to the User Profiles table without modifying the profile.
To delete a user profile:
In the User Profiles table displayed in detail-view, click on the user ID you want to delete.
The profile table for the user is displayed.
Click on the button to delete the user ID or to return to the User Profiles table without deleting the profile.
In addition to modifying or deleting existing profiles, you can also add new user profiles.
To create a new user profile:
Select an Adabas database in tree-view and expand it.
Select System Status in tree-view and right-click on it.
Select on the drop-down menu.
A user profile table appears in detail-view.
Enter the user ID for the new profile and allocate the values you require in the text boxes (as default the boxes show the active parameter values).
Click on the button to confirm the new user profile or and return to the User Profiles table.
The new user profile is now displayed in the table.
Each user who calls Adabas is assigned a user queue element (UQE). The user queue stores the UQEs for all users of a given database.
This section covers the following topics:
To review the user queue for a database:
Select an Adabas database in tree-view and expand it.
Select User Queue in tree-view under the expanded System Status.
The user queue for the database appears on the User Queue panel in detail-view.
The user queue information is displayed in a table that provides the following information:
| Statistics | Description | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TID | The unique internal identifier assigned to the user. | |||||||||||
| ET-ID | Logical user ID assigned by the ADALOD LOAD parameter ETID (which defines owner IDs to all records being loaded into a multiclient file). | |||||||||||
| Job Name | The job name associated with the user. | |||||||||||
| User Type | The user type. Possible values include: | |||||||||||
|
||||||||||||
| Status | The user status. Possible values include: | |||||||||||
|
||||||||||||
| Last Activity | Period of inactivity (in seconds). | |||||||||||
| Files | The file numbers of the Adabas files currently in use by the user. Note that no file list is provided for ET users. |
You can stop a specific user, all users from a specific job, all users using a specific file, or all inactive users. Any open transactions of the stopped users are backed out. You can also request that the stopped users be deleted. Note that EXF and UTI users are not stopped or deleted.
To stop specific users:
Click in the check boxes for all users you want to stop until check marks appear.
Click the button to confirm your selection.
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), stop specific users 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.
Click on the button to confirm or click on the button to cancel. Both will return you to the previous panel.
The nucleus backs out any open transactions of the selected users and deletes them (purges the user queue elements).
To stop users using a specific file number:
Right-click on under the expanded System Status.
Select on the drop-down menu.
The Stop Users using File panel is displayed in detail-view.
Enter the file number for which you want users stopped.
If you want the stopped users deleted (if you want to purge their user queue elements), check the Purge User Queue Elements check box.
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), stop users with Purge User Queue
Elements checked 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.
Click on the button to confirm or click on the button to cancel. Both will return you to the previous panel.
The nucleus backs out any open transactions of the affected users. If Purge User Queue Elements is checked, the nucleus also deletes the users (purges their user queue elements).
To stop inactive users:
Right-click on under the expanded System Status.
Select on the drop-down menu.
The Stop Inactive Users panel is displayed in detail-view.
Enter the inactivity time interval (in seconds). Users who have not executed a command during this time limit will be stopped.
If you want the stopped users deleted (if you want to purge their user queue elements), check the Purge User Queue Elements check box.
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), stop users with Purge User Queue
Elements checked 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.
Click on the button to stop the users or click on the button to cancel. Both will return you to the previous panel.
The nucleus backs out any open transactions of the affected users. If Purge User Queue Elements is checked, the nucleus also deletes the users (purges their user queue elements).
To stop users by jobname:
Right-click on under the expanded System Status.
Select on the drop-down menu.
The Stop Users by Jobname panel is displayed in detail-view.
Enter the name of the job whose users you wish to stop.
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), stop users by jobname 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.
Click on the button to stop the users or click on the button to cancel. Both will return you to the previous panel.
The nucleus backs out any open transactions of the affected users and deletes them (purges their user queue elements).
To review the user queue element for a specific user:
Select an Adabas database in tree-view and expand it.
Select User Queue under the expanded System Status.
The user queue for the database appears on the User Queue panel in detail-view.
On the User Queue panel in detail-view, click on the TID of the user whose user queue element you want to review.
The UQE information is displayed in several tables that provide the following information.
| Statistics | Description | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TID | The unique internal identifier assigned to the user. | |||||||||||
| User ID | The Adabas-assigned user ID, if available. | |||||||||||
| Job Name | The job name associated with the user. | |||||||||||
| User Type | The user type. Possible values include: | |||||||||||
|
||||||||||||
| Status | The user status. Possible values include: | |||||||||||
|
||||||||||||
| Last Activity | The date and time activity last occurred by the user. | |||||||||||
| CPU ID | The CPU ID of the user (a component of the Communication ID). | |||||||||||
| VM ID | The VM ID of the user (a component of the Communication ID). | |||||||||||
| OPSYS ID | The operating system ID of the user (a component of the Communication ID). | |||||||||||
| User ID | The user ID (a component of the Communication ID). | |||||||||||
| Communication ID (hexadecimal) | The 28-byte hexadecimal communication ID of the
user.
Note: |
|||||||||||
| Hold Queue Limit | The maximum number of held ISNs the hold queue can contain from one user. For detailed information about the NISNHQ parameter, see the ADARUN Control Statement in the Adabas Operations documentation. | |||||||||||
| Max. parallel CIDs per User | The total number of CIDs (command IDs) allowed per user, and therefore the maximum number of table elements the user has available at any point in time. For detailed information about the NQCID parameter, see the ADARUN Control Statement in the Adabas Operations documentation. | |||||||||||
| Max. ISNs per TBI Element | The maximum number of ISNs kept in a TBI (table of ISNs) element in memory (list of resulting ISN lists). For detailed information about the NSISN parameter, see the ADARUN Control Statement in the Adabas Operations documentation, . | |||||||||||
| Max. Time of Nonactivity | The maximum length of time, in seconds, that the user can be inactive before inactive processing occurs. For more information about Adabas timeouts, refer to your Adabas documentation. | |||||||||||
| Time Limit for Sx Commands | The maximum length of time, in seconds, permitted for Sx commands by this user. | |||||||||||
| No. of ISNs currently held | The number of ISNs currently held by the user. | |||||||||||
| No. of CIDs currently in use | The number of CIDs (command IDs) currently in use. For detailed information about the NQCID parameter, see the ADARUN Control Statement in the Adabas Operations documentation. | |||||||||||
| No. of Calls | The number of calls issued by the user during the user session. | |||||||||||
| No. of I/Os | The number of I/Os initiated by the user during the user session. | |||||||||||
| Priority from ET/CP File | The priority of the user. | |||||||||||
| Start Session | The start time of the user session. | |||||||||||
| Start Transaction | The start time of the transaction. | |||||||||||
| File List | The file numbers of the files currently in use by the user. Note that no file list is provided for ET users. |
You can return to the User Queue panel by clicking the button or you can stop this user. When users are stopped, they are deleted. Any open transactions of the stopped/deleted users are backed out. Note that EXF and UTI users are not stopped or deleted.
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), stop them only if you are certain that the users to be
deleted (stopped) 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.
To stop this user:
Click the button.
You can filter the user queue display by last activity (elapsed time in seconds), ET-ID, user type, job name and user ID.
Once you have specified a filter for the user queue display, it remains in effect for all databases registered until you turn it off.
To filter the user queue display:
Access the user queue display and in the upper left corner of the
display, click on the button ().
The User Queue filter panel appears.
Enter the values you want to filter the user queue for. You can use an asterisk (*) as a wildcard character.
Verify that the Turn Off Filter check box does not have a check mark in it. If it does, click in the check box until the check mark is gone.
When all filters have been specified, click on the button to save the filters or click on the button to cancel the filter settings and revert to the prior settings (if any).
When you refresh the user queue display, the filters are applied to the file list display.
To stop a user:
Select the user you want to stop from the resulting list and click the button.
To clear all filters on the user queue display:
Access the user queue display and in the upper left corner of the
display, click on the button ().
The Hold Queue filter panel appears.
Click in the Turn Off Filter check box until a check mark appears.
Click on the button to save the filters or click on the button to cancel the filter settings and revert to the prior settings (if any).
To review the work status:
Select an Adabas database in tree-view and expand it.
Select Work Status under the expanded System Status.
Work Status displays the WORK area sizes (in blocks) for the
data protection area (Work part 1; ADARUN LP parameter)
area used for intermediate ISN lists (Work part 2; ADARUN LWKP2 parameter)
area used for resulting ISN lists (Work part 3)
distributed transaction processing area (Work part 4; only available if Adabas Transaction Manager is installed on a separate nucleus in your system)
To review the work pool:
Select an Adabas database in tree-view and expand it.
Select Work Pool Usage under the expanded System Status.
Work pool statistics are displayed including the total length set in the ADARUN parameter LWP, the length of the used and unused parts of the pool, and the length of the longest single unused part. These numbers can be used to tune the work pool length for the next session.
