Page History
...
Column | Description | ||
---|---|---|---|
Node | The specific Precise framework installation.
| ||
Technology | The name of the technology that the process gathers data for. Processes that maintain the PMDB itself are listed, but the technology column remains empty. | ||
Process | The process name is a logical name that describes the process function. For example, “Calculate Baselines.” Two types of processes gather PMDB data. One process type includes processes that are part of the PMDB FocalPoint and run on the PMDB server, such as the Summarize Data process. The other process type includes processes that are part of another product, such as the Schema Changes process in a Microsoft SQL Server instance that Precise for SQL Server monitors. These processes run on the product’s server and on the PMDB FocalPoint, which is in charge of scheduling them. See “Batch processes in Precise” on page 75. | ||
Product | The name of the product the process runs for. | ||
Last Run | The last time the process that is named in this row ran. | ||
Next Scheduled Run | Time when the process that is named in this row is scheduled to run again. | ||
Status | An icon indicating the current status of the process that is named in this row. |
The current status of a process can be any of the following statuses:
...
Technology | Process | |
---|---|---|
DB2 | Calculate Objects Usage | |
Oracle | Collect Instance Definitions | |
Oracle | Collect Instance Statistics | |
Oracle | Collect Schema Changes | |
Oracle Storage | Load Data | |
Oracle | Perform SmarTune Analysis on DB Behavior | |
SQL Server | Collect Instance Statistics | |
SQL Server | Collect DB File Statistics | |
SQL Server | Collect Job Statistics | |
SQL Server (Storage) | Load Data | |
Sybase | Collect Instance Statistics | |
Sybase | Purge Internal Data | |
Sybase Replication Server | Load Data | |
SAP | Organizational Mapping | |
PMDB | Data Maintenance (Daily) | |
.NET | Load Data | |
Summarize Current Data |
To configure process parameters
- In the Main area table, select the process whose parameters you want to configure.
- Click Parameters.
In the Parameters dialog box, perform one of the following actions:
To edit the default values for the selected technology Click Edit Default Values.
In the Default Values dialog box, specify the values and click OK.
Unless instance-specific values override these values, they apply to all monitored instances.
To edit the values for a specific instance Select an instance in the table. Click Edit.
In the Edit Instance dialog box, clear the Use Defaults check box. Specify the values to be used for this instance.
Click OK.
In the Parameters dialog box, click OK.
Info After you change the default of the Minimum In Oracle time to load parameter in the Load Data process, you must stop and then restart the Precise for Oracle FocalPoint. The next step is to restart the Collector agents.
Info Changing the “Load Data” value from “300” to “30” for Precise for J2EE can take up to ten minutes to take effect.
Info You can also configure the Precise for Web URL mapping rule for a domain in a system: “Treat pages with different titles as different pages”. Select to view the URL along with the various titles that belong to it. The collected data includes page URLs and page titles. When cleared, you can only differentiate between different URLs, not between page titles. In this case, the collected data includes the page URL and the first page title for any URL in the system.
...
Default Interval | Technology | Process |
---|---|---|
Weekly | PMDB | Purge Data |
Weekly | PMDB | Warehouse Maintenance (Weekly) |
Weekly | PMDB | Calculate Baselines |
Weekly | Oracle | Collect Instance Definitions |
Weekly | Oracle | Collect Schema Changes |
Weekly | Oracle | Purge Data |
Weekly | Oracle | Identity Changes (SmarTune) |
Weekly | SQL Server | Collect Schema Changes |
Weekly | SQL Server | Purge Internal Data |
Weekly | Sybase | Purge Internal Data |
Daily | Oracle | Explain Statements |
Daily | Oracle | Collect Objects Statistics Changes |
Daily | SQL Server | Explain Statements |
Daily | SQL Server | Collect Space Utilization |
Daily | Sybase | Explain Statements |
Daily | Sybase | Collect Space Utilization |
Daily | SAP | Organizational Mapping |
Daily | PMDB | Warehouse Maintenance (Daily) |
Hourly | J2EE | Load Data |
Hourly | Oracle Storage | Load Data |
Every 8 hours | PMDB | Summarize Data |
Hourly | Oracle | Collect Instance Statistics |
Hourly | Oracle | Analyze Database Behavior (SmarTune) |
Hourly | SQL Server | Collect DB File Statistics |
Slice | Oracle | Load Data |
Slice | Web | Load Data |
Slice | SQL Server | Load Data |
Slice | SQL Server | Collect Instance Statistics |
Slice | SQL Server | Explain New Statements |
Slice | Sybase | Load Data |
Slice | Sybase | Collect Instance Statistics |
Slice | Sybase | Explain New Statements |
Slice | Sybase Replication Server | Load Data |
Slice | SAP | Load Data |
Slice | WebSphere MQ | Load Data |
Slice | Tuxedo | Load Data |
Slice | Oracle Applications | Load Data |
Slice | Network | Load Data |
Slice | Operating System | Load Data |
Slice | Insight SmartLink | Load Data |
...
The following table lists processes that cannot be scheduled per instance.
...
Technology | Process |
---|---|
PMDB | Calculate Baselines |
SAP | Organizational Mapping |
WebSphere MQ | Load Data |
Tuxedo | Load Data |
Oracle Applications | Load Data |
Other | Load Data |
To schedule a process
- Select a process in the Main area table and click Scheduling.
- In the Scheduling dialog box, perform any of the following tasks:
- Clear the Run this process in the PMDB check box to disable the process. This action removes the process from the PMDB Scheduler, but you can still run the process manually. See Manually running a process.
- Change the time that the process is scheduled to run. Each process runs at a predefined interval by default: Every 15 minutes (slice), hourly, daily, or weekly. You cannot change this interval, but you can set the exact time that the process runs, for example every 2 hours, 15 minutes after the hour.
- Schedule the process per instance (only available for some processes). This mechanism lets you perform the following tasks:
- Disable a process for a specific instance by clearing the relevant check box in the first table column.
- Set the interval of an instance within the process. For example, if you set the Run Every... column to 2, the instance executes every 2 minutes (or other) run of the process.
- Click OK.
...
- Select an instance in the Main area table and click Processes.
- In the PMDB Processes dialog box, the top table lists all processes involved in loading information for this instance. Select the process you want to focus on, such as a process that failed during its last run (indicated by the status icon).
The last run of this process affects the bottom table populated with detailed information on the PMDB tables. If an error occurred, focus on the details in the Error Message column. - Investigate all relevant data. Then click Close.
...