Like other retailers, Dillard’s faces the challenge of processing transactions that require complex information about pricing, promotional offers, and loyalty discounts. If its mainframe-based IBM® DB2® database can’t deliver fast, real-time performance for online and in-store sales—especially during holidays and other busy sales periods—quality of service and customer satisfaction can suffer.
Dillard’s uses BMC Database Performance for DB2 and BMC System Performance for DB2 to monitor DB2 systems, detect performance problems, and alert the IT staff to take corrective action before outages occur. The staff used the BMC APPTUNE component to create a “top 20” list of transactions that were the biggest consumers of MIPS.
BMC SQL Performance for DB2 helps the staff identify poorly performing SQL quickly and easily. The staff has dramatically reduced the number of MIPS used to free computing power for complex transactions while postponing costly mainframe upgrades.
“By regularly using the BMC solutions to identify the top consumers of MIPS, we’ve been able to prioritize our efforts and start with the ones that would have the biggest impact on CPU consumption. Our developers use the tool more because the interface is so easy to work with.”— Marc Tougaw, DB2 Systems Programmer, Dillard’s
简化 SQL 以改进 DB2 应用的可用性和性能了解更多
实现综合控制，优化整个 DB2 环境的性能了解更多
集中控制，最大限度提高 CICS 子系统的效率了解更多