Using TSM server 6.2.3.1, the following SQL command no longer works:
select node_name from nodes where node_name not in (select node_name from
filespaces)
It still works correctly if you take out the "not".
Any ideas?
- Margaret
Hi, Margaret. What error are you getting?
Taking a stab in the dark, explicitly using NODES and FILESPACES in your
predicate can cause unexpected results
(http://www-01.ibm.com/support/docview.wss?uid=swg21380830). I would
guess failing with the addition of the word "NOT" could be construed as
a
The error I get is this:
ANR2034E SELECT: No match found using this criteria.
Needless to say, I know I have a few nodes registered for which there are no
filespaces, and this negative result is wrong.
I don't actually care about this particular command, but there's other stuff
I'd like to do
