DB2 for OS/390 and z/OS V7 Load Resume and SQL INSERT Performance

From the developerWorks archives

Mai Nguyen and Akira Shibamiya

Date archived: January 12, 2017 | First published: March 01, 2002

The rise of e-business applications have made the performance of mass inserts even more critical. This report documents the results of different ways of adding data to a DB2 table in DB2 for z/OS: SQL INSERT, online load resume, and offline load resume. The costs and benefits of each method are presented, as well as recommendations for improving performance for whichever method is used.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=13847
ArticleTitle=DB2 for OS/390 and z/OS V7 Load Resume and SQL INSERT Performance
publish-date=03012002