The JDBCTM API test suite contains tests useful for testing a driver based on JDBC technology (“JDBC driver”) for it’s conformance to the requirements of the JavaTM 2 Platform Enterprise Edition (J2EETM). This test suite is intended to assist driver vendors in preparing their drivers for certificati

Replication Monitoring Center for DB2 is a software tool that supports DB2 replication supervision. It is used atop DB2 DataPropagator, the DB2 UDB data replication feature. The Replication Monitoring Center for DB2 is used to supervise replication scenarios, reporting configuration, and operational

IBM announced new software that extends the reach of business information to handheld computing devices. The new database software provides customers with real-time access to business information, enabling mobile employees to tap into critical data to respond faster to customer needs and be more pro

(Rick Merritt) Riding a wave of interest in Linux clusters, startup Mellanox Technologies Inc. rolled out its first Infiniband switch capable of handling 30 Gbit/second data transfers. The InfiniScale III is aimed at port aggregation and lowering cost per port for the high-speed, low latency interco

(Bruce Benfield and Richard Swagerman) This paper describes how to use new functions available in IBM DB2 Universal Database Version 7.2 (Unix & Windows) to easily integrate data encryption into database applications. For years, databases have been able to keep unauthorized persons from being able t

This section explains in detail how to declare bind variables in the otl_stream. A SQL statement, PL/SQL block or a stored procedure call may have placeholders which are usually connected with bind variables in the program. OTL 4.0 has a small parser that parses the SQL statament / PL/SQL block

(Paul Yip) This short article is intended for those who are new to DB2 UDB and wish to understand how to manipulate dates and times. Most people who have worked with other databases are pleasantly surprised by how easy it is in DB2 UDB.

A check constraint is a rule enforced by DB2 that specifies the values allowed in one or more columns of every row of a table. Prior to DB2 V4.1, check constraints could be specified on views, but their usefulness was quite limited. Find out more about constraints, how to create them and more wi

(Darryl K. Taft) IBM Corp. has put a name on its strategy to componentize its middleware on the way to delivering service-oriented architectures (SOAs), primarily through componentizing its WebSphere application server in a project known as “Vela,” company officials said.

(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip) Loops allow you to execute a set of statements repeatedly until a certain condition is reached. The loop terminating condition may be defined at the beginning, in the middle, or at the end of the lo