Jim,
I take it you read Richard's reply.
Richard Sims is a pretty high authority. I listen carefully to what he
says.
This issue has been discussed on here in the past.
You said, "Understood, but for various reasons it'd be nice to have an
alternative."
I can relate to that. Early on, I didn't have access to any of
the AIX/SUN/Linux client servers nor to most of the Windows client
servers and their passwords, yet I was expected to be able to prove what
mgmt class was bound to a file. So, I had to resort to this. I was
warned that TSM could get its knickers in a twist with this. It
traverses the largest table in the DB, tread carefully.
(Actually, for the Windows clients I could have installed TSM on my
desktop and run dsmc from there. I would have had to update the
password at the server, and then afterwards have someone on the Windows
Team update it on the actual client. But the Windows folks would have
murmured darkly about me making unapproved changes to production servers
or installing software on my desktop without approval...)
That said:
You are asking how to do a select against the backups table.
The oldest schema I have is for 5.4.
If you run, "select * from columns where tabname='BACKUPS' ", you can
see the one current to your 5.3 server.
I don't know what you are trying to look up, but limit the scope of the
query as much as possible with exact node_names, AND
filespace_names/filespace_ids, AND state (active or inactive). The
backup_date is not an indexed column, but it seems to be beneficial to
keep the date range of your select small.
I hope that helps. Stay out of trouble
George H.
IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
therefore recommends that you do not send any confidential or sensitive
information to us via electronic mail, including social security numbers,
account numbers, or personal identification numbers. Delivery, and or timely
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends
that you do not send time sensitive
or action-oriented messages to us via electronic mail.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|