(Samir Kapoor and Vincent Corvinelli) With column group statistics in IBM DB2 for Linux, UNIX, and Windows (DB2), the optimizer can determine a better query access plan and improve query performance when there is a correlation between multiple equality local predicates or equality join predicates. I

(Torsten Bittner) You can use IBM Rational Data Architect to define data mappings. When working with large schemas, it can be very cumbersome to manually create mappings. Rational Data Architect offers a discovery component to semi-automatically identify potential mappings. This tutorial provides an

(Chris Eaton) The next view I’ll focus on in this series of posts (click previous entry at the top of this page to view others) is the SYSIBMADM.LONG_RUNNING_SQL view. This view shows you the longest running SQL statements in the database you are connected to. From this view you can quickly see the

(Michael Baessler, Andrea Elias, Thilo Goetz and Sebastian Nelke) Walk through an end-to-end scenario for creating and deploying custom text analysis in IBM OmniFind Enterprise Edition 8.4. Find out everything you need to know from writing and testing a UIMA annotator, deploying it in OmniFind, and

(Willie Favero) I know you all know that DB2 Visual Explain (VE) Version 8 (with Statistics Advisor) is extremely cool. You probably have used VE or have at least seen a presentation about it at one of the conferences. If you are a fan, I have news for you.

(Dave Warner) Asynchronous JavaScript + XML (Ajax) is a dynamite technique for greatly enhancing the user experience on the Web. But it pays to remember that it’s only necessary because of the distance between the information source and the browser. Shorten that distance, and much of the need for Aj

(Chris Eaton) Yesterday I posted an entry on using SQL to query the notification log. Today I’ll show you how to use a new view to query the database history. In previous releases (and still today) you can look at the database history to see when objects were created or dropped, when objects were ma

(Alex Osuna, Jawarhar Lal, Roger Sanders and Jeremy Brumer) Database cloning is the process by which you create an exact copy of a DB2 database, either by physically copying the data or by performing what is known as a redirected restore. (pdf)

(Paul Zikopoulos) Customers choose the IBM DB2 data server because of its incredible time to value, its ability to scale and integrate across disparate environments, its robustness, and for the minimization of ‘down-time’ (both planned and unplanned). In this article, I focus on the high-availabilit

(Willie Favero) RELEASE (DEALLOCATE) changes a few of the rules when it comes to releasing storage. For example, even if you choose to use the DSNZPARM keyword CONTSTOR in attempt to take advantage of storage contraction, RELEASE(DEALLOCATE) negates the entire process. A commit does not trip CONTSTO