"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.