Articles & Content

Archives

John Deere's User Experience with DB2 9 New Features (B09)

Topic: DB2 for z/OS

Subtopic: 2010



DATE: 2010-5-13 (08:30 AM - 09:30 AM)
SPEAKERS: Bryan Paulsen (John Deere)

John Deere participated in the DB2 9 for z/OS Early Support Program back in 2007. Since that time we have been migrating DB2 9 to our Classic/Legacy and SAP environments. This updated presentation will include the items we tested as part of the ESP and include new material from what we have learned during the migrations and while running DB2 9. This presentation will provide an introduction to some of the new DB2 9 features including universal tablespaces, clone tables, partition by growth, index compression, not logged tables, roles and trusted context, several utility enhancements, BACKUP SYSTEM and RESTORE SYSTEM utilities, reordered row format and DB2 9 spatial object exploitation. I will cover the migration process, recommendations for work files, apars of interest and talk about converting from private protocol to DRDA. Just for fun, I'll compare some of the DB2 9 features with the equipment we make at John Deere.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

D2 9 migration process.

Apars of interest and work file recommendations.

DB2 9 new features; universtal tablespace, clone tables, partition by growth, index compression, not logged tablespace, database roles and trusted context, and utility enhancments.

DB2 9 spatial object exploitation and private protocol to DRDA conversion.

BACKUP SYSTEM and RESTORE SYSTEM utilities.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.