View previous topic :: View next topic
|
Author |
Message |
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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 |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
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. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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. |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi Farhad,
I understood what an utility is, Thank you. But we need only the timestamp when a utility was terminated.
Regards, |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
|