(Andy Warren) If you don’t have to deal with case sensitivity, count yourself lucky! SQL 2000 is much better than SQL 7 with regard for collations, supporting collations at database, table, and column level. In this article I’m going to delve into a interesting (or obvious?) item I noticed recen
Other News
Consolidating DB2 dataset extents
(Nick Nur) You can use SMS on the mainframe to consolidate dataset extents easily and quickly without recovering the tablespace. (R)
Set up a SPECjAppServer2004 application with DB2 Universal Database
(Tony Lau) SPEC provides a generic user guide on how to set up the SPECjAppServer2004 application. The technology coverage of the benchmark has been significantly extended from the benchmark released in 2002 in order to cover more aspects in a J2EE 1.3 environment. Vendor-specific information is not
FIX: The Database Lookup functoid/Value Extractor functoid produces inconsistent results
The BizTalk Server 2004 XML Mapper Database Lookup functoid and the BizTalk Server 2004 XML Mapper Value Extractor functoid produce inconsistent results when it tests a map that contains multiple Database functoids that are fired in a random order. This problem does not occur when testing a simple m
Oracle Performance Tuning – (Otherwise Known as Drowning in a Pool of Confusion)
(Steve Callan) If someone asked me what learning Oracle performance tuning is like initially, I would have to say the title of this article aptly describes the process. Moreover, to make matters worse, it is not even one pool, but several pools in which the novice tuner can drown. Knowing what defin
Mastering DocBook Indexes
(Jirka Kosek) These days DocBook is considered to be a standard documentation format. Good documentation should be accompanied by a good index. This article will show you how to create professional indexes in DocBook and how to deal with indexes in languages other than English.
Creating DB2 Java Stored Procedures on z/OS
(Peggy Rader) Stored procedures are a convenient option for connecting applications to the database. However, the task of manually creating stored procedures is anything but convenient—it can in fact be a labor-intensive and sometimes error-prone process. That’s why the recent availability of IBM’s
The Scalable Vector Graphic (SVG) pocket reference, Part 1
(Donovan Cowie) In 1722, Johann Sebastian Bach published a book called the Das wohltemperierte Klavier, which translates as The Well Tuned Keyboard. The book contained twenty-four examples that made use of a new system for tuning pianos and harpsichords, laying the foundation for Western Classical m
Managing Transaction Processing for SQL Database Integrity
(Ben Forta) In this lesson, you’ll learn what transactions are and how to use COMMIT and ROLLBACK statements to manage transaction processing.
Yukon Index enhancements
(RudolfH) Indexes in any modern relational database system are important but perhaps even more important is how you make use of them. With Yukon the functionality and features around indexes have become magnitudes better. Take a look at the following list of index related enhancements: 1. Disabli