Select Command

[TGMB3]

I am trying to create a select command so I can receive output for the Nodes, Mgmt class for each node and retention times from the copy group. Can someone help? I'm using AIX and TSM. Thanks.

 

[JohanW]

select -
    nodes.node_name, -
    bu_copygroups.class_name, -
    bu_copygroups.retextra -
from -
    nodes, -
    bu_copygroups -
where -
    nodes.domain_name = bu_copygroups.domain_name and -
    bu_copygroups.set_name='active'

 

[TGMB3]

JohanW, here is the response I received:
tsm: KANSTSM1>select nodes.node_name,bu_copygroups.class_name,bu_copygroups.rete
xtra from nodes,bu_copygroups where nodes.domain_name=bu_copygroup
s.domain_name and bu_copygroups.set_name='active'
ANR2034E SELECT: No match found using this criteria.
ANS8001I Return code 11.

I am using TSM 5.3.2 Does that make a difference??

 

[rore]

Hi,
Change 'active' by 'ACTIVE'.

Rudy

 

[TGMB3]

Rudy, thanks. I already found that out, but after I re-ran the command it gave me all the nodes I needed, but it also put one mgmt class next to all of the list of nodes. Then it started all over with a new class name for all the same nodes. This continued until all the mgmt classes were used. What I need is just one mgmt class for each node. Any Ideas??

 

[rore]

TGMB3,
You are a bit confused about the relationship between a mgmt class and nodes.
Take a look at this: http://adsm.org/forum/showthread.php?t=17065

Rudy