The International DB2 Users Group (IDUG) welcomed DB2 professionals, and many of the industry’s leading vendors to the Paris Hotel in Las Vegas, May 19-23, to exchange a wealth of DB2 information and resources at IDUG 2003 – North America.
Author: SSWUG Research
New DB2 Problem Determination Mastery Exam
Now available is the Problem Determination Mastery Exam for DB2 Universal Database (UDB) — the industry’s first standalone measure of problem determination skills. Based on customer feedback, this concise exam was developed by IBM’s leading DB2 UDB technical support staff. The exam is designed to p
Detecting and Fixing Out-of-Balance Indexes
By Boris Milrud – Oracle indexes are not self-balancing. They become fragmented after a large number of INSERTs and DELETEs, which may lead to significant performance degradation. In this 10-Minute Solution I show you how to detect these "out-of-shape" indexes and cure them.
RealNetworks open sources SMIL 2.0 implementation
Rob Lanphier from RealNetworks writes with news that they have released their implementation of the W3C’s Synchronized Multimedia Integration Language as open source.
Build Flexible, Lightweight XML-Based Images for ASP.NET Using Scalable Vector Graphics
Scalable Vector Graphics (SVG), a W3C graphics standard built around XML, is one of several vector graphics technologies that allows fast, lightweight drawings such as charts and graphs to be rendered on the fly in an appropriate viewer. There are many advantages to such vector graphics, including c
Coordinate system, can’t live without it
Excerpt from the book: Learn SVG. The SVG document provides us with a default coordinate system – the initial User Coordinate System. With this user coordinate system comes along a plane 2D-space. This canvas is theoretically infinite in both dimensions. To specify a point on the canvas, we also nee
Oracle Plots Acquisition Course
By Renee Boucher Ferguson – At its annual financial analysts meeting at its headquarters in Redwood Shores, Calif., Wednesday, Oracle Corp. said it’s in a position of strength and plans to use that to acquire other companies in its quest to give software giants SAP AG and Microsoft Corp. a run for t
Trigger to Prevent Dropping Objects
by Rajasekhar Aluru – This trigger secures objects, preventing a user from dropping them by mistake. To begin, create a table for the example below called secured_objects with a column objectname, with datatype varchar2(20). Insert a record into this table with a value, the name of the object, which
TOP N Clause vs. SET ROWCOUNT N
Q. Is using the TOP N clause faster than using SET ROWCOUNT N to return a specific number of rows from a query? A. With proper indexes, the TOP N clause and SET ROWCOUNT N statement are equally fast, but with unsorted input from a heap, TOP N is faster.
DB2 Gets Cube Smart
by Mark Leon – IBM claims to have taken some of the pain out of online analytic processing (OLAP) with a new piece of software called Cube Views that adds OLAP administrative and performance-enhancing functions to DB2, IBM’s relational database.