(Petrus Chan) This article discusses how to write SQL queries to find foreign key relationships in IBM DB2 for Linux, UNIX, and Windows database. Given a table with a primary key, you will learn how to return the children and descendant tables, as well as the referential integrity (RI) relationship

(Scott Hayes) 97% of our studio audience learned something! Berni’s life has been all about DB2 performance since 1988. During today’s show, Berni generously shared the latest DB2 10 performance news, tips, and insights with our audience.

(Ember Crooks) I work on a team of DBAs, and we will frequently talk through an issue together to find the root cause. We are all capable of getting there on our own, but sometimes we realize that we’re not seeing something or think one of the others might see an issue faster.

(Dave Beulke) While doing DB2 performance reviews for clients over the years, I’ve discovered that many times their projects are using Hibernate as their DB2 Object Relational Mapping (ORM) interface. While DB2 and Hibernate can produce tremendous performance there are many best practices to achiev

(Thuan Bui) This article is continued from Part 1, which discussed adaptive compression and temporal tables.

(Sonali Surange and Anju Bansal) Machine logs from diverse sources are generated in an enterprise in voluminous quantities. IBM Accelerator for Machine Data Analytics simplifies the task of implementation required so analysis of semi-structured, unstructured or structured textual data is accelerated

(Troy Coleman) Recognizing 30 years of DB2, IBM has produced a book, “IBM DB2: The Past, Present & Future.” Having read the document myself, I’ll relay a few highlights.

(Gene Cobb) In 2012, IBM i Technology Refresh 5 (TR5) was made generally available. If you’re not familiar with the IBM i Technology Refresh approach, think of it as a way for IBM to deliver significant enhancements in between the regular operating system version/release/modification cycles.

(Amol D. Barsagade) Information assets are key to day-to-day business. They are also a huge source of institutional value and intellectual property that must be preserved, extended, and repurposed as the systems underpinning them change. Given the current business environment, migration has taken on

(Kimberly Madia) It is not surprising to see that high-ranking executives are gaining awareness of data privacy concerns. In today’s hyper-connected world, information protection is expanding beyond the technical realm and becoming a strategic, enterprise-wide priority—and it takes only a glance at