(Scott Hayes) 97% of our studio audience learned something! Have you ever made a database change and then had an “oh crap!” moment? Mistakes happen!

(Gaurav Jajodia and Srinivasan Nanduri) This article provides tips and techniques for diagnosing and correcting many of the most common problems when using WebSphere Adapter for SAP Software, and it adds some best practices for performance.

(Serge Rielau) This week a co-worker converting an Oracle application to DB2 contacted me and requested a REVERSE function.

(Lockwood Lyon) Many applications have Service Level Agreements (SLAs) that promise quick turnaround or acceptable on-line response time. Lengthened transaction elapsed times are a cause for concern. Here are several methods the database administrator can use to alleviate these issues.

(Shilpa Jaganmohan) This demo shows how to use a Lua string function to privatize sensitive data by reversing the characters in a specific column. In particular, the phone numbers in the supplied, sample OPTIM_CUSTOMERS table for U.S.-based customers are masked.

(YeeKai Lai) In this video, you will learn how you can use DB2 V10.1 Time Travel Query to: – Transparently keep a system history of all data changes

(Paolo Bruni, Edwin Holt, Jan Larsson, Craig McKellar and Fabricio Pimentel) IBM DB2 Tools for z/OS support and exploit the most current versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and optimization of data performance. In addition, the IB

(Rob Strong and Hana Curtis) This tutorial discusses IBM DB2 10.1 support for data types, tables, views, triggers, constraints and indexes. It explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application.

(James Buck) In the first article of this series, we began to examine the basic form of an SQL statement to obtain information from a database table or tables:

(Susan Visser) Join DB2 expert Kelly Schlamb and panelists Ben Ream and Debbie Hauss as they discuss The New Rules Of Always-On Retailing in a free webinar.