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
 

 

which ims log utility can used?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Aj_Kumar

New User


Joined: 27 Mar 2013
Posts: 2
Location: india

PostPosted: Sat Aug 31, 2013 5:06 pm    Post subject: which ims log utility can used?
Reply with quote

Hi!
My query is to get all the transactions with each one's count from ims logs?

The ultimate aim is to find all the transactions which have 0 count.

Any idea on how can we go about this?

Thanks in advance.
Back to top
View user's profile Send private message

Aj_Kumar

New User


Joined: 27 Mar 2013
Posts: 2
Location: india

PostPosted: Sun Sep 01, 2013 9:01 pm    Post subject:
Reply with quote

That means which ibm utility can be used?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 02, 2013 6:12 am    Post subject:
Reply with quote

Hello and welcome to the forum,

I don't do IMS, so I don't havw a direct answer.

With other database systems, this is in the reporting manual(s) or the administration info. Read about logging there.

Keep in mind that this is a holiday weekend in the States and fewer of our seniors are available.

Good luck icon_smile.gif
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1476
Location: Chennai

PostPosted: Mon Sep 02, 2013 1:07 pm    Post subject:
Reply with quote

Hello,

The below suggestion may not pertain to IBM tools completely.

MXG software can process the IMS logs and give you the transaction counts with a fair accuracy(not 100% accurate).

Do you happen to have SYSVIEW OR MAINVIEW OR OMEGAMON OR some other performance monitoring for IMS at your shop?
One nice tool that comes with SYSVIEW is CA-EXPLORE, it can get you IMS transaction counts in a easy way. I've used it.

Quote:
The ultimate aim is to find all the transactions which have 0 count.

As far as I know IMS log transaction record is written only when a transaction is invoked. So when you process the logs, you would get details of transactions which have non zero transaction count. You would again need some methodology to compare the the ims log output with the complete list of all transactions and look what transactions are missing in IMS logs to get transaction with 0 count.

Hope it helps.
Back to top
View user's profile Send private message
Gary Jacek

New User


Joined: 17 Dec 2007
Posts: 47
Location: Victoria, BC, Canada

PostPosted: Thu Sep 12, 2013 10:28 pm    Post subject: Reply to: which ims log utility can used?
Reply with quote

The old Type 1 command

/DIS TRAN ALL.

Will produce a listing of all transactions. This is a lot of output, so consider any effect on automated operations/consoles before you use it.

If ENQCT and QCT are both zero, the transaction has not been used since the most recent IMS Coldstart, which in many shops will have taken place months earlier.

There are some shops that coldstart their IMS systems very frequently.
If your shop is one of these, then this method will not work for you.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Any docs / links for isub- cobol comp... SRICOBSAS COBOL Programming 4 Fri Aug 26, 2016 2:35 pm
No new posts Comparex utility to Syncsort conversion mistah kurtz SYNCSORT 11 Fri Jul 22, 2016 1:53 pm


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