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

which ims log utility can used?


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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
Reply with quote

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

Moderator Emeritus


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

PostPosted: Mon Sep 02, 2013 6:12 am
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: 1742
Location: Tirupur, India

PostPosted: Mon Sep 02, 2013 1:07 pm
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: 64
Location: Victoria, BC, Canada

PostPosted: Thu Sep 12, 2013 10:28 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts REASON 00D70014 in load utility DB2 6
No new posts ISRSUPC search utility - using high l... TSO/ISPF 2
No new posts Any JCL or VSAM Utility to get number... JCL & VSAM 1
No new posts DATA SET LIST UTILITY screen TSO/ISPF 6
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
Search our Forums:

Back to Top