(Whei-Jen Chen and Angela Carlson) Switching database vendors is often considered an exhausting challenge for database administrator and developer. Complexity, total cost, and the risk of downtime are often the reasons that restrain IT decision makers to start the conversion project. The primary goa

(Roger E. Sanders) For database administrators, how well database applications perform is of the utmost importance. One way to significantly speed up the response time of decision support queries is to use materialized query tables (MQTs).

(Troy Coleman) I believe that the future for all DB2 data storage on z/OS is in universal table space (UTS). This may be a strong statement, but as I look at IBM’s major DB2 enhancements over the past few years, they revolve around UTS.

(Shirley Huhtanen) The fact organizations are facing tough economic times is an understatement. Mergers, acquisitions and compliance projects are in the forefront, leaving us minimal time to handle projects, such as conversions, within our limited time and budget. We’re regularly challenged to do mo

(Bill Carpenter) It is the custom in many areas for small shops to keep track of their queued up customers by assigning them sequential numbers in the approximate order in which they arrive. The numbers are typically printed on slips of paper and dispensed from a single physical mechanical dispenser

(Susan Visser) Plenty of books exist, and if you’ve read any of my blog entries, you’ll know that I blog quite frequently about books before they publish, when they publish, or if we have an event around a book. To make it easy for you to keep up to date on the growing collection of books, I encour

(Michael Sansoterra) In Part 1 of this series, I discussed a generic method of passing a delimited set of text records in CSV (comma separated variable) format into a single stored procedure variable. Once the stored procedure had this text data, a generic Java user-defined table function (UDTF) was

(Antonio Cangiano) There are two main types of scalability: vertical and horizontal. Vertical scalability consists of potentiating the hardware specs of a given server. This is typically done by increasing the number (and to a minor extent, speed) of the processors, adding more RAM, and so on. Commo

(Kevin Foster) You’ve heard a lot here about pureQuery value: better performance, faster development, improved manageability, and increased security. Now we’re making it even easier to purchase pureQuery. We’re announcing two new DB2 Connect offerings that bundle Optim pureQuery Runtime: –DB2 C

(Shawn Moe) Optim Development Studio (ODS) V2.2 and InfoSphere Data Architect (IDA) V7.5.2 include enhancements to provide role-specific support to ensure that your confidential and personally identifiable information is properly privatized when right-sized testing environments are generated. Optim