DB2 for z/OS vs. DB2 UDB for LUW

Currency:V8.x.x and V9.x.xLevel:Intermediate to advancedAudience:DB2 DBAs, administrators and capacity planners.Prerequisites:At least six (6) months experience as a DB2 UDB for LUW or DB2 for z/OS DBA.Summary:Organised mainly for the DB2 DBA, this presentation focuses on the differences, similarities and sameness with regards DB2 LUW and DB2 z/OS; with this in mind, we focus on the following:

• Architecture
• Schema objects
• DB2 limits
• DB2 object creation and maintenance
• DB2 address spaces
• DB2 storage model
• DB2 tools
• Locking and concurrency
• I/O concepts
• DB2 optimizer
• Backup and recovery utilities
• Performance/monitoring tools
• Security and authorisation
• Performance and tuning issues

Objectives:Upon completion of this presentation, the delegate should be able to think clearly with regards DB2 UDB for LUW and DB2 for z/OS functional differences and likeness.