Chatta subito con l'assistenza
Chat con il supporto

Foglight for PeopleSoft 5.6.11 - User and Reference Guide

Using Foglight for PeopleSoft
Exploring the PeopleSoft Dashboards Foglight for PeopleSoft Agents PS_AppMonitor Agent PS_AppServer Agent PS_DB2SQL Agent PS_MSSQL Agent PS_OracleSQL Agent PS_PPM Agent PS_SchedMonitor Agent PS_SchedServer Agent PS_Scheduler Agent Manual Agent Naming Deployment Scenario Procedures
Foglight for PeopleSoft Reference
Views
PS_AppServer Views PS_DB2SQL Views PS_MSSQL Views PS_OracleSQL Views PS_PPM Views PS_SchedServer Views PS_Scheduler Views
Data

PS_DB2SQL 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 Foglight for PeopleSoft. 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.
 
* 
NOTE: EnableDBMonitoring should be set to one in the PeopleSoft application server domains in order to gather complete information for the PS_DB2SQL UserData table.
The PS_DB2SQL Agent is shipped with default properties that can be modified to suit your system requirements.
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, choose Administration > Agents > Agent Properties.
In the Agent Properties dashboard, in the Namespace > Type pane, select Legacy > PS_DB2SQL.
or
•
On the navigation panel, under Dashboards, choose Administration > Agents > Agent Status.
In the Agent Status dashboard, select the instance of the PS_DB2SQL agent whose properties you want to modify and click Edit Properties.
A list of agent properties appears in the PS_DB2SQL pane.
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.

Setting the PS_DB2SQL Connection Details

The PS_DB2SQL Agent must be configured with specific database information before the agent can connect to the database to collect user transactions within the PeopleSoft database.
The Connection Details agent properties allow you specify the environment variable to which the agent uses to connect to the PeopleSoft database. The connection information consists of a DB2 Instance Name, Database Name, Database Login ID and Password, and Database Home Directory.
To set the connection details:
1
Go to the Connection Details set of properties.
2
Click the Log SQL Output to Log File radio button, True or False, to create a log file for the PS_DB2SQL Agent.
3
If you selected True for the Log SQL Output to Log File, enter the path and log file name to which you want the SQL statement written, in the Log File Name (full path) box.
4
Enter the Database Instance Name file, in the DB2 Instance box.
5
Enter the database name in the Database Name box.
6
Enter the user account login that accesses the PeopleSoft database in the Database Login Name box.
 
* 
NOTE: This user must have access authority to obtain snapshots from the DB2 database.
7
Enter the password for database login in the Database Login Password box.
8
Enter the DB2 UDB home directory in the DB2 UDB Home box.
9
Click Save.
The PS_DB2SQL attempts to run on the Foglight Console. If successful, the agent status is listed as running
Once the PeopleSoft Connection Details agent properties are properly configured, the Management Server gathers data from the PeopleSoft agent.
 
* 
NOTE: For help configuring the other agent properties, see the Foglight online help.
10
Go to the Setting the PS_DB2SQL Data Management Parameters section.

Setting the PS_DB2SQL Data Management Parameters

Use the Data Management agent properties to set the sample frequency.
To set the data management properties:
1
Go to the Data Management set of properties.
2
Choose the list of table names that you want to update from the Edit Table Sample Frequencies list.
The collection rate, or sample frequency, is the number of seconds between the end of a collection period and the start of the next. The sample frequency can either be controlled at the agent level or set for each table. Table level sampling is the preferred method.
 
* 
IMPORTANT: Use Add or Delete only when directed to by Dell Support.
 
* 
NOTE: A single table is used for this agent.
 
* 
NOTE: The default Sample Frequency rate is applied to all tables not specifically listed in the Sample Frequency List.
3
Click Edit.
A secondary property list appears.
4
Add an entry to the list by clicking Add Row.
Fill in the dialog box fields.
5
Click Save Changes.
6
Ignore the Purge All Data After box. This field is not functional.
7
Click Save.

Investigating Database Usage and PeopleSoft User Intensive SQL Statements

The PS_DB2SQL Agent provides database usage statistics by measuring the number of active and inactive database users and identifies resource intensive SQL statements executed by PeopleSoft users.
The PS_DB2SQL Agent also monitors SQL activity for PeopleSoft users who execute a SQL statement during a sampling period. These statistics let you isolate problem SQL statements based on statement execution time, rows read, and rows written. The PS_DB2SQL Agent also lets you output the problem SQL statement to a log file for any further analysis of PeopleSoft user activities in the database. Using the Data Browser, you can also review SQL activity for each PeopleSoft user.
To start your investigation with the PS_DB2SQL_PID_Overview graph view:
•
Go to the PS_DB2SQL_PID_Overview graph view which displays the SQL execution times by the PeopleSoft application server process PID (system Process ID). This graph may provide an indication of which PIDs are the most resource intensive.
To view more detailed information:
Drill down on ExecTime to view the details about the DB2 database session corresponding to the PeopleSoft application server process PID, including the associated PeopleSoft Application user and SQL metrics in the PS_DB2SQL_PID_Detail table view.
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione