(ahk2chan) The DB2 DBM cfg (Database Management Configuration) Parameter NUM_POOLAGENTS represents the number of agents should be stayed in the pool instead of being discarded after used.

(George D. Simpson) IBM Informix Dynamic Server 11 (IDS 11) offers new features to assist in automating administration and maintenance tasks. Learn how the new scheduler and SQL API make a DBA’s daily tasks easier.

(Rick Weaver) Why do companies build applications in DB2? The ability to back up and recover (applying logged changes since the backup) is what sets a DBMS apart from sequential file systems. DB2 recovery resources are among the reasons so much corporate data is stored in DB2. The DB2 log is critica

(Beth Hamel) This article discusses best practices in the area of Q Replication recovery management. By examining several recovery scenarios and methods, you’ll learn about key recovery techniques and principles that can be employed in similar cases or in more general scenarios. Additionally, this a

(Susan Visser) We all know how important database security is — no one wants to hear that their precious data was hacked or compromised in anyway. According to the article The Job of Securing the Database published on DATE: 21-SEP-2007 by Deborah Perelman, a Forrester Research study shows that DBAs

(Robert Catterall) Will tuning buffer pools lead to a reduction in package CPU TIME in the PM Accounting report? I expected to see a reduction in Elapsed time and Suspension time. I expected SRB time to shrink, but I thought the CPU TIME reported for each package would remain more or less the same.

(Antonio Cangiano) We now have a working Python driver for DB2 which is currently undergoing internal testing. The driver is similar to the Ruby and PHP ones, which means that you get an advanced and very easy to use API. It also means that if you are confident with the Ruby driver, you will be able

Get ready for a new, highly interactive conference experience devoted exclusively to the needs of RPG & DB2 developers. Come to Minneapolis on October 2-4, 2007 to see for yourself why people are so enthusiastic about this refreshingly different educational event.

(Willie Favero) Do I have a deal for anyone just starting to plan their Version 8 upgrade or just starting to execute their Version 8 upgrade plan. For the last 2+ years I have been blogging DB2 for z/OS Version 8 upgrade tips. Some have been to help you plan your upgrade and some have been advice o

(Scott Hayes) We’ve looked at several metrics that can help you discover the presence of physical design “opportunities for improvement”, or problems. But, as many of you know, I don’t like the word “problems” – 1) Problems is too negative sounding, and 2) Sometimes inefficiencies, or tuning opportu