SHOW-USERS

This statement displays active users.

Scope of validity

DBH and SESDCN administration

Function

The SHOW-USERS administration statement displays all currently active users. Active users are those currently working with the DBH or with SESDCN.

If no users are currently active, you receive a message to this effect.

What is displayed in DBH administration differs from what is displayed in SESDCN administration.

In DBH administration, the following information is displayed for each active user:

• user identification
  If the user is an asynchronous UTM application, the conversation number is also displayed. System-generated identifications may also be displayed here, after a restart, for example (see "Identification of system-internal users"). If there is a lock sequence active for the system-internal user, this user is displayed here.

• number of password violations, if any

• user's activity status
  The following activity statuses are possible:

  • 'BLANK' (the request is being processed in a thread)

  • LOCK (the request is locked by another request)

  • FREE (the request is unlocked)

  • PTC (the transaction is at the prepare-to-commit stage)

  • ADM (the user is the system administrator)

  • ADM (the user is the system administrator)

  • CAN (the SQL data-manipulation statement is canceled by means of the CANCEL-STATEMENT administration statement)

  • UTI (utility monitor request)

  • INTERN (internal system transaction)

• string LOCK-SEQ if the user has opened a lock sequence

• number of logical files in CALL DML, if any are used

• number of password violations, if any

In SESDCN administration, the following information is displayed for each active user:

• the user identification
  If the user is an asynchronous UTM application, the conversation number is also displayed.

• the application's mode
  The following modes are possible:

  • UTM (UTM transaction application)

  • DCAM (DCAM transaction application)

  • TIAM (interactive mode)

  • BAT (transaction application in batch mode).

• the time (in hours:minutes) since the beginning of the conversation (ELAPSTIME)

• the name of the computer on which the addressed databases are stored (LOCATION).
  If no database has yet been addressed, the name of the home system appears here.

• the name of the database(s) being accessed by the SESDCN user (CATALOG IN USE).
  If no database has yet been addressed, “NO” appears here.

SHOW-USERS

STRUCTURE-OUTPUT = *NONE / *SYSINF / <structured-name 1..20>(...)
	<structured-name 1..20>(...)
		|	WRITE-MODE = *REPLACE / *EXTEND

Operands

STRUCTURE-OUTPUT = *NONE / *SYSINF / <structured-name 1..20>

(WRITE-MODE = *REPLACE / *EXTEND)

In S procedures, specifies whether the information is to be output in S variables (see section “Syntax for output in S variables”).

Output in S variables (DBH administration)

Output information	Name of the S variable	T	Contents
Host name	var(*LIST).HOST	S	<name 1..8>
Application	var(*LIST).APPLICATION	S	<name 1..8>
User	var(*LIST).CUSTOMER	S	<name 1..8>
Conversation number	var(*LIST).CONVERSATION	S	<x-text 1..8> / '' (void)
Numbering	var(*LIST).NUMBER	S	<integer>
User’s state	var(*LIST).STATE	S	ADM / LOCK / RESET / INTERN / CAN / PTC / FREE / UTI / '' (void)
Display of the lock sequence	var(*LIST).LOCK-SEQUENCE	S	LOCK-SEQ / '' (void)
Number of logical files	var(*LIST).LOGICAL-FILES	S	<integer>
Number of password violations	var(*LIST). PASSWORD-ERRORS	S	<integer>

Output in S variables (DCN administration)

Output information	Name of the S variable	T	Contents
Host name	var(*LIST).HOST	S	<name 1..8>
Application	var(*LIST).APPLICATION	S	<name 1..8>
User	var(*LIST).CUSTOMER	S	<name 1..8>
Conversation number	var(*LIST).CONVERSATION	S	<x-text 1..8> / 0
Number of password violations	var(*LIST). PASSWORD-ERRORS	S	<integer>
User ID (BS2000), job name (DCAM), program unit (UTM)	var(*LIST).USER-NAME	S	<name 1..8>
Mode	var(*LIST).MODE	S	TIAM / DCAM / UTM / BAT
Runtime (hh:mm)	var(*LIST).ELAPSED-TIME	S	<time 5 .. 5>
Location	var(*LIST).LOCATION(*LIST). HOST	S	NO / <name 1..8>
Database name	var(*LIST).LOCATION(*LIST). CATALOG	S	NO / NOT IN DIST. RULE / <filename 1..18>

Example 1

Output to the screen after entering the SHOW-USERS administration statement in DBH administration:

%SHOW-USERS
    1.: D016ZE07TSN=8GPZADMINIST             ADM                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
    2.: D016ZE09TSN=2A2VUSER0005                                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
    3.: D016ZE09TSN=2A2VUSER0006                                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
    4.: D016ZE09TSN=2A2VUSER0001                                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
    5.: D016ZE09TSN=2A2VUSER0002                                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
    6.: D016ZE09TSN=2A3VADMINIST             ADM                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
    7.: D016ZE09TSN=2A2VUSER0003                                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
    8.: D016ZE09TSN=2A2VUSER0004                                               
        NO. OF LOG. FILES IN CALL-DML:          1                              
% <date> <time> SES7215 END OF OUTPUT 
%// 

Example 2

Output to the screen after entering the SHOW-USERS administration statement in SESDCN administration:

%SHOW-USERS
            USER                        !MODE!ELAPS!LOCATION!     CATALOG
                                        !    ! TIME!        !     IN USE
--------------------------------------------------------------------------------
D016ZE09TSN=7QLXSEDI63  00000000SQLDB112!TIAM!00:04!D016ZE08!JDB3
                                        !    !     !D016ZE08!ACCOUNT3
                                        !    !     !D016ZE09!JDB
D016ZE09TSN=7QLZDSQL    00000000SQLDB112!TIAM!00:02!D016ZE08!ZIRD
                                        !    !     !D016ZE09!VIRST
D016ZE09TSN=7R12USER000100000000EXAMPLE !DCAM!00:38!D016ZE08!JDB3
                                        !    !     !D016ZE09!JDB
D016ZE09TSN=7R12USER000200000000EXAMPLE !DCAM!00:36!D016ZE08!ACCOUNT3
                                        !    !     !D016ZE09!ACCOUNT
%  <date> <time> SEN2014 END OF THE 'SESDCN' ADMINISTRATION STATEMENT
%// 

When a user is active at multiple locations (Location, Catalog in Use), one output line is generated per location. The first output line then contains all the information, and the following lines only the “Location”, and “Catalog in Use” data.

Administration command in ISP format and at the CALL DML interface

The USER,PR administration command corresponds to the SHOW-USERS administration statement here.

USER,PR