(Keith McDonald) Some of the information that db2top reports are statistics measured from the last reset of the snapshot. There is also a “delta” mode in which these same statistics are reset every second regardless of the refresh interval. This “delta” mode is the default mode that db2top runs in.

This is a Community Developed Appliance based on Ubuntu 9.10(Server and Desktop). (video)

(Rebecca Bond) I never could figure out my Rubik’s Cube, which is surprising considering I have almost learned how to manage the DBADM authority in DB2 9.7. Do you think this is a weird comparison? Well, let me explain.

(Keith McDonald) Today’s command line option is -R. In this post, we will look at how you can use the -R option to perform a reset of the snapshot when db2top is started.

(Kenney Ng and Shirley Braley) The IBM eDiscovery suite is a set of tools with capabilities to help you provide an integrated in-house approach that proactively manages information and helps you facilitate litigation response. Leveraging the scalable enterprise content management (ECM) platform, IBM

(Robert Catterall) I have recently done some work related to DB2 for z/OS data sharing, and that has me wanting to share with you a couple of items of information concerning group buffer pools (coupling facility structures used to cache changed pages of tablespaces and indexes that are targets of in

(Willie Favero) Wouldn’t it be nice if you could just prototype an index and not have to go through the overhead of creating a new index, all just to find out if the optimizer might decide to use it? Guess what? You can. As of DB2 9 for z/OS (and back fitted into DB2 Version 8 via APAR PK46687 ), […]

(Charul Kapil, Jaijeet Chakravorty and Manoj Sardana) One of the main reasons that DB2 provides static SQL execution is to help improve performance. Unfortunately, most Java applications (unless using SQLJ) did not have the option to use static execution until the introduction of pureQuery client op

(Paolo Bruni, Marcelo Antonelli, Davy Goethals, Armin Kompalka and Mary Petras) IBM continues to enhance the functionality, performance, availability, and ease of use of IBM DB2 utilities. (pdf)

(Keith McDonald) Today’s post is about the -B option, useful for terminals that don’t support bold text.