(Roger Sanders) A split mirror is an “instantaneous” copy of a database that is made by mirroring the disk(s) that contain the database’s data, and splitting the mirror when a backup copy of the database is required. Mirroring is the process of writing all database data to two separate disks (or
Tag: IBM
Workload Management for DB2 Data Warehouse
(C. Nin Lei) This IBM Redpaper addresses the workload management issues encountered in a data warehouse environment. It delivers a set of guidelines for overcoming these obstacles by utilizing the z/OS Workload Manager. It also provides tips and techniques for properly implementing a Workload Manage
Industry Process Accelerator for Business Intelligence
Industry Process Accelerator for Business Intelligence (IPA4BI) is a tool for modeling and generating data marts for DB2 Data Warehouse Edition. IPA4BI provides a framework for the creation of shareable and customizable templates for business intelligence. It is a centralized OLAP modeling tool that
IBM’s Database VP: Our Grid Scales Better
(Lisa Vaas) Q&A: Bob Picciano, vice president of database technology at IBM’s Toronto lab, says the company continues to pummel main database rival Oracle in terms of price and scalability.
DB2 ICE — Scaling Data with Linux Clusters
(Rav Ahuja) Putting together a database solution for managing large volumes of data is a daunting task. Many organizations struggle with solving the related technology integration challenges within IT budget constraints.
DB2 Information Integrator access to Sybase stored procedures that have result sets
(Micks Purnell) DB2 Information Integrator enables you to access data in many parts of your enterprise, stored in different data types, different databases and in differing formats. If you need to access Sybase stored procedures from DB2 Information Integrator, here’s help. Micks Purnell tells y
Convert a Universal Time Coordinated timestamp in DB2 Universal Database
(John Munteanu) This article presents the design of a Java implementation for a user-defined function for IBM DB2 Universal Database (UDB) that takes a UTC timestamp and a locale name as input parameters, and returns the timestamp equivalent in the new locale. This is an especially useful functi
IBM unveils DB2 for small business; Microsoft, Oracle say: ‘We’re not impressed’
The corporate database market historically has had two distinct tiers: one in which Oracle and IBM battle for the business of large enterprises, and a second one where Microsoft scoops up most of the sales from small and medium-size businesses.
TechTip: New Tool for Analyzing DB2 Performance
(Kent Milligan) If you’re looking for a reason to upgrade to V5R3 or if you’re wondering how to get more out of the latest release, then look no further than the new Index Evaluator. This new function makes it easier to analyze which indexes (and keyed logical files) are helping your SQL and query p
IBM Updates Application Development Life-Cycle Management Tools
(Barbara Darrow) IBM updated several of its application development life-cycle management tools recently as part of its never-ending On Demand marketing campaign.
