Chapter 8: WIN-202 Server Information

This section is focused primarily toward technical staff or those with administrative privileges that maintain the WIN-202 system. The three tools discussed in the following sub-sections include Promon, ProControl and Scheduled Tasks. Please note that this section is not intended to be a complete reference to Progress database management, but covers common processes useful to system administrators. Refer to the "Progress System Administration Reference" handbook for a complete and detailed reference guide.

Promon (Progress Monitor)

The Promon utility is an extremely useful tool for monitoring database and system activity. With Promon, system administrators can determine who is on the system, what kinds of locks are being held, system usage, if the batch manager is running, etc. To access this utility double-click the Promon icon on your desktop server. Note: If the icon is not on the desktop, right-click the desktop and select "New Shortcut". In the target type: C:\progress\openedge\bin\promon.bat [path to the database]\win202.

Although state database administrators should familiarize themselves with all of the options, the choices most often used are Option 5 (Activity) and Option 8 (Shut Down Database). These options are discussed below.

Promon Option 5: Activity

Selecting Option 5 on the Progress Monitor (Promon) opens the screen shown below. The screen displays how your database is performing at one moment in time. In the following example, the screen is for a sample time frame of 257 hours, 42 minutes and 39 seconds as shown at the top of the screen. The first time you bring up the screen, the data is for the period of time since the database was last started. Every time you hit return, via the [Enter] key on your keyboard, the screen displays system activity since the last time you viewed data.

This screen shows a variety of information including:

• How many commits occurred in the database in the specified amount of time
• How many updates occurred
• How many creates occurred
• How many reads occurred
• How many deletes occurred

You can find out whether your Batch Manager is running by looking at the second to the last line on the screen (see previous figure). This line shows the total number of users—in our example, it is nine. It further breaks down those users by type. A local user is running on the server. This most likely is the Watchdog utility, which detects processes that have terminated improperly and cleans up after them. The eight remote users are analysts, connecting remotely from their workstations. The Batch user is the Batch Manager. This line also shows two Asynchronous Page Writers (Apws) active on the database at this time. APWs are optional, but highly recommended since they improve database performance. For more information on Watchdog and APWs, see your Progress System Administration Guide. You can get a detailed listing of these users by selecting Option 8 (Shut Down Database) on the initial "Promon" screen described below.

Promon Option 8: Shut Down Database

Selecting Option 8 from the initial "Promon" screen displays the screen shown below. This screen shows the Batch Manager (shown as CON:, in this case user 6), a Before-Image Writer (BIW), the Watchdog (WDOG), two Asynchronous Page Writers (APW), and eight remote users. The BIW is optional, but highly recommended for improving system input/output performance. For more information on APWs, BIW, and Watchdog, see your Progress System Administration Guide. This screen also gives you the option to disconnect a user, perform an unconditional shutdown, or an emergency shutdown. Note: You must be logged-in as the "win202service" account to be able to disconnect a user.