SHOW-DISTRIBUTION-RULE-ENTRIES

This statement displays the active databases in the distribution rule.

Scope of validity

SESDCN administration

Function

The SHOW-DISTRIBUTION-RULE-ENTRIES statement displays all the databases entered in the distribution rule.

The following appears for each database:

• the logical database name (CATALOG)

• the number of users (USER)

• the host name (PRO-NAME)

• DBH name

• DCN name

• the configuration name (CNF-NAME).

SHOW-DISTRIBUTION-RULE-ENTRIES

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
Logical database name	var(*LIST).CATALOG	S	<filename 1..18>
Number of users	var(*LIST).USER	S	<integer>
Host name	var(*LIST).HOST	S	<name 1..8>
DBH name	var(*LIST).DBH-NAME	S	<alphanum-name 1..1> / ''BLANK''
DCN name	var(*LIST).DCN-NAME	S	<alphanum-name 1..1> / ''BLANK''
Configuration name	var(*LIST).CNF-NAME	S	<alphanum-name 1..1> / ''BLANK''

Example

Output to the screen after entering the SHOW-DISTRIBUTION-RULE-ENTRIES administration statement:

%SHOW-DISTRIBUTION-RULE-ENTRIES
    CATALOG          !  USER ! PRO-NAME !DBH-NAME!DCN-NAME!CNF-NAME! 
                     !       !          !        !        !        ! 
------------------------------------------------------------------------------
  DB6LOKG            !     7 ! D016ZE09 !   6    !   A    !   G    ! 
  DB7LOKG            !     0 ! D016ZE09 !   7    !   A    !   G    ! 
  DB0LOKG            !     0 ! D016ZE09 !        !   A    !   G    ! 
  DCCAT              !     0 ! D016ZE09 !   7    !   A    !   G    ! 
  DCCAT8             !     0 ! D016ZE09 !   8    !   A    !   G    ! 
  DB6REMG            !     0 ! D016ZE07 !   6    !   A    !   G    ! 
  DB7REMG            !     0 ! D016ZE07 !   7    !   A    !   G    ! 
  DB8REMG            !     0 ! D016ZE07 !   8    !   A    !   G    ! 
  DB6LOKH            !     0 ! D016ZE09 !   6    !   A    !   H    ! 
  DB7LOKH            !     0 ! D016ZE09 !   7    !   A    !   H    ! 
  DB8LOKH            !     0 ! D016ZE09 !   8    !   A    !   H    ! 
  DB6LOKI            !     0 ! D016ZE09 !   6    !   A    !   I    ! 
  DB7LOKI            !     0 ! D016ZE09 !   7    !   A    !   I    ! 
  DB8LOKI            !     0 ! D016ZE09 !   8    !   A    !   I    ! 
% <date> <time> SEN2014 END OF THE 'SESDCN' ADMINISTRATION STATEMENT 
%// 

Administration command in ISP format and at the CALL DML interface

The USER,CATALOG administration command corresponds to the SHOW-DISTRIBUTION-RULE-ENTRIES administration statement here.

USER,CATALOG