(Craig S. Mullins and Brenda Honeycutt) Business availability is more than just having a reliable hardware and database platform in place. Even the best high availability environment cannot safeguard itself from logical errors. Since most companies cannot afford downtime, it is important to plan ahe

A quick command to find out the database size is: db2 “call get_dbsize_info(?,?,?,0)”

(Lynette D. Adayilamuriyil and Manoj Mohan) Protect your most sensitive data by using the Label-Based Access Control (LBAC) feature of IBM Informix Dynamic Server V11 (and later). In this article, understand what LBAC is, and see how you can implement it to meet your most demanding security standard

(Roger Sanders) Here are two more sample questions to help you prepare for the DB2 9 DBA certification exam. Give these a try, then try past questions here. All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press an

(Adam Gartenberg)It’s great to see DB2 out of the back office and onto the ball field. IBM announced last week that we would be working with Major League Baseball on several initiatives, one of which is designed to prevent counterfeiting in what is now a multi-billion dollar memorabilia business.

(Knut Stolze, Ph.D. and Marcel Kutsch) Get the details on how to use the common SQL API (CSA), a set of stored procedures that exist across all IBM data servers. Learn to employ the common SQL API and integrate it in an application. Explore a small J2EE Web application, based on the common SQL API,

(Jon Deng and Jeff J. Li) This article introduces the IBM Information Server Pack for Salesforce.com. It describes the architectural design, demonstrates the packs usage, and highlights its benefits in contrast with other products. It also illustrates sample jobs to guide you though a complete deplo

(Willie Favero) You all know how I feel about zIIP engines. to me they are almost as cool a sliced bread. However, as the evolve, adjustments have to be constantly made.

(Wei Liu) IBM Rational Data Architect (RDA) is gaining momentum as a comprehensive tool that helps organizations to promote a thorough understanding of their enterprise information architecture. As more people use RDA, theres an increasing need for some customers to extend RDA to meet their unique d

(Frank Butt, Yu Dong and Gene Fuh) DB2 9 for z/OS Spatial Solution provides the database capabilities to help businesses manage and deliver geographic data on demand. Organizations realize greater benefits by being able to manage information identified by geographic locations and being able to integ