DB2 9 and 10 for z/OS Beta Program Begins…..

May 24, 2010

Hi again. For this month , I’m going to tell you about the wonders of database DB2 10 , the most recent database produced by IBM. DB2 has been on the database market for so many years , and it had it own market and customer. For us in Malaysia , many organization including the goverment had implemented database DB2 in their system. For DB2 10 , its specifically means for the z/os operating system. Here I include the excerpt from the Data Management Magazine from IBM that I received this month..Hope you all will enjoy….!

New version designed for improved performance, scalability, and cost savings

Building on the formidable capabilities of IBM DB2 9 for z/OS and the IBM System z platform, the next version of DB2 for z/OS has moved one step closer to release. Beginning in March, IBM made DB2 10 for z/OS available to selected organizations in a closed beta program. The new version includes features that can improve performance, increase the resiliency of business-critical data, and accelerate application and warehouse deployment.

Internal testing at IBM indicates that customers may realize significant out-of-the-box CPU savings with DB2 10, depending on the type of workload. Additional savings and higher performance can be achieved by taking advantage of features including hash access, index include columns, in-line large objects, parallel index updates, faster single-row retrieval, in-memory work files, index list prefetch, and a 1 MB page size for System z10 buffer pools.

The new version of DB2 can also support up to 10 times as many users per data-sharing group member than was possible with previous versions of DB2. Depending on the configuration and situation, this can mean that fewer data-sharing members are needed, greatly increasing the number of users that can be supported on reduced memory and CPU resources.

Maintaining the resiliency of business-critical information is another area of emphasis in this release. More data access, data management, and data definition functions can be handled concurrently, reducing overall downtime. Schema evolution, or data definition on demand, enables developers and DBAs to change the structure of the database in certain ways without requiring DB2 to come down—and fewer planned outages result in higher availability. DB2 10 also has several features aimed at enhancing security and simplifying regulatory compliance, including data masking, more granular administrative privileges, and new audit capabilities.

Enhancements for rapid application and warehouse deployment to support business growth round out the feature set for DB2 10, including support for temporal or versioned data, which facilitates a more automated process for rolling old data into archives over time. A number of SQL enhancements make the DB2 10 SQL implementation more consistent with other members of the DB2 family and make it easier to adapt SQL applications originally written for other database platforms. Examples include a 64-bit ODBC driver, Currently Committed locking, implicit casting or loose typing, time stamp with time zone, and moving sum and average.

DB2 10 also features enhancements to DB2 pureXML that focus on improving performance and usability of XML data applications. These include schema validation in the engine, a binary XML exchange format, multiversioning, easy update of subparts of XML documents, stored procedures, user-defined functions and triggers, and XML index matching with date/time stamp.

Query Management Facility (QMF), the DB2 query and reporting facility, also contains many updates for DB2 10, including more than 140 new analytical functions and support for HTML, PDF, and Flash report output.

Migration to DB2 10 is supported from both DB2 9 and from DB2 for z/OS V8.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: