Hi Dirk, I know this commands, but I need more info about database, that I mentioned here. I built my own excel table with database tables and columns structure, but that's not enough for me. I'd tried to connect to DB through ODBC and got a lot of tables with particular data, but some kind of data can't get. For example ... I need know all keywords, which can occur in column RESULT.EVENTS. When all this keywords didn't occur in my "piece of database", I can't establish all possible values to write errorless monitoring software. But your PDF will be greateful, please send it to [EMAIL PROTECTED]
Thanks Tom -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Dirk Billerbeck Sent: Wednesday, April 24, 2002 12:37 PM To: [EMAIL PROTECTED] Subject: Re: TSM DB detailed description Hello Tom, try this commands: help select or select * from syscat.columns and select * from syscat.tables If you are interested in a pdf file with all DB tables and columns send me a short notice and I will mail it to you (116 KB). Mit freundlichen Gr|_en, Met vriendelijke groeten, With best regards, Bien amicalement, CU/2, Dirk Billerbeck Dirk Billerbeck GE CompuNet Kiel Enterprise Computing Solutions Am Jaegersberg 20, 24161 Altenholz (Kiel), Germany Phone: +49 (0) 431 / 3609 - 117, Fax: +49 (0) 431 / 3609 - 190, Internet: dirk.billerbeck @ gecits-eu.com This email is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this mail in error, please tell us immediately by return email and delete the document. [EMAIL PROTECTED]@VM.MARIST.EDU on 24.04.2002 10:30:59 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: TSM DB detailed description -------------------------------------------------------------------------- Hi all, my question is if there is somewhere detailed technical description of TSM DB available. I mean it inner table links, column and variable types, enumerated lists of values, dynamic processing description .... and so on. I need to use some specific monitoring of TSM server and its processes through ODBC and need this kind of informations. Any help will be appreciated. Tom =
