There IS a doc written by Andy Raibeck called 'Using the ADSM SQL Interface'
which hass quite a comprehensive overview of the TSM DB. I found it by
typing the name in, in quotes, in google.
Infact, here's the link
ftp://borg.isc.ucsb.edu/pub/adsm/docs/!updates/raibeck.pdf
hope it helps.
-----Original Message-----
From: Dmochowski, Ray [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 17:11
To: [EMAIL PROTECTED]
Subject: FW: TSM database documentation
To:
Richard ..
David..
Wanda ...
& others ..
Thanks for your help and great advice!
but I was wondering if there was any IBM, Tivoli, or other
documentation, manuals or redbooks about the DB?
-----Original Message-----
From: David Longo [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 11:17 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM database documentation ?
To get this info use select statements.
select * from syscat.tables
select * from syscat.columns
select * from syscat.enumtypes
This will give you lots of info and you can use to see what
is in each table, etc. You can modify selects to get just
certain info instead of the whole thing.
That's it in a nutshell.
- David B. Longo
>>> [EMAIL PROTECTED] 07/20/01 11:00AM >>>
While we await an update to the ER diagram for TSM, can anyone
direct me to current documentation about the tables in the TSM Database,
including descriptions of each, with the names and descriptions of each
data coulmn included in the tables?
Ray Dmochowski <[EMAIL PROTECTED]>
(908) 740-3261
Schering-Plough Research Institute
Kenilworth, NJ 07033, U.S.A.
============================================================================
==
***************************************************************
This message and any attachments is solely for the intended recipient. If
you are not the intended recipient, disclosure, copying, use, or
distribution of the information included in this message is prohibited --
please immediately and permanently delete this message.
http://www.phoenixitgroup.com
******************Internet Email Confidentiality Footer*******************
Phoenix IT Group Limited is registered in England and Wales under company
number 3476115. Registered Office: Technology House, Hunsbury Hill Avenue,
Northampton, NN4 8QS
Opinions, conclusions and other information in this message that do not
relate to the official business of our firm shall be understood as neither
given nor endorsed by it.
No contracts may be concluded on behalf of our firm by means of email
communications.
Confidentiality: Confidential information may be contained in this message.
If you are not the recipient indicated (or responsible for delivery of the
message to such person), you may not take any action based on it, nor should
you copy or show this to anyone; please reply to this email and highlight
the error to the sender, then delete the message from your system.
Monitoring of Messages: Please note that we reserve the right to monitor and
intercept emails sent and received on our network.
Warning: Internet email is not 100% secure. We ask you to understand and
observe this lack of security when emailing us. We do not accept
responsibility for changes made to this message after it was sent
Viruses: Although we have taken steps to ensure that this email and any
attachments are free from any virus, we advise that in keeping with good
computing practice the recipient should ensure they are actually virus free.
