(Jim Cooper) Constraints, sometimes referred to as integrity constraints or integrity rules, are restrictions based on business rules and other business policies and procedures that ensure data in a database are acceptable and accurate.

(Jack Vamvas) An application owner reported an error on a DB2 database connection attempt. A query on db2diag.log returned this message

(Erika Von Bargen) Have you ever wanted to monitor your IBM Informix database servers on the go from your mobile device? This article introduces the IBM Mobile OpenAdmin Tool for Informix (OAT) application.

(Craig S. Mullins) DB2 automatically guarantees the integrity of data by enforcing several locking strategies. These strategies permit multiple users from multiple environments to access and modify data concurrently.

(Henrik Loeser) DB2 allows users to switch to different identities. One way is through the means of so-called trusted contexts (which I won’t discuss today), the other option is to call SET SESSION AUTHORIZATION (old: SET SESSION_USER).

(Nakul Bharade) Examples in this article show you how to configure access and manage security for WebSphere Service Registry and Repository, for users and groups defined in an external Lightweight Directory Access Protocol (LDAP) user registry. This approach lets you add or remove users from the ext

All of us are familiar with backup/restore commands and this is the most widely used method for db2 backup and recovery. But there are other ways you can use to backup and recover your data.

(Timothy Prickett Morgan) IBM has created a neat new database feature for its DB2 database for Linux, Unix, and Windows operating systems that will hopefully make its way into the integrated DB2 for i database that resides inside the IBM i operating system.

(Predrag Maksimovic) The Oracle Connector is a connectivity component in IBM InfoSphere Information Server. It is utilized by IBM InfoSphere DataStage and other products in the Information Server suite to perform extract, lookup, load, and metadata import operations on Oracle databases.

(Martin Hubel) 96% of our studio audience learned something! Michael presented new features (DB2 9.7 and 10) of the Explain functions within DB2 LUW.