IBM - DB2 for z/OS - Advanced Programming for DB2 z/OS

KURSZIEL
IBM - DB2 for z/OS - Advanced Programming for DB2 z/OS: Zielgruppe
This advanced course is for the classical COBOL or PL/I mainframe programmer and C, C++ programmer with an interest in advanced topics and recommended practices to code and prepare high performing programs in a DB2 for z/OS environment. The programs in the lab exercises are pre-coded using COBOL; the student must only supply the DB2/SQL specifics.
Kursziele

• Develop high performing database applications that align with the organizations application growth plan and maintenance strategy
• Process SQL statements using the DB2 Pre-compiler or DB2 Coprocessor
• Code, prepare and run dynamic SQL programs
• Code applications that coordinate updates across multiple servers
• Debug applications using the DEBUG tool for z/OS
• Describe some components and architectural characteristics of Web applications and the role that DB2 plays in the Web application environment
• Describe how your program can interact with the Web
• Manipulate large objects
• Facilitate the exchange of large objects between DB2 and local data sets
• Develop applications that minimize locks on resources to support concurrent programs
• Use scrollable cursors efficiently
• Use stored procedures
• Consider using tools as an alternative to writing a program
• Write applications that do not hinder other applications

ZIELGRUPPE
Zielgruppe
This advanced course is for the classical COBOL or PL/I mainframe programmer and C, C++ programmer with an interest in advanced topics and recommended practices to code and prepare high performing programs in a DB2 for z/OS environment. The programs in the lab exercises are pre-coded using COBOL; the student must only supply the DB2/SQL specifics.
Kursziele

• Develop high performing database applications that align with the organizations application growth plan and maintenance strategy
• Process SQL statements using the DB2 Pre-compiler or DB2 Coprocessor
• Code, prepare and run dynamic SQL programs
• Code applications that coordinate updates across multiple servers
• Debug applications using the DEBUG tool for z/OS
• Describe some components and architectural characteristics of Web applications and the role that DB2 plays in the Web application environment
• Describe how your program can interact with the Web
• Manipulate large objects
• Facilitate the exchange of large objects between DB2 and local data sets
• Develop applications that minimize locks on resources to support concurrent programs
• Use scrollable cursors efficiently
• Use stored procedures
• Consider using tools as an alternative to writing a program
• Write applications that do not hinder other applications

KURSINHALT
This is the classroom version of Instructor Led Online course Advanced Programming for DB2 z/OS - Instructor Led Online (3V770).
This course provides lectures and hands-on lab exercises for the advanced application developer in a DB2 for z/OS environment.
You are expected to apply the knowledge acquired in this course to code and prepare high performing concurrent, static and dynamic programs supporting a local, remote, or distributed DB2 environment. An array of topics are taught which facilitates the coding and the maintenance of programs to enable you to write multi-purpose flexible programs that process large objects, use stored procedures, scroll through result sets, interact with the web, improve the usability of an application, use tools verses writing an application, and debug an application using the IBM Debug Tool.
Themenübersicht

• Application Architecture
• Application Architecture Exercise
• Program Preparation
• Dynamic SQL
• Dynamic SQL Exercise
• Distributed Data Access
• Distributed Data Access Exercise
• DEBUG Tool for z/OS
• DEBUG Tool for z/OS Exercise
• DB2 and the Web
• Large Objects
• Large Objects Exercise
• Locking
• Locking Exercise
• Scrollable Cursors
• Scrollable Cursors Exercise
• Using Stored Procedures
• Using Stored Procedures Exercise
• Tools versus Applications
• Tools versus Applications Exercise
• Performance
• Performance Exercise

VORRAUSSETZUNG
You should have:

• DB2 SQL Workshop (CE12) or equivalent SQL knowledge
• DB2 SQL Workshop for Experienced Users (CE13) or equivalent SQL knowledge
• DB2 9 for z/OS Application Programming Workshop (CV72D1DE) or equivalent experience
• DB2 9 for z/OS Stored Procedures (CV73D3DE) or equivalent experience
• Java programmers should attend course DB2 9 for z/OS Programming Using Java (CV14D1DE)