(Anita Corcoran) In a previous Tech Tip, “Use a Stored Procedure as Your Data Source in DB2 Web Query for i,” I discussed using a stored procedure as the data source in DB2 Web Query for i. Using a stored procedure as your data source offers many benefits to you as a developer:
Tag: IBM
IBM InfoSphere DataStage and DB2 pureXML, Part 1: Integrate XML operational data into a data warehouse
(Branislav Barnak, Amir Bar-or, Cynthia M. Saracco and Paul Stanley) It’s no secret: XML is everywhere. Web-based applications, service-oriented architectures (SOA), and industry-specific data exchange formats all rely heavily on XML to represent critical business data. This growing use of XML is pr
Approaches to Access Path Management
(Craig Mullins) BIND and REBIND are important components in assuring efficient DB2 applications. Because the BIND/REBIND process determines exactly how your DB2 data is accessed, it is important that you develop an appropriate strategy for when and how to REBIND your programs.
APAR Friday: And you thought it was gone… (smile)
(Willie Favero) Once again, I have APARs to discuss; not that there weren’t any APARs out there for the last few months or so. It’s just that now there a couple that sound interesting. And if that’s not enough, I even had a few requests to bring APAR Friday back. By popular demand (sort of) here it
Configure WebSphere Business Monitor for high throughput and performance
(Torsten Wilms) This article provides performance tuning guidelines for IBM WebSphere Business Monitor V6.1 (hereafter referred to as Monitor). It discusses best practices for development and configuration, and describes tuning parameters for Monitor components that have the most impact on throughpu
DB2 Gets More Bite With COBRA
(Julian Stuhler) IBM has been making huge technical strides with their flagship database, DB2, over the past few years. As expected, the recent launch of DB2 9.7 has not failed to impress, incorporating even more improvements.
Approaches to DB2 Tuning: What’s the Best Use of Your Time?
(Lockwood Lyon) Assume you’ve been given a directive by IT management to “tune” things. What strategies are available and how do you judge which ones are best? Considering the current economic climate, can any be implemented on a shoestring budget? Can any of these tasks be assigned to resources wit
Loading a large volume of Master Data Management data quickly
(Neeraj Singh and Yongli An) The Rapid Deployment Package (RDP) for IBM InfoSphere™ Master Data Management (MDM) Server solution is built to address the needs of clients in the first phase of implementing initial load solutions. At this stage, clients deploy InfoSphere MDM Server for master data man
DB2 9.7: Moving to DB2 is Easy
This video highlights some of the new features in DB2 9.7 that make it very easy to enable Oracle applications to DB2. It includes demos for features like support for PL/SQL, CLP Plus, the free IBM Data Movement tool, and Optim Development studio for debugging. (video)
Performance Features in DB2 V9 for z/OS – Part 6
(Dave Beulke) As I talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these features can really benefit your standard DBA operations and improve application performance and overall availability of your systems and data.
