DB2 - TERMINATE utility

vasanthz · Posted: Mon May 15, 2017 11:49 pm

Hi,

Could you please let me know how to determine when a DB2 utility was terminated.
DB2 utility for instance a LOAD utility.
I am a novice in DB2 so pardon the basic question.

Regards,
Vasanth.S

Arun Raj · Posted: Tue May 16, 2017 1:54 am

Vasanth,

At one of my previous sites, we used to check the SYSIBM.SYSCOPY DB2 system catalog table to know when LOADs were done last on a particular table. ICTYPE = 'S' is what we used to look for.

Now looking at the manual, I see there are different values
R - LOAD REPLACE LOG(YES)
S - LOAD REPLACE LOG(NO)
T - TERM UTILITY command (This one might be of interest to you).

Btw, we don't use DB2 at my current shop, so I can't run a test for you.

Besides, we also used to run the DISPLAY UTLITY command from the DB2I Primary Option Menu panel >> DB2 COMMANDS to see the status of utilities. It used to show which all utilities are in execution, and the phase/sub phase, etc. IIRC, it showed the status of STOPPED utilities as well.

vasanthz · Posted: Tue May 16, 2017 2:48 am

Hi Arun,

Thank you for the pointer about ICTYPE. I guess I did not explain my scenario in detail, I would try now,

We have a LOAD job and it failed due to a resource unavailability.
The subsequent run of the same job failed saying that the previous LOAD was inconsistent.
The next run of the same job went fine.

Yes, the person who did this was doing the same thing over and over and expecting the result to be different.

We are trying to find how the 3rd run went fine.
I am suspecting that a TERMINATE utility was run after the second failure and would want to confirm when the TERMINATE was performed.

I am not sure if it is written to DB2 log or SMF or some other place.

farhad_evan · New User Joined: 30 Aug 2014 Posts: 24 Location: UK

When your utility job fails, First you must run term util command to clean up it , Except that in LOAD utility Table Space goes to recover pending mod and indexes in rebuild pending mod.
In this situation your object is unavailable .
If data not important or must be replace you can just start force table space and indexes for reuse them and if data is important there are variety of scenario to solve it.

vasanthz · Posted: Tue May 16, 2017 10:12 pm

Hi Farhad,
I understood what an utility is, Thank you. But we need only the timestamp when a utility was terminated.

Regards,

farhad_evan · New User Joined: 30 Aug 2014 Posts: 24 Location: UK

If you have DB2 Query Monitor on your system you can find it so easy, But if you don't have I think you must try to read DB2 logs.