Foglight 5.9.8 - Upgrade Guide


	IMPORTANT: If you are upgrading to the current version of Foglight for SQL Server in a Federation architecture, the upgrade should be applied first to the Federated Children and then to the Federation Master. If the Federation Master is upgraded first, it will display incorrect information regarding the number of instances being monitored in the Status Summary section.

Upgrade Foglight for SAP ASE

The latest version of Foglight for SAP ASE (formerly Foglight for Sybase) is 5.9.7.20. However, due to architectural changes in the Foglight for SAP ASE 5.9.7.20, legacy cartridge versions cannot be upgraded to version 5.9.7.20. You may install the new SAP ASE cartridge on the same FMS instance as the old cartridge. The new Sybase cartridge must use a different FglAM than the legacy cartridge. Both FglAMs may be installed on the same FMS.


	NOTE: If you upgrade the Management Server to version 5.5.8 or later, you must upgrade the Cartridge for SAP ASE to version 5.5.5 or later.

To upgrade from version 5.5.5 or 5.5.8 to 5.7.5.50:

Deactivate the existing Sybase_MDA and Sybase_RS agent instances.

Install version 5.7.5.50 of the cartridge as you would install a new Foglight for SAP ASE. Do not delete the older version of the .car file. Install version 5.7.5.50 over the older version. For cartridge installation instructions, see “Installing Foglight cartridges” in the Administration and Configuration Help.

Deploy the agent package. For complete instructions, see “Installing Foglight cartridges” in the Administration and Configuration Help.

Activate the Sybase_MDA and Sybase_RS agent instances.

If the Management Server has a questdb database, the appropriate new stored procedures are installed automatically by the agents during the activation process.


	NOTE: If the agent fails to collect data, check the agent log for information about the problem.

When upgrading from version 5.5.5 of the cartridge, the upgrade overrides the value of the common Performance Poll Cycle (seconds) property, and uses that value to set the collection rate for each table in the PerfMon_Dflt list. Versions of the cartridge prior to 5.5.8 included the common Sybase_MDA agent properties, Performance Collection True/False and Performance Poll Cycle (seconds), used to control the collection of performance data. This version of the cartridge includes performance monitoring properties that enable or disable the collection of performance data and the length of the polling interval on a per-table basis. The secondary agent properties in the PerfMon_Dflt list now include two new columns, Collect and Poll Cycle (sec), that control these values for each individual table.


	NOTE: The file setup_mon_tables.sql contains all of the required parameters with sample values. The last four parameters were added in version 5.5.8. NOTE: There is a known defect: when deploying the agent package, a progress bar appears but never indicates completion. Typically the deployment has completed successfully. For a workaround procedure that verifies that the deployment has completed, see section “Upgrade” in the Cartridge for Sybase 5.7.5.50 Release Notes.