(Keith McDonald) Today’s topic is db2top’s Federation screen. Federation is a technology that allows you to build a heterogeneous set of database management systems into a single interface without requiring you to move all your data into one database. DB2 for LUW federation lets you query and perfor

(Willie Favero) By now I am sure you are all aware that DB2 9 combined its sort work file space and temp space (used for declared global temporary tables) to both use only the work files. It was a great idea that should have simplified a bunch of stuff in DB2. However, you are probably also aware th

(Troy Coleman) Using DB2 enforced referential integrity (DB2 RI) can be a good choice, but it depends on what you’re trying to accomplish. You’d typically avoid defining DB2 RI on a table that’s linked to a code table (e.g., state code).

(Keith McDonald) A colleague of mine asked me the other day if I knew whether db2top reported storage path information anywhere. He knew that the information was being read from the snapshots but couldn’t see it anywhere in the db2top interface. My first thought was that the table spaces screen migh

(Dhanashri Kudgavkar and Prasanna Alur Mathada) IBM Informix Dynamic Server, with its copious feature set, meets or exceeds expectations for a high-performing, scalable, reliable, maintainable database server for enterprise applications. However, if you need to segregate older data and maintain it i

(Kate Dawson) IDUG has just announced a brand new contest for DB2 fans this Spring, titled “Do you DB2”. You can win great prizes such as a WiFI enabled HD TV from Vizio or an Apple iPad by telling IDUG your best DB2 stories.

(Dave Beulke) Whether you are currently using DB2 Version 8 or Version 9, getting ready for all the CPU efficiencies in DB2 10 is easy. Your company may not be thinking about migrating to DB2 10 for a couple of more years, but DB2 10 is going to get huge industry wide support once the cost savings b

(Kyle Brown, Stacy Joines, Hiroshi Yamamoto and Billy Newport) Data is the central element of all computing systems, which exist to manage, mine, and manipulate data. In the Internet age, applications demand not only immediate access to data, but they also often attempt this access in a crushing wav

(Susan Visser) Don’t you love it when there is a conference that is local to your home or office? Well, at least this one is local to me… maybe not for you, but I hope you can come and enjoy our lovely city!

(Keith McDonald) HADR stands for High Availability Disaster Recovery. It is a technology that protects your database against data loss and allows it to be highly available even when you have a partial or complete site failure. It does this by replicating data changes from one database, called the pr