On Jan 21, 2009, at 12:54 PM, Todd D. Taft wrote:
I've issued SQL queries on the server similar to the one you suggested, and I've noticed that they are much slower than if I issue the equivalent queries using the ba client. Does the ba client issue a different query to get its information, or is there some reason why the ba client queries are able to respond much faster than the server SQL queries?
The client employs "old family secret" type programming to perform its interactions with the server, similar to the API, but more optimized.
Is there a way that a TSM administrator, who might not know the node password, can access the standard client to issue the various commands on the client? ...
Not really; nor should they be able to. The TSM server administrator is not intended to have such capabilities, by design, as the details of the data is not within the purview of the server admin. The data belongs to the group using the TSM client, where they are given the tools to examine and manage their data. The server administrator's job is to assure the health of the storage pools holding the data, rather than delve into what's in there. Richard Sims