As you troubleshoot activity involving multiple clients, you may need to identify when particular connections occur. The log entry lists an identifying user number field for each connected server. Each server also has an assigned server number, specified in message 19552.

For example, consider a three-step scenario where the broker logs in, followed by an ABL remote server, and then a SQL remote server.

  1. PROSERVE starts the broker, specified by user type BROKER and its user number, 0. Message number 19552 displays the server number, which is also 0.
    [2020/02/16@23:02:53.152-0500] P-22642      T-22642 I BROKER  0: (333)   Multi-user session begin. 
    [2020/02/16@23:02:53.153-0500] P-22642      T-22642 I BROKER  0: (15321) Before Image Log Initialization at block 0  offset 645.
    …….
    [2020/02/16@23:02:54.181-0500] P-22642      T-22642 I BROKER  0: (19552) Broker with server num 0 logged in. 
    [2020/02/16@23:02:54.181-0500] P-22642      T-22642 I BROKER  0: (4281)  Server started by jsmith on /dev/pts/59. 
    [2020/02/16@23:02:54.182-0500] P-22642      T-22642 I BROKER  0: (6574)  Started using pid: 22642.
  2. A remote user starts an ABL server, specified as server type threaded server with user number 1. Message number 19552 displays the server number, which is also 1. The remote user is user number 2, identified by message 7129.
    [2020/02/16@23:02:59.437-0500] P-22687      T-22683 I TSRV    1: (452)   Login by rbrown on batch. 
    [2020/02/16@23:02:59.445-0500] P-22687      T-22683 I TSRV   1: (19552) Server with server num 1 logged in. 
    [2020/02/16@23:02:59.445-0500] P-22687      T-22683 I TSRV    1: (5646)  Started on port 1025 using TCP IPV4 address 0.0.0.0, pid 22687. 
    [2020/02/16@23:03:00.455-0500] P-22687      T-22690 I TSRV    1: (742)   Login usernum 2, userid rbrown client type ABL , on oelxc76dev90 59 using TCP/IP IPV4 address 10.124.45.6. 
    [2020/02/16@23:03:00.455-0500] P-22687      T-22690 I TSRV    1: (7129)  Usr 2 set name to rbrown.
  3. Another remote user starts a SQL server, specified as SQL Server with user number 3. Its server number, which is 2, is identified by message 19552. This remote user is user number 4.
    [2020/02/16@23:03:15.039-0500] P-22787      T-22787 I SQLSRV2 3: (19262) SQL Server 12.2ALPHA.02 started, configuration: "sportsdb.virtualconfig" 
    [2020/02/16@23:03:15.039-0500] P-22787      T-22787 I SQLSRV2 3: (19552) SQL Server with server num 2 logged in.
    ……
    [2020/02/16@23:03:16.043-0500] P-22787      T-22792 I SQLSRV2 3: (8873)  Login usernum 4, remote SQL client.