New Features in Brother-Panther® 6.1 for DB2 LUW

Supported Platforms

Database Servers

• DB2 9.5, 9.7, 9.8
• DB2 10, 10.5, 10.5.4

Database Server
Operating Systems

• Red Hat Linux ES/AS 3, 4, 5 (64 bit)
• Red Hat and SUSE z/Linux
• IBM AIX 5.2, 5.3, 6.1, 7.1
• Sun Solaris 8, 9, or 10 (SPARC)
• Microsoft Windows® 2003 (64 bit)
• Microsoft XP Pro SP2 (64 bit)
• Microsoft Windows® Vista 64 bit
• Microsoft Windows 7® 64 bit
• Microsoft Windows 8.1® 64 bit
• Microsoft Windows Server 2012® 64 bit
• Don't see yours here? Let us know

Client Requirements

• Microsoft Windows 2003 (32 bit), Microsoft XP Pro (32 bit), Microsoft Vista 32/64 bit, Microsoft Windows 7 64 bit
• Microsoft Windows 8.1® 64 bit
• Microsoft Windows Server 2012® 64 bit
• DB2 LUW V9.5 Runtime Client or later
• Microsoft IE 6.x or later is required for accessing online help
• Microsoft Windows .Net Framework 2.0. If this is not installed, the DBI Admin Console will optionally install this component
• Adobe Reader v7 or later is required to view PDF reports

Please consult the product release notes for complete details "Ready for BLU!" Brother-Panther adds full support for DB2 V10.5, plus adds a number of exciting customer requested enhancements.

Stored Procedure Performance

No longer are poorly performing statements contained within procedures hidden from analysis! For DB2 v9.7.5 and above, this release captures procedure statement performance data and stores it in the repository for subsequent display and analysis.

New Current Activity Displays

Sometimes a DBA just needs to see what is happening now and resolve issues in real time... With this release you can view the current application, SQL, and locking activity for any monitored DB2 database, version 9.7.5 and above. These displays are easily accessible off the main DB Score panel.

Lock Contention

With this display you can clearly see any locking contention in a database and take steps to resolve them in real-time.

SQL Activity

This display allows you to see what SQL statements are currently running and take steps to analyze and improve their performance. The information can be displayed in one of three ways - by CPU consumption, I/O resource usage, and by execution time. The display can be configured to auto-refresh as well.

Applications

This display allows you to see what applications are currently running in a database. In addition you can see what SQL statement is being executed by an application and take steps to analyze and improve its performance. The display can be configured to auto-refresh as well.

Last Used Default Schema

The default schema that was last specified by a user is now remembered and used in subsequent explains and physical design requests. A default schema is saved for each database and is unique to each user of the product.

New DBM and DB Configuration Displays

Two new tabs have been added to the profile configuration panel to show current database manager and database configuration settings for a selected database.

Fast Path to Statement Compare from Database Compare

Added the ability to traverse from the "Database Compare Workload" panel directly to the "Statement Compare Workload" panel for the same timeframes. This eliminates the need to re-enter the before and sfter timeframes for the statement compare panel.

Multi-User Workspace Enhancement

Multiple employees sharing the same secure machine will have their user-specific settings respected. This is typically useful in environments using Citrix.

New Edit functions for Execute SQL Panel

The Execute SQL editor has been enhanced to include useful edit functions.

Thank you

Thanks for taking a look at Brother-Panther's latest enhancements. CLICK HERE to return to Brother-Panther's product page.