INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Usage Reports

Usage Reports

(OP)
So - we are using MM5.2 and recently started getting errors pulling the data. The tracing file had to be rebuilt - too large I think. From what I understand, it takes a while before data is available again and also have heard a 3rd party option to capturing data would be better. Anyone out there have thoughts on that? If you are using the reports, any issues?

RE: Usage Reports

if it is setup correctly there wouldn't be any issues. If your operation history or your transaction databases had to be rebuilt because they reached the 2GB limit then either your Tracing configuration is not setup properly or your scheduled tasks are not running correctly to clean up those databases. (going from memory) OpHist is the DB where you can keep your operational history data but you can only see the past 3 days worth using the operational history viewer tool from MM (even if you chose to keep more than 3 days worth of operation history). Trxdb is where the transactions are stored. Transactions are generated (by default) everyday and are what the reports you run are based on. So you can run reports on today's data, just the data upto the time when the last transactions were generated. The default keep period for transactions is 30 days but if you want to run reports for periods of time longer than that you will need to modify that in the Tracing portion of the VMSC.

RE: Usage Reports

Along with this... if you have more than one MAS the database for Tracing is installed on only one MAS in an MM domain. You can point the database to other MAS and this procedure is in the Messaging Application Administration guide.

RE: Usage Reports

(OP)
So if it is rebuilt or even just stop/started, data should be available in the Usage Reports? Seems to me it should be but I'm being told it is not a guaranty.

RE: Usage Reports

If the tracing service is simply stopped/started you should not have lost any operation history as each MAS has a buffer (default 4 MB but I usually set that to 99 MB) to keep before purging operation history. So depending on how busy each MAS is, will factor into whether or not the MAS would fill up the buffer before the tracing service could reconnect to the MAS to capture the data.

If the operation history DB was rebuilt, that would only affect the data from the point in which it reached the 2GB limit and when the DB was rebuilt. That portion of your data would be lost and would not show up in transactions that were generated from it.

Keep in mind that all your reporting is based on the data in the transaction DB, not the tracing/operation history DB. The transactions should be generated daily from the data contained in the operation history DB.

RE: Usage Reports

Also, if you are looking for data on the reports for the last hour, you won't find it in the usage reports on the MAS. The pull of data is done nightly from the settings in the VMSC, Tracing times. These are usually set for staggered times (1, 2, & 3am). By design, these staggered times should never run at one time or it can also create issues with the Tracing system.

RE: Usage Reports

(OP)
Thanks for your input. The data is there now as our vendor said it would be.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close