(Daniel L. Luksetich) While recursive SQL will become a reality for mainframers with DB2 UDB for z/OS Version 8, it has been available on DB2 UDB for Linux, Unix, and Windows for quite some time. This very powerful SQL construct can be utilized to quickly solve many business functions, and will
Tag: IBM
DB2 Java connectivity with JDBC
(Kulvir Bhogal and Grant Hutchinson) DB2 UDB provides for JDBC connectivity through a number of Java classes and interfaces that implement the JDBC specification. The implementation is known as a JDBC driver. DB2 currently offers JDBC drivers known as legacy/CLI drivers and the universal JDBC driver
Hints and Tips for DB2 Data Warehouse Enterprise Edition
(Sermsak Sukjirawat) DB2 UDB Data Warehouse Enterprise Edition (DWEE), Version 8.1.2, is IBM’s complete business intelligence platform, bringing together DB2 UDB, DB2 UDB Database Partitioning Feature, DB2 Cube Views, DB2 Intelligent Miner Modeling, Scoring and Visualization, DB2 Office Connect, DB2
MySQL to DB2 UDB Conversion Guide
DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbook is an informative guide that describes how to migrate the database system from MySQL to DB2 UDB Version 8.1 on Linux, and how to convert applications to use DB2 UDB instead of MySQL. This guide pr
IBM creates a Google for corporations
(Kristi Heim) In the red-hot market for search technology, IBM hopes to do for corporate data what search engines like Google have done for the Web.
IBM Tools Eye Java-to-Non-Java Integration
(Vance McCarthy) Over the past few weeks, IBM has left no doubt that business-level integration and workflow are not just add-ons anymore — these are core platform services. IBM WebSphere and DB2 products have both added significant support for cross-platform data-driven integration.
The DB2 Configuration Files Revealed
(Marin Komadina) IBM has provided us with an automated installation process. As a result, many DBAs do not have any overview of where DB2 has stored important configuration information. The DB2 configuration files contain security setting parameters, system resource allocation, backup environment va
How High? High Availibility for Linux
(Simon Harris) This article describes the software, tools and techniques adopted in a recent project to provide a highly available, high volume OLTP system based on the Linux operating system. This article describes at a high level how High Availability (HA) systems operate and pays particular a
It’s RAD – Recovery, Audit, Data migration plus – using a DB2 log processing tool
This session will discuss capabilities and uses of Log Master for DB2. In addition to discussing Recovery, Audit, and Data Migration capabilities, we will also discuss alternative uses, such as methods to reduce maintenance window outages. (R)
An Introduction to Control Center Personalities in DB2 Universal Database Stinger
(Paul C. Zikopoulos and Roman B. Melnyk) If you come from a Windows background, you are likely to leverage a graphical user interface (GUI) to perform most of the management tasks for your environment, including managing your IBM DB2 Universal Database (DB2 UDB) server. The Control Center is the
