Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 - TERMINATE utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1504
Location: Chennai

PostPosted: Mon May 15, 2017 11:49 pm    Post subject: DB2 - TERMINATE utility
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: 2284
Location: @my desk

PostPosted: Tue May 16, 2017 1:54 am    Post subject:
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: 1504
Location: Chennai

PostPosted: Tue May 16, 2017 2:48 am    Post subject:
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: 22
Location: UK

PostPosted: Tue May 16, 2017 4:29 pm    Post subject:
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: 1504
Location: Chennai

PostPosted: Tue May 16, 2017 10:12 pm    Post subject:
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: 22
Location: UK

PostPosted: Mon May 22, 2017 8:12 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us