--- title: "DB2 LOAD Utility Essential Features(1 of 2)" description: "The best DB2 Load utility options that you need when you are working with DB2 projects. The methods given here always good to improve performane." url: https://srinimf.com/2010/05/16/db2-load-utility/ date: 2010-05-16 modified: 2026-10-10 author: "Srini" image: https://i0.wp.com/srinimf.com/wp-content/uploads/2010/05/pexels-photo-7512766.jpeg?fit=1880%2C1253&ssl=1 categories: ["DB2"] tags: ["DB2 Load Utility", "DB2 utilities", "DB2 Utilities with examples"] type: post lang: en --- # DB2 LOAD Utility Essential Features(1 of 2) The [LOAD utility](https://srinimf.com/2010/08/26/db2-load/) is used to accomplish bulk inserts to DB2 tables. It can add rows to a table, retaining the current data, or it can replace existing rows with the new data.  ## **Load utility performance** The biggest LOAD performance considerations focus on optimizing the LOAD utility itself. Of course, as LOAD adds data to DB2 tables, you need to be sure that you gather updated statistics by running either inline statistics or by following up each LOAD with a RUNSTATS. Failing to do so leaves outdated statistics in the DB2 Catalog, increasing the risk of improper access paths and poor application performance. With the [LOAD utility](https://srinimf.com/2019/01/15/db2-load-utility-useful-questions-for-interviews/), t[here are](https://srinimf.com/2017/11/21/db2-load-utility-top-parameters-example-jcl/) a lot of advantages. For instance, you can do mass deletes by specifying input data set [DD DUMMY](https://srinimf.com/2010/03/12/answer-jcl-question/). ## **How to restart LOAD utility JCL** You can restart the JCL, by specifying UTPROC=RESTART in the JCL. When space abend (SB37) occurs with input dataset, just increse SPACE in I/p data set and RESTART the jcl. If space abend occurs for O/P data set, you need to contact admin to increase O/P space. **Two methods for LOAD JCL** There are two distinct methods regarding the use of the LOAD utility. - The first and generally recommended philosophy takes more time to implement but is easier to support. It requires the reservation of sufficient disk space to catalog the LOAD [work data sets](https://srinimf.com/2010/06/12/load-utility-db2/) in case the LOAD job abends. The work data sets for the LOAD job are allocated for the DDNAMEs SORTOUT, SYSUT1, SYSERR, and SYSMAP with DISP=(MOD,DELETE,CATLG). This enables the data sets to be allocated as new for the initial running of the REORG job. If the job abends, it catalogs the data sets in case they can be used in a restart. After the step completes successfully, the data sets are deleted. The space for these data sets must be planned and available before the LOAD job runs. - Second approach is you can create JCL with restart option. This helps when job fails for an abend, you can restart the job. **Latest Posts** - [How to Find Databricks Job Status, Owner, and Active Runs Fast](https://srinimf.com/2026/10/17/databricks-find-job-status/) - [30 SQL Practice Queries with Solutions — Run Them Live](https://srinimf.com/2026/10/01/30-sql-practice-queries-with-solutions-run-them-live/) - [Supercharge Your Database Skills: Try Our New Interactive SQL Plugin!](https://srinimf.com/2026/09/30/supercharge-your-database-skills-try-our-new-interactive-sql-plugin/) ### Share this: - - [Tweet](https://twitter.com/share) - [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2010%2F05%2F16%2Fdb2-load-utility%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2010%2F05%2Fpexels-photo-7512766.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=DB2%20LOAD%20Utility%20Essential%20Features%281%20of%202%29) - - [Share on Tumblr](https://www.tumblr.com/share) - [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2010/05/16/db2-load-utility/?share=jetpack-whatsapp) - [More](#) - - [Print (Opens in new window) Print](https://srinimf.com/2010/05/16/db2-load-utility/?share=print) - [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2010/05/16/db2-load-utility/?share=reddit) - [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2010/05/16/db2-load-utility/?share=telegram) - [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20DB2%20LOAD%20Utility%20Essential%20Features%281%20of%202%29&body=https%3A%2F%2Fsrinimf.com%2F2010%2F05%2F16%2Fdb2-load-utility%2F&share=email) - ### Like this: Like Loading…