Salesforce

How to use PROMON to find the port used by the database broker at startup

Printable View
« Go Back

Information

 
TitleHow to use PROMON to find the port used by the database broker at startup
URL NameP6689
Article Number000129226
EnvironmentProduct: Progress OpenEdge
Version: All supported versions
OS: All supported platforms
Other: PROMON
Question/Problem Description
How to use PROMON to find the port used by the database Broker at startup
Using PROMON to find the listening port number to use to connect client/server to the database
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Start a PROMON session against the running database:
$   promon <dbname>

At the "Enter your selection" prompt, Type R&D
Select Option 1 "Status Displays"
Select option 3 "Servers"

The Servers display will show all Login Brokers with the Server Type "Login" and the resolved port number the Broker is listening on.

For example:
$   proserve dbname -S 2054
$   proserve dbname -m3 -S 3054
PROMON dbname > R&D > 1, 3 (Status, Servers)

Sv                                         Pend.   Cur.   Max.   Port
No    Pid  Type       Protocol     Logins  Users  Users  Users    Num
  0   7460 Login      TCP               1      0      0      5   2054
  1  12668 Login      TCP               1      0      0      5   3054
  2   9388 Auto       TCP               1      0      1      5   3000
  3   5172 Auto       TCP               1      0      1      5   3001
  4  15076 Auto       TCP               1      0      1      5   3002

Where: 
Sv 0 is the Primary Broker listening on Port 2054
Sv 1 is the Secondary Login Broker listening on Port 3054
Sv 2 - 4 are remote servers that have been spawned by client/server connection requests to these Login Brokers. The number of remote servers each Login Broker has spawned can be viewed through:
 
PROMON dbname > R&D > 1, 17 (Status, Servers By Broker)

Sv                                         Pend.   Cur.   Max.   Port
No    Pid  Type       Protocol     Logins  Users  Users  Users    Num
  0   7460 Login      TCP               1      0      0      5   2054
  4  15076 Auto       TCP               1      0      1      5   3002

  1  12668 Login      TCP               1      0      0      5   3054
  2   9388 Auto       TCP               1      0      1      5   3000
  3   5172 Auto       TCP               1      0      1      5   3001

Alternatively the _CONNECT and _SERVERS Virtual System Tables (VST) can be used, refer to the example provided in Article How to find the login broker a remote client initially connected to ?   
 
Workaround
Notes
Keyword Phrase
Last Modified Date9/26/2022 9:26 PM
Powered by