Utilities
The following utilities have changed to accommodate both license models (user count and capacity based).
•
License Administrator (GUI and CLI)
•
Monitor
•
Query Plan Viewer
License Administrator (GUI and CLI)
License Administrator now displays the limit for user count, session count, and data in use for a key. A value of “n/a” (“not applicable”) is displayed for the limit total if the type of key does not apply. For example, session count and data in use do not apply to a key for
Pervasive PSQL v11 SP2, so both limits display as “n/a.” See
License Administration
in
Pervasive PSQL User's Guide
for details.
Monitor
Monitor has the following changes to accommodate both license models. The changes are summarized for the graphical user interface. The command line interface (bmon) contains similar changes where applicable. See
Monitoring Database Resources
in
Advanced Operations Guide
for details.
•
The “Active Users” menu command and “MicroKernel Active Users” dialog have been renamed to “Active Sessions” and “MicroKernel Active Sessions,” respectively. The dialog has been modified to reflect session information.
•
The “MicroKernel Resource Usage” dialog shows the current, peak, and maximum values for user count, session count, and data in use. “Licenses in Use” has been removed.
•
The “MicroKernel Active Files” dialog lists the physical file size in kilobytes (KB) for a given file.
•
The amount of time in weeks, days, hours, and minutes that the database engine has been running (referred to as “MicroKernel Uptime”) is shown on the “MicroKernel Communications Statistics” dialog and on the “MicroKernel Resource Usage” dialog.
If a resource does not apply to the type of product being monitored, “n/a” (“not applicable”) appears for each statistic. For example,
“n/a” appears as the Maximum value for “Session Count” and “Data in Use MB” if Pervasive PSQL v11 SP2 is being monitored.
However, if you are considering using Pervasive PSQL Vx Server, you need the ability to estimate Current and Peak values for “Session Count” and “Data in Use MB.” Consequently, those statistics
are
displayed for Pervasive PSQL v11 SP2 but are
not
enforced. No notifications are sent about them regardless of their values.
Also note that, if a file is immediately closed after you insert a large number of records, Monitor does not immediately reflect the changes in file size. For example, the statistics for
“Data in Use MB” and “Physical File Size KB” are not refreshed for that file until the next time the file is opened for reading or writing.
Query Plan Viewer
Query Plan Viewer contains the following changes.
Query Viewer Window
•
The window can be scrolled vertically.
•
Shortcut keys are provided for the View menu items.
•
An option to export an XML file of the query is provided on the File menu.
Plan Viewer Window
•
The window can be scrolled both vertically and horizontally, zoomed, and set to several fixed-percent sizes.
•
The window displays the name of the query or subquery in parentheses in its title (to be consistent with the Query Viewer window); its cursor changes shape to a hand when the user mouses over “hot” nodes in the tree; and Subquery menu items are dynamically created instead of irrelevant items being disabled.
See
Query Plan Viewer
in
SQL Engine Reference
.