Applicable Versions: 5.50.0046 and above
From version 5.05.0024 and above, you can use a simple Environmental Variable switch to allow access to OpenEdge virtual system tables (VST's) to build dashboards that offer insights into the physical storage, performance, memory usage and user activity of the database (see "How do I access to the OpenEdge VST's with DataPA OpenAnalytics?" for details). However, using these VST's does require some fairly detailed knowledge of how the OpenEdge database engine works.
To make things easier, we thought we'd build a simple, generic dashboard any of our customers could use. This does mean we need to use business logic subjects (they need to work for any database) so requires a little work to configure. The steps required are below, if you struggle just email firstname.lastname@example.org and we'll give you a hand. NB. Steps 2 through 4 are concerned with implementing pre-written business logic subject that supports the generic queries. For a more detailed explanation of implementing a business logic subject, see "Can I create a query that runs a Progress function on the server to retrieve data?".
- Download the dashboard, subjects and supporting logic from here.
- Extract the 3 procedures (ReadSystemTableStartup.p, ReadSystemTableDB.p, ReadSystemTable.p) and place them in the PROPATH of your AppServer.
- Add ReadSystemTableStartup.p as the startup procedure for your AppServer (if you already have a startup procedure, just copy the last 3 lines of ReadSystemTableStartup.p into your current procedure).
- Restart the AppServer.
- Extract the file DatabasePerformanceMonitor.pax and use the Import/Export wizard in the Analytics Engine to import it into DataPA OpenAnalytics.
- Modify the connection details for the Database Performance Monitor system you have just imported to connect to your AppServer.
- Save changes to the Analytics Engine and exit.
- Extract and open the dashboard DatabasePerformanceMonitor.edp.
- Refresh all the queries.