(Alan Smith) This tip gives you a list of tablespaces in a DB2 subsystem that hasn’t been copied in a certain number of days. It gives the date of the latest copy if one exists, or ‘*NO COPY*’ if there is no image copy. For recovery purposes, it’s important for a DBA to be able to determine which
Other News
IBM Puts Extra Barbs in ‘Stinger’ for LinuxWorld
(Clint Boulton) While speed and performance are considered requisite constants in the realm of database software, major vendors aim to keep their products fresh by adding new features. On the strength of that notion, IBM is poised to unveil a few new features to its next-generation Universal Dat
MDX Essentials: Basic Set Functions: The EXCEPT() Function
(William Pearson) In this lesson, we will focus our attention on a function that behaves in a manner that is dramatically different from the INTERSECT() function. Instead of returning the common members of two sets, EXCEPT() returns the difference between two sets. Duplicate handling is managed thro
Why RDF model is different from the XML model
(Tim Berners-Lee) This note is an attempt to answer the question, “Why should I use RDF – why not just XML?”. This has been a question which has been around ever since RDF started. At the W3C Query Language workshop, there was a clear difference of view between those who wanted to query documents an
Using a Script to Kill Processes in SQL
Backing up and restoring databases is part of every administrator’s job. While performing backups, a number of methods can be used to save time. If a database needs to be moved from one server to another, a backup on one server and a restore on another server is a great method. Some projects require
Working with Microsoft Office Word 2003’s XML
(Chuck Urwiler) The .doc file format that is still present in Word 2003 is essentially a proprietary binary format; sadly, .doc files are difficult to extract information from. By saving documents in the new XML format, you can easily retrieve information trapped inside of Word 2003 documents by usi
Application development: An introduction to serialization in .NET
(S. Vikram) Serialization is the process of saving the state of an object by converting it to a stream of bytes. The object can then be persisted to file, database, or even memory. The reverse process of serialization is known as deserialization. In this article, I discuss the uses of serialization
Enterprise Information Integration
(Pat Selinger) Almost any enterprise, even a small one, has multiple data sources containing business information. Consider e-mail databases, files containing text documents, spreadsheet files and so forth. Yes, you’re right; these are not “databases” in the classical DB2 Universal Database sense.
The Trigger Effect
(Willie Favero) New to the OS/390 community, DB2 Triggers can automate tasks and enable code reuse. Here’s what you need to know to put them to work. Database managers on DB2’s distributed platforms already know how triggers can save time and effort. Triggers have been available on Unix, OS/2, a
Oracle 9i: Performance Tuning with OMLET
(Amjad Daoud) This book is about performance tuning techniques using OMLET (Oracle Monitoring Applet): proactive (OMLET statspack edition) and iterative (OMLET professional edition). OMLET is a lightweight, non-obtrusive, pure 100% JAVA application that runs everywhere JAVA 2 lives!. Supported pla