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

OMEGAMON to see In-DB2 times and Wait Times History


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

New User


Joined: 04 Mar 2016
Posts: 2
Location: India

PostPosted: Fri Mar 04, 2016 11:28 am
Reply with quote

Hi all!!
I have inserted I lakh record into DB2 table through Java program using JDBC connectivy. To see the thread history details of the job in Mainframes Tivoli Omegamon , I have specifed all the required details , but I am unable to see In-DB2 times and Wait Times History.

Could anyone please suggest me the correct way to resolve this issue.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Fri Mar 04, 2016 12:39 pm
Reply with quote

Ask your technical support people. We can't guess where your DB/2 is tucked away.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2448
Location: Hampshire, UK

PostPosted: Fri Mar 04, 2016 2:00 pm
Reply with quote

A couple of points - 'lakh' is an Indian numeric term not a general numeric/IT term so should be avoided and it would appear that the number of records, or the faact that they were being inserted, is irrelevant to your question. Also, it is preferred that you do not use attachments but do a simple cut and paste using the code tags to present your code/data.
Back to top
View user's profile Send private message
Archana89

New User


Joined: 04 Mar 2016
Posts: 2
Location: India

PostPosted: Fri Mar 04, 2016 5:03 pm
Reply with quote

Hi all icon_smile.gif
Thanks for the suggestions. I have contacted my DB2 team, they are saying like some application traces should be captured in datasets. Any idea regarding this...
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2448
Location: Hampshire, UK

PostPosted: Fri Mar 04, 2016 6:06 pm
Reply with quote

No - we do not know how things are set up in your company. Look at the datasets specified in your JCL, have a look at the contents and see if anything looks like trace information. If the trace data was written to SYSOUT then you should be able to see it on the spool for yur job. Ask your team members.

Did your support mean that you need to capture the data in another run or did they mean that your data will already have been captured?
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 -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Job is loading load modules several t... COBOL Programming 12
No new posts Started transaction enters "firs... CICS 3
No new posts How to count the number of times key ... DFSORT/ICETOOL 14
No new posts SYSIBM Catlog tables to see DDL chang... DB2 2
No new posts VSAM RLS Wait time JCL & VSAM 3
Search our Forums:

Back to Top