(Kayalvizhi Ganesan and Scott Walkty) Configure DB2 automatic maintenance operations from either the command line or programmatically, using new stored procedures introduced in IBM DB2 9.5 for Linux, UNIX, and Windows. This article discusses different configuration options and provides examples.

(Rob Williams) In doing numerous reviews of stored procedures, we see many customers with SQL injection issues. SQL injection is one of the most basic and common security issues in database applications.

(Susan Visser) The IBM Education Pack can be used to attend IBM Technical conferences, such as Lotusphere 2008 – Orlando, Florida, USA Impact 2008 – Las Vegas, NV Automated Operations Technical Council – New Orleans, Louisiana, USA IBM Pulse 2008 (a new Tivoli Technical User Conference) – Orl

(Roger Sanders) Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, to help you prepare for the certification test. The questions are reprinted with permission. Check back each week for more, and try past

(Rob Williams) This Saturday marks 30 years to the “Unix Millennium Bug” where it has been 2^31 seconds since UNIX epoch. This is when the standard signed int overflows its time representation. 0111 1111 1111 1111 1111 1111 1111 1110 changes to 1000 0000 0000 0000 0000 0000 0000 0000 which is negati

(Larry Barrett) Maybe it’s just a cat thing. IBM announced its Informix Dynamic Server (IDS) will support the Mac OS X 10.5 operating system, a.k.a. ‘Leopard’ beginning with the mid-year release of the latest version of IDS 11, code-named Cheetah 2.

(Darik Siegfried and Mike Marin) The IBM FileNet P8 Business Process Management (BPM) product uses the XML Process Definition Language (XPDL) V2.0 as a file format to store processes. XPDL is a standard process definition file format developed by the Workflow Management Coalition (www.wfmc.org) and

(Troy Coleman) If you’ve been in IT for any length of time you know that change is constant. You must regularly make improvements to the systems you develop and support. On top of that, the tools you use are also changing. As a DB2 for z/OS specialist, it’s very important for me to stay up on the la

(Martin Hubel) In DB2 9.5, the database engine has switched from a process-based model to a threaded model. This means that the entire database engine is under one address space (any piece of code can access any global variable). This, naturally, has both pros and cons. One advantage is that threads

(Punit Shah, Basker Shanmugam and Sunil Kamath) Learn best practices for deploying IBM DB2 9 with the IBM System p virtualization technologies. System p virtualization technologies offer a richer set of platform-deployment features. These features range from simple resource isolation to an array of