On Wed, Jan 21, 2009 at 12:54 PM, Todd D. Taft <[email protected]> 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? Depends on how "similar". The backups table is indexed. If your SQL query has wild cards or doesn't use an index, it can REALLY drag. NODE_NAME is one of the indexed columns, you'll always do better when going after 1 NODE_NAME at a time. Even properly indexed, the SQL query can be slower than the client access, though. > > > 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? Obviously, an administrator could change the node password and > then login with the ba client, but without changing the password, is it > possible for a TSM admin to see exactly what the client sees? In general, you can do want you want with -virtualnodename without directly accessing the client or changing the password. On your own machine (let's assume windows here): CD into the c:\program files\tivoli\tsm\baclient directory and start the client this way: dsm -virtualnodename=NAME-OF-CLIENT-TO-VIEW You will get a prompt asking for the password. In the prompt box, OVERTYPE the name of the client with your own TSM admin id and then use your TSM admin id password. When the GUI opens, you will see the file tree of NAME-OF-CLIENT-TO-VIEW, not your own machine. Also works for the command line version. On *IX systems, adjust the directory accordingly. You must be starting the client on the SAME platform as the client you want to view; Windows to Windows, *IX to *IX. And your TSM admin id must have system, domain, or clientowner authority relative to the client you want to view. W > > > Erwann Simon wrote: > >> Hi, >> >> It shows nicer when sqldisplaymode is set to wide BUT it could be a huge >> query for your TSM server depending on the number of objects stored ! >> >> The select to run wil look like this one : >> select filespace_name,hl_name,ll_name from backups - >> where node_name='<YOUR_NODENAME>' and filespace_name='<YOUR_FS_NAME>' >> >> I personnaly prefer dsmc q fi and dsmc q ba, but these commands are from >> the other side (client side). >> >> -- >> Best regards / Cordialement / مع تحياتي >> Erwann SIMON >> >> >> Erwin Zavala a écrit : >> >>> How can i see the files stored on a filespace on a node >>> >> > > -- > Todd D. Taft > [email protected] >
