Articles & Content


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

Topic: 2010 NA

Subtopic: DB2 for z/OS

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


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.


This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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