(Mary Hayes Weier) When banks, retailers, hospitals, and other businesses talk about allowing access to data internally and with partners, they’re often talking about their customers’ personal data: addresses, phone numbers, Social Security numbers, etc. At IBM, distinguished engineer Jeff Jonas has

(Carolyn Henry, Leila Johannesen, Don Langworthy and Patti Tonello) This article highlights the integration between IBM DB2 Change Management Expert, IBM’s newest tool for database change management, and Rational Data Architect. You’ll learn about the common look and feel, the strengths of each prod

(Kevin Forsythe) One of the weak links in IBM’s SQL support is the lack of an ad hoc “RUNSQL” type of command that lets us easily execute an SQL statement from a command line or from within a CL program. However, programmers who are so inclined can fill in this gap by writing just a little code of t

(Noureddine Brahimi) This article guides you through a Siebel 7 database environment upgrade from DB2 UDB Version 8 to DB2 9. You’ll walk through the necessary steps and learn the tools and commands that you will need to accomplish the migration.

(Craig Mullins) Here is another quick post in my series on new features in DB2 9 for z/OS.

(Stephen Swoyer) As many a grey-haired IT pro will tell you, the mainframe isn’t dead. In fact—and if recent market research is a reliable indicator—the mainframe has experienced a comeback of sorts: Big Time. Mainframe revenues are up, mainframe processing capacity (measured in MIPS) is at an all-t

(Marion Behnen, Patrick Titzler and Hoi Yoo) The IBM DB2 Data Warehouse Edition (DWE) Administration Console provides a WebSphere Application Server (WAS) web-based user interface for common SQL Warehousing administration tasks, such as configuration, execution, progress monitoring and execution st

(Willie Favero) Have you heard about Optimization Service Center for DB2 for z/OS or OSC for short? This new tool has been demo’ed at a few of the conferences. If you haven’t had the chance to experience this latest no cost tool from IBM for DB2 for z/OS, you need to. This thing is like Visual Expla

(Abhishek Mathur) Learn about a new wizard coming in the new version of IBM Informix Dynamic Server (IDS), code-named “Cheetah” — customize install options to pick and choose the features and functions you want, enabling you to minimize the footprint and control the install with much greater granul

(Craig Mullins) With this blog entry I am introducing a new series in which I will briefly blog about the new feature of DB2 9 for z/OS. Today’s entry will cover the new INTERSECT and EXCEPT keywords