Workaround: upgrade the FMS to 7.1.x and install the latest SAP ASE cartridge
SAP ASE cartridge 7.1.0 does not require Sybase Open Client to be installed.
After installing the cartridge, update the SAP ASE account for Foglight by manually downloading and running the scripts DB_Sybase_FirstRun_Scripts located under Foglight > Dashboards > Administration > Agents > Cartridges > Components for Download.
1 |
2 |
Run these scripts to complete the upgrade and to display the correct information on the new dashboards. For script execution instructions, see “Configuring Sybase Login Privileges” in the Foglight for Sybase User and Reference Guide. Failed to upgrade the user account will result in broken agent instances. |
3 |
Once you have installed the cartridge, deploy the agent package. For complete information, see “Deploying agent packages to monitored hosts” in the Foglight Administration and Configuration Help. After upgrading the cartridge and starting the agent, the Agent log will display the database version, cartridge version, EBF level, and so on. |
• |
For RS cartridge you need to configure the path to the sql.ini file in the ASP with all the servers participating in the RS Agent. You can take the sql.ini file which exists in the Replication Server as an example. |
After installing the Cartridge for SAP ASE, perform the configuration steps below:
To create a new SAP ASE user, run the following scripts as sa user (use your username and password).
On the navigation panel, under Dashboards, click Administration > Cartridges > Cartridge Inventory. For details specific to the installation of the cartridge agents, see the following sections.
Sybase Adaptive Server Prerequisites: Sybase_MDA Agent
If the monitoring tables are not installed in your Adaptive Server (12.5.4 or later), have the Sybase DBA for the respective ASE follow the steps to install the tables listed in the Addendum at the end of this section.
For versions 15.x, there is no need for loopback and installmontables.
Command to execute via ISQL or other client tool:
grant role mon_roleto_<logon_name>
Sybase Adaptive Server Pre-requisites: Sybase_RS Agent
Preparation of the ASE version 12.5.4 or later for Foglight Cartridge for SAP ASE
2 |
Execute the installmontables script located in the $SYBASE/ASE-12_5/scripts directory (%SYBASE%/ASE-12_5/scripts for Windows) using ISQL: |
Adaptive Server Enterprise configuration parameters
enable stmt cache monitoring = 1 | |
statement statistics active = 1 per object statistics active = 1 | |
Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat. Quest Software. Where next meets now. For more information, visit https://www.quest.com/.
Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center