Connected user data file and connected user details file

If an attempt is made to terminate HiRDB while a user is still connected, HiRDB outputs the KFPS05120-W message, together with the connected user data file ($PDDIR/spool/cnctusrinf) and the connected user details file ($PDDIR/spool/cnctusrdtl). For a HiRDB parallel server configuration, these files are output to the server machine where the system manager is located. The HiRDB administrator can identify the connected users from the information in these files.

Organization of this subsection: (1) Information output in the connected user data file; (2) Information output in the connected user details file

Output example

 
 UNIT ID : M350(173420)
 UID   PID     GID   SVID   TIME    PROGRAM   C-GRP   C-PID   C-IP
 334   22118   300   fes1   173330  uap00     PC      22205   172.17.32.37
 
 UNIT ID : M35b(173427)
 UID   PID     GID   SVID   TIME    PROGRAM   C-GRP   C-PID   C-IP
 334   17524   300   fes2   173343  uap01     PC      17619   172.17.32.39
 334   17533   300   fes2   173333  uap02     PC      22200   172.17.32.37

Explanation

UNIT ID: Displays the unit identifier (4 bytes) and the connected user data file creation time (6 bytes in hour-minute-second format) in parentheses.

UID: Displays the user ID of each user who is connected to HiRDB (5 bytes, right-aligned).

PID: Displays the process ID of each connected user's HiRDB server process (10 bytes, right-aligned).

GID: Displays the group ID of each user who is connected to HiRDB (5 bytes, right-aligned).

SVID: Displays the server ID of the server to which each connected user is connected (8 bytes, left-aligned).; Spaces might be displayed immediately after HiRDB server process activation.

TIME: Displays the time (hour-minute-second format) at which HiRDB received each service request (6 bytes). 999999 is displayed for a server where no user is connected.

PROGRAM

Displays the value specified in the PDCLTAPNAME operand of the client environment definition (30 bytes, left-aligned).

If this operand is omitted, Unknown is displayed. For details on the PDCLTAPNAME operand, see the HiRDB Version 9 UAP Development Guide.

******** is displayed for a utility.
******** might be displayed immediately after HiRDB server process activation.

C-GRP

Displays the user type (client group type) of each user who is connected to HiRDB (2 bytes).

If the connection frame guarantee facility for a client group is used and a client group selected arbitrarily by the user is defined, the user-defined client group name is displayed.

Displayed character string	User type
XA	User who connected to HiRDB using the X/Open XA interface
PC	User who connected to HiRDB from a PC client
WS	User who connected to HiRDB from a WS client
MF	User who connected to HiRDB from a mainframe client (VOS3 client, for example)

C-PID

Displays the process ID of the client that is connected to HiRDB (10 bytes, right-aligned).

The process ID is not displayed in the following cases:

The version of the client to which the UAP is linked is earlier than HiRDB Version 4.0 04-00.
The client is connected from a Type4 JDBC driver.

C-IP: Displays the IP address of the client that is connected to HiRDB (15 bytes, left-aligned).

20.13.2 Connected user data file and connected user details file

(1) Information output in the connected user data file

(2) Information output in the connected user details file