Solace PubSub+ Monitor v6.4.0

The Solace monitor now filters out all Queues started with the #P2P/QTMP/ prefix. If you need to monitor these, navigate in the Configuration Application to Solace > Data Collection > Filter Out Regular Expressions. Change the value of the Queue field to: !(.*)

Data Historian

  1. New database tables SOL_VPN_CAPACITY and SOL_VPN_CAPACITY_EXT have been added for the Solace Solution package. The first is enabled by default. Users should refer to the SQL schemas under rtvapm/solmon/dbconfig for appropriate table creation syntax.

  2. New optional database table SOL_BRIDGE_TOTALS has been added for Oracle and MySQL databases. Users should refer to the SQL schemas under rtvapm/solmon/dbconfig for appropriate table creation syntax.

  3. It is now possible to customize the table name SOL_VPN_TOTALS. If you have an existing table named SOL_VPN_TOTALS with historical data you wish to keep, ask your DB Admin to rename SOL_VPN_TOTALS to the new customized name.

  4. There have been columns added to existing tables. Reference the below syntax for altering existing tables.

Oracle:

ALTER TABLE "SOL_APPLIANCE_CAPACITY" ADD ("egress-flow-count-per-cent" REAL)

ALTER TABLE "SOL_MESSAGE_SPOOL" ADD ("egress-flow-count" REAL)

ALTER TABLE "SOL_VPN" ADD ("avg-spool-msg-size-in-kb" REAL, "cur-spool-usage-in-mb" REAL, "high-water-mark-in-mb" REAL, "connections-util-percent" REAL)

MySQL:

ALTER TABLE "SOL_APPLIANCE_CAPACITY" ADD "egress-flow-count-per-cent" DOUBLE;

ALTER TABLE "SOL_MESSAGE_SPOOL" ADD "egress-flow-count" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "avg-spool-msg-size-in-kb" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "cur-spool-usage-in-mb" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "high-water-mark-in-mb" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "connections-util-percent" DOUBLE;

SQLServer:

ALTER TABLE [SOL_APPLIANCE_CAPACITY] ADD [egress-flow-count-per-cent] FLOAT;

ALTER TABLE [SOL_MESSAGE_SPOOL] ADD [egress-flow-count] FLOAT;

ALTER TABLE [SOL_VPN] ADD [avg-spool-msg-size-in-kb] FLOAT;

ALTER TABLE [SOL_VPN] ADD [cur-spool-usage-in-mb] FLOAT;

ALTER TABLE [SOL_VPN] ADD [high-water-mark-in-mb] FLOAT;

ALTER TABLE [SOL_VPN] ADD [connections-util-percent] FLOAT;

DB2:

ALTER TABLE "SOL_APPLIANCE_CAPACITY" ADD "egress-flow-count-per-cent" DOUBLE;

ALTER TABLE "SOL_MESSAGE_SPOOL" ADD "egress-flow-count" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "avg-spool-msg-size-in-kb" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "cur-spool-usage-in-mb" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "high-water-mark-in-mb" DOUBLE;

ALTER TABLE "SOL_VPN" ADD "connections-util-percent" DOUBLE;

 

Solace PubSub+ Monitor v6.4.1

Data Historian

New database tables SOL_CONNECTORS and SOL_WORKFLOWS have been added. Both are disabled by default. Users should refer to the SQL schemas under rtvapm/solmon/dbconfig for appropriate table creation syntax.

 

Solace PubSub+ Monitor v6.4.2

Data Historian

There has been a new column added to SOL_VPN_TOTALS, which is used by the Message Volume Displays. Users who have enabled these displays should run the following command on their existing database table. If a table name other than SOL_VPN_TOTALS was specified then use that name in the"ALTER TABLE" commands given below.

Oracle:

ALTER TABLE "SOL_VPN_TOTALS" ADD "connections" REAL;

MySQL:

ALTER TABLE SOL_VPN_TOTALS ADD COLUMN "connections" DOUBLE DEFAULT 0;