Guidelines to creating a report to monitor the month-end process.

(Keith McDonald) Today’s video is a comparison between the output of the db2mtrk command and the db2top Memory screen. It covers current allocations, high watermarks, and maximum allocations for the instance, database, and application groups of memory pools as well as the repeat mode of db2mtrk.

(Willie Favero) No, I’m not going to discuss SQL performance best practices, although it does seem that SQL tuning is something I get more calls for every week. No, for this post I’m just going to point you to a short blurb out on the IBM support web.

(Susan Visser) I’m still catching up on work after being away for my summer vacation… so forgive me for the lack of posts I’ve made!

(Leons Petrazickis) The DB2 Express-C database server is downloaded worldwide, but broadband internet is not yet universal. Because of this, we are releasing a light version of DB2 Express-C 9.7.2 for Windows. It’s an amazing 44% smaller than the full download.

(Simon Harris and Rajesh Sambandhan) pureQuery improves application throughput on DB2 for z/OS by making it easy to deploy static SQL for Java for any new or existing application. For new applications, this can be accomplished by using the pureQuery DAO interfaces and annotated methods. The client o

(Willie Favero) New, cool, and simple to use… What else could you ask for? Oh, not enough, you want even more… How about, it will make your life as a DB2 DBA or DB2 security administrator simpler and more productive. Just how, you might ask? I’ll tell you how…

(Keith McDonald) Today’s video is a demonstration of buffer pool hit ratio in the Bufferpools screen of db2top. To produce a hit ratio of 100%, we query a single row repeatedly to perform logical reads with no corresponding physical reads. To reduce the hit ratio, we query more data than can fit in

Complex cross ownerships where at lower levels companies are attached to groups at % less than equity consolidation method. At higher levels they need to combine with other ownerships using purchase method.

(Henrik Loeser) The XML support in DB2 is tightly integrated into the database engine and provides fast and sophisticated processing of XML data. In the past I had explained why – for compactness and speed – element and attribute names, namespace information is replaced with so-called stringIDs. The