(Peter Backlund) Triggers are an important tool for achieving better data quality. They can be found in other RDBMSs and have been available for a long time in DB2 for Linux, UNIX, Windows. For DB2 for z/OS and OS/390 triggers were added in Version 6. A trigger is tightly coupled to a table and
Other News
Migrating your HA database environment from IBM DB2 UDB EE V7.2 to IBM DB2 UDB ESE V8.1
(Gene Thomas) After migrating your High Availability database environment from IBM DB2 Universal Database Enterprise Edition Version 7.2 (DB2 UDB EE V7.2) to IBM DB2 Universal Database Enterprise Server Edition Version 8.1 (DB2 UDB ESE V8.1), you must also perform some DB2 instance-level configurati
An Introduction to Clustered and Non-Clustered Index Data Structures
(G. Vijayakumar) When I first started using SQL Server as a novice, I was initially confused as to the differences between clustered and non-clustered indexes. As a developer, and new DBA, I took it upon myself to learn everything I could about these index types, and when they should be used. This a
Finding the product of a column
(Vadivel Mohanakrishnan) There isn’t a prebuilt function for finding the product of column or set of values in SQL Server. But there is a workaround by using a combination of the SUM(), POWER() and LOG10() functions. If not for this query we would have to fetch all the records to the front-end and t
Find out when the database was started
(Vijay Kaushik) This query is useful for knowing how long your database has been up and when it was started. It has been tested on versions 8 and up. (R)
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
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
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
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.
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