Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 14 Nov 2002 @ 22:28:58 GMT


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


Subj:   Re: Comparing RESNode and BEZ Reports
 
From:   John Hall

You're right about GROUPID, it can be found in these Views:

DBC.RESCPUUSAGEBYAMPVIEW
DBC.RESCPUUSAGEBYPEVIEW
DBC.RESGENERALINFOVIEW
DBC.RESSHSTGROUPVIEW
DBC.RESSLDVGROUPVIEW

To take advantage of GROUPID, you'll have to modify the Views to match your needs. NCR might already have made the change, so do a SHOW VIEW and take a look. The default GROUPID logic looks like:

   AS SEL THEDATE
        , THETIME

        ...

        , /* GROUPID */
          CASE
             WHEN NODEID IN ('001-01', '001-03', '001-05') THEN 'A'
             WHEN NODEID IN ('001-02', '001-04', '001-06') THEN 'A'
             ELSE 'A'
             END

The macros that take advantage of GROUPID are:

RESAMPCPUBYGROUP
RESCPUBYGROUP
RESHOSTBYLGROUP
RESLDVBYGROUP
RESMEMBYGROUP
RESNETBYGROUP
RESNODEBYGROUP
RESPECPUBYGROUP

Since the Macros use the above Views, you can use the Macros as they are.



     
  <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