IDUG 2004 – North America features one of the most comprehensive technical programs dedicated to the DB2 professional. The conference focuses on continual learning, where you can gain insightful, relevant information concerning DB2 and topics such as Autonomic Computing and SMARTer databases, how yo

(Amyris V. Rada) This article introduces DB2 UDB products and their capabilities, discusses porting databases and applications, and describes the most important aspects of porting applications from Microsoft SQL Server 2000 to DB2 UDB V8. It describes the differences between the two products in data

(Bonnie Baker) Sometimes we create programs that don’t perform as well as we’d like. We may ignore long runtimes and slow response times for a while, hoping that we’ll eventually find the time to evaluate the program’s access paths and logic and fix the problem. Then one day, for whatever reason, we

(Michael Lee Epley and Kulvir Singh Bhogal) In this article, you’ll learn how to build an application that will allow for the efficient transfer of Microsoft Excel spreadsheet data into a DB2 UDB database using Apache’s POI and HSSF.

BMC Software markets a comprehensive, premier line of backup and recovery products for the DB2 OS/390 platform. The product line includes individual DB2 backup and recovery point products that augment the native DB2 utilities with additional functionality and performance. In addition, BMC offers in

(Alexander Kuznetsov) Let us consider a very common situation. A GUI application issues a query, then the first 25 rows from the result set are displayed on screen. If the user presses Page Down, then the next 25 rows will be displayed, and so on. It is well known that FETCH FIRST 25 ROWS and OPTIMI

(Sasirekha Cota) Every business needs to protect its data. But the old practice of controlling access at the table level is coming up short as a solution to data security requirements. Businesses increasingly need more granular access — and they need a manageable way to provide it.

(Cindy Wong) This article will introduce you to the SQL/XML functions available with DB2 UDB version 8 and the DB2 XML Extender.

(Marin Komadina) My first DB2 article, “Who needs incremental delta backup” published on January 29, 2003 was an introduction to the DB2 backup and recovery technology on the SUN Solaris platform. Since then, I have been asked many times to write on some very interesting topics that are not covered

(Sreejumon) Most of the retail applications are still running in legacy systems like AS/400, Mainframe etc. If you are planning to migrate the entire application (or any modules) to Microsoft .NET, migration of the existing data will be the bottleneck (since there can be terra bytes of data, synchro