Home > DB2 for z/OS > DB2 V8 for z/OS: V8 Update (Developer)

DB2 V8 for z/OS: V8 Update (Developer)

Course Code:	DZ8DS2
Duration:	2 days
Audience:	Developers, Programmers and DBAs.
Prerequisites:	At least six (6) months of developer, SQL, experience.
Summary:	This presentation aims at developing a clear understanding of DB2 V8's SQL and programming enhancements in terms of: z/OS concepts DB2 V8 exploitation of z/OS Interactive and static SQL Application programming changes Multiple level security (e.g., row) Enhanced table design options Enhanced index design options Locking and concurrency Explain tools, including Visual Explain Query tuning guidelines Developer friendly utilities
Objectives:	Upon completion of this presentation, the delegate should be able to code interactive and static SQL to exploit the z/OS architecture. Additionally, best practices and tuning tips will be discussed as these relate to design and programming.
Detailed Outline

Course Schedule