(Roger Miller) Customers are migrating more quickly to DB2 9 this year. The DB2 9 value is helpful for most customers, and the migration experience has been positive. Migration is a broad topic, so I’ll emphasize some keys to success, point to many resources, emphasize some important points and pr

(Troy Coleman) For years I worked as a consultant for numerous companies. While managing databases supporting banks and health insurers, I had full access to sensitive production data. I could view financial data about my neighbors and friends. I could see personal health information about myself an

(Li Long Chen, Ravi Mani, Elaine Zhan, Chuan Yang and Lin Zhi Zou) The IBM WebSphere Application Server Feature Pack for Web 2.0 provides a rich set of components that enable developers to easily and more efficiently build powerful Ajax-based applications. This article explains how you can build a W

(Imran Sayed) In this post I would like to introduce some of the added features of 9.7 (courtesy Drew Bradstock):-

(Susan Visser) We’re going to talk about Index Design Best Practices for both DB2 LUW and Oracle! So far we have one special guest lined up: Curt Triplett is an Independent Oracle Consultant specializing in Oracle performance optimization (amongst many other things). We’re going to look at Oracle In

(Albert Yao and Dimple Bhatia) This series of articles introduces the IBM InfoSphere Warehouse Administration Console 9.7, which is part of the IBM InfoSphere Warehouse product. The InfoSphere Warehouse Administration Console provides an integrated Web portal to administer, monitor, and configure re

(Craig Mullins) Application developers frequently need to retrieve a limited number of qualifying rows from a table. For example, maybe you need to list the top ten best selling items from inventory, or a list of the top five most expensive products (i.e., highest price tag). There are several ways

(Willie Favero) After saying that out loud, I’m sure if you’ll find that a good thing or a bad thing… LOL

(Praveen R. Sogalad) IBM DB2 Driver for JDBC and SQLJ has a datasource property called useRowsetCursor. The default value for this property is true, which means the driver will always try to use multi-row fetch (MRF) for scrollable cursors if the server supports it. This property allows the applicat

(Willie Favero) A few months back (May 15, 2009 to be exact), I did a compression post (Compression on DB2 for z/OS ) soliciting information from you, my readers. I was interested at that time in what kind of compression companies were achieving with DB2 for z/OS so I could brag about it during my I