I am trying to get a list of nodes that have no filespaces and I am getting stuck on what seems to be a very basic select statement. Can someone tell me where I am going wrong? The way I understand it, the select should at least show the node I just created with no filespaces.
tsm: TSM1500>reg n shawntest xxxx do=admin userid=none ANR2060I Node SHAWNTEST registered in policy domain ADMIN. tsm: TSM1500>select node_name from nodes where node_name NOT IN (select distinct(node_name) from filespaces) ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11.
