(Ajay Jain) If you are also working for a client like me, where migrating production system(s) to latest version(V9) takes months even after you migrated the QA/DEV/other boxes, then I assume, you may face a situation when there is a need to restore v8 prod copy into one of the v9 migrated QA/DEV/ot

(Scott Forstie) IBM DB2 for i customers are accustomed to seeing SQL server mode job activity, otherwise known as QSQSRVR prestart jobs, in the QSYSWRK subsystem. Over time, customer applications, third-party software, and IBM middleware have increased the use of SQL server mode. A consequence of th

(Paul Zikopoulos) In the first part of this series, I showed you how to use Microsoft Access 2007 as a graphical front end to a back-end IBM DB2 data server. Specifically, I showed you how to implement linked tables and create an abstraction layer over those linked tables such that information worke

(Michael Sansoterra) I would like to write a conditional INSERT in SQL so I can use a prepared statement through JDBC. However, SQL supports IF only in SPL, the Stored Procedures Language. Is there another way to insert the record if doesn’t exist?

(Punit Shah and Basker Shanmugam) Learn about Live Partition Mobility, a feature of the System p virtualization PowerVM Enterprise edition. See how Live Partition Mobility can be applied to DB2 deployments, and how it helps you migrate AIX and Linux partitions and hosted applications from one physic

Recently a colleague asked me for a quick way to delete duplicate data from a big table. The problem my colleague faced was that he had to create a new unique index on a table with over million records. There were many duplicates records in the table with respect to this new index and hence his crea

(Andrew Ford) Last month we explored some of the basic, but powerful, funtionality of the Informix High Performance Loader (HPL) and the CLI configuration utility onpladm. Today we will be looking at some advanced uses of HPL that will allow you to simultaneously unload and load data without the nee

(Ray Willoughby) I am a design architect for DB2 Optimization Expert for z/OS (OE), which is IBMs query optimization solution. I would like to give you a brief overview of what OE is and how it can help you identify and resolve query optimization issues.

(Kent Milligan) What is the best way to join three files using SQLRPGLE? (R)

(Willie Favero) I really enjoy talking about z/OS, workload manager (WLM), and zIIPs. Although today’s APAR is a few months old, it does allow me to talk about all three. And being just a little old may put this one close to your planned APAR apply window.