IBM introduced new software that allows businesses to better manage the growth of information by integrating data warehousing and archiving capabilities.
Tag: IBM
DB2 History 101: Version 1.2
(Willie Favero) Even though DB2 V1.1 had only been GA for 10 months, Database 2 (DB2) Version 1 Release 2 was announced on February 4, 1986. Just one month later on March 7, V1.2 went GA. Since DB2 had now been in use by the general database community for a whole year almost (not counting the time i
Travels with Mark: A Hitchhiker’s Guide to the UniVerse, Part 5: Increase dynamic array processing performance in IBM UniVerse
(Mark Baldridge) This installment of the UniVerse performance series, investigates the effects of field-level caching in dynamic array access and suggests improvements for dynamic array access. (R)
Optimization Service Center Helps You Tune Your Applications and Queries in DB2 9 for z/OS
(Patrick Bossman and Gene Fuh) DB2 9 for z/OS includes new tools to improve the productivity of application developers and DBAs in tuning SQL workloads and individual SQL statements. Optimization Service Center (OSC) is a workstation tool for monitoring and tuning SQL workloads and individual SQL s
DB2 9 System Parameter Changes for Application Development
(Troy Coleman) Last week I discussed a quick way to create a list of system parameter changes by comparing the source macros found in SDSNMACS library. Some of these parameters impact your application developers while others impact your database programmers and how DB2 manages memory and resources.
DB2 Backup Basics – Part 3
(Chris Eaton) So far we have discussed backup syntax including targets and backup types and some options for backup. In this posting let’s look at a few other options on the backup command.
Implement new security capabilities in DB2 9.5, Part 2: Understanding trusted contexts
(Paul Read) IBM DB2 9.5 provides new options for tighter security, and allows for more granularity and flexibility in administration of the database. This tutorial is the second of two tutorials that cover roles and trusted contexts. Follow the exercises in this tutorial, and learn how to take advan
Referential Integrity: Application-Based or DB2-Based?
(Robert Catterall) This is a debate that has interested me for years. I’ve heard very good arguments on both sides, but before I get into that I’ll state that what I don’t like to see is the use of both DB2-based and application-based methods used to define and enforce the same referential integrity
DB2 History 101: Version 1
(Willie Favero) So why the nostalgia? As I mentioned Friday, a few post on the DB2-L list started me thinking about how much history there is with DB2. Couple that with the fact that this year we will be celebrating the 25th anniversary of the announcement of DB2. I not prepared to through a birthda
The information perspective of SOA design, Part 1: Introduction to the information perspective of a Service Oriented Architecture
(Brian Byrne, David McCarty, Dr. Guenter Sauter, Peter Worcester and John Kling) This article is written for architects and practitioners designing a Service Oriented Architecture (SOA). It introduces a set of patterns and capabilities representing the information perspective in the design of an SOA
