(Prasad Mujumdar) Using an index on Informix Dynamic Server (IDS) row-type columns speeds queries significantly, but isn’t possible with normal indexing mechanisms. I’ll show you some techniques that enable indexing for this powerful data type.

(Mark Fontecchio) The bloggers over at iDevelop recommend updating your DB2 lingo so all the Oracle and SQL Server folks dont think youre from the 1970s.

(Philip Howard) A couple of months ago I reported on the announcement of IBM InfoSphere Streams as the company’s high end (complex) event processing platform. I also described IBM’s approach to event processing more generally. I did this on the assumption that the one day conference I attended was t

(Abhinay Nagpal, Eldho Mathew and Gaurav Mehrotra) IBM DB2 clusters on virtual machines (Xen) enable you to reap the benefits of utility computing and high availability. Virtual machines have become a key requirement for many enterprises. They help reduce the total cost of ownership and can be lever

(Willie Favero) A question I seem to get all too often is “When is Version 8 going out of service”. I never really know exactly what to say, at least until now. Although I still don’t know when V8 will go out of service (often referred to as EoS), I can tell you when end of marketing of DB2 for […]

Our user dr_te_z has shared a cool way of monitoring db2 databases/instances running on Windows environments using db2top utility. Thanks dr_te_z for sharing this wonderful tip:

(Ronny Bartsch, Susan Malaika and Christian Pichler) This article describes how to build a complete IBM DB2 application in a day using an end-to-end XML architecture. The latter means that XML is used for storing, viewing, and manipulating information. The application may be shown to colleagues and

(Daniel Krook) I recently compared two DB2 databases that should have been identical, but for some reason were not. The foreign keys were missing from one of the instances.

(Fay Wang, Catalina Wei, David Wisneski and Asim Singh) IBM WebSphere Application Server V7 delivers an enhancement to its implementation of the Java Persistence API (JPA) to enable optimization of data access to IBM DB2 data servers for enhanced security, and the potential to significantly reduce o

(Roger E. Sanders) I’ve noticed in my seven years in the storage industry that DBAs often rely on a storage administrator to give them the space they need when deploying a DB2 database in network attached storage (NAS) or storage area network (SAN) environment. Unfortunately, few storage administrat