Articles & Content

Archives

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

Topic: 2011 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



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.