Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Feb 2007 @ 19:52:38 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: PMON data tables
From:   Meade, Cornelius

Sorry for the somewhat compressed earlier reply but I was rushed at the time....In thinking about your question I had a couple of additional thoughts.

You mention your need is "historical", well you are writing your own application code to access the PM-API, you can probably collect and archive what you want but that seems a lot of potential work. ResUsage data collects performance related metrics for Teradata and likely records/captures metrics to support your ultimate need. The time granularity of the ResUsage data is dependant on the collection rate setting, which is shown on at least one particular PMON display if memory servers me correctly. The amount of historical ResUsage data you may have access to is dependant on how your system admin may have chosen to that that up. Depending on what you need truly is, there is much more detail you'll need so check the archives for references to ResUsage as this type of question comes up periodically. And of course, if you have access, take a look at Teradata doc.....

Cornelius Meade III
EDS - Consulting Services/BI/CRM

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020