Articles & Content


Speed Up SQL Inserts with DB2 for z/OS Data Sharing (E03)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2011

Users were complaining about long running batch jobs with high volume SQL Inserts. They were afraid not to commit Service Level Agreement anymore. In DB2 for z/OS Data Sharing, some technical aspects (DDL, freespace, locks, logging, access patterns, ...) may have more impact on Performance compared to non-Data Sharing. We tested different solutions before to implement the most useful ones in Production in order to reduce CPU and Elapsed times.

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.