(Steven Aoki, Darryl Bloch and Stacia Sambar) Finding product-related information in traditional hard-copy documentation is often a difficult user task because of searchability and retrievability obstacles. The introduction of the Information Center, here described for the IBM DB2 Content Manager On

(Marin Komadina) A long line of applying database FixPaks has ended with number 11, the last FixPak V7, and a brand new line has begun with DB2 V8. Currently, a total of six FixPaks have been released for DB2 V8. Consequently, support for DB2 V7 has come to an end. This event triggered many DBAs to

(Kim Moutsos) Thanks to an innovative roll-out strategy, the “light and nimble” new release of DB2 enjoyed months of buzz before its debut. As the ship date approaches, IBM Canada’s Bob Picciano sheds light on what’s in it for you.

(Jason Zhang) How do you use a surrogate key as a primary key? The core of a surrogate key solution is to find an efficient way to generate unique sequential numbers. Learn about three implementations: the traditional way, Key Manager, and new IBM DB2 Universal Database (UDB) features.

(Craig Mullins) DB2 v7 z/OS: Our performance monitor has a SQL error summary that shows thousands of SQL error codes per hour. Most of these errors are handled in the application code (COBOL CICS) and do not result in an abend in which the user is aware of. My question is how much CPU overhead is th

(Malcolm Nolan) IBM DB2 Universal Database (UDB) for z/OS Version 8 and its feature, DB2 Query Management Facility (QMF) V8.1, became generally available this year. Both improve upon their predecessors and can help streamline the operation of your enterprise.

(Craig Mullins) Can I use FETCH FIRST ROW ONLY in a select statement of update query? Example: (SELECT SCH.SCHEDULEID FROM ASHOK.INTERVIEWERSCHEDULEMASTER SCH, ASHOK.RESUMEDETAILS SSS WHERE SCH.INTERVIEWLOCATION =SSS.CANDIDATELOCATION AND SSS.SCHEDULEID IS NULL AND SSS.REQUIREMENTID IS NO

(Philipp K. Janert) What are the best choices when designing the schema for a relational database? What is the rationale in deciding in favor of one and against some other alternative? Given the amount of vendor-specific recommendations, it is all too easy to overlook basic relational database funda

(Bob Swart) This article demonstrates how to build the user interface (a thin-client application) for a SOAP Web service engine with Kylix 3 on Linux, exposing the data from DB2 UDB database tables to the outside world.

IBM announced new software to help businesses better manage and gain control over product information and to enable increasingly popular initiatives such as radio frequency identification (RFID), global data synchronization, electronic commerce and portals. Approximately 90 days after acquiring