SHOW-CATALOG-USERS

Displays the number of active users of selected databases

Scope of validity

DBH administration

Function

The SHOW-CATALOG-USERS administration statement displays the number of users accessing selected databases when you issue the statement. This means that only those users are output that have access to the database within the transaction. CALL DML users that only have one CALL DML open on a table in the database but do not yet have access within a transaction are not taken into account.

If no databases are entered in the SQL database catalog, you receive a message to this effect.

The following is displayed:

• the logical name(s) of the selected database(s)

• the status of each database (see the SHOW-SQL-DB-CATALOG-ENTRIES administration statement on "SHOW-SQL-DB-CATALOG-ENTRIES")

• the number of active SQL and CALL DML users.

SHOW-CATALOG-USERS

CATALOG-NAME = *ALL / <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

CATALOG-NAME = *ALL / <filename 1..18 without-cat-user-gen-vers>

Logical name of the selected databaseThe default is *ALL, which means that all databases are selected.

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
Logical database name	var(*LIST).CATALOG	S	<filename 1..18>
Database status	var(*LIST).STATE	S	ACTIVE / FREE / LOCKED / REORG / RECOVER / REFRESH
Number of active users	var(*LIST).USER	S	<integer>

Example

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

%SHOW-CATALOG-USERS
CATALOG  DCCAT                STATE ACTIVE         0 USERS                      
CATALOG  DB6LOKG              STATE ACTIVE         7 USERS                      
% <date> <time> SES7215 END OF OUTPUT 
%//

Administration command in ISP format and at the CALL DML interface

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

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