(Ember Crooks) The DB2 Administrative SQL Cookbook is a series of blog entries that are short. Each focuses on one or a few SQL statements that may be useful when administering DB2 databases. They usually address system catalog views, snapshot tables/views, or snapshot table functions that are stand

(Lockwood Lyon) With the data stored in the EDW, analysis can now begin. Most IT enterprises provide software packages to users that perform detailed analysis. This is sometimes called Business Intelligence Analytics. Some packages access the EDW data directly, while some extract subsets of data for

(Emmanuel Tissandier and Stéphane Lizeray) In an active-active topology, the server is installed in several data centers that all serve requests from mobile applications. Such a topology requires that you establish a database replication between the data centers.

(Troy L Coleman) In my career as a DBA, developers have asked me countless times about SQL Error -805. I’ll tell you what I’ve always told them: This error can be triggered for any number of reasons.

(Jack Vamvas) Getting the DB2 server instance owner is a common requirement for auditing and inventory management. As a DBA, application owners request my team start managing a DB2 server.

(Lockwood Lyon) In general, storage and analysis of Big Data will occur either within or in concert with the Enterprise Data Warehouse (EDW). Integrating all parts of your Big Data solution will require interfaces to every part of the EDW process. Here is a summary of the main subsystems of an EDW.

(Iqbal Goralwalla) db2look is a great utility which is commonly used by DB2 DBAs to extracts the DDL statements from a source database that can then be used recreate the database objects in a target database.

(Scott) 100% of our audience learned something! Based on his popular and humorous IDUG presentations, Adam treats our audience to his wit and wisdom for DB2 LUW — and even includes a bonus trick! #6!

(Susan Visser) A few weeks ago, I started a discussion in the DB2 Professional LinkedIn group that turned out to be quite popular. Request to join the group so you can take part in this and other discussions.

(Andres Gomez Casanova) SQL PL routines stored in DB2 databases contain business logic that can be used by all applications that access the database. However, these routines are not always completely tested. Until now, no standard procedure existed to perform automatic tests against them.