The 2004 IBM DB2 Information Management technical conference will give you the opportunity to grow in your knowledge on how to maximize your existing investment in the IBM DB2 information management software product portfolio. DB2 information management software is much more than our award winning d

(Susan Lawson) Scans are just as undesirable in text documents as they are with our DB2 tables. We need to create indexes so that sequential scans of documents are not necessary. By using a text index, you can speed up the searches performed on these documents. (R)

(Barbara Darrow) IBM Software is prepping beta versions of its next-generation DB2 database and information integration products for release by the end of June. The next release of DB2, code-named Stinger, will be offered with a new “Partition Advisor” to make it easier for administrators to con

DBAs often express the need to view log records for a specific table. You might want to view the log records to: –Determine how invalid entries are being inserted into the database. –Identify actions taken by a specific user. –Create an audit trail of actions on key, critical database ta

(Paul C. Zikopoulos and Roman B. Melnyk) The maintenance of any database involves the routine invoking of utilities that perform backup operations, data rebalancing, updating the database statistics, reorganizing a table, and so on. In IBM DB2 Universal Database for Linux, UNIX and Windows (DB2 UDB)

(Greg Nash) Have you ever wondered why some of your queries take so long to run? Or how DB2 interprets your requests? As with all high-level programming languages, SQL must be translated into a set of smaller operations, which can be performed in turn. Because the efficiency of each operation ca

(Paul C Zikopoulos) Stinger is the next release of DB2 UDB, and it’s chock full of new features that cut the time-to-value for your on demand solutions. It will feature enhancements for application development, vast improvements in lights-out operation and manageability, high availability, security,

(Dirk Wollscheid) In this article, we explain how to enable security for a DB2 Web Service Provider application, which includes enabling authentication, setting authorization and making sure that messages are encrypted. We also explain how Web Service users can be mapped to database users.

(Knut Stolze) In a previous article, Knut Stolze explained how to implement a user-defined aggregate function in DB2 UDB. Now he takes us a step further, and shows two different implementation techniques to support grouping for user-defined aggregates using Java.

(Craig Mullins) I need to create some extract programs to read a set of DB2 tables in our mainframe environment? I don’t have time to learn COBOL but I have 18 years of experience with MVS Assembler. Is there a way to connect the two (DB2 and Assembler)? (R)