I have a Progress 9.1d server running for an application that has about 5 clients on at any given time. I don't know if they are 4GL or SQL clients as I don't know how the application that they use is coded. I would like to access the database via ODBC from another Windows machine on the network. I've fought long and hard all day to figure out the TCP port of each Broker I have running (apparently I have two brokers, and both are enabled for 4GL and SQL server), I've figured out how to install the Merant ODBC driver on the client machine and get it to attempt to connect to the database server via the ports specified for each broker. I've also figured out how to find the log and figure out how the database is starting up.
I get the "exceeding permissible number of connections" error when testing the connection via ODBC.
Now, I've searched high and low on this issue and the general consensus is to create another "broker" using "Progress Explorer". The problem is that I can't find this "Progress Explorer" anywhere in my start menu on the server. It's nowhere. Anywhere else I should look?
Another odd thing is I guess this program starts the database using this command line: dbman -database pubdb -start. I don't know if that's a factor or not.
Here is my log file showing the server startup:
05:30:04 BROKER 0: Multi-user session begin. (333)
05:30:05 BROKER 0: Begin Physical Redo Phase at 192 . (5326)
05:30:08 BROKER 0: Physical Redo Phase Completed at blk 2087 off 6129 upd 276. (7161)
05:30:08 BROKER 0: Started for dtx-odbc using TCP, pid 5364. (5644)
05:30:08 BROKER 0: Connecting to Admin Server on port 7835. (8836)
05:30:08 BROKER 0: Registered with Admin Server. (8846)
05:30:08 BROKER 0: PROGRESS Version 9.1D on WINNT. (4234)
05:30:08 BROKER 0: Server started by SYSTEM on CON:. (4281)
05:30:08 BROKER 0: Started using pid: 5364. (6574)
05:30:08 BROKER 0: Physical Database Name (-db): D:\dtx9\pubdir\pubdb. (4235)
05:30:08 BROKER 0: Database Type (-dt): PROGRESS. (4236)
05:30:08 BROKER 0: Force Access (-F): Not Enabled. (4237)
05:30:08 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
05:30:08 BROKER 0: Number of Database Buffers (-B): 88. (4239)
05:30:08 BROKER 0: Maximum private buffers per user (-Bpmax): 22. (9422)
05:30:08 BROKER 0: Excess Shared Memory Size (-Mxs): 16387. (4240)
05:30:08 BROKER 0: The shared memory segment is not locked in memory. (10014)
05:30:08 BROKER 0: Current Size of Lock Table (-L): 8192. (4241)
05:30:08 BROKER 0: Hash Table Entries (-hash): 23. (4242)
05:30:08 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
05:30:08 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
05:30:08 BROKER 0: Crash Recovery (-i): Enabled. (4244)
05:30:08 BROKER 0: Database Blocksize (-blocksize): 4096. (6573)
05:30:08 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
05:30:08 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
05:30:08 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
05:30:08 BROKER 0: Before-Image Cluster Size: 524288. (4250)
05:30:08 BROKER 0: Before-Image Block Size: 8192. (4251)
05:30:08 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
05:30:08 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
05:30:08 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
05:30:08 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
05:30:08 BROKER 0: Number of After-Image Buffers (-aibufs): 5. (4256)
05:30:08 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
05:30:08 BROKER 0: Maximum Number of Clients Per Server (-Ma): 1. (4257)
05:30:08 BROKER 0: Maximum Number of Servers (-Mn): 5. (4258)
05:30:08 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
05:30:08 BROKER 0: Maximum Number of Users (-n): 11. (4260)
05:30:08 BROKER 0: Host Name (-H): sgcserver1. (4261)
05:30:08 BROKER 0: Service Name (-S): dtx-odbc. (4262)
05:30:08 BROKER 0: Network Type (-N): TCP. (4263)
05:30:08 BROKER 0: Character Set (-cpinternal): ISO8859-1. (4264)
05:30:08 BROKER 0: Parameter File: Not Enabled. (4282)
05:30:08 BROKER 0: Maximum Servers Per Broker (-Mpb): 1. (5647)
05:30:08 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
05:30:08 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
05:30:08 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
05:30:08 BROKER 0: SQL Server Stack Size (-SQLStack): 1000. (10026)
05:30:08 BROKER 0: SQL Server Statement Cache Size (-SQLStmtCache): 100. (10027)
05:30:08 BROKER 0: SQL Server Max Open Cursors (-SQLCursors): 50. (10028)
05:30:08 BROKER 0: Created shared memory with segment_id: 10354688 (9336)
05:30:11 BROKER 1: Started for dtx using TCP, pid 4936. (5644)
05:30:11 BROKER 1: This is an additional broker for this protocol. (5645)
05:30:11 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)
05:30:13 WDOG 5: Started. (2518)
I will say, this is one tough system to figure out for the uninitiated. Years of DBA experience do me no good with this system. I'm in dire need of help here!
I get the "exceeding permissible number of connections" error when testing the connection via ODBC.
Now, I've searched high and low on this issue and the general consensus is to create another "broker" using "Progress Explorer". The problem is that I can't find this "Progress Explorer" anywhere in my start menu on the server. It's nowhere. Anywhere else I should look?
Another odd thing is I guess this program starts the database using this command line: dbman -database pubdb -start. I don't know if that's a factor or not.
Here is my log file showing the server startup:
05:30:04 BROKER 0: Multi-user session begin. (333)
05:30:05 BROKER 0: Begin Physical Redo Phase at 192 . (5326)
05:30:08 BROKER 0: Physical Redo Phase Completed at blk 2087 off 6129 upd 276. (7161)
05:30:08 BROKER 0: Started for dtx-odbc using TCP, pid 5364. (5644)
05:30:08 BROKER 0: Connecting to Admin Server on port 7835. (8836)
05:30:08 BROKER 0: Registered with Admin Server. (8846)
05:30:08 BROKER 0: PROGRESS Version 9.1D on WINNT. (4234)
05:30:08 BROKER 0: Server started by SYSTEM on CON:. (4281)
05:30:08 BROKER 0: Started using pid: 5364. (6574)
05:30:08 BROKER 0: Physical Database Name (-db): D:\dtx9\pubdir\pubdb. (4235)
05:30:08 BROKER 0: Database Type (-dt): PROGRESS. (4236)
05:30:08 BROKER 0: Force Access (-F): Not Enabled. (4237)
05:30:08 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
05:30:08 BROKER 0: Number of Database Buffers (-B): 88. (4239)
05:30:08 BROKER 0: Maximum private buffers per user (-Bpmax): 22. (9422)
05:30:08 BROKER 0: Excess Shared Memory Size (-Mxs): 16387. (4240)
05:30:08 BROKER 0: The shared memory segment is not locked in memory. (10014)
05:30:08 BROKER 0: Current Size of Lock Table (-L): 8192. (4241)
05:30:08 BROKER 0: Hash Table Entries (-hash): 23. (4242)
05:30:08 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
05:30:08 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
05:30:08 BROKER 0: Crash Recovery (-i): Enabled. (4244)
05:30:08 BROKER 0: Database Blocksize (-blocksize): 4096. (6573)
05:30:08 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
05:30:08 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
05:30:08 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
05:30:08 BROKER 0: Before-Image Cluster Size: 524288. (4250)
05:30:08 BROKER 0: Before-Image Block Size: 8192. (4251)
05:30:08 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
05:30:08 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
05:30:08 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
05:30:08 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
05:30:08 BROKER 0: Number of After-Image Buffers (-aibufs): 5. (4256)
05:30:08 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
05:30:08 BROKER 0: Maximum Number of Clients Per Server (-Ma): 1. (4257)
05:30:08 BROKER 0: Maximum Number of Servers (-Mn): 5. (4258)
05:30:08 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
05:30:08 BROKER 0: Maximum Number of Users (-n): 11. (4260)
05:30:08 BROKER 0: Host Name (-H): sgcserver1. (4261)
05:30:08 BROKER 0: Service Name (-S): dtx-odbc. (4262)
05:30:08 BROKER 0: Network Type (-N): TCP. (4263)
05:30:08 BROKER 0: Character Set (-cpinternal): ISO8859-1. (4264)
05:30:08 BROKER 0: Parameter File: Not Enabled. (4282)
05:30:08 BROKER 0: Maximum Servers Per Broker (-Mpb): 1. (5647)
05:30:08 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
05:30:08 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
05:30:08 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
05:30:08 BROKER 0: SQL Server Stack Size (-SQLStack): 1000. (10026)
05:30:08 BROKER 0: SQL Server Statement Cache Size (-SQLStmtCache): 100. (10027)
05:30:08 BROKER 0: SQL Server Max Open Cursors (-SQLCursors): 50. (10028)
05:30:08 BROKER 0: Created shared memory with segment_id: 10354688 (9336)
05:30:11 BROKER 1: Started for dtx using TCP, pid 4936. (5644)
05:30:11 BROKER 1: This is an additional broker for this protocol. (5645)
05:30:11 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)
05:30:13 WDOG 5: Started. (2518)
I will say, this is one tough system to figure out for the uninitiated. Years of DBA experience do me no good with this system. I'm in dire need of help here!