(Marichu Scanlon) This article discusses the system-related tasks that you, as a DB2 for z/OS V8 or V9 user, should consider when utilizing the functions in Developer Workbench (DWB). It provides an overview of DWB, then discusses customization JCLs, RACFs, and migration considerations. Finally, you

(Philip Nelson) I’m writing this in the departure lounge at San Francisco airport, on the way home from this year’s IDUG (International DB2 User Group) North American conference.

(Stephen B. Morris) If Derby were the only product to come out of the open source arena, I think I’d be happy with that! That’s an exaggeration of course, but it points to the importance of Derby. Database technology has traditionally occupied an exalted and expensive position in the world of softwa

(Evan C. Lee) Learn how to optimize your queries for the best possible performance when accessing multiple Informix servers. In this article, you’ll learn to read the optimizer’s Explain output and understand how Informix processes distributed queries. You’ll learn to recognize inefficiencies in a q

(Rebecca Bond) When we think about security, we often mention the term “security in depth.” Layer after layer, we build our security architecture attempting to achieve a robust defense mechanism. We put in firewalls, build access control lists, devise elaborate intrusion detection schemes, enforce

(Kevin Forsythe) If you’ve braved the intimidating unknowns of creating stored procedures, you’ve probably learned that support for them in IBM’s STRSQL command is limited. You can call a stored procedure only if it does not return a parameter or a result set.

(Li-Fang Lee, Wayne Rosario and Soloman Barghouthi) IBM DB2 High Availability Disaster Recovery (HADR), plus the Automatic Client Reroute capability, enables its client applications to recover from a failed database server with minimal interruption. This article shows you the steps for building a hi

(Scott Hayes) Many of you know that I spent years as a DB2 for Linux, Unix, and Windows performance guy. In September 2005, I pulled my head out of the sand and took an interest in security, auditing, and compliance.

(Jason Williamson) First I wanted to make a quick reference to a good article written by Mark Wilcox on how we can be more of a “blogging company”, which is my inspiration for this particular post. So, this keystroke saving effort is my effort to help break down those walls.

(Hunter Medney) IBM Lotus Expeditor is a compelling platform for building solutions for desktops and devices. Learn about three architectural patterns for offline applications and approaches for synchronizing data between client and server. To illustrate an offline application, a sample is provided