(Willie Favero) 1993 was the year of DB2’s 10th anniversary. It was the year that DB2 Version 3 was announced and became generally available (GA) on October 25, 1991 and then again on March 22, 1992.
Tag: IBM
DB2 9 and Microsoft Access 2007: Working with your DB2 Data in Access 2007
(Paul Zikopoulos) In the first part of this series, I showed you how to use Access 2007 as a graphical front end to a back-end DB2 data server. Specifically, I showed you how to implement linked tables and create an abstraction layer over those linked tables such that information workers can work wi
Does the order of coding elements in your IN list matter?
(Klaas Brant) If IN list column is indexed (and chosen as a matching column), DB2 Sorts IN list into ascending sequence, removing duplicates. The IN list values are then used to probe the index to find the matching rows. Thus order of elements is irrelevant for an IN list that is chosen for IN list
DB2 History 101: Version 2.3
(Willie Favero) Just over two years will go by before the next new release of DB2 becomes available.
An introduction to Master Data Management Reference Architecture
(Martin Oberhofer and Allen Dreibelbis) Get a short introduction to the Master Data Management Reference Architecture for the enterprise which supports implementing multiform Master Data Management (MDM). Learn about the key concepts that drive the design of the MDM Reference Architecture and Logica
DB2 DBA Certification Sample Questions: Configuring server communications and understanding SMS tablespaces
(Roger Sanders) As the 20th IDUG convention nears, you might be considering taking advantage of the free certification exams that will be offered there. If you’re considering the DB2 9 DBA certificiation exam, try your hand at these sample certification questions from the book DB2 9 for Linux, UNIX,
TechTip: RUNSQLSTM Is Bigger and Better in V6R1
(Kent Milligan) As SQL becomes more widely used by i5/OS developers, it’s important for IBM to continue to enhance the tools and utilities supporting the SQL interface to increase the adoption of SQL. The Run SQL Statements (RUNSQLSTM) system command is one of those SQL utilities that is enhanced in
Optimizing Restore and Recovery Solutions with DB2 Recovery Expert for z/OS V2.1
(Paolo Bruni, Tom Hubbard, Rajasekhar Jonnagadla, Ravikumar Kalyanasundaram and Hennie Mynhardt) IBM DB2 Recovery Expert manages the recovery of DB2 for z/OS V8 and V9 objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert V2.1 for z/OS (5697-N92) major focus is on DB2 s
Migrate DB2 applications to a partitioned database
(Bill Wilkins and Peter He) Using a partitioned database allows you to maximize the scalability and capacity of DB2 for Linux, UNIX, and Windows. This article discusses what DB2 database partitioning is, outlines the benefits and costs of using it, and helps you decide whether or not to use a partit
IBM Uncages Cheetah 2 Data Server
(Brian Prince) Less than a year after unleashing its “Cheetah” data server, IBM is set to release a new version of its software with enhanced availability.
