SHOW-SPACE-USERS

This statement displays the users currently working in a space.

Scope of validity

DBH administration

Function

The SHOW-SPACE-USERS administration statement displays all users currently working in the selected space of a specific database. A user works in a space when using tables or indexes created in this space. In addition, system-generated identifications of the internal administrator (see "Syntax for the identification of users") are output if transactions are executed for the internal administrator in the space.

Only those users are output that have access within a transaction to the space. CALL DML users that only have one CALL DML open on a table of the space but do not have access within the transaction are not taken into account.

The following information is displayed:

• the user identification

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

• the program runtime in seconds (DURATION-TIME)

• the access mode (ACCESS) of the space (READ, WRITE or ADMIN)

• the state of the space (“copy”, “check pending” or “defect”). You will find information on the different space states in the “ Core manual”.

SHOW-SPACE-USERS

SPACE-NAME = <filename 1..18 without-cat-user-gen-vers>
,CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
,STRUCTURE-OUTPUT = *NONE / *SYSINF / <structured-name 1..20>(...)
	<structured-name 1..20>(...)
		|	WRITE-MODE = *REPLACE / *EXTEND

Operands

SPACE-NAME = <filename 1..18 without-cat-user-gen-vers>

Name of the space whose users are displayed. The name of the space is the name of the space file in BS2000.

CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
Logical name of the selected database

If the space cannot be identified based on the two names, a message to this effect is output.

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

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)
Program runtime (in seconds)	var(*LIST).DURATION-TIME	S	<integer>
Access mode	var(*LIST).ACCESS-MODE	S	WRITE / READ / ADMIN

Example

Output to the screen after entering the SHOW-SPACE-USERS SPACE-NAME=TABLESPACE,CATALOG-NAME=CAT-1 administration statement:

SPACE  TABLESPACE 
------------------------------------------------------------------------ 
  USER-IDENTIFICATION               !DURATION-TIME! ACCESS 
------------------------------------------------------------------------ 
 D016ZE07TSN=12LDSESUTI             !         20  ! READ 
%  <date> <time> SES7215 END OF OUTPUT 
%// 

Administration command in ISP format and at the CALL DML interface

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

USER,SPACE=space-name,C[ATALOG]=catalog-name