(Reginaldo Barosa) Without writing any Java code, you can build a three-tier Web application that uses servlets, JSPs, and Java, and accesses a DB2 database. Follow the steps and sample code in this article and learn how to use VisualAge Generator and WebSphere Studio to create, test, and deploy the

Many DB2 for z/OS and OS/390 DBAs don’t realize that DB2 monitor accounting and statistics reports contain a wealth of detail that can help with performance tuning. Accounting reports reveal information about application execution and statistics reports document activity at the subsystem level — tw

You need to be able to access all of your information wherever it resides. DB2 Information Management software protects your current database investment and delivers information on demand to ensure your information is integrated, comprehensive, uniform, analyzable and accessible all the time across

(Frank J. Ingrassia) When programs are created to run under DB2, they are submitted to the Bind process, which creates a set of control blocks called Data Base Request Modules, or DBRMs. These modules are stored in a library and can be the subject of a rebind, if the module moves to another subsyste

(Alan Zeichick) Enterprise-class relational databases are one obvious application categtory that’s especially capable of leveraging the large memory space and increased performance offered by 64-bit processors. IBM has had a head start in 64-bit computing, having long offered versions of its DB2 Uni

(Ron Turull) DB2 maintains a number of cross-reference files that you can use to easily retrieve information about files on your system. They contain information on files, fields, keys, referential constraints and much more, and they are easy the work with. The cross-reference files are automati

The IT community is by now well acquainted with the value proposition of the data warehouse – indeed, the focus of most discussion has shifted beyond the warehouse itself to the larger issues surrounding an overall enterprise architecture for business intelligence (BI) and real-time analytics. The w

(C. M. Saracco and T. J. Rieger) The authors share their experiences and compare the relative cost of implementing entity Enterprise JavaBeans that span different backend data sources both with and without DB2 Information Integrator for federated database access.

(Craig Mullins) One of our large tables (12 million rows that continues to grow by 15,000 rows per week) on AIX UDB V7.1 has two indexes — one primary clustered and the other a non-clustered, non-unique index. Reorgchk cmd (F6) recommends to reorg the second index (non-clustered, non-unique). After

(David Kline and Nanda Pilaka) Any database management system must have mechanisms for securing data consistency and recoverability. One of the many mechanisms used by relational database systems to insure those all-important qualities is transactional logging. In this article, we will define an