IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 - TERMINATE utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1689
Location: Tiruppur, India

PostPosted: Mon May 15, 2017 11:49 pm
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Tue May 16, 2017 1:54 am
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1689
Location: Tiruppur, India

PostPosted: Tue May 16, 2017 2:48 am
Reply with quote

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
View user's profile Send private message
farhad_evan

New User


Joined: 30 Aug 2014
Posts: 24
Location: UK

PostPosted: Tue May 16, 2017 4:29 pm
Reply with quote

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
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1689
Location: Tiruppur, India

PostPosted: Tue May 16, 2017 10:12 pm
Reply with quote

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
View user's profile Send private message
farhad_evan

New User


Joined: 30 Aug 2014
Posts: 24
Location: UK

PostPosted: Mon May 22, 2017 8:12 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts Issue in KWIKKEY utility while creat... JCL & VSAM 2
No new posts DSLIST utility ISRDSLST line command CLIST & REXX 5
No new posts Utility to list Data Set Information JCL & VSAM 6
Search our Forums:

Back to Top