Archives of the TeradataForum

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

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

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>>