TERMINATE A STOPPED DB2 UTILITY

When your DB2 LOAD JOB stops with some issue, your TABLESPACE status will show UTUT, which means the LOAD utility that used in your job has actually held your TABLESPACE. At this point, you cannot even do a SELECT on your Table. So to re submit the LOAD job or to access the DB2 table, you have to first terminate the utility that has held your TABLESPACE. The UTILITY id usually will be your JOB NAME or you can even get it from the abended JOB in the SPOOL.

Once you have the UTILITY ID, follow the below steps to terminate it.

  1. Go to DB2I(DB2 interactive functions).
  2. Select your DB2 subsystem.
  3. Go to option 7 (DB2 commands).
  4. Use the command “-DISPLAY UTIL(*)” to see the utilities currently being executing or stopped.
  5. Use the command “-TERM UTIL(MYUTIL)” to terminate the problem utility id “MYUTIL”.

Note: This post is just to let you know the way to terminate the utility. Please read the comment from Jun below. As mentioned, this should be considered as last resort. It is always best to check with DBA before performing. In testing phase, if you are sure, you are not losing anything, you can go ahead and do this.

Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
DB2 SQL Query to read COMP (COBOL) data stored in CHAR column
DB2 Performance – Using SET vs SYSDUMMY1 table
DB2 Performace – Predicates Processing Order
DB2 External Stored Procedures
DB2 UPDATE QUERY – UPDATE TABLE1 FROM TABLE2 DATA
DB2 PERFORMANCE ISSUE (When using EXISTS)
HOW DOES DB2 INTERNALLY (PHYSICALLY) STORE THE DATA
HOW DO YOU FIND WHO HAS ACTUALLY LOADED THE DB2 TABLE RECENTLY
TERMINATE A STOPPED DB2 UTILITY
SELECT UNIQUE RECORDS USING “GROUP BY”
DB2 and SQL INTERVIEW QUESTIONS
DB2 TIPS
Optimistic Locking vs. Pessimistic Locking
DB2 BIND OPTIONS and ISOLATION
Is SCHEMA name necessary for DYNAMIC QUERY
DB2 SQL – REPLACE CHARACTERS WITH ACCENTS (NON ENGLISH ALPHABETS)

 

 

 

Advertisements