User monitor

You can use this function to view the different Adonix tasks in progress on the server. The current process server tasks are displayed by default, but any server accessible via the network that has a software connection process with the same service number can be accessed.

Prerequisites

See also Refer to documentation Implementation

Screen management

This function displays as a single screen without a left list.

Entry screen

This function displays the connection characteristics for the default server. If you want to view the connections on another server, it is necessary to give its name. It is possible to view it if the service number is the same as the remote server.

The three following sections are on this screen.

Open sessions

This first section contains a grid named Open sessions which displays the characteristics of the Adonix tasks in progress:

Active processes

The grid present in the second section displays, when the user selects a specific line in the upper grid (Open sessions), the active processes managed for the session. These processes are:

These processes can have the following types:

In addition to the process number (UNIX or NT depending on the case), the server name on which the process is running is also visible.
It can be:

By right-click, there is access from each table row, to the Process stop function. You can use this function to stop the corresponding process (by kill under UNIX or using the killadx function under NT). From a database angle, stopping a process involves the actual stopping of the transaction in progress but also losing data in the process of being entered. Be very careful when using this function. Use it for the resolution of operational incidents. The user's rights to carry out this type of function depend on the characteristics of the user connection. If users want to stop tasks that they have not launched themselves, they must connect as a super user (root in the case of UNIX).

Total sessions

This section displays the number of active sessions by session types (primary, secondary, batch, ADAPI) with a global total. In addition, after each session type, the total number of connections authorized by type is displayed.

Field descriptions

Block number 1

This field indicates the number of open sessions.

Machine (field SERVEUR)

Define the process server on which the processes are viewed. By default, the server that is proposed when starting the function is the current application server.
License (field LICENCE)

This field defines the license number assigned by Sage for the installation. This license number is unique. It is associated with:

  • A group of authorizations (number of sessions, options, etc.)
  • Two series of texts identifying:
    • The user client for the license
    • The partner that has implemented the solution

The license display function allows you to view all this information.
Total sessions (field NBTOTSES)
CPU time (field CPUFLG)

Select this check box to display the CPU time used by the Adonix process in the Open sessions grid.

Grid Open sessions

This field displays the IP address of the web client.

Client (field CLIENT)

This field defines the network name of the workstation used to establish the connection for the session. This network name can be:

  • The client workstation connected to the client-server
  • The web server that makes the connection between the web browser and the server
  • The BATCH keyword, in the case where the process is a batch task and has no associated client
  • The web server on which the terminal or web server operates
Type (field TYP)

This field defines the connection type:

  • Batch
  • Primary
  • Secondary
  • ADAPI
Web client (field IPCLI)
Login (field USER)

This field defines the user code (in the software sense) under which the session has been opened.
Folder (field DOSSIER)

The Ident1 and Ident2 fields are unique identifiers managed by the Adonix engine for the user connection. The first is unique for a given folder. It corresponds with the result of the evaluation of the adxuid(1) function. The APLLCK file (this is the LCKPID field) also uses it.

The second is unique for a given server and service number. It corresponds with the result of the evaluation of the adxuid(2) function.
Module (field MODULE)

This field defines the module to which the function that is being executed is attached. The list of modules varies according to the software. It corresponds to the local menu number 14.
Function (field FONCTION)

This field defines the code for the function executed by the connected user. This code corresponds to the value of the GFONCTION variable on the workstation itself.

If the user is connected without being in this function (for example, he is in a menu), this field is empty.

The batch server itself is present as a task called SERVEUR, functioning in BATCH mode on the folder where the name depends on the software but starts in principle with the letters SERV.
System login (field LOGIN)

This field defines the user code (in the system login sense) in which the connected user is known.
Service (field PORT)

This field defines the connection service number. It is the characteristic of the adxd task to which the workstation is attached at the connection request.
Date (field DATCON)

This field defines the date of the start of the connection to the workstation.
UTC time (field HRECON)

This field defines the time of the start of the connection to the workstation.
Date + UTC time (field DATTIME)

This field defines the date and time of the start of the connection to the workstation. This timestamp is in the UTC format.
CPU (field CPU)

This field displays the CPU time used by the Adonix process from its startup. This time is expressed in minutes:seconds.

You need to select the CPU check box in the header of the table.
Session ID (field ID)

The Ident1 and Ident2 fields are unique identifiers managed by the Adonix engine for the user connection. The first is unique for a given folder. It corresponds with the result of the evaluation of the adxuid(1) function. The APLLCK file (this is the LCKPID field) also uses it.

The second is unique for a given server and service number. It corresponds with the result of the evaluation of the adxuid(2) function.
Type (field NATURE)

This field defines the nature of the connection of the current session. It can be internal or external.

Grid Active processes

Process no. (field NUMERO)

For each process associated with the current line session in the upper grid, a unique process number displays here. This number is linked to the server on which this process is executed. It is a process id in the operating system sense, whether UNIX, Linux, or Windows.
Processes (field PROCESS)

This field defines the name of the processes executed on the process server corresponding to the current session in the upper grid. You can find the following information:

  • adonix, which corresponds to the execution engine for the processes
  • sadora, which corresponds to the pilot for the Oracle database session
  • sadoss, which corresponds to the pilot for the SQL database session
  • sadudb, which corresponds to the pilot for the  DB2 UDB database session
  • sadfsq, which corresponds to the process that manages the access to the sequential files
  • sadsys, which corresponds to the process executing the system commands on the server
Machine (field MACHINE)

This field identifies the computers on which each process operates associated with the current session in the upper grid.

It can be one of the network servers. It is often the process server or the application server.

It can also be the client workstation. For example, when writing on the local workstation, a sadfsq process is then open.

Grid Total sessions

This section displays the number of active sessions by session types (primary, secondary, batch, ADAPI) with a global total. In addition, after each session type, the total number of connections authorized by type is displayed.

Session type (field TYPSES)
Type (field TYPINTSES)
Total (field TOTSES)
Action icon
Process stop

By right-click, there is access from each table row, to the Process stop function. You can use this function to stop the corresponding process (by kill under UNIX or using the killadx function under NT). From a database angle, stopping a process involves the actual stopping of the transaction in progress but also losing data in the process of being entered.

Be very careful when using this function. Use it for the resolution of operational incidents. The user's rights to carry out this type of function depend on the characteristics of the user connection. If users want to stop tasks that they have not launched themselves, they must connect as a super user (root in the case of UNIX).

Menu bar

Update

This button, also accessible using the F5 key, is used to refresh the display of the open sessions.

Search

Click this button to search the session using a process where a number is entered. If this process can be attached to a session, the user is positioned on the line in question at the end of the search.

Deletion of inactive sessions

Click this button to delete any inactive sessions from the open sessions grid. A session is inactive when it is no longer connected to the database.

Menu bar

Sort / Folder

This function is used to sort the lines by folder.
Sort / Client

This function is used to sort the lines by client workstation.
Sort / Login

This function is used to sort the lines by connection code.
Sort / System login

This function is used to sort the lines by system connection code.
Sort / Date

This function is used to sort the lines by date.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

xxxx: Server not accessible.

This message can mean that:

This message can display after a long wait time.

Tables used

See also Refer to documentation Implementation