Case Study: ATPCO achieves dramatic DB2 productivity gains with BMC Software

ATPCO manages airfares for 460+ airlines and optimizes its databases with advanced automation

ATPCO, which manages airfares for more than 460 airlines (representing the vast majority of scheduled commercial air travel), faced the challenge of maintaining and synchronizing massive, rapidly changing DB2 databases—handling as many as five million fare and rule changes daily across multiple growing environments—while ensuring high transaction throughput and reliable data distribution.

BMC Catalog Manager for DB2 and BMC Change Manager for DB2 automated catalog and change processes, enabling DBAs to complete structure changes 7.5× faster, drop/create objects 30× faster, perform structure comparisons up to 120× faster and clone databases 320× faster; moves between development, test, and production now take minutes, with an estimated 60% productivity gain for data architecture and DBA teams.

ATPCO

Dave Pichosky

Manager of Data Architecture