(Knut Stolze and Torsten Steinbach) This article will demonstrate in detail how to use DB2 Index Extensions as well as quering Interval Trees and filtering by User-defined Predicates. DB2 Universal DatabaseTM offers a wide variety of extensibility mechanisms, including user-defined functions, sto

This is a report prepared by Branham Group Inc. that compares the two leading commercial database software packages for Linux: Oracle 9i version 9.2 Enterprise and IBM DB2 version 8.1.2 ESE. Comparison is based on cost of ownership, ease-of-use, reliability, and scalability. The results of the repo

(Roger Miller) I think of this question as a soliloquy. “To REBIND or not to REBIND, When is the question. To ponder whether its nobler to suffer the the slings and arrows of outrageous access paths now or to be struck in the back later.” The question is not so much whether to REBIND, but rather

(Bryan F. Smith) If you have seen the announcements from IBM entitled “E-business On Demand,” you know that an important element of this strategy is autonomic computing. The term is derived from the human nervous system-a system that automatically increases your heart rate when your oxygen supply is

The native DB2 recover utility always processes logs forward when performing a point-in-time recovery. This means that, in almost every case, either image copies or a pack backup must provide the basis for the log processing. Today, indexes are generally rebuilt from the tablespace data. In DB2 V6.1

(David Beulke) My job (yours, too, most likely) has gotten tougher lately. I’m doing more work in less time with fewer people to help me. The daily challenges of application changes, on-call maintenance, and opportunities to improve performance would make a great reality TV show — but no one would b

(Aslam Nomani and Lan Pham) DB2 Universal Database (UDB) is the industry’s first multimedia, Web-ready relational database management system, strong enough to meet the demands of large corporations and flexible enough to serve medium-sized and small e-businesses. DB2 Universal Database combines inte

(David Schipper and Richard J. Bolesta) Database Administrators (DBAs) face two growing trends: database growth and database complexity. As a database grows, the ability to properly manage the database becomes increasingly complex and time consuming. Performance issues are more difficult to

(Peter J. Haas) The vast amount of data in warehouses and on the web poses a major challenge for users who want to run BI or OLAP queries, execute advanced analytical, mining, and statistical algorithms or interactively explore their data. Most of these tasks simply do not scale to the hundreds of t

(Predrag Jovanovic) Without full concurrency there is really no on-line application, let alone a 24×7 application. Concurrency means that many different processes with fully secure data integrity can process the data, and every request will be correctly processed. How do you ensure full concurre