Faster! Faster! Everybody wants their apps and reports to run faster!
Written by Kent Milligan
All of you have users and bosses who regularly ask if it's possible to make applications and reports run faster on your IBM i. Usually, these applications and reports spend a significant amount of time processing data stored in your DB2 for i databases. This article contains seven DB2 for i performance-tuning tips for speeding up the applications and reports running on your IBM i systems.
Senior managers expect IT teams to deliver consistent, high-quality data that creates a single view across the business. But with data stored across multiple databases and platforms, where does this single view reside? Attempting to combine all data into one "logical" database presents major data formatting, transformation, and consistency challenges.
Thousands of active Synon, or CA-2E, applications are still under maintenance around the world. The 4GL had a surge in the late '80s and early '90s, but like so many such tools on all platforms, it had its detractors.