--- title: "How to Check Your [DB2 Utility] Job is Completed" description: "Here's a way you can use to check DB2 utility job completion status in mainframe Z/Os." url: https://srinimf.com/2021/06/06/how-to-check-your-db2-utility-job-is-completed/ date: 2021-06-06 modified: 2026-10-10 author: "Srini" image: https://i0.wp.com/srinimf.com/wp-content/uploads/2021/06/pexels-photo-3771110.jpeg?fit=1880%2C1253&ssl=1 categories: ["Categories", "DB2"] tags: ["DB2 Pending States", "DB2 utilities"] type: post lang: en --- # How to Check Your [DB2 Utility] Job is Completed In Zo/s, DB2 is a chief database. After running the utility job, the status you can check either in Spool or CLI. Usually, developers run [LOAD/UNLOAD utility (normally developers do) jobs](https://srinimf.com/2019/01/15/db2-load-utility-useful-questions-for-interviews/). They check the job’s status in the Spool. On the other hand, you can also check in CLI. The below example shows you [how to](https://srinimf.com/2015/11/09/how-you-can-use-display-utility-in-db2/) do it. Subscribe: For daily DB2 Tips ## Logs at Spool The [Spool is the space allocated for logs](https://www.ibm.com/docs/en/zos/2.2.0?topic=control-spool-data-sets-spooling) in Zo/S. So Spool is there to check job status why CLI of DB2 [you need](https://srinimf.com/2017/11/27/reorgchk-utility-top-role-in-db2-maintenance/)?. You can use it to check the status of submitted utility jobs online/Batch. ## Logs at DB2 CLI ``` -DISPLAY UTILITY(*) ``` Output ``` DSNU100I - DSNUGDIS - USERID = SAMPID MEMBER = UTILID = RUNTS PROCESSING UTILITY STATEMENT 1 UTILITY = RUNSTATS PHASE = RUNSTATS COUNT = 0 STATUS = STOPPED STATUS = STOPPED JOBNAME = STATSJB DSN9022I - DSNUGCC '-DISPLAY UTILITY' NORMAL COMPLETION ``` Here’s SAMPID, which tells userid submitted RUNSTATS utility. Its final status is “Normal Completion”. That means execution is completed normally. In interviews, you may ask a question that [when to perform](https://srinimf.com/2021/01/10/db2-5-bold-ideas-when-to-execute-runstats/) and who’ll perform. This is the admin’s role, not the developer’s. ## LOAD/UNLOAD These two are top [DB2 utility batch jobs](https://www.bmc.com/blogs/db2-ibm-utilities/)submitted by developers. You can see the status of completion either in Spool or DB2 CLI. *DB2 Job Status* ## Pending States In DB2, all the pending states while running utilities will happen on Table Space & Index Space. To continue your utility job progress, you need to reset by using any one of the methods & you need to re-run your job. Related[DB2- 5 Types of Utilities](https://srinimf.com/2013/04/03/db2-5-types-of-utilities/) The **[check pending](https://srinimf.com/tag/check-pending/) **flag for the **table space** can be reset by: - Running the [CHECK DATA](https://srinimf.com/2015/08/31/2-top-features-of-ibm-db2-check-data-utility/) utility for the tables in the table space specifying DELETE YES. - Running the CHECK DATA utility for the tables in the table space specifying DELETE NO if no constraint violations are encountered. - Running the LOAD utility specifying the ENFORCE CONSTRAINTS option. - Altering tables in the table space to drop foreign keys and check constraints. - Running the REPAIR utility specifying SET NOCHECKPEND for the table space or issuing the START command for the table space with the ACCESS(FORCE) parameter. Neither option corrects the problem flagged by the pending state; they merely reset the pending flag. The **copy pending** flag for the **table space** can be reset by: - Running the REORG utility with the LOG YES option or running the LOAD utility with both the REPLACE and LOG YES options. - Running the COPY utility specifying both the SHRLEVEL REFERENCE and the FULL YES options. - Running the REPAIR utility specifying SET NOCOPYPEND for the table space or issuing the START command for the table space with the ACCESS(FORCE) parameter. Neither option corrects the problem flagged by the pending state; they merely reset the pending flag. The **recover pending** flag for the **table space** can be reset by: - Running the LOAD utility with the REPLACE option. - Running a full recovery for the table space. - Running the REPAIR utility specifying SET NORCVRPEND for the table space or issuing the START command for the table space with the ACCESS(FORCE) parameter. Neither option corrects the problem flagged by the pending state; they merely reset the pending flag. The **recover pending** flag for the **index **can be reset by: - Running the REBUILD INDEX utility for the index. - Running the RECOVER INDEX utility for the index. - Running the REPAIR utility specifying SET NORCVRPEND for the index or issuing the START command for the index with the ACCESS(FORCE) parameter. Neither option corrects the problem flagged by the pending state; they merely reset the pending flag. Related Posts - [How to Check Status of Utility Jobs in DB2](https://srinimf.com/2015/11/09/how-you-can-use-display-utility-in-db2/)DateNovember 9, 2015 - [DB2- 5 Types of Utilities](https://srinimf.com/2013/04/03/db2-5-types-of-utilities/)DateApril 3, 2013 - [How to Resolve Check Pending State in DB2](https://srinimf.com/2017/02/21/the-best-reasons-why-check-pending-state-happens-in-db2/)DateFebruary 21, 2017 ### 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%2F2021%2F06%2F06%2Fhow-to-check-your-db2-utility-job-is-completed%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2021%2F06%2Fpexels-photo-3771110.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=How%20to%20Check%20Your%20%5BDB2%20Utility%5D%20Job%20is%20Completed) - - [Share on Tumblr](https://www.tumblr.com/share) - [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2021/06/06/how-to-check-your-db2-utility-job-is-completed/?share=jetpack-whatsapp) - [More](#) - - [Print (Opens in new window) Print](https://srinimf.com/2021/06/06/how-to-check-your-db2-utility-job-is-completed/?share=print) - [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2021/06/06/how-to-check-your-db2-utility-job-is-completed/?share=reddit) - [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2021/06/06/how-to-check-your-db2-utility-job-is-completed/?share=telegram) - [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20Check%20Your%20%5BDB2%20Utility%5D%20Job%20is%20Completed&body=https%3A%2F%2Fsrinimf.com%2F2021%2F06%2F06%2Fhow-to-check-your-db2-utility-job-is-completed%2F&share=email) - ### Like this: Like Loading…