DB2 9 for z/OS by Willie Favero

Hi DB2 user,

Willie Favero published several posts about DB2 9 for z/OS on his Blog: Getting the Most out of DB2 for z/OS and System z

- Clone tables
- Let's continue our discussion on CLONE tables in DB2 9 for z/OS
- DB2 9 for z/OS, compression, REORG/LOAD, and a possible surprise
- DB2 9 for z/OS Universal Table Spaces (UTS)
- Spatial and DB2 9 for z/OS
- Index contention relief
- Optimization Service Center (OSC) Part I
- Optimization Service Center (OSC) Part II
- NOT LOGGED option
- Determining when a row was last changed
- IMPLICITLY HIDDEN column attribute
- INSERT performance improvement
- Reordered row format
- DB2 9 Premigration Checkout Job
- SQL MERGE statement


Regards,

DB2usa.

DB2 9 for z/OS by Craig Mullins

Hi DB2 user,

Craig Mullins published several posts about DB2 9 for z/OS on his DB2 Portal Blog:

- Encryption
- Index Compression
- CLONE Tables
- New Data Types
- New Built-in Functions
- Implicitly Created Database Objects
- Skipping Locked Rows
- Do You Want to Ignore Clustering?
- Reordered Row Format
- INSTEAD OF Triggers
- LOB Enhancements
- New OLAP Capabilities
- Implicitly Hidden Columns
- Index on Expressions
- Database Definition on Demand
- SELECT from DELETE, UPDATE, and MERGE
- MERGE and TRUNCATE
- Native XML Support in DB2 Databases
- ORDER BY and FETCH FIRST in Subselects
- INTERSECT and EXCEPT

Regards,

DB2usa.

DB2 for z/OS V8 Migration (podcasts)

Hi DB2 user,

IDUG published audio materials from Willie Favero and Roger Miller on IDUG website:

- DB2 for z/OS V8 Migration Issues (Part 1)
with Willie Favero

- DB2 for z/OS V8 Migration Issues (Part 2)
with Willie Favero

- 10 Minute Tip: DBAs - Face Your Fears!
with Roger Miller


Regards,

DB2usa.