The Adabas session monitoring functions allow you to control and manage major Adabas resources. These functions are most useful when analyzing system performance or seeking the cause of performance problems. Session monitoring functions can be accessed from the menu:
15:19:52 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
- Session Monitoring - PAC0012
Code Service Code Service
---- --------------------------- ---- ----------------------------
A Display cluster members S Current snapshot statistics
C Maintain user profiles T Maintain TCP/IP URL
D Display parameters U Display interval utilization
I Display installed products V Replicator Management
L Display event log buffer W Display session utilization
P Modify parameters X Cluster usage
Q Display queues Z Display maintenance levels
R Refresh interval statistics
? Help . Exit
---- --------------------------- ---- ----------------------------
Code ......... _
Database ID .. 1955 (WIS1955) NucID .. 1021
MENU04 : 'Session Utilization' function interrupted
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit Menu |
Note:
In cluster environments, the PF2 key allows you to
scroll sequentially through nucleus IDs in the cluster using the
NextNucid command. In addition, the current nucleus
ID is shown in a NucID field on this screen. When the
highest nucleus in a cluster is reached, PF2 causes AOS to cycle back to the
beginning and changes the nucleus ID to the lowest nucleus ID in the cluster.
Once the nucleus ID is changed, it remains in use for all Adabas Online System
screens until it is changed again.
Using the session monitoring environment you can monitor the Adabas nuclei in a multiprocessing environment. When you enter the DBID of a cluster database on the menu, subsequent screens include a field to specify the ID of the nucleus (NUCID) in the cluster you want to monitor:
If you do not set the nucleus ID, AOS defaults to the local nucleus.
If you set the nucleus ID to zero for a cluster database, the selected function is performed for all active nuclei in the cluster.
Using the AOS session monitoring environment, you can perform the following functions, accessible by menu option:
Selecting option from the menu to display cluster members produces the following screen:
21:23:16 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 1955 - Display Cluster Members - PACA002
Total number of active(WORK not empty) nuclei in the cluster ... 5
I Sel I NucID | Image ID I Jobname I Status I Available Plex Services I
----------------------------------------------------------------------------
I _ I 1 I DAEMVS I ADANUC01 I Active I All I
I _ I 2 I DAEMVS I ADANUC02 I Inactive I List,Cache I
I _ I 3 I DDZMVS I ADANUC03 I Active I All I
I _ I 4 I DDZMVS I ADANUC04 I Active I All I
I _ I 1021 | ZHST | USAXXXRP | Active | All I
I I | | | | I
I I | | | | I
I I | | | | I
I I | | | | I
I I | | | | I
I I | | | | I
I I | | | | I
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help PPT Exit Refresh -- - + Menu |
The screen displays a list of nuclei participating in the cluster and information about the current status of each nucleus.
To select a nucleus for additional processing:
Enter "S" in the Sel column opposite that nucleus.
To display additional information about a nucleus:
Enter "D" in the Sel column opposite that nucleus.
For an Adabas cluster nucleus that has a nonzero nucleus ID, its entry in the parallel participant table (PPT) is displayed in a screen similar to the following:
21:23:16 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 1955 - Display PPT Entry - MACA012
NucID ... 1021 Active Nucleus, PLOG(s) not copied, CLOG(s) not copied
Name Dataset Status DataSet Name
------ -------------------------- ----------------------------------------
WORK1 RD.USAXXX.DB1955.WORKR1
PLOGR1 RD.USAXXX.DB1955.PLOGR1
PLOGR2 RD.USAXXX.DB1955.PLOGR2
CLOGR1 RD.USAXXX.DB1955.CLOGR1
CLOGR2 RD.USAXXX.DB1955.CLOGR2
Press 'ENTER', PF3 or PF12 to continue
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
To display the PPT for this DBID:
Press PF2. The Display PPT screen appears.
16:42:08 ***** A D A B A S BASIC SERVICES ***** 2014-05-05
DBID 1955 - Display PPT - MACA022
NucID .. 1021 Active Nucleus, PLOG(s) not copied, CLOG(s) not copied
Image .. ZHST All Sysplex Services Active
Label Name Dataset Name
---------- ----------------------------------------
WORK1 RD.USAWIS.DB1955.WORKR1
PLOGR1 RD.USAWIS.DB1955.PLOGR1
PLOGR2 RD.USAWIS.DB1955.PLOGR2
CLOGR1 RD.USAWIS.DB1955.CLOGR1
CLOGR2 RD.USAWIS.DB1955.CLOGR2
PF1----- PF3------ PF4------ PF6------ PF7----- PF8----- PF9----- PF12-----
Help Exit Refresh PrevPPT NextPPT Menu |
Adabas allows you to retain user-related information from session to session in a user profile table that includes
ET records;
user priority;
user-specific timeout (TNxx, TT, and TLSCMD);
ISN buffering (NSISN, NSISNHQ);
command ID (NQCID) values that differ from the established ADARUN values; and
owner ID information for multiclient files.
Selecting Maintain user profiles
(option ) on the menu displays the following menu:
15:46:52 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
- Maintain User Profiles - PACIC02
Code Service
---- ---------------------------
L List/modify user profile(s)
M Mass function
X Delete ETID-ranges
? Help
. Exit
---- ---------------------------
Code ......... _
Start UID .... ________
Database ID .. 1957 (WIS1957)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
From the menu, you can:
list and modify a user profile table (option );
copy a user profile to one or more other users (option ); and
remove one or more ETIDs from the Adabas checkpoint file thereby deleting both profile and ET data (option ).
If necessary, you can supply a starting user ID. If the
Start UID field is left empty, Basic Services displays
entries starting from the beginning of the user profile table. You can use
range notation for the starting value. For example, if you enter
JA* in the Start UID field,
the display begins with user IDs that start with the letters
"JA".
If necessary, you can change the database by specifying the database ID in the Database ID field..
To list and modify the user profile table
Enter in the Code field.
The List/Modify User Profiles screen displays the user profile table:
15:47:17 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 1957 - List/Modify User Profiles - PACICL2
Mark entries with 'M' to modify or 'X' to delete :
M Userid Prty TNAA TNAE TNAX TT TLSCMD NSISN NISNHQ NQCID Owner-Id
- -------- ---- ----- ----- ----- ----- ------ ----- ------ ----- ----------
_ *USAX *USAXXX
_ *USF *USF1
_ AUTO1 AUTOMAT1
_ AUTO2 AUTOMAT2
_ AUTO3 *UTOMAT
_ BAFKE 9 100 100 100 100
_ CC 9 100 100 100 100
_ CICS
_
_
_
_
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit -- - + Menu |
You can modify existing profiles and add new user ones. 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. An equivalent direct command is
CHANGE 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 copy the attributes of a user profile to one or more other
user profiles
Enter in the Code field.
15:48:06 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 1957 - Maintain User Profiles - PACICM2
Set the user profiles of the userids entered below to the same as
userid .. USER1___
Userid Userid Userid Userid Userid Userid Userid
-------- -------- -------- -------- -------- -------- --------
XYZ1 XYZ2
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
On the resulting screen, you can type in the user ID of the profile to be copied, and the names of the users whose profiles are to be taken from that user ID.
In the example, users XYZ1 and XYZ2 inherit all values from user USER1 and effectively define a group.
To delete a range of user IDs
Enter in the Code field.
Specify a complete or partial user ID or an asterisk (all user IDs) in the Start UID field.
A window opens asking whether you want to delete all user IDs or select the user IDs to be deleted:
15:49:04 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
- Maintain User Profiles - PACIC02
Code Service
---- ---------------------------
L List/modify user profile(s)
M Mass function
X Delete ETID-ranges
? Help
. Exit +-------------------------------+
---- --------- | |
Code ..........x | 'Y' - Select ETIDs for |
Start UID .... ba* | Deletion |
Database ID .. 105 (RD-105) | 'N' - Delete ETIDs with NO |
| Selection |
| |
| Y <==== Select Option |
| |
| PF1=Help PF3=Exit |
Command ==> +-------------------------------+
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
 |
Warning: Be careful about answering (No) to the prompt. You could inadvertently delete IDs that you want to keep. |
If you enter (No) in the window's Select Option field, Basic Services deletes all user IDs in the specified range without any confirmation.
If you answer (Yes, the default), the Mass Delete of ET-IDs screen is displayed so that specific user IDs may be marked for retention:
15:50:26 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 1955 - Mass Delete of ET-IDs - PACICD2
Delete all ET-IDs starting with Userid = BA*
All entries marked 'K' (Keep) will N O T be deleted.
Userid Userid Userid Userid Userid Userid Userid
-------- -------- -------- -------- -------- -------- -------
BABRAB BABRAN BACANT BADBEE BADFUE BADKED BADKHK
BADNTU BADTCS BADWAT BAFCKA BAFJVS BAGDTS BAGJAR
BAGJKI BAGJVN BAGKIT BAGLAW BAGNET BAGPCT BAGPCP
BAGPCR BAGPST BAGSIR BAGSWI BAGTUF BAGTON BAGZAP
BAHNAK BAJLOB BAJPJS BAKLIM BAKSAT BAMCID BAMLIP
BAMLOT BAMPCS BAPEHN BAPLAB BARHEN BARHER BASHEP
BASMOR BASWAN BASWIG |
As indicated in the message on the screen, you need to mark with "k" those user IDs that you want to keep. Unmarked user IDs will be deleted when you press ENTER.
Note:
When a user ID is deleted, both the user profile and any
ET data for the user are deleted.
You can leave the screen without deleting any user IDs by using the EXIT key PF3 .
To view Adabas nucleus (ADARUN) parameters:
Select option on the menu and press Enter.
The equivalent direct command is
DISPLAY PARAMETERS
A series of Display Parameters screens appear. You can scroll through the screens using the PF7 (scroll backward) and PF8 (scroll forward) keys. The information on these screens and the number of screens that appear varies depending on the type database you have selected. ADARUN Parameter Reference
The following screens might display for an Adabas database in an Adabas cluster:
19:15:21 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Display Parameters - PACPD32
NucID 1021
-------------- Pools -------------- ------------- Queues ------------------
Sort Area (LS).. 19968 Command Queue (NC) .. 20
Int. User Buffer (LU).. 400000 Hold Queue (NH) .. 1200
Buffer Pool (LBP).. 283392 User Queue (NU) .. 200
Format Pool (LFP).. 150000 ------------ Time Windows -------------
ISN List Table (LI).. 360000 Transaction Time (TT) .. 4858
Seq. Cmd. Table (LQ).. 20000 Max Transaction Time (MXTT) .. 3600
Work Pool (LWP).. 1500000 Nonactivity ACC-User (TNAA) .. 4858
Attached Buffer (NAB).. 100 Nonactivity ET-User (TNAE) .. 4858
Security Pool (LCP).. 10000 Nonactivity EXU-User (TNAX) .. 4858
UQ-DE Pool (LDEUQP).. 50000 Max Nonactivity Time(MXTNA) .. 3600
Err. Recovery (MSGBUF).. 36 Time Limit Sx-Cmds (TLSCMD) .. 300
Max Time for Sx-Cmds(MXTSX) .. 3600
Command Time (CT) .. 3858
SYNS60 Interval (INTNAS) .. 3600
Page 1 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Modify + Menu |
15:28:41 ***** A D A B A S BASIC SERVICES ***** 2018-04-04
DBID 1955 - Display Parameters - PACPD22
NucID 1021
--------- Miscellaneous ----------- --------- Miscellaneous --------------
Read only (READONLY).. NO LARGEPAGE ................. NO
UTI only (UTIONLY).. NO V64BIT .................... NO
OPEN required (OPENRQ).. NO SRLOG ..................... Upd
Ignore DIB Entry(IGNDIB).. NO LOGWARN ................... 0
Local nucleus (LOCAL) .. NO SECUID .................... ALLOW
Number of Threads (NT) .. 25 INDEXCROSSCHECK ........... YES
Non DE Search (NONDES) .. YES Print on refresh(REFSTPRT). YES
Log AOS/DBS Upd.(AOSLOG).. NO Number plog buffers ....... 1
Batch Support (BATCH) .. NO Number work1 buffers ...... 1
Data Protection Area(LP).. 1000 Event log buffer size ..... 1024
Ignore Wrk Prt4(IGNDTP) .. NO Auto-restart buffers (ARN). 9
WORK-Part-4 Area (LDTP) .. 0 zIIP processors (ZIIP) .... YES
WORK-Part-2 Area(LWKP2) .. 160
SVC (SVC) .. 249
Page 2 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Modify - + Menu |
19:15:21 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Display Parameters - PACPD32
NucID 1021
--------- Space Warning ----------------
ASSOSPACEWARN ..... 0
DATASPACEWARN ..... 0
--------- Auto Increase ------------------------------------------------
AUTOINCASSOTHRESHOLD ..... 0 AUTOINCDATATHRESHOLD ..... 0
AUTOINCASSOSIZE ... 0 CYL AUTOINCDATASIZE ... 0 CYL
AUTOINCASSOTOTAL .. 0 CYL AUTOINCDATATOTAL .. 0 CYL
--------- SMF --------------------------
SMF ............... NO
Page 3 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Modify - + Menu |
19:15:21 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Display Parameters - PACPD32
NucID 1021
---- Command Logging ---- ------------ Command Logging --------------
Command Logging .. YES Log VOLSER info (LOGVOLIO) .. NO
LOGCB ............ NO Max buffer size/cmd (CLOGMAX) .. 16384
LOGFB ............ YES Max buffer size/buf(CLOGBMAX) .. 4096
LOGRB ............ YES Log ABDX (LOGABDX) .. NO
LOGSB ............ NO Log multifetch buffer (LOGMB) .. NO
LOGVB ............ NO Command log layout(CLOGLAYOUT).. 8
LOGIB ............ NO
LOGIO ............ NO
LOGUX ............ NO
LOGSIZE .......... 5064 ---------- Protection Logging -----------
DUAL CLOG Size ... 675 PLOG required (PLOGRQ) .. YES
DUAL CLOG Dev. ... 3390 DUAL PLOG Size (DUALPLS) .. 240
NCLOG ............ 0 DUAL PLOG Device (DUALPLD) .. 3390
NPLOG .......................... 0
Page 4 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Modify - + Menu |
19:15:21 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Display Parameters - PACPD32
NucID 1021
------------ Large Pools ------------- --------- Other Services ---------
Flush I/O Pool (LFIOP) .. 80000 Triggers / Procedures (SPT) .. YES
Delta Save Facility (DSF) .. YES
Cache Facility (CACHE) .. NO
Transaction Manager (ATM) .. NO
-------- User Specific Limits -------- TCP/IP Support (TCPIP) .. NO
Hold Queue Limit (NISNHQ) .. 400 Ext. Error Recovery (SMGT) .. YES
CIDs per User (NQCID) .. 40 2 Phase Commit Support(DTP) .. NO
ISN per TBI Element(NSISN) .. 100
Review:
------------ Buffer Pool ------------- Support (REVIEW) .. NO
Bufferflush Dur. (TFLUSH) .. 1
Parallel LFIOP I/O (FMXIO) .. 1 Filter ............. YES
Async. by Vol-Ser (ASYTVS) .. YES Max bufsize cmd .... 16384
Max bufsize buf .... 5120
Page 5 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Modify - + Menu |
19:15:21 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Display Parameters - PACPD32
NucID 1021
----- Cluster/Parallel Services ------- ---- Cluster/Parallel Services ----
Environment .......... Sysplex MXMSG .................. 300
ARM element name ..... MXMSGWarn .............. 0
Cache structure name . ADA_CACHE4 MXCANCEL ............... 300
Lock structure name .. ADA_LOCK4 MXCANCELWarn ........... 75
Sysplex group name ... WISPLEX MXWtor ................. 0
Cache type ........... DSP MXStatus ............... 15
DIrratio ............. 4
ELemratio ............ 1 CLUPUBLPROT ............ YES
Redo Pool (LRDP) ..... 80000 CLUWORK1CACHE .......... 0
CLOGMRg .............. NO
CLUCACHEUnchanged .... No
CLULOCKSize .......... 0
CLUCACHESize ......... 0
Page 6 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Modify - + Menu |
19:15:21 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Display Parameters - PACPD32
NucID 1021
---- Replication Parameters -------
Replication .......... YES
RPWARNPercent ........ 0
RPWARNINCrement ...... 10
RPWARNINTerval ....... 60
RPWARNMessagelimit ... 5
RPCONNECTCount ....... 0
RPCONNECTInterval .... 0
RPLSORT .............. YES
LRPL ................. 100000
Page 7 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Modify - Menu |
Notes:
NextNucid command. In addition, the current nucleus
ID is shown in a NucID field on this screen. When the
highest nucleus in a cluster is reached, PF2 causes AOS to cycle back to the
beginning and changes the nucleus ID to the lowest nucleus ID in the cluster.
Once the nucleus ID is changed, it remains in use for all Adabas Online System
screens until it is changed again.
To modify Adabas nucleus (ADARUN) parameters:
Choose option on the menu and press Enter. Modifiable values are highlighted (intensified) on the displays. The equivalent direct command is:
MODIFY PARAMETERS
A series of Modify Parameters screens appear. You can scroll through the screens using the PF7 (scroll backward) and PF8 (scroll forward) keys. The information on these screens and the number of screens that appear varies depending on the type database you have selected. For a description of each ADARUN parameter, read ADARUN Parameter Reference.
The following screens might display for an Adabas database in an Adabas cluster:
19:16:32 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Modify Parameters - PACP032
NucID 1021
Modify parameters below, as required:
-------------- Pools -------------- ------------- Queues ------------------
Sort Area (LS).. 19968 Command Queue (NC) .. 20
Int. User Buffer (LU).. 400000 Hold Queue (NH) .. 1200
Buffer Pool (LBP).. 283392 User Queue (NU) .. 200
Format Pool (LFP).. 150000 ------------ Time Windows -------------
ISN List Table (LI).. 360000 Transaction Time (TT) .. 4858
Seq. Cmd. Table (LQ).. 20000 Max Transaction Time (MXTT) .. 3600
Work Pool (LWP).. 1500000 Nonactivity ACC-User (TNAA) .. 4858
Attached Buffer (NAB).. 100 Nonactivity ET-User (TNAE) .. 4858
Security Pool (LCP).. 10000 Nonactivity EXU-User (TNAX) .. 4858
UQ-DE Pool (LDEUQP).. 50000 Max Nonactivity Time(MXTNA) .. 3600
Err. Recovery (MSGBUF).. 36 Time Limit Sx-Cmds (TLSCMD) .. 300
Max Time for Sx-Cmds(MXTSX) .. 3600
Command Time (CT) .. 3858
SYNS60 Interval (INTNAS) .. 3600
Page 1 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Display + Menu |
19:16:32 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Modify Parameters - PACP032
NucID 1021
Modify parameters below, as required:
--------- Miscellaneous ------------ --------- Miscellaneous --------------
Read only (READONLY).. NO LARGEPAGE ................. NO
UTI only (UTIONLY).. NO V64BIT .................... NO
OPEN required (OPENRQ).. NO SRLOG ..................... Upd
Ignore DIB Entry(IGNDIB).. NO LOGWARN (LOGWARN) ........ 0
Local nucleus (LOCAL) .. NO SECUID (SECUID) .......... ALLOW
Number of Threads (NT) .. 5 INDEXCROSSCHECK (IND) .... YES
Non DE Search (NONDES) .. YES Print on refresh (REFSTPRT) YES
Log AOS/DBS Upd (AOSLOG).. YES Number plog buffers ....... 1
Batch Support (BATCH) .. NO Number work1 buffers ...... 1
Data Protection Area(LP).. 1000 Event log buffer size ..... 1024
Ignore Wrk Prt4(IGNDTP) .. NO Auto-restart buffers (ARN). 9
WORK-Part-4 Area (LDTP) .. 0 AUDITLOG (AUDITLOG) ...... CONSOLE
WORK-Part-2 Area(LWKP2) .. 180
SVC (SVC) .. 249
Page 2 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Display - + Menu |
19:16:32 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Modify Parameters - PACP032
NucID 1021
--------- Space Warning ----------------
ASSOSPACEWARN ..... 0___________________
DATASPACEWARN ..... 0___________________
--------- Auto Increase ------------------------------------------------
AUTOINCASSOTHRESHOLD ..... 0__ AUTOINCDATATHRESHOLD ..... 0__
AUTOINCASSOSIZE ... 0_________ CYL AUTOINCDATASIZE ... 0_________ CYL
AUTOINCASSOTOTAL .. 0_________ CYL AUTOINCDATATOTAL .. 0_________ CYL
--------- SMF --------------------------
SMF ............... NO
Page 3 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Display - + Menu |
19:16:32 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Modify Parameters - PACP032
NucID 1021
Modify parameters below, as required:
---- Command Logging ---- ------------ Command Logging --------------
Command Logging .. YES Log VOLSER info (LOGVOLIO) .. NO
LOGCB ............ NO Max buffer size/cmd (CLOGMAX) .. 16384
LOGFB ............ YES Max buffer size/buf(CLOGBMAX) .. 4096
LOGRB ............ YES Log ABDX (LOGABDX) .. NO
LOGSB ............ NO Log multifetch buffer (LOGMB) .. NO
LOGVB ............ NO Command log layout(CLOGLAYOUT).. 8
LOGIB ............ NO
LOGIO ............ NO
LOGUX ............ NO
LOGSIZE .......... 5064 ---------- Protection Logging -----------
DUAL CLOG Size ... 675 PLOG required (PLOGRQ) .. YES
DUAL CLOG Dev. ... 3390 DUAL PLOG Size (DUALPLS) .. 240
NCLOG ............ 0 DUAL PLOG Device (DUALPLD) .. 3390
NPLOG .......................... 0
Page 4 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Display - + Menu |
19:16:32 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Modify Parameters - PACP032
NucID 1021
------------ Large Pools ------------- --------- Other Services ---------
Flush I/O Pool (LFIOP) ... 80000 Triggers / Procedures (SPT) .. YES
Delta Save Facility (DSF) .. YES
Cache Facility (CACHE) .. NO
Transaction Manager (ATM) .. NO
-------- User Specific Limits -------- TCP/IP Support (TCPIP) .. NO
Hold Queue Limit (NISNHQ) .. 400 Ext. Error Recovery (SMGT) .. YES
CIDs per User (NQCID) .. 40 2 Phase Commit Support(DTP) .. NO
ISNs / TBI Element (NSISN) .. 100
Review:
------------ Buffer Pool ------------- Support (REVIEW) .. NO
Bufferflush Dur. (TFLUSH) .. 1
Parallel LFIOP I/O (FMXIO) .. 1 Filter ............. YES
Async. by Vol-Ser (ASYTVS) .. YES Max bufsize cmd .... 16384
Max bufsize buf .... 5120
Page 5 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Display - + Menu |
19:16:32 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Modify Parameters - PACP032
NucID 1021
----- Cluster/Parallel Services ------- ---- Cluster/Parallel Services ----
Environment .......... Sysplex MXMSG .................. 300
ARM element name ..... MXMSGWarn .............. 75
Cache structure name . ADA_CACHE4 MXCANCEL ............... 300
Lock structure name .. ADA_LOCK4 MXCANCELWarn ........... 75
Sysplex group name ... WISPLEX MXWtor ................. 0
Cache type ........... DSP MXStatus ............... 15
DIrratio ............. 4
ELemratio ............ 1 CLUPUBLPROT ............ YES
Redo Pool (LRDP) ..... 80000 CLUWORK1CACHE .......... 0
CLOGMRg .............. NO
CLUCACHEUnchanged .... No
CLULOCKSize .......... 0
CLUCACHESize ......... 0
Page 6 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Display - + Menu |
19:16:32 ***** A D A B A S BASIC SERVICES ***** 2017-09-25
DBID 1955 - Modify Parameters - PACP032
NucID 1021
---- Replication Parameters -------
Replication .......... YES
RPWARNPercent ........ 0
RPWARNINCrement ...... 10
RPWARNINTerval ....... 60
RPWARNMessagelimit ... 5
RPCONNECTCount ....... 0
RPCONNECTInterval .... 0
RPLSORT .............. YES
LRPL ................. 100000
Page 7 of 7
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit ABC List Display - Menu |
Notes:
NextNucid command. In addition, the current nucleus
ID is shown in a NucID field on this screen. When the
highest nucleus in a cluster is reached, PF2 causes AOS to cycle back to the
beginning and changes the nucleus ID to the lowest nucleus ID in the cluster.
Once the nucleus ID is changed, it remains in use for all Adabas Online System
screens until it is changed again.
The following screen might display as the last screen of the series or parameter screens for an Adabas database that operates as an Event Replicator Server:
02:17:45 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1954 - Modify Parameters - PACP022
------- Reptor Parameters -------
RPLParms ............. None
RPWARNPercent ........ 0
RPWARNINCrement ...... 10
RPWARNINTerval ....... 60
RPWARNMessagelimit ... 5
RPCONNECTCount ....... 0
RPCONNECTInterval .... 0
LRPL ................. 25000000
Page 6 of 6
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit ABC List Display - Menu |
Choose option on the menu and press ENTER to display a list of installed products.
02:19:08 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBid 1955 - Display Installed Products - PACII02
NucID 1021
-------------------------- ----- ------------------------------- ----
Cache Facility ........... NO Extended Error Recovery ....... YES
Delta Save Facility ...... YES Recovery Aid .................. YES
Cluster Services ......... YES Stored Procedures & Triggers .. NO
Parallel Services ........ NO Two Phase Commit .............. NO
Fastpath ................. NO TCPIP support ................. NO
Vista .................... NO Event Replicator .............. YES
Transaction Manager ...... NO
SAF Security Interface ... NO
Review ................... LOCAL
Adabas Online System ..... YES
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
This screen displays what is installed on the current selected Adabas
Selecting (option ) from the menu invokes the Display Event Log Buffer screen.
The Adabas event log is a wraparound log in memory that is used to log each response code 145 (RSP145) event. The INFOBUFFERSIZE ADARUN parameter identifies the size of the Adabas event log. Each entry in the event log is currently 128 bytes, although this may change in later Adabas releases. When the Adabas event log fills up, the oldest entries in the log are overwritten.
This is the equivalent of running the ADADBS DEVENTLOG utility function.
16:05:10 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 11131 - Display Event Buffer Log - PACL002
Sel Nucid File Resp ISN Date Time Aff Jobn Causer Jobn
--- ----- ----- ----- ---------- ---------- -------- -------- --------
_ 1 145 9999 2009-08-14 20:12:18 SCAATATU SCAATATU
_
_
_
_
_
_
_
_
_
_
_
Enter 'S' to display
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu
|
When you enter an "S" next to an event listed on the Display Event Buffer Log screen, the Selected Event Buffer Log screen appears, allowing you to review detailed log data in the event log for the selected event.
16:05:10 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 11131 - Selected Event Buffer Log - PACL002
File Resp ISN Date Time Nucid
----- ----- ---------- ---------- -------- ------
1 145 9999 2009-08-14 20:12:18
---------------------------------------------------------
Affected
Jobname ET id SAF id
-------- -------- --------
SCAATATU ???
Userid (hex)
0004A10E20980000404040404040404000FC0100E4F0F0F200000000
---------------------------------------------------------
Causer
Jobname ET id SAF id
-------- -------- --------
SCAATATU ???
Userid (hex)
0004A10E20980000404040404040404000FC0100E4F0F0F100000000
Press ENTER to continue
|
Choose option on the menu and press ENTER to display the menu.
16:31:49 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
- Queue Displays - PACQ002
Code Service
---- ---------------------------
A Display User Queue Elements
C Display Command Queue
H Display Hold Queue
? Help
. Exit
---- ---------------------------
Code ............... _
Max No. Elements ... 100
Last Activity ...... 0 (elapsed time in seconds)
Selection Criteria (Selected User USASASW and Tid TSU03216)
ET-ID (User-ID) .. ________ User Type ... ___
Job Name ......... ________
Terminal ID ...... ________
Database ID ........ 1955 (WIS1955) NucID .. 1021
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit Clear UID Menu |
Notes:
NextNucid command. In addition, the current nucleus
ID is shown in a NucID field on this screen. When the
highest nucleus in a cluster is reached, PF2 causes AOS to cycle back to the
beginning and changes the nucleus ID to the lowest nucleus ID in the cluster.
Once the nucleus ID is changed, it remains in use for all Adabas Online System
screens until it is changed again.
The Display Queues function shows, in table format, the contents of the user, command or hold queues. Each displayed table entry contains a related terminal ID (TID), job name, user ID (ET-ID or security user ID, as appropriate), current status, and related information such as files currently in use and command type.
If you try to display a queue that is currently empty, an appropriate message appears on the Display Queues menu.
Individual entries in the selected queues can be displayed to provide more detailed information, or selected for a later Basic Services function (the individual user-level statistics sampling described in section Obtaining Current Snapshot Statistics is an example).
This section covers the following topics:
If you select (option ) on the menu, you must also specify the maximum number of elements to display. Other selection criteria you may optionally specify include:
number of seconds since last activity
logical user ID (ETID)
type of user (ACC, AOS, ET, EXU, EXF, UTI)
job name
terminal ID and
database ID
If multiple selection criteria are specified, they are combined with logical ORs.
The equivalent display direct command is:
DISPLAY UQ user queue
14:42:12 ***** A D A B A S BASIC SERVICES ***** 2015-05-20
DBID 1955 (1021) - Display User Queue - PACQA42
SEL-CRIT: MAX-NUM = 100
Total Users .. 3
Mark entries with 'D' (Display) or 'S' (Select):
I I I I User I User I Last I I
M I TID I ET-ID I Jobname I Type I State I Active I File(s) I
-----------------------------------------------------------------------------
_ I TSU09745 I USAWIS I USAWIS I AOS I I I None I
_ I CEF94B54 I I USAWISRP I ET I ET I 36 I 11 I
_ I USAWIS 1 I I ZCOMPLET I ET I ET I 20 I None I
_ I I I I I I I I
_ I I I I I I I I
_ I I I I I I I I
_ I I I I I I I I
_ I I I I I I I I
_ I I I I I I I I
_ I I I I I I I I
_ I I I I I I I I
_ I I I I I I I I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh SECUID - + Menu |
Note:
In cluster environments, the PF2 key allows you to
scroll sequentially through nucleus IDs in the cluster using the
NextNucid command. In addition, the current nucleus
ID is shown in a NucID field on this screen. When the
highest nucleus in a cluster is reached, PF2 causes AOS to cycle back to the
beginning and changes the nucleus ID to the lowest nucleus ID in the cluster.
Once the nucleus ID is changed, it remains in use for all Adabas Online System
screens until it is changed again.
The PF6 key allows you to switch columns of either having the ET-ID displayed or the security user ID (SECUID) displayed.
If you choose to display (D) an individual user ID, a user queue element information screen similar to the following appears:
16:55:21 ***** A D A B A S BASIC SERVICES ***** 2015-05-20
DBID 1955 (1021) - Display User Queue Element - PACQA42
I I I I I User I User I Last I
I TID I SECUID I Jobname I ETID I Type I State I Active I
------------------------------------------------------------------------
I TSU09745 I USAWIS I USAWIS I USAWIS I AOS I I 0 I
------------------------------------------------------------------------
Global Uid= 0009A10E28280000 4040404040404040 00FBE100 E3E2E4F0F9F7F4F5
Hold Queue Limit ............ 0 ETID Hex Display .. E4E2C1E6C9E24040
Max. parallel CIDs per User . 40
Max. ISNs per TBI Element ... 100 Start Times
Max. Time of Nonactivity .... 3775 Session ...... 2015-05-20 10:42:09
Max. Transaction Time ....... 0 Transaction .. 0000-00-00
Time Limit for Sx Commands .. 300 File List
No. of ISNs currently held .. 0 None
No. of CIDs currently in use: 0
No. of Calls ................ 121
No. of I/Os ................. 131
Priority from ET/CP File .... 0
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
Note:
The ET-ID column on both of these
screens will show ETIDs or security user IDs (SECUIDs), as appropriate for your
site. The column title will change, based on what is displayed.
If you choose (option ) on the menu, the current commands in the command queue and their status are listed. PF2 allows you to switch the display between "time-in" and "job name".
The equivalent display direct command is:
DISPLAY CQ
16:33:58 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display Command Queue - PACQC12
NUCID: 1021
Mark entries with 'S' to select :
M TID Secuid Jobname Time Status Cmd File Length
---I---------I---------I---------I---------I--------I---I------I-------
_ I TSU03505 USAXXXX USAXXXX 12:33:58 Active UC 720
_ I
_ I
_ I
_ I
_ I
_ I
_ I
_ I
_ I
_ I
_ I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh - + Menu |
Note:
The Secuid column on this screen will
show ETIDs or security user IDs (SECUIDs), as appropriate for your site. The
column title will change, based on what is displayed.
If you choose (option ) on the menu, a list of the ISNs currently in hold status is displayed.
The equivalent display direct command is:
DISPLAY HQ
10:44:47 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display Hold Queue - PACQH22
Mark entries with 'S' to select a user :
M I FNR I ISN I Mode I TID I SECUID I Jobname I ETID
--------------------------------------------------------------------------
_ I 1 I 20 I I USAXXX 2 I USAXXX I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
_ I I I I I I I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh - + Menu
|
Selecting (option ) on the menu displays the screen:
13:18:12 ***** A D A B A S BASIC SERVICES ***** 2014-04-29
DBID 1955 - Interval Statistics - PACR012
NUCID 1021
Mark each nucleus statistic to be reset:
_ Command Usage
_ File Usage
_ Pool Usage
_ Thread Usage
_ Counters
_ Time Elapsed
_ I/O
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
To select the statistics to be refreshed, place an "X" in the space next to the statistic type.
More than one statistic may be refreshed at the same time. The statistics selected are reset to zero.
PF3 cancels the request and returns to the menu. PF12 cancels the request and returns to the AOS .
Selecting (option ) on the menu invokes the menu:
13:22:10 ***** A D A B A S BASIC SERVICES ***** 2014-04-29
- Snapshot Statistics - PACS002
Code Service
---- -----------------------------
G Start General Statistics
R Read General Statistics
S Read User Statistics
U Start User Statistics
? Help
. Exit
---- -----------------------------
Code ......... _
Duration ..... 60 seconds
User ID ......
Database ID .. 1955 (WIS1955) NucID .. 1021
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Disp UQ Exit Clear UID Menu |
Snapshot statistics provide information about file and command use either for a single user (user statistics) or for all currently active users (general statistics). The statistics must first be 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
Start general statistics (option ) and, after the specified duration, read them (option ).
The equivalent direct commands are:
START STATISTICS READ STATISTICS
For more information, read Basic Services Direct Commands.
If user statistics are started (option ) or subsequently read (option after the specified duration), a user ID must either be indicated on this screen or have been previously selected in the Display User Queue (PF2) or Display Command Queue options. PF4 is used to deselect a previously selected user ID.
This section covers the following topics:
Three screens of statistics are displayed: the first two show command usage (use PF7 and PF8 to toggle between these; the third shows file usage (use PF4 to toggle between the file usage and command usage screens):
The following general command usage information for all currently active users is displayed:
09:24:04 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - General Statistic: Command Usage - PACSR32
NUCID 1021
Statistic Start Time .. 2014-05-02 05:20:42
Total Commands ........ 10,887
CMD-Type Nr. CMDs CMD-Type Nr. CMDs CMD-Type Nr. CMDs
--------------------- --------------------- ---------------------
A1/4 0 L2/5 1 S5 0
BT 0 L3/6 2,136 S8 0
CL 30 L9 219 S9 0
C1 0 N1/2 0 UC 503
C3 0 OP 36 U0 0
C5 0 RC 1,569 U1 0
ET 0 RE 0 U2 0
E1/4 0 REST 5,288 U3 0
HI 0 RI 0 V1 0
LF 3 S1/4 1,061 V2 0
L1/4 15 S2 0 V3 13
Page 1 of 2
PF1----- PF2------ PF3------ PF4------ PF7----- PF8----- PF9----- PF12-----
Help Exit File + Menu |
09:24:04 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - General Statistic: Command Usage - PACSR32
NUCID 1021
Statistic Start Time .. 2014-05-02 05:20:42
Total Commands ........ 10,887
CMD-Type Nr. CMDs CMD-Type Nr. CMDs CMD-Type Nr. CMDs
--------------------- --------------------- ---------------------
V4 13
YA 0
YB 0
YCAL 0
YF 0
YP 0
Page 2 of 2
PF1----- PF2------ PF3------ PF4------ PF7----- PF8----- PF9----- PF12-----
Help Exit File - Menu |
If PF4 (File) is clicked, the commands used by file number are shown.
09:24:04 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - General Statistic: File Usage - PACSR32
NUCID 1021
Statistic Start Time ...... 2014-05-02 05:20:42
File File Name No. Cmds File File Name No. Cmds
----- ------------------- --------- ----- ------------------- ---------
0 *Cmds with no Fnr* 7 11 NAT-SYSTEM 2
Total Commands: 10887
Command ==>
PF1----- PF2----- PF3----- PF4----- PF6----- PF7----- PF8----- PF12----
Help Exit Cmds -- - + Menu |
If user statistics are collected and read, the following command usage information is displayed for the specific user:
16:12:34 ***** A D A B A S BASIC SERVICES ***** 2014-03-17
DBID 1957 - User Statistics: Command Usage - PACSS22
Statistic Start Time ...... 2013-03-05 11:11:15 UserID ... TSU02013
(USAXXXX)
L1/4 - Read/Get Record .... A1/A4 - Update Record ....
L2/5 - Read Physical ...... N1/N2 - Add Record .......
L3/6 - Read Logical ....... E1/E2 - Delete Record ....
L9 - Read Descriptor ....
LF - Read Field Def. .... OP - Open User Sess ...
RE - Read ET Data ....... CL - Close User Sess ..
ET - End Transaction ..
S1/4 - Find Records ....... BT - Backout Tran. ....
S2 - Find Sorted ........
S5 - Find Coupled ISN ... RC - Release Cmd ID ...
S8 - Process ISN List ... UC - Utility Command .. 9
S9 - Sort ISN List ......
Press PF8 for more
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit File + Menu |
16:12:34 ***** A D A B A S BASIC SERVICES ***** 2014-03-17
DBID 1957 - User Statistics: Command Usage - PACSS22
Statistic Start Time ...... 2013-03-05 11:11:15 UserID ... TSU02013
(USAXXXX)
REST - Follow up cmds .... U0 - U0 commands .......
U1 - U1 commands .......
YA - YA commands ....... U2 - U2 commands .......
YB - YB commands ....... U3 - U3 commands .......
YC - YC commands .......
YP - YP commands ....... V1 - V1 commands .......
YCAL - YCAL commands ..... V2 - V2 commands .......
V3 - V3 commands .......
V4 - V4 commands .......
Thread Time (msec) ........ 0.0 100% User's commands ..
No. of I/Os ............... 0 Total commands ... 10
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help GStat Exit File -- - Menu |
The following general file usage information for all currently active users is displayed:
16:13:57 ***** A D A B A S BASIC SERVICES ***** 2014-03-17
DBID 1957 - General Statistic: File Usage - PACSR22
Statistic Start Time ...... 2013-03-05 11:11:15
File File Name No. Cmds File File Name No. Cmds
----- ------------------- --------- ----- ------------------- ---------
0 *Cmds with no Fnr* 10
Total Commands: 10
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Cmds -- - + Menu |
If user statistics are collected and read, the following file usage information is displayed for the specific user:
16:55:50 ***** A D A B A S BASIC SERVICES ***** 2014-03-17
DBID 1957 - User Statistics: File Usage - PACSS22
(USAXXXX)
Statistic Start Time ...... 2013-03-05 11:17:06 UserID ... TSU02013
Thread Time (msec) ........ 0.0 No. I/Os.. 0
File File Name No. Cmds File File Name No. Cmds
----- ------------------- --------- ----- ------------------- ---------
*** No Files Used ***
Perc of all cmds .. 100% Commands processed:
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help GStat Exit Cmd Menu |
Selecting (option ) from the menu invokes the Display/Maintain URL screen:
16:09:20 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display/Maintain URL - PACTC02
Mark entries with 'O' to Open or 'C' to Close a URL:
M URL Status Message
- -------------------- ------- -------
_ HPS://TCPIPMVS:1962_ Closed
_ HPS://TCPIPMVS:1963_ Open
_ HPS://TCPIPMVS:1964_ Open
_ HPS://TCPIPMVS:1965_ Open
_ ____________________
Command ===>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refr -- - + Menu |
The screen displays a list of all defined URLs and their current status: open or closed.
To change the status of a URL:
Enter "O" to open or "C" to close a URL in the corresponding M column next to the URL entry.
To define a new URL and open it:
Use the blank line provided at the end of the URL list.
Once you have made your changes, press PF4 (Refr) to refresh the list.
Interval utilization displays provide a comprehensive overview of Adabas operations for an interval.
Each of the interval utilization options contain a refresh capability (PF4) that allows you to refresh the displayed values, a convenience for long-term monitoring of Adabas system functions.
Selecting (option ) from the menu invokes the menu:
16:39:08 ***** A D A B A S BASIC SERVICES ***** 2014-05-05
- Interval Utilization - PACU002
Code Service Code Service
---- ------------------------------- ---- -------------------------------
C Command usage S System status
F File usage T Thread usage
H High watermarks (pools/queues) V I/Os by Volser
L Workpool (LWP) usage W WORK status
N Nucleus File Status Y Display PPT
P PLOG status
? Help
. Exit
---- ------------------------------- ---- -------------------------------
Code ......... _
File Number .. 0
Database ID .. 1955 (WIS1955) NucID .. 1021
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit Menu |
Note:
In cluster environments, the PF2 key allows you to
scroll sequentially through nucleus IDs in the cluster using the
NextNucid command. In addition, the current nucleus
ID is shown in a NucID field on this screen. When the
highest nucleus in a cluster is reached, PF2 causes AOS to cycle back to the
beginning and changes the nucleus ID to the lowest nucleus ID in the cluster.
Once the nucleus ID is changed, it remains in use for all Adabas Online System
screens until it is changed again.
This section covers the following topics:
Selecting (option ) on the menu displays the Command Usage screen, which shows the total and average execution time of each Adabas command type issued during the current session and processed by the Adabas nucleus. It also shows the total of all Adabas commands issued.
The values shown on this screen are shown in compressed form. Each can display as a nine-digit value, with appropriate multiplier letters "k" (1000), "M" (1000000), "G" (1000000000), and "T" (1000000000000) (representing consecutive powers of 1000) if necessary. On any of these screens, you can press PF9 to see the actual values (without the multipliers) of the counters on the screens. In this view (full view), there are fewer statistics on each screen, so there are more screens to page through. To return to compressed view, just press PF9 again.
If the value of a counter on these screens ever exceeds the space available for the statistic, the statistic will display in red.
The equivalent direct command is:
DISPLAY CMDUSAGE
18:35:22 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - Command Usage - PACUC22
NucID 1021
Total Commands .. 7,228
CMD-Type I Nr. CMDs I Aver. Dur. CMD-Type I Nr. CMDs I Aver. Dur.
------------------------------------- -------------------------------------
A1/4 I 0 I BT I 0 I
CL I 18 I 4.627 C1 I 0 I
C3 I 0 I C5 I 0 I
ET I 0 I E1/4 I 0 I
HI I 0 I LF I 0 I
L1/4 I 15 I 1.486 L2/5 I 1 I
L3/6 I 1,633 I 3.580 L9 I 203 I 1.797
N1/2 I 0 I OP I 24 I 10.539
RC I 1,260 I 0.008 RE I 0 I
REST I 3,127 I RI I 0 I
S1/4 I 678 I 7.635 S2 I 0 I
(Aver. Dur. - units of milliseconds) Page 1 of 2
PF1----- PF2------ PF3------ PF4------ PF7----- PF8----- PF9----- PF12-----
Help Exit Refresh + Fullview Menu |
18:35:22 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - Command Usage - PACUC22
NucID 1021
Total Commands .. 7,228
CMD-Type I Nr. CMDs I Aver. Dur. CMD-Type I Nr. CMDs I Aver. Dur.
------------------------------------- -------------------------------------
S5 I 0 I S8 I 0 I
S9 I 0 I UC I 251 I 2.291
U0 I 0 I U1 I 0 I
U2 I 0 I U3 I 0 I
V1 I 0 I V2 I 0 I
V3 I 9 I V4 I 9 I 0.009
YA I 0 I YB I 0 I
YCAL I 0 I YF I 0 I
YP I 0 I
(Aver. Dur. - units of milliseconds) Page 2 of 2
PF1----- PF2------ PF3------ PF4------ PF7----- PF8----- PF9----- PF12-----
Help Exit Refresh - Fullview Menu |
Adabas includes some V* and Y* commands , which you may see mentioned in Adabas shutdown statistics or in Adabas Online System (AOS) screens. These commands are used internally by Adabas and Adabas add-on products and should not be used in direct calls in your applications. Should you use them, errors will result.
Selecting (option ) on the menu displays the File Usage screen , which shows one of the following things.
If you select file number 0 (zero) on the menu, all files of the database used during the session and the number of accesses to each file are displayed on the File Usage screen.
The equivalent direct command is:
DISPLAY FILUSAGE
18:36:33 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - File Usage - PACUF42
Nucid: 1021
Fnr Tot. Cmds I Fnr Tot. Cmds I
---------------------------------- ----------------------------------
0 4,714 I 11 2,360 I
12 158 I 19 17 I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Repos Exit Refresh -- Menu
Û 19,009 |
If you select an actual file number on the menu, the File Usage screen shows the users that are currently active on the file. A maximum of five users are displayed.
18:36:33 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - File Usage - PACUF32
Usage Numbers for File 11 : ACC Users .. 1 EXU Users ..
(EMPLOYEES) UPD Users .. 1 UTI Users ..
-- USERS --
M I TID/User I SECUID I Jobname I ETID I Open Mode
-----------------------------------------------------------
I USAXXX 2 I I ZCOMPLET I I UPD ACC
I I I I I
I I I I I
I I I I I
I I I I I
I I I I I
I I I I I
I I I I I
I I I I I
I I I I I
Mark entry with a 'S' to select a User
Total Users for file: 2 Showing only 1 Page 1 of 1
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh + Menu
|
Selecting (option ) on the menu displays the use of major Adabas pools and queues. It shows the size of each pool or queue as well as the highest amount or the pool or queue used and the current amount in use.
Note:
The Replication Pool may appear as "Replication
N/A" on this screen if the database is not an Event Replicator Server or if
replication is not activated for the database.
The HW Used column and the %Used column following it show the highest size (in bytes) and highest percentage of the pool or queue reached in the current session. These counters may be doubleword fields. They are shown as nine digits with an optional multipler letter: "k" (1000), "M" (1000000), "G" (1000000000), and "T" (1000000000000), representing consecutive powers of 1000.
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.
The equivalent direct command is:
DISPLAY HWM
A multiple-screen report appears.
18:38:32 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - High Watermarks - PACUH22
NucID: 1021
Sel Pool / Queue I Size I HW Used %Used I Current %Used
------------------------------------------------------------------------------
_ Attached Buffer(NAB) I 409600 I 33536 8.1 I 0 0.0
_ Command Queue (NC) I 3840 I 192 5.0 I 192 5.0
_ Unique DE Pool (DUQ) I 50000 I 0 0.0 I 0 0.0
_ Format Pool (LFP) I 150000 I 8416 5.6 I 8416 5.6
_ Hold Queue (NH) I 41600 I 0 0.0 I 0 0.0
_ PLOG Prot buf(NPLOGB) I 1 I 1 100.0 I 0 0.0
_ Redo Pool (LRDP) I 80000 I 28 0.0 I 0 0.0
_ Replication Pool(LRP) I 100000 I 0 0.0 I 0 0.0
_ Security Pool (LCP) I 10000 I 0 0.0 I 0 0.0
_ ISN List Tab (LI) I 360000 I 0 0.0 I 0 0.0
_ Seq. Cmd. Table(LQ) I 20000 I 508 2.5 I 0 2.5
_ User Queue (NU) I 74256 I 1820 2.4 I 1456 1.9
_ UQ File List (UQF) I 19584 I 216 1.1 I 144 0.7
Page 1 of 2
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh + Menu |
18:38:32 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - High Watermarks - PACUH22
NucID: 1021
Sel Pool / Queue I Size I HW Used %Used I Current %Used
------------------------------------------------------------------------------
_ Work Prt1 Prot bf(NW) I 1 I 1 100.0 I 0 0.0
_ Work Pool (LWP) I 1500000 I 62788 4.1 I 8016 0.5
_ Work Part 1 (LP) I 1000 I 1 0.1 I 0 0.0
_ Work Part 2 (LWKP2) I 158 I 0 0.0 I 0 0.0
_ Work Part 3 (WORKPT3) I 6932 I 0 0.0 I 0 0.0
_ ATM Trans. IDs (XID) I 0 I 0 0.0 I 0 0.0
I I I
I I I
I I I
I I I
I I I
I I I
I I I
Page 2 of 2
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh - Menu |
You can select each line to see the full values of the pool or queue, since only nine digits can be displayed. Simply enter an "s" to the left of the pool or queue and a popup window appears showing you the full values for that pool or queue. The following sample shows detailed high-water statistics for the hold queue.
Note:
You can select more than one pool or queue at a time;
multiple popup windows will appear in sequence (you only need to press any key
to move to the next one). When all the popups have been displayed once, you are
returned to the High Water Marks selection
screen.
Selected pool / queue .. Hold Queue(NH)
Available ............. 41,600
High watermark ........ 0
High watermark % used . 0.0
High watermark date ... 2014-04-30
High watermark time ... 14:06:52
Current used .......... 0
Current % used ........ 0.0
Press any key
|
The time and date values on this popup window show you when the highest value was reached. Values may be zero when the pool/queue is not used. For the attached buffer pool, no time and date value are given. Also, note that Work part 3 values show the leftover amounts after the Work allocation of Work parts 1 and 2.
Selecting (option ) on the menu displays the length of the used and unused parts of the work pool as well as the length of the longest single unused part. These numbers can be used to tune the work pool length for the next session.
The equivalent direct command is:
DISPLAY LWPUSAGE
18:40:38 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - Workpool Usage - PACUL02
NUCID 1021
Workpool (LWP)
Used part ............ 8016 Bytes
Unused part .......... 1481312 Bytes
Biggest unused part .. 1480336 Bytes
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
Selecting (option )on the menu is the equivalent of entering the DNFV operator command. The following display appears:
18:41:18 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - Nucleus File Status - PACUN02
NucID 1021
Locking
File NucID Access count Update count State
----- ----- ------------- ------------- ----------------------
11 0 0 Access
12 0 0 Access
19 0 0 Access
Last page
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9------- PF12-----
Help Repos Exit Refresh - + Menu |
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, the Locking NucID column for the file shows the ID of the nucleus that has exclusive control.
The Access count and Update count columns display the number of access or 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 the "R" option or are using the file in an as yet incomplete transaction.
The State column indicates when the file is used for access only or for access and update. It 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.
Selecting (option ) on the menu displays the status of dual protection logs, if used.
The equivalent direct command is:
DISPLAY PLOGSTATUS
18:41:52 ***** A D A B A S BASIC SERVICES ***** 2014-04-30
DBID 1955 - PLOG Status - PACUP02
NucID: 1021
The nucleus is currently writing on ............ PLOGR1
Size of one PLOG area (in BLKs.) ............... 240
Last block written ............................. 46 ( 19 %)
Number of switches since nucleus start ......... 0
Date/Time of last switch ....................... 0000-00-00 00:00:00
Number of switches due to coordinated switch.... 0
Number of writes forced by the merge process.... 0
Number of switch requests before threshold met.. 0
Threshold setting .............................. 75%
Number of PLOGs ................................ 2
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh PrevNuc NextNuc Menu
Û 02,001 |
Selecting (option ) on the menu displays I/O counts for the ASSO, DATA, WORK, and PLOG data sets; remote and local call distribution; and other current session status information.
The equivalent direct command is:
DISPLAY SYSTEMSTATUS
The values shown on this screen are shown in compressed form. Each can display as a nine-digit value, with appropriate multiplier letters "k" (1000), "M" (1000000), "G" (1000000000), and "T" (1000000000000) (representing consecutive powers of 1000) if necessary. On any of these screens, you can press PF9 to see the actual values (without the multipliers) of the counters on the screens. In this view (full view), there are fewer statistics on each screen, so there are more screens to page through. To return to compressed view, just press PF9 again.
If the value of a counter on these screens ever exceeds the space available for the statistic, the statistic will display in red.
Note:
The values on the sample screens in this section have been
artificially enhanced.
21:07:32 ***** A D A B A S BASIC SERVICES ***** 2016-12-05
DBID 1955 - System Status - PACUS12
NucID: 1021
Physical Reads Writes Call Distribution
----------------------------- ---------------------------------------
ASSO 997 7 No. of HQEs active ......... 0
DATA 287 0 No. of UQEs in User Queue .. 2
WORK 2 3 No. of CQEs waiting in CQ .. 0
PLOG 15 3 No. of PLOG switches ....... 0
CLOG 19 2 No. of CLOGs ............... 2
No. of PLOGs ............... 2
PLOG protection blks . 2
PLOG protection I/Os . 2 Format translations ..... 22
PLOG different blks . 2 Format overwrites ....... 0
WORK1 protection blks. 2 Auto-restarts ........... 0
WORK1 protection I/Os. 2 Throw-backs for ISN ..... 0
WORK1 different blks . 1 Throw-backs for Space.... 0
Logical reads ........ 1,482
Buffer efficiency .... 1.1 page 1 of 5
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh + FullView Menu |
Pressing PF8 displays additional system status statistics.
21:07:32 ***** A D A B A S BASIC SERVICES ***** 2016-12-05
DBID 1955 - System Status - PACUS12
NucID: 1021
Call Distribution Commands
------------------------------------ -----------------------------
User sessions ........ 3 Remote ........ 0
Buffer flushes ....... 0 Local ......... 287
Flush phases ......... 0 Internal ...... 18
Blocks flushed ....... 0 Operator ...... 0
Flush I/Os ........... 0 Total ......... 305
Flush Requests Returned Time Elapsed
------------------------------------ ----------------------------------
Immediately .......... 0 Duration .... 0 day, 00:13:51
After logical flush .. 0 Wait-time ... 0 day, 00:13:49
After entire flush ... 2 CPU time .... 0 day, 00:00:00
page 2 of 5
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh - + FullView Menu |
Pressing PF8 again will display an additional screen that indicates if one or more of the following are in progress:
Online database save running;
ADAEND in progress;
Online file save running;
READONLY/UTIONLY transition;
READONLY status;
Update processing suspended;
ET-sync in progress;
UTIONLY status; and
Exclusive-DB-control utility running.
Otherwise, "Adabas operation normal" is displayed.
21:07:32 ***** A D A B A S BASIC SERVICES ***** 2016-12-05
DBID 1955 - System Status - PACUS12
NucID: 1021
Nucleus Status Flags
------------------------------------
Adabas operation normal
page 3 of 5
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh - + FullView Menu |
Note:
The following screens are only visible in a cluster
environment.
21:07:32 ***** A D A B A S BASIC SERVICES ***** 2016-12-05
DBID 1955 - System Status - PACUS12
NucID: 1021
Cluster Nucleus
----------------------------------------
WORK1 publishing blocks .. 0
WORK1 publishing I/Os .... 0
WORK1 publishing waits ... 0
Buffer flush V2 timeouts . 0
page 4 of 5
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh - + FullView Menu |
21:07:32 ***** A D A B A S BASIC SERVICES ***** 2016-12-05
DBID 1955 - System Status - PACUS12
NucID: 1021 Cluster WORK I/O Statistics
NucID Read I/Os Write I/Os Nucid Read I/Os Write I/Os
----- ------------- ------------- ----- ------------- -------------
1021 1 0
page 5 of 5
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh - FullView Menu |
Selecting (option ) on the menu displays a table of all defined Adabas threads, the status of each, the command type currently in process in each active thread, and the number of commands processed by each thread in the current session.
The equivalent direct command is:
DISPLAY THREADUSAGE
The values shown on this screen are shown in compressed form. Each can display as a nine-digit value, with appropriate multiplier letters "k" (1000), "M" (1000000), "G" (1000000000), and "T" (1000000000000) (representing consecutive powers of 1000) if necessary.
If the value of a counter on these screens ever exceeds the space available for the statistic, a greater than symbol (>) appears as the multiplier letter.
20:59:55 ***** A D A B A S BASIC SERVICES ***** 2015-05-01
DBID 1955 - Thread Usage - PACUT12
NucID: 1021
Nr. I Thread Status I Command Type I Wait Event I Nr. CMDs
-----------------------------------------------------------------------------
1 I Active I Simple Cmd. I I 6,576
2 I Not active I I I 103
3 I Not active I I I 71,981,983 K
4 I Not active I I I 5,792,340 M
5 I Not active I I I 8,462,628 M
6 I Not active I I I 0
7 I Not active I I I 16,777,215 T
8 I Not active I I I 16,777,215 >
9 I Not active I I I 0
10 I Not active I I I 0
11 I Not active I I I 0
12 I Not active I I I 0
13 I Not active I I I 0
14 I Not active I I I 0
15 I Not active I I I 0
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF9----- PF12-----
Help Exit Refresh Fullview Menu |
Press the Enter key to scroll through the Thread Usage screens.
You can press PF9 to see the actual values (without the multipliers) of the counters. A pop-up window appears showing the actual values aligned to the right. To return to compressed view, just press Enter again.
Thr Command Counts
1 6,576
2 103
3 73,709,551,615
4 6,073,709,551,615
5 8,873,709,551,615
6 0
7 18,446,744,073,709,551,614
8 18,446,744,073,709,551,614
9 0
10 0
11 0
12 0
13 0
14 0
15 0
Enter-
Continue
|
Selecting (option ) on the menu displays a table of the read and write I/Os performed by volume serial number on the I/O by Volser screen. It also shows the highest RABN on each volume.
The equivalent direct command is:
DISPLAY IOVOLSER
The I/O counts shown on this screen are shown in compressed form. Each can display as a nine-digit value, with appropriate multiplier letters "k" (1000), "M" (1000000), "G" (1000000000), and "T" (1000000000000), representing consecutive powers of 1000, if necessary.
16:07:17 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
DBID 1955 - I/O by Volser - PACUV02
NucID 1021
Volser Type I Read I/Os I Write I/Os I Highest RABN
--------------------------------------------------------------
SMSZ11 ASSO I 2,583 I 202 I 53,982
SMSZ11 DATA I 2,854 I 65 I 89,989
I I I
I I I
I I I
I I I
I I I
I I I
I I I
I I I
I I I
I I I
I I I
I I I
I I I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF9----- PF12-----
Help Exit Refresh Fullview Menu |
Press the Enter key to scroll through the I/O by Volser screens.
You can press PF9 to see the actual I/O counts (without the multipliers). A pop-up window appears showing the actual values aligned to the right. To return to compressed view, just press Enter again.
Read I/O Write I/O
2,583 202
2,854 65
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
__________________________ __________________________
Enter-
Continue
|
Selecting (option ) on the menu displays the Work area sizes (in blocks) for the:
data protection area (Work part 1; ADARUN LP parameter);
work part 1B (Work part 1B; ADARUN CLUWORK1CACHE parameter);
area used for intermediate ISN lists (Work part 2; ADARUN LWKP2 parameter);
area used for resulting ISN lists (Work part 3);
The equivalent direct command is:
DISPLAY WORKSTATUS
21:01:15 ***** A D A B A S BASIC SERVICES ***** 2016-12-05
DBID 1955 - WORK Status - PACUW02
NucID 1021
W O R K Dataset
+--------------------------------------------------------+
I Protection Area 1000 Blks I
I--------------------------------------------------------I
I Work Part 1B (CLUWORK1CACHE) 0 Blks I
I--------------------------------------------------------I
I Intermediate ISN Area 176 Blks I
I--------------------------------------------------------I
I Resulting ISN Area 9614 Blks I
I--------------------------------------------------------+
I Distributed Transaction Processing Area 0 Blks I
+--------------------------------------------------------+
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Menu |
If you have DTP=RM in your ADARUN parameter settings, and press PF4 on the new screen, then the new screen DTP Work Area displays (shown below):
16:08:09 ***** A D A B A S BASIC SERVICES ***** 2014-05-01
- DTP Work Area - PACUK02
Code Service
---- --------------------------------------
D Display PET-status users
H Display heuristically terminated users
R Display DTP rabns
U Work Part 4 usage
X Force heuristic BT/ET
? Help
. Exit
---- --------------------------------------
Code ............. _
Selected User ....
Database ID ...... 1955 (WIS1955)
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Clear UID Exit Menu |
The DTP Work Area menu performs the following functions:
| Option | Function | Action |
|---|---|---|
| D | Display PET-status users | Displays the current environment of PET-status users. You can select one or more to display additional information. |
| H | Display heuristically terminated users | Displays a list of the heuristically terminated users. You can select one or more to display additional information. |
| R | Display DTP Rabns | Displays a list of allocated RABNs. You can select a user, display additional information, issue BT or ET, and display total RABNs for a user. |
| U | Work Part 4 Usage | Displays the breakdown of information of the Work Part 4. |
| X | Force Heuristic BT/ET | Issues a BT or ET for a selected user. Select the user through the "Display DTP RABNs" menu item. |
| --- | PF2 | Clears the selected user. |
If you select Display PET-status users, the screen Display PET-Status Users displays (shown below):
16:08:09 ***** A D A B A S BASIC SERVICES ***** 2014-05-01 DBID 1955 - Display PET-Status Users - PACUKD2 Mark entries with 'D' (Display): M I Global ID I RMID hex I ------------------------------------------------------------ - -------- - _ I 000F710020640000B96353B18528B38200000000B96353B185286F02 I 044E0059 I _ I I I _ I I I _ I I I _ I I I _ I I I _ I I I _ I I I _ I I I _ I I I PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12----- Help Exit Refresh - + Menu |
Selecting (option ) on the menu displays the PPT. The labels and corresponding data set names are listed.
The equivalent direct command is:
DISPLAY PPT
16:40:12 ***** A D A B A S BASIC SERVICES ***** 2014-05-05
DBID 1955 - Display PPT - MACA022
NucID .. 1021 Active Nucleus, PLOG(s) not copied, CLOG(s) not copied
Image .. ZHST All Sysplex Services Active
Label Name Dataset Name
---------- ----------------------------------------
WORK1 RD.USAWIS.DB1955.WORKR1
PLOGR1 RD.USAWIS.DB1955.PLOGR1
PLOGR2 RD.USAWIS.DB1955.PLOGR2
CLOGR1 RD.USAWIS.DB1955.CLOGR1
CLOGR2 RD.USAWIS.DB1955.CLOGR2
PF1----- PF3------ PF4------ PF6------ PF7----- PF8----- PF9----- PF12-----
Help Exit Refresh PrevPPT NextPPT Menu |
Use the PF6 and PF9 fields to scroll between the PPTs.
The Replicator management screens are only visible if the Event Replicator for Adabas is installed and active. If the option on the menu is not highlighted, the Event Replicator is not installed and this option cannot be selected. For more detailed information concerning Replicator Management screens, refer to the Event Replicator for Adabas documentation.
Selecting (option ) on the menu displays the menu:
18:06:16 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
- Session Utilization - PACW002
Code Service
---- -------------------------------
C Command usage
F File usage
H High watermarks (pools/queues)
S System status
T Thread usage
? Help
. Exit
---- -------------------------------
Code ......... _
File Number .. 0
Database ID .. 1955 (WIS1955) NucID .. 1021
Command ==>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit Menu |
This menu provides access to command usage, file usage, high watermark, system status, and thread usage statistics for the ongoing session. If you elected to refresh these statistics during your Adabas session, the numbers presented in this area of Adabas Online System may be different than the interval statistics. Otherwise, they should be identical. For examples of the session utilization statistics that are collected and displayed, read the following sections:
Selecting (option ) on the menu allows you to review command usage statistics for the ongoing session. The Session Command Usage screen displays.
18:06:37 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1955 - Session Command Usage - PACWC22
NucID 1021
Total Commands .. 3,058
CMD-Type I Nr. CMDs I Aver. Dur. CMD-Type I Nr. CMDs I Aver. Dur.
------------------------------------- -------------------------------------
A1/4 I 0 I BT I 0 I
CL I 15 I 4.565 C1 I 0 I
C3 I 0 I C5 I 0 I
ET I 0 I E1/4 I 0 I
HI I 0 I LF I 0 I
L1/4 I 0 I L2/5 I 0 I
L3/6 I 1,000 I 5.272 L9 I 180 I 1.201
N1/2 I 0 I OP I 20 I 10.017
RC I 710 I 0.010 RE I 0 I
REST I 500 I RI I 0 I
S1/4 I 549 I 6.185 S2 I 0 I
(Aver. Dur. - units of milliseconds) Page 1 of 2
PF1----- PF2------ PF3------ PF4------ PF7----- PF8----- PF9----- PF12-----
Help Exit Refresh + Fullview Menu |
This screen shows the number of times a command was issued during the session and the average duration of each command. The statistics are displayed in two sets of repeated columns, unless you press the PF9 key, when they are displayed in longer form.
You can scroll forward and backward between the screens of command statistics using the PF8 (forward) and PF7 (backward) keys.
Selecting (option ) on the menu allows you to review file usage statistics for the ongoing session. The Session File Usage screen displays.
18:09:29 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1955 - Session File Usage - PACWF42
Nucid: 1021
Fnr Tot. Cmds I Fnr Tot. Cmds I
---------------------------------- ----------------------------------
0 1,343 I 11 1,747 I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Repos Exit Refresh -- Menu |
This screen shows the number of commands issued against a file during the session.
You can scroll forward and backward between the screens of file statistics using the PF8 (forward) and PF7 (backward) keys.
Selecting (option ) on the menu allows you to review high watermark (pool and queue) statistics for the ongoing session. The Session High Watermarks screens display.
18:09:55 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1955 - Session High Watermarks - PACWH22
NucID: 1021
Sel Pool / Queue I Size I HW Used %Used I Current %Used
------------------------------------------------------------------------------
_ Attached Buffer(NAB) I 409600 I 32768 8.0 I 0 0.0
_ Command Queue (NC) I 3840 I 192 5.0 I 192 5.0
_ Unique DE Pool (DUQ) I 50000 I 0 0.0 I 0 0.0
_ Format Pool (LFP) I 150000 I 0 0.0 I 6528 4.3
_ Hold Queue (NH) I 41600 I 0 0.0 I 0 0.0
_ PLOG Prot buf(NPLOGB) I 1 I 1 100.0 I 0 0.0
_ Redo Pool (LRDP) I 80000 I 28 0.0 I 0 0.0
_ Replication Pool(LRP) I 100000 I 0 0.0 I 0 0.0
_ Security Pool (LCP) I 10000 I 0 0.0 I 0 0.0
_ ISN List Tab (LI) I 360000 I 0 0.0 I 0 0.0
_ Seq. Cmd. Table(LQ) I 20000 I 0 0.0 I 0 0.0
_ User Queue (NU) I 74256 I 1820 2.4 I 1456 1.9
_ UQ File List (UQF) I 19584 I 216 1.1 I 144 0.7
Page 1 of 2
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh + Menu |
20:54:19 ***** A D A B A S BASIC SERVICES ***** 2016-12-05
DBID 1955 - Session High Watermarks - PACUH22
NucID: 1021
Sel Pool / Queue I Size I HW Used %Used I Current %Used
------------------------------------------------------------------------------
_ Work Prt1 Prot bf(NW) I 1 I 1 100.0 I 0 0.0
_ Work Pool (LWP) I 1500000 I 53364 3.5 I 0 0.0
_ Work Part 1 (LP) I 1000 I 1 0.1 I 0 0.0
_ Work Part 2 (LWKP2) I 176 I 0 0.0 I 0 0.0
_ Work Part 3 (WORKPT3) I 9614 I 0 0.0 I 0 0.0
_ ATM Trans. IDs (XID) I 0 I 0 0.0 I 0 0.0
_ Work Part 1B(CLUWOR.) I 0 I 0 0.0 I 0 0.0
I I I
I I I
I I I
I I I
I I I
I I I
Page 2 of 2
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh - Menu |
This screen shows the size, amount used, percentage used, current usage, and current percentage used of each pool, queue, and Work part. T
You can scroll forward and backward between the screens of high watermark statistics using the PF8 (forward) and PF7 (backward) keys.
Selecting (option ) on the menu allows you to review system status usage statistics for the ongoing session. The Session System Status screens display.
18:10:32 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1955 - Session System Status - PACWS12
NucID: 1021
Physical Reads Writes Call Distribution
----------------------------- ---------------------------------------
ASSO 1,310 28 No. of HQEs active ......... 0
DATA 2,025 7 No. of UQEs in User Queue .. 1
WORK 2 33 No. of CQEs waiting in CQ .. 0
PLOG 6 24 No. of PLOG switches ....... 0
CLOG 20 4 No. of CLOGs ............... 2
No. of PLOGs ............... 2
PLOG protection blks . 23
PLOG protection I/Os . 23 Format translations ..... 39
WORK1 protection blks. 33 Format overwrites ....... 0
WORK1 protection I/Os. 33 Auto-restarts ........... 0
Throw-backs for ISN ..... 0
Logical reads ........ 12,292 Throw-backs for Space.... 0
Buffer efficiency .... 3.6
page 1 of 3
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh + FullView Menu |
18:10:32 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1955 - Session System Status - PACWS12
NucID: 1021
Call Distribution Commands
------------------------------------ -----------------------------
User sessions ........ 25 Remote ........ 0
Buffer flushes ....... 7 Local ......... 2,612
Flush phases ......... 7 Internal ...... 505
Blocks flushed ....... 28 Operator ...... 0
Flush I/Os ........... 28 Total ......... 3,117
Flush Requests Returned Time Elapsed
------------------------------------ ----------------------------------
Immediately .......... 0 Duration .... 0 day, 07:29:54
After logical flush .. 0 Wait-time ... 0 day, 07:29:52
After entire flush ... 9 CPU time .... 0 day, 00:00:04
page 2 of 3
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh - + FullView Menu
Û 02,001 |
18:10:32 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1955 - Session System Status - PACWS12
NucID: 1021
Nucleus Status Flags
------------------------------------
Adabas operation normal
page 3 of 3
PF1---- PF2---- PF3----- PF4----- PF6----- PF7----- PF8----- PF9----- PF12----
Help Exit Refresh - FullView Menu |
These screens show various system statistics for the session and span three screens, with statistics on some of the screens displayed in two sets of repeated columns. If you press the PF9 key, they are displayed in a single column,
You can scroll forward and backward between the screens of system status statistics using the PF8 (forward) and PF7 (backward) keys.
Selecting (option ) on the menu allows you to review thread usage statistics for the ongoing session. The Session Thread Usage screens display.
18:12:54 ***** A D A B A S BASIC SERVICES ***** 2014-06-30
DBID 1955 - Session Thread Usage - PACWT12
NucID 1021
Nr. I Thread Status I Command Type I Wait Event I Nr. CMDs
-----------------------------------------------------------------------------
1 I Active I Simple Cmd. I I 3,155
2 I Not active I I I 6
3 I Not active I I I 0
4 I Not active I I I 0
5 I Not active I I I 0
6 I Not active I I I 0
7 I Not active I I I 0
8 I Not active I I I 0
9 I Not active I I I 0
10 I Not active I I I 0
11 I Not active I I I 0
12 I Not active I I I 0
13 I Not active I I I 0
14 I Not active I I I 0
15 I Not active I I I 0
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF9----- PF12-----
Help Exit Refresh Fullview Menu |
This screen shows the threads in numerical order and indicates the thread status, command type, wait event, and number of commands processed by the thread in the session. To see a smaller, more summarized view of the thread usage statistics, press the PF9 key. A popup window appears listing only the thread number and number of commands processed by the thread in the session.
Press ENTER to see the next screen of threads. When you press ENTER on the last screen, the menu appears again.
Note:
This option is only active in an Adabas nucleus cluster
environment.
Selecting (option ) on the menu displays nucleus cluster statistics that are equivalent to those displayed using the DXCACHE, DXLOCK, and DXFILE operator commands. These statistics are made available through selections on the menu. For more information, read the Adabas Cluster Services or Adabas Parallel Services documentation.
The equivalent direct command is:
DISPLAY CLUSTERSTATUS
14:05:08 ***** A D A B A S BASIC SERVICES ***** 2014-06-19
- Cluster Usage - PACUX02
Code Service
---- ------------------
C Cache statistics
F File statistics
L Lock statistics
M Message statistics
? Help
. Exit
---- ------------------
Code ......... _
File Number .. 0
Database ID .. 1955 (WIS1955) NucID .. 1021
Command ==>
PF1----- PF2----- PF3------ PF4------ PF6----- PF9----- PF10----- PF12-----
Help NextNuc Exit Fuse Flist Menu
|
This section covers the following topics:
Choosing Cache Statistics (option ) on the menu displays the menu:
10:47:57 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
- Cache Statistics - PACUX12
Code Service
---- -----------------------
K Cast-out / Directory
P Publishing requests
X Individual cache blocks
. Exit
? Help
---- -----------------------
Code ......... _
Database ID .. 1955 (WIS1955) NucID .. 1021
PF1----- PF2----- PF3----- PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu |
On all subscreens of cache statistics, displayed counters may include a unit code, with the following possible values:
| Unit Code | The total shown is in . . . |
|---|---|
| blank | bytes |
| k | 1000 bytes |
| M | 1,000,000 bytes |
| G | 1,000,000,000 bytes |
| T | 1,000,000,000,000 bytes |
If a value has a unit code shown, it has been divided by the unit measurement to convert it to bytes, showing the significant digits to nine places with no decimal point.
Press PF9 to see the entire value. This value is the exact count up to 20 digits in length.
Choosing (option ) on the menu display the following:
10:47:57 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Cast-out / Directory - PACUX12
NucID 1021
Cast-out Directory Reads Directory Reads
--------------------------- ---------------------------
Total ....... 170 Total ....... 1
Sync ..... 107 Sync ..... 0
Async .... 63 Async .... 1
Unlock Cast-out Calls
---------------------------
Total ....... 85
Sync ..... 0
Async .... 85
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9------- PF12-----
Help Exit Refresh Detail Menu |
Choosing (option ) on the menu displays the following:
10:49:46 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Publishing Requests - PACUX12
NucID 1021
Publishing Request Category
---------------------------------
Update sync ....... 85
BT or CL or ET .... 2
Redo threshold .... 0
Full bufferpool ... 0
All blocks ........ 86
Specific RABN ..... 0
File DS blocks .... 0
All DSST blocks ... 85
File NI blocks .... 0
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9------- PF12-----
Help Exit Refresh Detail Menu |
Choosing (option ) on the menu displays the following:
10:50:17 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - All Cache Blocks - PACUX12
NucID 1021
Reads Writes
-------------------------------- ----------------------------------
Total ............ 6,378 Total .............. 347
Sync .......... 963 Sync ............ 153
Async ......... 5,415 Async ........... 194
In cache ...... 85 Written ......... 347
Not in cache .. 6,293 Not written ..... 0
Struc. full ... 0 Struc. full ..... 0
Cast-out Reads Other
-------------------------------- ----------------------------------
Total ............ 340 Validates .......... 37,896
Sync .......... 340 Invalid ......... 0
Async ......... 0 Deletes ............ 0
Timeouts ........ 0
Redo processes ..... 0
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9------- PF12-----
Help Repos Exit Refresh PrevBlk NxtBlk Detail Menu |
Use PF7 and PF8 to scroll through the cache blocks; use PF2 to reposition.
Statistics are displayed for the following:
All cache blocks;
Address converter (AC ) cache blocks;
Data Storage (DS) cache blocks;
Data Storage space table (DSST) cache blocks;
File control block (FCB) cache blocks;
Normal index (NI) cache blocks;
Upper index (UI) cache blocks.
Work cache blocks.
Choosing (option ) on the menu for file 25 displays the following screen:
10:51:09 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - File 12 Statistics - PACUX22
NucID 1021
Reads Writes
-------------------------------- ----------------------------------
Total ............ 86 Total .............. 0
Sync .......... 4 Sync ............ 0
Async ......... 82 Async ........... 0
In cache ...... 0 Written ......... 0
Not in cache .. 86 Not written ..... 0
Struc. full ... 0 Struc. full ..... 0
Cast-out Reads Other
-------------------------------- ----------------------------------
Total ............ 0 Validates .......... 1,502
Sync .......... 0 Invalid ......... 0
Async ......... 0 Deletes ............ 0
Timeouts ........ 0
Redo processes ..... 0
PF1----- PF2----- PF3----- PF4----- PF7----- PF8----- PF9------- PF12-----
Help Repos Exit Refresh Detail Menu |
Choosing (option ) on the menu displays the menu:
10:51:28 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
- Lock Statistics - PACUX39
Code Service Code Service Code Service
---- ------------------ ---- ------------------ ---- ------------------
A Buffer flush L Global ET sync W Replicat handshake
B Cancel M Glbl upd cmd sync X Security
C Checkpoint N Hold ISN Y Spats
D Container O LOB tracker Z Unique descriptor
E Delta Save (DSF) P Net-wrk DBID asgmt 1 User
F Distributed tranID Q New-Data-RABN 2 Wkpt4 RABN index
G ETID R Online save 3 Wkpt4 PET user tbl
H File-lock-table S Parameter . Exit
I Format-addr-conver T Record read ? Help
J Free space table U Recovery (online)
K GCB V Recovery log(RLOG)
---- ------------------ ---- ------------------ ---- ------------------
Code ......... _
Database ID .. 1955 (WIS1955) NucID .. 1021
PF1----- PF2----- PF3------ PF4------ PF6----- PF7------ PF8----- PF12-----
Help Exit Refresh Menu |
Each of the options on the menu displays statistics for a particular lock. For each lock, the screen displays obtain-and-release information about the various types of that lock that are currently in use by a cluster nucleus:
The system may obtain locks conditionally or unconditionally, synchronously or asynchronously. A conditional request for a lock may be granted or rejected.
Releases may be issued synchronously or asynchronously.
The system may alter locks conditionally or unconditionally, synchronously or asynchronously, A conditional request to alter a lock may be granted or rejected. An unconditional request to alter a lock may be deadlocked and rejected.
For example, choosing (option ) on the menu displays the Hold ISN Lock screen:
10:51:28 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Hold ISN Lock - PACUX39
NucID 1021
Obtains Alters
------------------------------ ------------------------------------
Conditional .... 86 Conditional .......... 0
Granted ..... 86 Granted ............ 0
Rejected .... 0 Rejected ........... 0
Unconditional .. 0 Unconditional ........ 0
Rejected-deadlock .. 0
Sync ........... 3
Async .......... 83 Sync ................. 0
Async ................ 0
Releases
------------------------------
Issued ......... 86
Sync ........ 8
Async ....... 78
PF1----- PF2----- PF3------ PF4------ PF6----- PF7------ PF8----- PF12-----
Help Repos Exit Refresh PrevLok NxtLok Menu |
Use PF7 and PF8 to scroll through the lock displays; use PF2 to reposition to a different lock display.
Choosing Mesage Statistics (option ) on the menu displays the screens. There are two message statistics screens; use PF8 and PF7 scroll forward and backward between them.
Note:
These screens display the same information you would see if
you entered the Adabas DXMSG command.
14:08:50 ***** A D A B A S BASIC SERVICES ***** 2014-06-19
DBid 1955 - Message Statistics - PACUX50
Nucid 1021
Message Control Block Statistics Statistics for ACMD-type messages
------------------------------------ ----------------------------------
Allocated .......... 25,094 Messages sent ...... 183,378
Used ............... 4 Messages arrived ... 146,411
Total .............. 329,789 Messages accepted .. 146,411
Replies sent ....... 146,358
Number of message type areas ... 1
Number of transport areas ...... 1 Page 1 of 2
PF1----- PF2----- PF3----- PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit + Menu
|
14:13:55 ***** A D A B A S BASIC SERVICES ***** 2014-06-19
DBid 1955 - Message Statistics - PACUX50
Nucid 1021 Statistics for SMM transport messages
Msgs subject MXMSG Msgs not subj. MXMSG Total all Msgs
------------------ ------------------ ------------------
Minimum .. 0.000011 0.000011 0.000011
Maximum .. 12.807110 53.605695 53.605695
Mean ..... 0.021852 0.069410 0.033985
Std Dev .. 0.227699 1.436602 0.194475
Msg Count 4,292 1,470 5,762
> 1000 s 0% 0 0% 0 0% 0
> 100 s 0% 0 0% 0 0% 0
> 10 s 0% 1 0% 1 0% 2
> 1 s 0% 3 0% 3 0% 6
> 100 ms 2% 81 1% 21 2% 102
> 10 ms 24% 1,015 33% 483 26% 1,498
> 1 ms 22% 942 11% 168 19% 1,110
> 100 us 33% 1,418 37% 549 34% 1,967
<= 100 us 19% 832 17% 245 19% 1,077
Page 2 of 2
PF1----- PF2----- PF3----- PF4------ PF6----- PF7----- PF8----- PF12-----
Help NextNuc Exit + Menu
|
Note:
This function is only available for Adabas version 8 or above
databases.
Selecting (option ) on the menu displays information about the Adabas nucleus modules:
10:52:25 ***** A D A B A S BASIC SERVICES ***** 2014-05-02
DBID 1955 - Display Maintenance Levels - PACZ002
NucID .. 1021
Select Module Name: ________
-----------------------------------------------------------------------------
ADARUN RUNMVS Date 2013-09-17, Version 8.3, SP 8
RUNIND Date 2014-03-21, Version 8.3, SP 8
ADANCX Date 2014-04-21, Version 8.3, SP 8
ADAXCF Date 2012-04-19, Version 8.3, SP 8
ADAXEC Date 2012-10-11, Version 8.3, SP 8
ADAXEL Date 2013-10-21, Version 8.3, SP 8
ADACLU Date 2014-04-15, Version 8.3, SP 8
ADAMXI Date 2013-12-10, Version 8.3, SP 8
ADAMIM Date 2014-03-21, Version 8.3, SP 8
ADARVU Date 2014-03-21, Version 8.3, SP 8
ADACLX Date 2013-12-30, Version 8.3, SP 8
ADARMT Date 2014-03-19, Version 8.3, SP 8
Command ===>
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit -- - + Menu |
Maintenance levels for each module are displayed. Any zaps that are applied to the module are also listed.
The list of modules can be limited by entering a specific module name in the Select Module Name field at the top of the screen. An asterisk (*) can also be used as a wildcard value in this field. For example, specifying "ADARUN" displays information for the ADARUN module only. Specifying "ADAR*" lists all modules with names that begin with "ADAR", which would include ADARUN as well as ADARVU and other modules.