(Heather Havenstein) IBM overhauled its approach to business intelligence by adding analysis capabilities to its data warehouse and unveiling BI appliances for small and midsize companies.

(Willie Favero) I still get questions about DB2 V8 and DFSORT. I posted a couple of times about this way back on 08/01/2005 and 09/11/2005. One of the short comings of a blog, you are only reminded about the most current entries. Things that were posted months ago tend to be “out of sight, out of

(Martin Packer) Twice the “128GB” question has come up in newsgroups (the latest in DB2-L). This sort of thing freaks people out – so let me tell you what I know of the matter…

(Willie Favero) Just think, you thought you wouldn’t have anything to do this weekend. Thank goodness the DB2 lab has made all of the DB2 9 for z/OS documentation available for download from the web. Now you can spend Saturday and Sunday downloading the PDF versions of all of the latest manuals and

(Donald E. Payne) Learn how IBM DB2 parses XML, handles whitespace, and serializes XML, and see how document encoding and client data type affect parsing and serialization. Learn, also, how DB2 validates XML against an XML schema as well as how to use SQL/XML functions to “shred” XML to relational d

(Joachim Dagerot) IBM WebSphere Portal is bundled with a number of useful portlets for external connections, integration, and Internet/intranet tools. But sometimes your needs go beyond what these bundled portlets can accommodate, and you have to build your own portlet. By comparing the design techn

(Willie Favero) You may have noticed that I have started to post some details about DB2 9 for z/OS. With the GA this Friday, I guess I can assume all is now fair game. So expect to see a bunch of stuff here discussing some of the less talked about features of DB2 9. In fact, if you have heard […]

(Hernando Bedoya, Jaime Gaug, James Kerlk, Ser Ser NG and Jose Cardoso dos Santos) The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server’s resources by minimizing network traffic, disk I/O, and CPU time. (pdf)

(Kent Milligan) When using SQL to create DB2 for i5/OS tables that will be accessed by non-SQL interfaces, such as RPG native interfaces, you need to consider the record format name generated by DB2. By default, the record format name for an SQL created table is identical to the table (or file) name

(Whei-Jen Chen, Chandramouli Chandrasekaran, Don Gneiting, Gustavo Castro, Paul Descovich and Tomohiro Iwahashi) As organizations strive to do more with less, IBM DB2 for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions b