(Craig Mullins) I want to update an attribute that is part of a foreign key. I want to change this in both the parent and the child. What is the best way? Dropping the foreign key and afterwards creating it again is an option I do not really like. Maybe rebinds have to be done then? (R)

(Howard Fosdick) Certification has arrived, no question. But as a DB2 professional, should you certify? Will it increase your abilities or help your career? How can you do it quickly and inexpensively? That last thought is key — knowing the inside story on DB2 certification before you proceed will

(Howard Fosdick) DBA certification requires significant time, effort, and expense, so you want to make sure you certify with the right product. My previous column compared the cost and effort necessary to certify as a DBA for DB2, Oracle, and Microsoft SQL Server. But questions remain: Which DBA cer

(Kulvir Bhogul and Grant Hutchinson) The relational database serves as a location to persist data for many applications. Java programmers commonly use JDBC to interact with backend databases. This article shows you how to set up your environment to write Java programs that interact with IBM DB2 Univ

(Fraser McArthur) Here’s the help you need for getting optimal performance out of your DB2® UDB database and its applications. The author takes a practical approach, discussing techniqes you can implement at various stages of development or to a production system, including techniques for database d

When it comes to databases, users care about just one thing: performance. But tuning to improve performance can be tricky. Without a specific, measurable goal in mind, tuning can turn into an exercise in futility. (R)

(Paul C. Zikopoulos and Roman B. Melnyk) This article outlines range-clustered table (RCT) support in the IBM DB2 Universal Database (DB2 UDB) products as of Version 8.1.4. RCTs represent a new table type that is supported through the ORGANIZE BY KEY SEQUENCE clause on the CREATE TABLE statement.

The Microsoft OLE DB Provider for DB2 (DB2OLEDB) that ships with Host Integration Server 2000 or SNA Server 4.0 Service Pack 4 supports SELECT, INSERT, UPDATE, and DELETE statements from SQL Server Linked Server.

(Paolo Bruni) This IBM Redbook helps you design, install, manage, and tune stored procedures with DB2 for z/OS. Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2 has offered an ever improving support for developing and ope

(Marin Komadina) This article examines the procedure for making a database backup using Tivoli Storage Manager, (TSM).