Articles & Content

Archives

Exploiting Multi Row INSERT - Points to Ponder (A07)

Topic: 2009 NA

Subtopic: DB2 for z/OS



DATE: 2009-5-13 (01:30 PM - 02:30 PM)
SPEAKERS: Anthony Tichonoff (Florida Hospital)

Multi-row FETCH in V8 provided a significant perfomance boost, but what about multi-row INSERT? It can significantly boost INSERTing perfomance and reduce CPU usage. Converting existing programs involves some serious structural changes to both SQL and program logic. Learn from those who have gone before into the world of multi-row INSERT. Attend this session if you want to understand the power and pitfalls of multi-row INSERT.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Explain the concept of how multi-row INSERT works

Describe some of the reasons and implications of using multi-row INSERT

Specify the changes required to implement multi-row insert in your COBOL programs

Identify potentical pitfalls with; unit of work, error handling, array processing, backout processing

Describe the way this has been successfully implemented in one business



Click Here to Download

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