This article explains how defining tablespaces with Locksize Row can impact your DB2 implementation. Find out about several different responses to this request for help in determing the best set of options to use with DB2.
Author: SSWUG Research
New SQL Capabilities in Oracle Database 10g
Oracle’s SQL Engine is the underpinning of all Oracle Database applications. Oracle SQL continually evolves to meet the growing demands of increasingly more sophisticated database applications, and to enable emergent standards-based computing architectures, APIs, and network protocols. Oracle Dat
Building a High-Traffic Web Site with Static Delivery Using XML – Dynamic and static sites: get the best of both worlds
(Todd Price) Dynamic sites – sites that pull and assemble content stored in a repository – are easy to customize and capable of providing rapidly changing content. These sites provide the richest feature set for contributors and are easier and cheaper to build and manage. However, a high-traffic dyn
Designing Mixed-element Schema
A reader asks for—and receives—an XML schema that can support an unbounded number of and elements in any order. It’s more complex than it seems.
Performance Optimizations for XML Data Type
This paper covers several techniques to improve the performance of queries against and modifications to the XML data type in the latest version of Microsoft® SQL Server™, SQL Server “Yukon.” To get the most value from this paper, you should have some familiarity with XML features in the context of S
Managers’ Guide to DB2 Data Protection
The IBM DB2 Universal Database has become one of the leading relational database management systems for installations that require a high-performance, scaleable platform for running business-critical data warehouse and OLTP applications in a UNIX environment. Its success is based on the strengt
ColdFusion MX: Creating a JDBC data source for DB2
This TechNote describes how to configure a Macromedia ColdFusion MX JDBC data source to connect to DB2 using the DB2 Universal Database driver. There are several JDBC Type IV drivers that are provided with ColdFusion MX Server Enterprise Edition and ColdFusion MX for J2EE. DB2 Universal Database
The Threat from Below
(Michael Otey) SQL Server is too expensive. At least that’s what more and more readers—many of whom are looking at the free MySQL or other lower cost open-source databases—have told me over the past year. With SQL Server 2000, Microsoft introduced a per-processor licensing model, increasing the p
Basic Performance Tuning, Part 2
(Roger Sanders) How to change your instance and database parameters for the best Performance effect. If you read the first installment of this Distribued DBA column in the Quarter 3, 2003 issue, you know that database performance problems typically arise from one of the following factors: –Sy
Tip: Implement XMLReader
(Benoit Marchal) In this tip, Benoit Marchal explores APIs for XML pipelines. He concludes that the familiar XMLReader interface is appropriate for many XML components. One of the most popular designs for processing XML documents is the pipeline. A pipeline is a group of components where each com