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 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.

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.

See Query Plan Viewer in SQL Engine Reference.