Mullins As a professional DB2 developer your days are extremely busy. Not only do you need to understand DB2, but you also need to understand programming and design issues, SQL, data modeling, operating system internals, on-line transaction processing systems, performance monitors, third-party tools, distributed data, and office politics. Well, now there is! The book is designed for ease of use both as a learning tool and a reference. The latest edition of a classic book on DB2 for database administrators and application programmers.

Author:Voodoohn Kigazshura
Language:English (Spanish)
Published (Last):25 December 2019
PDF File Size:1.4 Mb
ePub File Size:15.99 Mb
Price:Free* [*Free Regsitration Required]

Version 1 Release 2 was announced on February 4, and was released for general availability a month later on March 7, Can you imagine waiting only a month for a new release of DB2 these days? But that is how it happened back then.

Versions are major changes, whereas releases are not quite as significant as a version. Version 2 Release 1 was announced in April and delivered in September Here we start to see the gap widening again between announcement and delivery. V2R1 was a significant release in the history of DB2, a bellwether of sorts for when DB2 began to be viewed as capable of supporting mission-critical, transaction processing workloads. Not only did V2R1 provide significant performance enhancements but it also signaled the introduction of declarative Referential Integrity RI constraints.

But it was not until a year later that it became generally available on September 23, DB2 V2R2 again bolstered performance in many ways. It also saw the introduction of distributed database support private protocol across MVS systems.

Version 2 Release 3 was announced on September 5, , and became generally available on October 25, Two very significant features were added in V2R3: segmented table spaces and packages. Segmented table spaces quickly became a de facto standard and packages made DB2 application programs easier to support.

Now it may look like things sped up again here, but not really. This is when the early support program for DB2 started. Early support was announced in March and delivered to customers in June V3 greatly expanded the number of buffer pool options available from 5 pools to 80 , and many advances were made for DB2 to take better advantage of the System environment, including support for hardware-assisted compression and hiperpools.

Version 4 signaled another significant milestone in the history of DB2. It was highlighted by the introduction of Type 2 indexes, which removed the need to lock index pages or subpages, now obsolete.

Prior to V4, index locking was a particularly thorny performance problem that vexed many shops. In June DB2 Version 5 became generally available. Not as significant as V4, we see the trend of even-numbered releases being bigger and more significant than odd-numbered releases of course, that is just my opinion.

Version 6 brings us to and the introduction of the Universal Database term to the DB2 moniker. And the Release Guide swelled to over pages!

Six categories of improvements were introduced with V6 spanning object-relational extensions, network computing, performance and availability, capacity improvements, data sharing enhancements, and user productivity. The biggest of the new features were SQLJ, inline statistics, triggers, large objects LOBs , user-defined functions, and distinct types. It added functionality to DB2 without there being a new release or version. Developed and released around the time of the Year hubbub, it offered much-improved utilities and some nice new SQL functionality including scrollable cursors, limited FETCH, and row expressions.

Unicode support was also introduced in Db2 V7. DB2 Version 8 followed, but not immediately. IBM took advantage of Y2K and the general desire of shops to avoid change during this period to take its time and deliver the most significant and feature-laden version of DB2 ever. V8 had more new lines of code than DB2 V1R1 had total lines of code!

The XML is stored natively as a new data type that can be searched and analyzed without the need to reformat it. Examples include improved compression, cache optimization, blades for running the Smart Analytics Optimizer, etc. New functionality is now delivered in Function Levels FLs that are easily applied and delivered much more rapidly than in the past. Indeed, the current Db2 function level is FL, which means there have been 6 new function levels added since Version 12 brought with it a plethora of new capabilities including virtual storage enhancements, optimization improvements, and improved control over the introduction of new SQL capabilities.

TT2168 PDF

Craig Mullins - IBM Gold Consultant



Craig Mullins and DB2 11! Don't miss it


Related Articles