(Raj Mahal) When you think of a database you think of rows and columns, or that is what was thought of a few years ago. The modern DB2 data server for Linux, UNIX, and Windows (LUW) is a lot more than just a bunch of rows and columns. It is now a powerful server able to replicate many of the […]

This paper provides hands-on guidance for how to enable highly available content management solutions on officially supported platforms, using IBM DB2 Content Manager V8.4.2. It serves as a reference example, showing how to set up the Content Manager stack in a highly available configuration, and ou

(Kent Milligan) The IBM i 7.1 announcement materials have given the most ink to DB2 enhancements for XML integration and column-level encryption enablement—and deservedly so. However, the DB2 for i 7.1 release includes several unheralded features that are sure to make life easier for both programmer

(Keith McDonald) Today’s topic is the Statements screen. Unlike the Dynamic SQL screen, the Statements screen lets you see both dynamic and static statements and it groups them by the applications in which they run. As with the Agent screen, you can use this screen to see the operation that a statem

(Bob Gibson) Developing IBM WebSphere Application Server administrative scripts from scratch is not difficult, but practical information to step you through the process is difficult to come by. This article helps you do just that, beginning with an idea of what you want your script to do, and then p

(Antonio Cangiano) Recently Matt Aimonetti wrote an insightful article about Rails and the Enterprise. In it he identifies five core Enterprise application needs: –Reliability –Support –Performance –Advantage over the competition –Integration and transition path

(Rebecca Bond) The task of keeping up with database security can sometimes be monumental! A major challenge when it comes to administering authorities and privileges is how to approach this puzzle in a sensible, time-saving, ‘security robust’ manner. There is no need for concern; we have a hint or t

This paper provides hands-on guidance for how to install and set up an IBM DB2 Content Manager V8.4.2 system on Sun Solaris 10 using Oracle Database 10g Release 2 in an Oracle Real Application Cluster, deploying an active-active high availability environment. For the Content Manager resource manager

(Dave Beulke) Security improvements within DB2 make it essential to do a security review of old existing and new practices and applications that are executing in your environment. While helping to review a system recently, several findings highlighted many interesting items from previous administrat

(Keith McDonald) In the first post on the db2top Memory screen, we examined the gauges and table that are visible at all screen sizes. We saw that we could differentiate between the various memory pools on the system and determine how much memory each was consuming in near real-time.