Chat now with support
Chat with Support

Foglight for Sybase 5.9.5.10 - User and Reference Guide

Using Foglight for SAP ASE
Exploring the SAP ASE Dashboards About the Sybase_MDA Agent About the Sybase_RS Agent Generating SybaseMDA Reports
Reference

Configuring SAP ASE Login Privileges

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.

To create a login account without 'sa' privileges:
1
Ensure that all of your MDA configuration parameters are set properly.
* 
TIP: The file setup_mon_tables.sql contains all of the required parameters with sample values.
2
Create a Foglight login account. For example, fog123:
sp_addlogin 'fog123' , 'foglight' , sybsystemprocs
go
grant role mon_role to fog123
go
3
Run the rapsAdmin.sql script as the sa user.
The scripts included with the Foglight for SAP ASE can be found in the directory <FglAM_Home>/agents/SybaseCartridge/<version>/config/Sybase/scripts.
isql -Usa -P<password> -S<serverName> -i rapsAdmin.sql -o
rapsAdmin.out
The above command creates two helper stored procedures: sp_fgl_addgrant and sp_fgl_adduser. In addition, the script drops previously installed stored procedures and previously created temporary tables.
4
Run the sp_fgl_adduser procedure as the sa user. For example:
sp_fgl_adduser 'fog123' , 'foglightGroup'
go
The above command creates a group named foglightGroup and a user named fog123 in each database, and in the sybsystemprocs database, it grants the permission for creating procedures to that user account.
* 
IMPORTANT: The group and user names used here (foglightGroup and fog123) are just examples, you can substitute them with more appropriate values.
To update a non-sa user after the cartridge upgrade:
1
Complete Step 3 and Step 4 described in To create a login account without 'sa' privileges:.

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.

Using a secondary database to store collected data

Foglight stores data collected by monitoring an ASE server in temporary tables. By default, it uses the tempdb database. It can also uses another database for that.

The following code block shows how to create a temporary database (questdb), and bind a Foglight user (fogdb) to that database.

use master

go

 

– device creation

disk init name = 'questdb_temp',

physname = '/sybvol01/sap16/data/questdb_temp.dat', size = '50M',

dsync = false

go

 

– quest temp database creation

create temporary database questdb on questdb_temp = 50

go

 

– bind the foglight user to the new tempdb

sp_tempdb bind,

'LG', – = login_name (don't change)
'fogdb',-- set the login name
'DB', – = database (don't change)
'questdb' – set the database name

go

 

* 
NOTE:
1. Run this code as the sa user.
2. For an existing Foglight environment that already uses tempdb, re-run the rapsinstall2_questdb.sql in the ASE instance. With running rapsinstall2_questdb.sql, Foglight’s stored-procedures in the ASE instance will be updated with the questdb code.

Configuring the Sybase_MDA Agent for Remote Monitoring

The Sybase_MDA Agent can be configured for remote monitoring. Remote monitoring does not require a Sybase_MDA Agent instance to run on the monitoring host. The agent instance can run on another machine, provided that you point it to the monitored machine using Sybase_MDA Agent properties.

To configure the Sybase_MDA Agent for remote monitoring:
1
Install and run the Foglight Agent Manager on the monitored host. You can use the Agent Manager embedded on the Foglight Management Server.
2
On the computer running the Agent Manager, install Sybase Open Client.
3
On the Sybase Open Client, use the dsedit tool to add an entry representing the monitored SAP ASE Server in the interface file.
4
Define a SAP ASE user for the SAP ASE cartridge.
5
Configure the Sybase_MDA Agent’s Sybase Home property to point to the Open Client home directory: %Sybase% (Windows) or $Sybase (Unix).
* 
TIP: The Sybase Home agent property can be found in the Connection Details group of agent properties. For more information, see Setting Connection Details .
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.

Sybase_MDA Agent Properties

When an agent connects to the Foglight Management Server, it is provided with sets of properties that it uses to configure its correct running state.

Each agent is provided with a combination of two types of properties: agent properties and shareable properties.

Default versions of these properties are installed with the Foglight for SAP ASE. However, you can edit the default shareable and agent properties, configure agent properties that apply only to a specific agent instance, and create edited clones of shareable properties that are used by a subset of the agents of a certain type.

For more information about working with agent properties, see the Foglight Administration and Configuration Guide.

The Sybase_MDA Agent is shipped with default properties that can be modified to suit your system requirements.

Agent properties described in this section comprise:

•
Setting Connection Details
•
Setting Callback Connection Properties
•
Setting Data Management Properties
•
Setting Table Space Management Properties
•
Setting Data Retrieval Properties
•
Setting Benchmark Properties
•
Setting Configuration Properties
To modify agent properties:
1
Ensure that the navigation panel on the left is open.
To open the navigation panel, click the right-facing arrow on the left .
2
Open the dashboard that lets you navigate to the agent properties by completing one of the following steps:
•
On the navigation panel, under Dashboards, click Administration > Agents > Agent Properties.
In the Agent Properties dashboard, in the Namespace > Type pane, select DB_Sybase > Sybase_MDA.
•
On the navigation panel, under Dashboards, click Administration > Agents > Agent Status.
In the Agent Status dashboard, select the instance of the Sybase_MDA agent whose properties you want to modify and click Edit Properties.
A list of agent properties appears in the Sybase_MDA pane.
Figure 47. Agent Properties
The position of the Properties pane depends on the dashboard you used to access agent properties. If you used the Agent Properties dashboard, the Properties pane appears to the right of the Namespace > Type pane in the display area. If you used the Agent Status dashboard, the Properties pane appears across the display area.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating