(Carlton Doe) In mid-2007, IBM unleashed the fastest cat in the data server world: Informix Dynamic Server (IDS) 11, code-named “Cheetah.” That release strengthened and enhanced IDS’s legendary ease of use with a wide range of additions to its autonomic system-management capabilities, including a fl

(Terry Frangos) There you are merrily going about your DB2 LUW work when you have to call in to get some assistance on a problem you’ve encountered. Little do you know that the first words you may hear from a support analyst are, “That version of DB2 is out of support”

(Troy Coleman) As a database administrator (DBA), I find it’s important to review what’s new in each release of DB2* and see how these new features can be used to improve the performance, availability and maintenance of the data. It’s important to also understand your business and the requirements o

(Willie Favero) IDUG North America 2008 ended a few weeks ago. This conference, like IOD and SHARE before it, had lots of topics on DB2 for z/OS. Craig, Troy, and I have all been blogging about DB2 9 and there have been plenty of articles published on the subject. Now that lots of information descri

(Nelson King) Storing XML data in a relational database brings reliability, manageability, and other RDBMS strengths. But with clumsy storage methods (like shredding and CLOBs), application performance was once an open question. Two years after IBM introduced pureXML in DB2 9, that question has been

(Troy Coleman) I recently needed to find the description and layout of IFCID 184. After spending an hour or so futilely pulling up different DB2 V9 manuals in PDF format and searching for IFCID, I sent a message to my friend Roger Miller. His reply? Check the DB2 Information Center.

(Paul Zikopoulos) In a previous set of articles, I showed you all the great integration features between the IBM DB2 9 for Linux, UNIX, and Windows (DB2 9) data server and Microsoft Visual Studio 2005. In another series, I showed you the integration between DB2 and Visual Studio 2003. Quite simply,

(Jarek Miszczyk) The graphical interface used to manage all aspects of System i operations has recently quite dramatically evolved. In addition to the traditional Windows client, you now have the ability to perform most of the tasks through a Web browser. Although System i Access for Web has quite i

(Pavan K. Al) WPAR (Workload Partition) is a licensed program product shipped with IBM AIX 610. Tthis article teaches WPAR concepts and configurations. By following the examples in this article, you will be able to install and configure DB2 on a system and application WPAR.

(Scott Hayes) It is an unfortunate reality that the database and the DBA are too often presumed guilty by default. Everyone tends to want to blame the database first, even though performance degradation could be caused by network problems, storage problems, the Web server, sun spots, or poor applica