(Peter Coffee) When technologies move from the laboratory to the enterprise IT stack, they must make the transition from dancing bear to chorus line. Research projects can claim success if they dance at all, whether or not they dance well, but an enterprise solution must dance consistently—and well

(Lisa Vaas) As the deadline for Basel II compliance nears, IBM’s business intelligence solutions group is readying a new DB2-based tool to help financial institutions comply.

DB2 UDB V8 has several new on-line database maintenance features. These features can improve both the database availability and performance. This article reviews some of those features.

(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

(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

(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

(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.

Embarcadero Technologies, Inc., a leading provider of application and data lifecycle management solutions, announced expanded functionality for job scheduling across distributed, cross-platform enterprise environments with the general availability of Embarcadero Job Scheduler 3.1. Job Scheduler

Concurrency has always been an important issue with database systems. As well, in today’s systems the trend is towards self managing of memory to reduce DBA cost of management. DB2 has designed its locking mechanisms to address both issues simultaneously. Oracle is claiming that DB2s lock memory man

As in all Java programs, error handling is done using try/catch blocks. Methods throw exceptions when an error occurs, and the code in the catch block handles those exceptions. JDBC provides the SQLException class for handling errors. All JDBC methods throw an instance of SQLException when an er