(Robert Catterall) DB2 for z/OS is very good (through data provided in accounting trace classes 2 and 3) how time is spent when SQL statements are executed (this is often referred to as in-DB2 time). That said, it is often the case that one will see, in a DB2 monitor accounting report or an online m

(Willie Favero) Today I have two APARs that I recommend you check out: PK44133 and PK55239. One APAR is for DB2 9 and the other is for DB2 Version 8; I need to have a little something for everyone.

(Carlton Doe) Confused about the various editions of IBM Informix Dynamic Server (IDS)? In this article you’ll get an introduction to each edition, and then you can compare features, benefits, and licensing considerations in a side-by-side table. Regardless of which edition you choose, IDS brings yo

(Chris Eaton) I thought I would start the year with some basics as I have had a lot of people asking me to cover off some of the basics of backup and recovery.

(Scott L. Forstie) DB2 for i5/OS on V5R4 has been enhanced to include an index advice condenser feature to simplify the analysis of index advice from the query optimizer. Index advice is accumulated as it occurs based upon query and SQL activity. Much of the raw index advice generated by DB2 has som

(Billy Sundarrajan) Application developers and database administrators often face challenges with differing access paths in Production and Test DB2 subsystems when performing an EXPLAIN for a given SQL. In most installations, tables in Test subsystems are a lot smaller than the ones in Production su

(Willie Favero) This morning I listened in on Phil Grainger’s DB2 9 webcast (“DB2 9 for z/OS Pre-Reqs, Migrations, Deprecations”) and it reminded me of something that has always bothered me about blogging. You blog in the “today”. A blog is very much like have a conversation with someone. Most peopl

(Kent Milligan) Many System i developers are starting to use SQL to create their database objects instead of the proprietary non-SQL interfaces. This article will show you how to use a schema with IBM DB2 for i5/OS to group related database objects. DB2 for i5/OS was previously named DB2 UDB for iSe

(Abhishek Singh and Georgiana Ivy Avram) IBM WebSphere Portlet Factory V 6.0.1 provides builders that facilitate creating, retrieving, updating, and deleting content in IBM WebSphere Portal Document Manager. This article describes these new builders and demonstrates their use through a sample applic

(Martin Hubel) A customer asked me to develop a function to check whether a character string was in fact numeric with the further stipulation that it be done in SQL. He reported that the documentation seemed to be lacking.