DB2 9 pour z/OS par Willie Favero

Bonjour,

Willie Favero a publié plusieurs articles sur DB2 9 pour z/OS sur son 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

Amicalement,

DB2usa.

DB2 9 pour z/OS par Craig Mullins

Bonjour,

Craig Mullins a publié plusieurs articles sur DB2 9 pour z/OS sur son 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


Amicalement,

DB2usa.

Migration vers la version 8 de DB2 pour z/OS (podcasts)

Bonjour,

IDUG vient de mettre à disposition des podcasts audio de Willie Favero et Roger Miller sur son site web.

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

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

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


Amicalement,

DB2usa.