Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

BMC supercharges IBM DB2 for mainframes

Joab Jackson, IDG News Service | April 8, 2011
Exploiting recent hardware enhancements that IBM added into its System z mainframe servers, enterprise software provider BMC has updated its line of performance tuning products to help customers get more from the latest version of the DB2 database.

"We can get day-by-day answers, which we never had the ability to do before," said Bob Goodman, the hospital's senior database administrator.

With the installation, the hospital will also deploy a number of the newly upgraded BMC products, such as MainView for DB2.

MainView will come in handy for troubleshooting the data warehouse, Goodman said. The data warehouse will field a lot of dynamic queries, or unique queries that haven't already been optimized for repeated use. "MainView gives the ability to actually look at dynamic SQL," Goodman said.

He explained that MainView, unlike most monitors he has worked with in the past, offers the option of saving a history of SQL calls and the paths they took through the system.

"With MainView, we can go back to [an earlier] connection and look at it. That is a productivity aid for us. We used to have to chase after and figure out what is wrong. Now we can see it," he said.

 

Previous Page  1  2 

Sign up for CIO Asia eNewsletters.