(Keith McDonald) The db2top tool is very configurable. It would be inconvenient to configure it to your liking only to lose your configuration when you shut down the tool, so an option is available for saving your configuration to a file.

(Troy Coleman) IBM has announced that the DB2 10 for z/OS beta will begin on March 12.

(Shenfu (Mike) Fan) You can configure a broker in WebSphere Message Broker V6.1 or later to perform access control for individual messages in a message flow by using an external security provider. This article describes security at the message flow level and shows you how to implement message flow s

(Henrik Loeser) When you are a software developer, you don’t necessarily have insight into the pricing and sales process. From coding days I know how to hook up functionality to a license server and how to make sure features are only used when money was paid (that’s the part regarding job security).

(Keith McDonald) The final two command line options, -C and -f, work together. The -C option tells db2top to run in data collector mode and -f lets you tell db2top where to write or read the results of such a collection.

(Matthias Nicola) The SQL language standard includes XML as one of the SQL data types, which allows you to have columns of type XML in tables and result sets. The latest JDBC standard (JDBC 4.0) now includes an interface and data type called SQLXML that correspond to the XML data type in the databas

(Alex Woodie) Altova is now supporting the System i server and its integrated DB2/400 database with its MissionKit, a suite of popular XML, data conversion, and UML modeling tools for developers and database administrators. Altova’s CEO expects System i shops to get the most use out of two of the su

(Vikram S. Khatri and Sushma Yeleshwarapu) Moving data from a source database to IBM DB2 for Linux, UNIX, and Windows can be a challenge; particularly when the source database is quite large and you do not have enough space available to hold the intermediate data files. The sample code provided and

(Julian) If you make use of RTS and DEFINE NO, you might want to review your processes to ensure that you’re picking up all of the tablespaces you should be……

(Keith McDonald) By default, db2top shows data aggregated from all partitions. In this post, I’ll show you how to use the -P option to override this behavior so that you can look at one partition at a time.