I am not really sure what you are asking.

If you are asking if this is a bug: the answer is "no". TSM is operating
correctly.

If you are asking for a philosophical reason: Well, if a schedule has no
associated nodes, then there are no associations for that schedule. But
maybe the original developers of the QUERY ASSOCIATION command thought it
would be useful to show you which schedules had no associations. Thus
QUERY ASSOCIATIONS gives you information about schedules with and without
associations. On the other hand, the ASSOCIATIONS table is a strictly
tabular view of which nodes are associated with which schedules. If there
is no association, then there is no record in the ASSOCIATIONS table.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-03-01
08:46:59:

> Hi,
>
> I notice, that "q assoc" gives me a complete list of
> associations, while a "select * from associations"
> misses those domain/schedule pairs, which are not
> associated with any node.
>
> Any reason for that?
>
> TIA
>
> Andreas