DB2 for OS/390 and z/OS V7 Load Resume and SQL INSERT Performance
From the developerWorks archives
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.