(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
Other News
DB2 Business Intelligence: The Big Picture
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
Windows XP SP2 Defaults Break SQL Server Connections
(Brian Moran) If you’re running Windows XP Service Pack 2 (SP2) and SQL Server, you’ve probably figured out that the XP SP2 default installation prevents most network access to SQL Server—including to Microsoft SQL Server Desktop Engine (MSDE). Fortunately, making SQL Server and XP SP2 coexist isn’t
Mixed Emotions About .NET Managed Code in SQL Server
(A. Russell Jones) Microsoft’s impending release of the new capability to write stored procedures in SQL Server is a big advance and technologically admirable, but it raises serious questions about whether such a capability is appropriate. In short, do managed stored procedures increase or solve som
Backup Scenarios for Successful SQL Server Restores and Recovery
The intent of this document is to explore various backup scenario plans for SQL servers and come up with a recommendation to successfully restore them when the need arises. Database Administrators (DBAs) typically spend most of their time working on configuring and monitoring backup plans, but rarel
Inside Search Arguments
(Kalen Delaney) One of my favorite SQL Server topics to teach about is the query optimizer, whose job is to determine which query plans SQL Server will use to execute the queries your applications submit for processing. A main optimizer task is to determine which indexes, if any, SQL Server will use
Our Experience with Developing Entity EJBs over Disparate Data Sources
(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.
Guidelines for running a reorg on a large table
(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
An Overview of Transactional Logging in DB2 Universal Database
(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
Using XML to Improve File-Upload Processing
(Marco Nanni) This article examines an example of multiple binary file upload for Web applications using Extensible Markup Language (XML) technology, without the typical limitation of traditional file upload processing. It describes how to use Microsoft XML Parser 3.0 (MSXML) and ActiveX Data Object