progress-4gl Getting started with progress-4gl Running sports2000 as a service

Example

Once the sports2000 database has been installed it's time to run it as a standalone server (and not connect to it as a file).

Start proenv (proenv in the startmeny on Windows or /usr/install-directory/bin/proenv on Linux/Unix).

This example is from Windows. Linux is the same but you need to change paths etc to match your install.

proenv> cd \db\sports2000
proenv> proserve mySportsDb -H localhost -S 9999
OpenEdge Release 11.6 as of Fri Oct 16 19:01:51 EDT 2015
20:09:54 BROKER     This broker will terminate when session ends. (5405)
20:09:54 BROKER     The startup of this database requires 17Mb of shared memory.  Maximum segment size is 128Mb.
20:09:54 BROKER  0: Multi-user session begin. (333)
20:09:55 BROKER  0: Begin Physical Redo Phase at 0 . (5326)
20:17:36 BROKER  0: Before Image Log Initialization at block 1  offset 5300. (15321)
20:09:55 BROKER  0: Login by xyz on CON:. (452)
20:09:55 BROKER  0: Started for 9999 using TCP IPV4 address 127.0.0.1, pid 2892. (5644)
proenv> 

(You might not get exactly this output).

This will start the mySportsDb on localhost and use port 9999 as primary port for database access. If you want to connect to this database from another client on the same network or elsewhere localhost wont work. Use your IP-address or hostname instead:

proenv> proserve mySportsDb -H 192.168.1.10 -S 9999.

Connecting and disconnecting

Once your database is up and running you can connect to it in your Progress editor:

CONNECT mySportsDb -H localhost -S 9999.

or

CONNECT "-db mySportsDb -H localhost -S 9999".

If you get an error message you have either gotten some information wrong in the command or the database isn't up and running. You could also have a software firewall or similar interfering.

You can check the database logfile (mySportsDb.lg in this example) for any clues.

Disconnecting is just as easy:

DISCONNECT mySportDb.

or

DISCONNECT "mySportsDb".

Shutting down the database (or disconnect users

To shut the database down you can run the proshut command from proenv:

proenv> proshut mySportsDb
OpenEdge Release 11.6 as of Fri Oct 16 19:01:51 EDT 2015
usr    pid    time of login           user id     Type  tty                  Limbo?
 24   7044 Wed Feb 01 20:22:57 2017   xyz         REMC  XYZ-PC               no
            1  Disconnect a User
            2  Unconditional Shutdown
            3  Emergency Shutdown (Kill All)
            x  Exit

1. Use 1 to disconnect specific users.
2. Use 2 to shut down the database. Note: no questions asked, shutdown starts directly!
3. Use 3 only if you can't take down the database any other way. This might corrupt your data.
4. Use x to exit the proshut utility.

You can also shutdown the database directly from the command line:

proenv>proshut mySportsDb -by

Or disconnect a user from command line (assuming you know it's user number, usr in the list above):

proenv>proshut mySportsDb -C disconnect 24
OpenEdge Release 11.6 as of Fri Oct 16 19:01:51 EDT 2015
User 24 disconnect initiated. (6796)