SHOW-INACTIVE-SQL-USERS

This statement displays inactive SQL users.

Scope of validity

DBH administration

Function

The SHOW-INACTIVE-SQL-USERS administration statement displays all currently inactive SQL users. If there is no user in the system, a message will appear stating this fact.

The following appears:

• the user identification

• the user's conversation number (if the user is an asynchronous UTM application)

• the inactivity time in seconds (INACT-TIME).
  The inactivity time is the time in which an SQL conversation has not opened a transaction.

SHOW-INACTIVE-SQL-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 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)
Inactivity time (in seconds)	var(*LIST).INACT-TIME	S	<integer>

Example

Output to the screen after entering the SHOW-INACTIVE-SQL-USERS administration statement:

%SHOW-INACTIVE-SQL-USERS
USER-ID: D016ZE09TSN=2BBZUTMTOOL           INACT-TIME:           44 (SEC.)      
% <date> <time> SES7215 END OF OUTPUT 
%// 

Administration command in ISP format and at the CALL DML interface

The USER,INACT administration command corresponds to the SHOW-INACTIVE-SQL-USERS administration statement here.

USER,INACT