The Sybase_MDA agent collects performance metrics using the Sybase MDA tables. This requires the SAP ASE login to have only the role mon_role assigned to it, as described above. The SAP ASE login does not need to have the role sa_role assigned to it. From Cartridge for SAP ASE version 5.5.8.39, the agent installs the Foglight for SAP ASE stored procedures during the initial activation. Therefore, if you are upgrading the Cartridge for SAP ASE, no action is required regarding the stored procedures. If you are installing the agent for the first time, you must perform the following pre-requisite procedure.
3 |
4 |
IMPORTANT: The group and user names used here (foglightGroup and fog123) are just examples, you can substitute them with more appropriate values. |
1 |
The above procedure results in the new user being created (fog123 in this example) in the group foglightGroup in each database, including the model database. Having that user and group in the model database causes a creation of a temporary database using these credentials when the SAP ASE server is restarted.
disk init name = 'questdb_temp',
physname = '/sybvol01/sap16/data/questdb_temp.dat', size = '50M',
– quest temp database creation
create temporary database questdb on questdb_temp = 50
– bind the foglight user to the new tempdb
3 |
On the Sybase Open Client, use the dsedit tool to add an entry representing the monitored SAP ASE Server in the interface file. |
5 |
Configure the Sybase_MDA Agent’s Sybase Home property to point to the Open Client home directory: %Sybase% (Windows) or $Sybase (Unix). |
6 |
Configure the Sybase_MDA Agent’s Server Name property to point to the host name or IP address of the monitored server, as defined in dsedit. |
For more information about working with agent properties, see the Foglight Administration and Configuration Guide.
Agent properties described in this section comprise:
• |
On the navigation panel, under Dashboards, click Administration > Agents > Agent Properties. |
• |
On the navigation panel, under Dashboards, click Administration > Agents > Agent Status. |
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center