(Chris Eaton) Here are a few scripts to check on the health of your page cleaners and prefetchers. Prefetchers are processes in DB2 that read data pages from disk into the bufferpool in advance of the DB2 agents with the hope that it prevents an agent from having to wait on I/O. There are many forms

(Gary Minnaert) Learn how to configure and deploy the IBM DB2 Content Manager Portlets V8.3 with this step-by-step tutorial. This tutorial shows how to customize the IBM DB2 CM Portlets 8.3 for a basic and also for a more advanced configuration. You will learn the various options for Content Manager

(Joe Pluta) Concurrent Versions System (CVS) has long been a standard in the UNIX world for managing source code. Roughly 20 years old, CVS started as a bunch of scripts on top of the slightly older Revision Control System (RCS) utility. From these humble beginnings, the package has evolved into

Costs are tight, DBAs are clever, a database is a database – so why not get the mainframe DB2 DBAs to look after DB2 for LUW? This presentation, co-sponsored by the International DB2 Users Group (IDUG) and CA, is a crash course on administration for DB2 UDB for Linux, UNIX, Windows. It is design

(Monty Wright) Database systems running on the Linux platform have become a foundation for critical business applications. DB2 Universal Database (DB2 UDB) utilizes the Linux platform well by leveraging a designed feature set unique to this platform.

(Paul Zikopoulos) Are you trying to apply DB2 FixPack 10 maintenance to your IBM DB2 Universal Database for Linux, UNIX, and Windows (DB2) server and getting a SQL0443N SQLSTATE=38553 error? Spending 10 minutes of your time reading this article will not only help you solve this problem; it will prep

System monitoring is an integral component of IBM Content Manager OnDemand (‘OnDemand’) daily operations, system management and report generation. OnDemand version 7 provides ‘built-in’ monitoring facilities that allow for the monitoring of OnDemand transactions on a transaction by transaction basis

(Howard Goldberg) CSI: Crime Scene Investigation, one of my favorite television shows, always operates on the same premise: a medical examiner searches for a victim’s cause of death by combining physical information gathered from the cadaver with the victim’s profile, crime scene information, and ot

(Kent Milligan) I am attempting to invoke a stored procedure (SQL) from a COBOL program. The stored procedure returns ONE result set, so the last (meaningful) statement in the stored procedure is OPEN cursor name. Once I issue the CALL in the COBOL program, how do I associate the result set to somet

(Chris Eaton) Here is a script you can run if you find yourself in a situation where your applications are running slow and you want to know if there are locking problems. This script will list all the applications currently running, who is the authorization ID running the application and from what