Db2 for z/OS advanced programming (EN/NL/FR)

In this two-day ABIS training, you discover Db2 specific aspects (like materialisation and pseudo-conversations) which are important in application programs.

During this course participants learn

• to coordinate the development of batch-oriented applications with the characteristics of Db2, specifically regarding restartability, i.e., how to make long-running applications restartable;
• how Db2 is to be used in an interactive context: as a back-end of a web interface, or in combination with a Transaction Processing environment (CICS TS, IMS/TM, or ISPF);
• to give attention to the integrity of data manipulations, as well as to performance;
• how to set up pseudo-conversations.

These goals can be achieved through a thorough analysis of the cursor concept, and by finding out when Db2 materialises its result set.

At the end of this course you will be able to build optimal applications independently, both for interactive use and for batch.

Intended for

Application developers, DBAs, and everyone involved in designing, writing, or supporting Db2 applications.

Backgroud

Participants should be familiar with embedded SQL (Db2) in COBOL PL/I, SQL PL, or an other programming language (see course Db2 for z/OS fundamentals course). At least a few months of practical experience is recommended.

You can test for yourself to see whether you have sufficient background by filling out the online self-test "Db2".

Main topics

• Embedded SQL: new and advanced possibilities: row sets • indicators • less known cursor options • more about subqueries
• Cursor processing: internal functions • link with integrity • performance aspects • materialisation
• Pseudo-conversations: scrolling • positioning • repeatable read • scrollable cursors
• Batch oriented application: synchronisation • restartability • bulk processing of data • off-line alternatives
• SQL solutions versus programmed solutions: integrity • performance
• Increasing importance of packages, of dynamic SQL, and of BIND options like REOPT
• Locking: selection of the most suitable options for optimal concurrency
• New(er) possibilities of Db2 in this context, like package versioning, optimistic locking, multi-row fetch, piecemeal delete, and pagination

Training method

Apart from theory, ample time will be spent on several examples and exercises.

Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

Certificate

At the end of the session, the participant receives a "Certificate of Completion".

Duration
2 days.