(Craig Mullins) Did you know that DB2 provides a method to change the way that a program or SQL statement acquires locks? That way is known as the isolation level and it can be set to specify the locking behavior for a transaction or statement. Standard SQL defines four isolation levels that can be
Other News
Index Design for Performance
(Gabrielle Wiorkowski) It is important for both DBAs and programmer/analysts to understand how to use indexes. DBAs are usually concerned with physical design and maintenance, and programmer/analysts must understand how to write SQL statements that make the best use of indexes. Chapter IU describes
Date conversion when porting Sybase to DB2
(Parminder Singh) When data is migrated from Sybase to DB2, problems arise from the MONEY, IMAGE, FLOAT and DATE data types. The format in which Sybase stores data is often different than DB2, which becomes a problem when manually porting from one to the other. For example, Sybase and DB2 DATE forma
Exporting Access 2003 Data to XML
For those of you who are already familiar with XML in Access 2002, note that the enhanced XML support in Access 2003 enables you to specify XSL (Extensible Stylesheet Language) transform files when importing data from, or exporting data to, XML. When importing, the transform is applied to data as so
Generate Spool File Layout
(Gautam Arora) Use this simple SQL script–lay.sql–to generate the layout for the spooled file. Run the script before spooling the table to get the layout. (script)
Validating XML
(Nicholas Chase) In the creation of a database, a data model and integrity constraints can create certainty in the structure and content of the data. But how do you enforce that kind of control when your data is just text in hand-editable files? Fortunately, validating files and documents can ma
An introduction to DB2 UDB Backup Solution with Veritas NetBackup
(Sylvia Qi and Raul F. Chong) This article provides step by step instructions on how to setup Veritas NetBackup to work with DB2 Universal Database (UDB). It also provides examples of how DB2 UDB backups and restores work.
Benchmarking Performance of a Query – Part 2 CPU and I/O
(Gregory A. Larsen) This is the second article in a series discussing benchmarking T-SQL query performance. The first article in this series discussed different methods of capturing the elapsed time of a T-SQL batch, pieces of a batch, or a single T-SQL statement. This article will discuss how to de
Database Optimization: The logic of the User Mode Scheduler in SQL Server
(Mark Kaelin) Achieving and maintaining optimal operational performance is the holy grail of every database designer and administrator who has created a normalized table. And, like that elusive icon, the search is seemingly never-ending and all-consuming. (R)
Script: Generate all database default DDL
This will generate all default DDL in a given database. (R,script)