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
Améliorez la disponibilité et les performances de vos applications DB2 en rationalisant vos instructions SQLEn savoir plus
Optimisez et automatisez vos processus de réorganisation et de maintenanceEn savoir plus
Contrôles consolidés pour l'optimisation des performances dans votre environnement DB2En savoir plus
Contrôle centralisé pour augmenter au maximum l'efficacité de vos sous-systèmes CICSEn savoir plus