(Sheryl Larsen) Performance is measured by response time, throughput, peak response time, hits, and sessions per second. SQL coding and tuning techniques directly impact performance. Developing high performing DB2 applications on any platform requires an understanding of the techniques that best wor

(Deb Landon, Celestyna Baranska, Wilfried Blankertz, Javier Galvez, Kim Greene, Frode Langmoen, Mark Owusu-ansah and John Taylor) IBM Workplace Services Express is software that makes it simple for you, your colleagues, your teams, and your entire organization to quickly collaborate and effectively

(Willie Favero) NOT !!!!! I was doing a presentation at a conference last year that covered DB2 packages. It was kind of like a reintroduction to packages with a little “what’s new” aded it, or at least that was my intent. I have done this presentation in its various forms quite a few times over

(Mary Taylor and Li (Tony) Wei) The ability for a company to integrate multiple repositories of customer data to provide a “single view of the customer” is critical for effective Service-Oriented Architecture (SOA) transformations. WebSphere Customer Center (WCC), a building block for solutions, pro

(Paul Zikopoulos) Without a doubt, Microsoft Excel, is the world’s most ubiquitous reporting and data analysis tool. Quite often I see clients export massive amounts of data from their enterprise systems into another data server (guess which one) for the sole purpose of supporting Excel reporting.

(Bill Arledge and Judy Quenet) DB2 for z/OS incorporates unique relational characteristics with traditional database capabilities, including robust locking mechanisms that ensure data integrity while maximizing concurrency for the world’s most sophisticated DB2 applications. DB2 locking is a broad

(Marty Lurie and Aron Y. Lurie) Google’s new Maps API Version 2 allows for more advanced mashup applications. In this article, you’ll graduate from the basic mashup development explained in Part 1 of this series and see how to use the DB2 REC2XML function to eliminate lines of code from the PHP: Hyp

(Paolo Bruni, Roy Cornford, Rafael Garcia, Sabine Kaschta and Ravi Kumar) This book introduces the enhancements made available with DB2 9 for z/OS. Its helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities. (pdf)

(Willie Favero) My second podcast discussing upgrading to DB2 for z/OS Version 8 has just been posted on IDUG’s web site. If this sounds interesting, you can download it at DB2 for z/OS V8 Migration Issues (Part 2). IDUG also has a subscription service so you can set up an RSS feed for future podca

(Jim Flanagan and Shantan Kethireddy) The story in this column illustrates a methodology DBAs can use to solve SQL query performance issues in DB2 for i5/OS V5R4 when crucial evidence is missing.