Part of a series of recorded IBM® BetaWorks™ presentations that describe new features of DB2® 9 for z/OS®. This presentation covers the process of migrating to DB2 9 for z/OS.

This presentation describes non-uniform statistics for indexes and non-indexed columns, new index statistics, and how statistics are kept for data-partitioned secondary indexes in DB2® for z/OS®, Version 8.

DB2® 9 for z/OS® performance topics presented at IBM® Information On Demand 2007 by Akira Shibamiya, Senior Technical Staff Member, DB2 for z/OS performance. Both system and SQL application performance are covered.

You can acquire z/OS products either as part of a system replacement offering or in a product upgrade offering. This Support Technical Exchange describes the advantages of each offering, as well as how to acquire products electronically. Level of Difficulty: Intermediate Presenter(s): Greg Daynes DATE: 10 June 2009

Learn about the various practices for security and ways you can improve security in your system. This presentation discusses various security needs and objectives, and the IBM tools that can help to meet your individual security needs. The presentation outlines choices and guidelines that you should consider to improve security for your individual situation.

Read this presentation to gain new insight on large objects (LOBs). This presentation discusses new features relating to LOBs in DB2® 9 for z/OS® , and ways to use LOBs. Some other topics covered in this presentation are file reference variable support in DB2 9, LOB support in DB2 utilities, and improved LOB handling for LOAD and UNLOAD in DB2 9. Some preliminary performance results are also discussed.

This presentation discusses the new backup and recovery features in DB2® 9 for z/OS®. The presentation discusses the DB2 managed FlashCopy solution in Version 8 and the new copy pool enhancements, including managing copy pool backups to tapes, using copy pool backups as the source for DB2 table and index recovery, and features of incremental FlashCopy. The presentation also discusses restart enhancements, including how to extend RECOVER utility to support point-in-time recovery with transaction level con

This presentation discusses 64-bit hardware, 64-bit real storage, 64-bit virtual storage, and use of the new structure in DB2 for z/OS. The discussion includes some of the earlier techniques, including use of multiple address spaces, hiperpools, data space buffer pools, and global buffer pools. Then, the presentation discusses the Version 8 implementation with the new memory structure, which moves the IRLM data and many pools in the DBM1 address space above the bar. The net results of this change is simple

Find out about the substantial security changes in DB2 ® for z/OS® Version 8 . There are new options for high security with multi-level security and row level security, in addition to improved flexibility in security for e-business and web applications. This presentation outlines the new options available for tighter security, more granularity, and more information for additional flexibility in applications and SQL for Version 8. The presentation also discusses expected changes beyond Version 8.

If your DB2® users have high demands on continuous operations and applications performance, this presentation is for you. DB2 for z/OS®, Version 8 introduces a number of features that are particularly relevant to SAP, PeopleSoft, Seibel and any complex installation. Enhancements in DBA operations, particularly backup, recovery, and monitoring, online schema changes, as well as various performance improvements make DB2 Version 8 very attractive for the demanding application suites. This presentation demonstr