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.
