Embarcadero Performance Center ReadMe

Welcome to Embarcadero® DB Performance Center© 2.7.3

Performance Center Web Site | Embarcadero Technologies Home | Technical Support

Published: December 3, 2010

Thank you for using Embarcadero DB Performance Center, an enterprise DBMS monitoring and performance management system that enables the proactive and reactive monitoring, diagnosis, and management of multiple Oracle, SQL Server, Sybase ASE, and DB2 UDB LUW databases in real time. Embarcadero DB Performance Center is equipped with intelligent diagnostics and expertly designed tuning guidelines; including performance threshold violation detection, alarms, notifications, and powerful reporting mechanisms, all intended to help pinpoint and solve every performance problem you face.

What's New in Version 2.7.3

Support for Windows 7 and Windows Server 2008

Web client support for Firefox and Chrome

Support for IBM DB2 LUW 9.7 and Sybase ASE 15.5

New built-in message logging

Release Notes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in Version 2.7.3

Support for Windows 7 and Windows Server 2008

DB Performance Center can now be installed and run on Microsoft Windows 7 (32-bit or 64-bit) and Server 2008 (32-bit or 64-bit), including Server 2008R2. See Known Issues below for special instructions regarding Oracle connectivity on 64-bit systems.

Web client support for Firefox and Chrome

The web client now works with Mozilla Firefox 3.x and Google Chrome 7, in addition to Internet Explorer 7 and 8. There are no known issues with the web client under the Opera 10 browser, but it is not yet officially supported.

Support for IBM DB2 LUW 9.7 and Sybase ASE 15.5

DB Performance Center has been validated against IBM DB2 LUW 9.7 and Sybase ASE 15.5 for monitoring.

New built-in message logging

DB Performance Center error message component has been rewritten/improved. Logging now uses an internal tool, and message logs are available through the web client. The logging level is configurable with a new parameter in the Server Options dialog.

Release Notes

System Requirements

The following are the minimum hardware and system requirements to run DB Performance Center:

Microsoft Windows (one of):
- Windows 2000 Server
- Windows Server 2003
- Windows XP
- Windows Vista (Aero or Basic)
- Windows Server 2008 (32- or 64-bit)
- Windows 7 (32- or 64-bit)
512 MB of RAM
250 MB of hard disk space (more space is recommended in large environments)
Database vendor-specific middleware for connectivity to repository and monitored data sources

The following are the minimum hardware and system requirements to run DB Performance Center Client:

Microsoft Windows (one of):
- Windows 2000 Server
- Windows Server 2003
- Windows XP
- Windows Vista (Aero or Basic)
- Windows Server 2008 (32- or 64-bit)
- Windows 7 (32- or 64-bit)
64 MB of RAM
75 MB of hard disk space

DBMS Support

DB Performance Center supports the following platforms:

Oracle 8i, 9i, 10g, and 11g
Sybase ASE 12.0, 12.5, 15, 15.5
IBM DB2 for LUW 8.1, 8.2, 9.1, 9.5, and 9.7
Microsoft SQL Server 2000, 2005, and 2008

Known Issues

When installing DB Performance Center on 64-bit versions of Windows, there is a known issue with Oracle, where the client will fail to connect if the application is installed under a path that contains parenthesis characters ("(" or ")"). By default the installer will attempt to install DB Performance Center under "C:\Program Files (x86)", as this is the standard location for 32-bit applications. If you will be monitoring Oracle servers or using an Oracle repository, do not install DB Performance Center under C:\Program Files (x86). Use another path that does not contain parentheses.
When installing DB Performance Center, IIS 7 is not supported and Apache should be used instead.
A known issue causes problems with the installation program. The following measures should be taken if DB Performance Center does not install or uninstall properly:

Problem: Embarcadero DB Performance Center does not uninstall and starts the validation of the DB Performance Center installation.
Solution: Remove the validation key HKEY_CURRENT_USER\Software\Embarcadero\Performance Center\2.6\InstallationOptions\Validator.

Problem: Embarcadero DB Performance Center setup does not install/copy all files. An error message indicates it cannot register a list of DLL files.
Solution: Remove the validation key HKEY_CURRENT_USER\Software\Embarcadero\Performance Center\2.7\InstallationOptions\InstallPreReqReboot.

Problem: Embarcadero DB Performance Center does not install, but opens the uninstall window.
Solution: Remove the uninstall key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{0D57C744-A9F6-4D3D-A86A-C8E45214EBA8}

Problem: Embarcadero DB Performance Center fails to install with unknown causes. Running the installation and uninstallation programs do nothing, and the solutions provided above do not help.
Solution: Follow the steps below:
1. Remove HKEY_CURRENT_USER\Software\Embarcadero\Performance Center from the registry.
2. Delete the shortcut located in Start Menu\Programs\Startup\Server Status.
3. Restart the machine.
4. Stop the 'Embarcadero Performance Center' service.
5. Stop the ETPMonSvc.exe process via Task Manager.
6. Delete all of the files from the Program Files\Performance Center directory.
There is a known issue when attempting to register a DB2 UDB LUW database that is at release level v8.2.0003 and later (v8.1 Fixpack 10 and later). DB Performance Center reports an error when trying to populate the list of available database login IDs. This is a known issue since the introduction of Fixpack 10, and is related to a post-installation task that needs to be performed against the DB2 server. In order to resolve this issue you must follow the post-installation tasks in the DB2 Fixpack ReadMe file related to binding package "db2schema.bnd", and grant access to this package to PUBLIC:
```
db2 BIND <PATH>/db2schema.bnd BLOCKING ALL GRANT PUBLIC sqlerror continue
```
This action only needs to be performed once for every database in the DB2 server, not for all clients.
When installing DB Performance Center using domain user account authentication, do not use a user account that is subject to password change policies. If the password changes, the DB Performance Center service will not restart. Workaround: Uninstall DB Performance Center and reinstall using the new password.
When installing DB Performance Center, if IIS is the default web server, it is strongly recommended that an actual domain user is selected to run the service, and not the Local System account. Also, that user must be in the administrators group.

Bug Fixes

Bugs Fixed in Version 2.7.3
Bug	DBMS	Version	Description
5854	All	All	An error is displayed when the user opens the Operating System page for AIX OS.
5915	DB2, Oracle	All	[Regression] Web Client - for DB2 and Oracle the majority of the tables have a column added so the values doesn't correspond anymore with the column header.
5923	Sybase	All	WEB_CLIENT: Devices under Space screen are overlapped when there are many devices.
5944	DB2	All	Login failure, deployment appears to have failed due to DB2s DPF configuration
5977	Sybase	15	SPACE_PAGE: Sybase database size not correct when database has 8k pagesize.
5993	Sybase	12.5,15	sp_perfcntr_primary returning Arithmetic overflow error for Sybase v12.5 & v15 datasource.
5994	SQL Server	2000	TS: MSSQL2000 - Arithmetic overflow errors when running 'sp_perfcntr_primary'.
5999	SQL Server	2008	Deployment failed for MSSQL 2008 (in 2000 compatibility mode) datasource registration.
6001	SQL Server	2005	Arithmetic overflow when populating session details on MS SQL Server 2005
6003	Oracle	All	Bufferpool usage query (part of primary stored proc) consumes too much CPU
Bugs Fixed in Version 2.7.2
Bug	DBMS	Version	Description
5916	All	All	[Regression] Cannot schedule a report in the future if the Start Time is earlier than the system time.
5925	Sybase	All	Datasource registration drop-down menu is missing Sybase datasources even though SQL.ini and all environmental variables exist for Sybase client.
5931	SQLServer	All	Contention Vital Signs - Number of Deadlocks statistic is incorrect.
5935	All	All	Frequent ping Alerts causing DBAs to be awakened at night although DS is OK.
5937	Oracle	All	CPU goes up from 5% to about 40% when the perfcntr_refresh_primary is run.
5951	Oracle	All	Oracle Statspack Help contains two missing links.
5953	Oracle	All	Change the users waiting query for Oracle 10g and 11g.
Bugs Fixed in Version 2.7.1
Bug	DBMS	Version	Description
5621	All	All	Web client displaying corrupt SQL Server version - should be 2000.
5728	Sybase	All	REPORTS: Report end time not correct - graph is always four hours earlier than specified time.
5742	All	All	Datasource Homepage graphs not correctly reflecting statistic values.
5804	All	All	OS_Monitoring - Linux OS - Processor time incorrectly indicates 114.00% and 1218.00%.
5805	Sybase	All	OS_Monitoring - Linux OS - Modify Conflicts value incorrectly indicates 158.00%.
5806	All	All	Closing PC Client causes multiple Application errors.
5853	All	All	If a Scheduled Task with same name does exist, that report can be overwritten or renamed instead of cancelling the Report creation..
5874	Oracle	All	The Oracle Rollback Contention Ratio is always at 100%.
5878	All	All	When registering a datasource through Start -> Programs -> Performance Center -> Register Datasource on a brand new repository, this doesn't work.
5885	All	All	OS_Monitoring: I/O Devices all zero (SAN in use).
5886	All	All	OS_Monitoring: Disk space free - file system device names should use mount name.
5887	All	All	OS_Monitoring: Network - Loopback values are exponential numbers.
5888	All	All	OS_Monitoring: Network values - too many decimal places.
5892	All	All	Report: Change title "Worst Databases" report to "Worst Datasources".
Bugs Fixed in Version 2.7
Bug	DBMS	Version	Description
574	All	All	Manage with DBArtisan not functioning when DBArtisan is not running.
589	Oracle	All	PC 196 BUG - The customer's Oracle datasources take a long time for the data to get populated. Sometimes it is an hour or more after starting up the DB Performance Center Client.
637	All	All	Would like ability to avoid duplicate email notifications.
1972	All	All	Would like to be able to get a notification when an alert has been cleared.
2289	SQL Server	All	DB Performance Center is generating blocks on a production server.
2809	All	All	Customer is having issues sending notifications to Tivoli, which in turn sends information to their notification system.
4099	All	All	OS_MONITORING: Linux OS - Processor time is 10600.00%.
4100	All	All	OS_MONITORING: Linux OS - CPU Utilization time at 1600% and 9000%.
4102	All	All	REPORTS: Unable to run reports due to baseline date discrepancy.
4120	Sybase	All	Web client - datasource page not updated since datasource was disabled and re-enabled.
4121	All	All	INSTALL: Down datasource being incorrectly reflected as "up and connected".
4148	SQL Server	All	INSTALL: Have to manually restart DB Performance Center after installation to successfully connect to Repository.
4156	Sybase	All	HOME_PAGE: Sybase "Large I/O hit rate" value is incorrect.
4817	All	All	DB Performance Center shuts down frequently.
5623	All	All	User was forwarded email message from EPC indicating a licensing issue - data appears to be lost and the PC service restarts.
5719	All	All	OS_Monitoring - Linux OS: Processor time incorrectly indicates 4600.00%.
5720	Sybase	All	Contention page shows several statistics > 100%.
Bugs Fixed in Version 2.6.2
Bug	DBMS	Version	Description
4093	All	All	Getting an error "Exception caught: Number: -2147467259 Source: Description LastDllError()" during the installation of DB Performance Center.
5600	All	All	Getting 0 datasources when using a trial license
Bugs Fixed in Version 2.6.1
Bug	DBMS	Version	Description
4101	All	All	DATASOURCE_REGISTRATION: Registered new DS not displayed until DB Performance Center is restarted.
4205	All	All	No scroll bar appears in Web Client when there are many data sources and the Web Client is maximized.
4801	All	All	OS Monitoring continues after datasource is disabled.
4953	All	All	Chart graph from previous Historical report used when new report is generated.
4954	All	All	Export Report options not available in 2.5.2 Historical Reports.
5077	All	All	Cannot add periods to Enterprise Database Availability Comparison to Baseline report.
4254	Oracle	10g	ALERTS: Deadlock violated threshold of 0 with a value of 3.28947368421053E-03.
4774	Oracle	10g	Statistic "Free memory" SQL not correct for Oracle 10 sga_target - returns error.
4792	Sybase	12.5	WEB_CLIENT: Graphs are not automatically refreshed.
4795	Sybase	12.5	WEB_CLIENT: All values/graphs seem to increase all the time.
Bugs Fixed in Version 2.6
Bug	DBMS	Version	Description
4110	All	All	Home Page: Error "[DATAABS-3092] Unable to acquire statistic value for stat id".
4179	All	All	CLNTSERV and CLTRTER errors when right-clicking datasource and selecting threshold.
3241	All	All	Web Client crashes every night - have to restart Apache and DB Performance Center.
3715	DB2	V9	PC250 3509: No data is being stored in the Repository database.
4558	Oracle	All	Getting an error when trying to register an Oracle database "Failed to initialize OCI Layer".
4217	Oracle	All	Contention Health Index always shows 0% on all datasources.
3368	Oracle	All	DATASOURCE: Many CLTRTER-3106 & CLTRTER-3118 data conversion errors.
3369	Oracle	All	Error SFTTREE-3025 when attempting to drill down into Memory, I/O, and Users tabs.
2178	SQL Server	All	Stored Procedures getting overwritten constantly.
4134	SQL Server	All	Client is taking an hour or more to start and display in a large monitoring environment of a 100 plus datasources.
2112	SQL Server	All	Proc Plan Hit Ratio and Adhoc SQL Hit Ratio are incorrectly showing a NULL.
2177	SQL Server	All	REQ-4019 Cannot deploy the objects to datasource.

Additional Resources

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. See the steps outlined below to license DB Performance Center. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] and [email protected] for sales in the EMEA and Asia-Pacific regions, respectively.

Licensing DB Performance Center

To license the product, take the following steps:

You can install the DB Performance Center Server and Client or only install the DB Performance Center Client using the MSI installation.
During installation of the DB Performance Center Server, you will be prompted to register a valid serial number.
NOTE: To register DB Performance Center, you need a valid serial number and an active Embarcadero Developer Network (EDN) account. This also applies to the Trial version of DB Performance Center.
Enter the Serial Number and the EDN account number into the correct fields in the DB Performance Center Server Registration dialog and click Register.
If you purchased a DB Performance Center Server license with 50 datasource registrations, you will be able to launch the client from the final page of the installer (or from the start menu at Start > Programs > Embarcadero DB Performance Center 2.7.3 > Performance Center) and begin working with DB Performance Center.
If you have purchased a datasource registration add-on, you must register it separately in the License Manager:
1. From the DB Performance Center client (running on the same machine as the server), open the About... dialog from the Help menu.
2. From the Embarcadero Product License Manager dialog select Serial and then click Add to enter the valid serial number for the data source add-on. The newly added serial number is listed on the Unregistered Serial Numbers node.
3. Expand the Unregistered Numbers node, right-click on the newly entered serial number, and select Register.
4. The Embarcadero Product Registration dialog appears. Enter the correct DN account to register the serial number for the server.

Embarcadero Technologies Product Support

The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit http://www.embarcadero.com/support/index.php, or click any of the links below, to find:

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.

Embarcadero Technologies on the Web

To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at http://www.embarcadero.com/.