Tom,
The only thing I can recommend is that you might try writing good exception
handling instead of trying for errorless monitoring software. Unless you
have an "in" with Tivoli developers, you might have to settle for setting a
flag if you come across an as-yet-unknown value.
If you look at the Events.Result column, it is an integer. If it were an
enum_type, you would know what values it could possibly have, but as an
integer, you're pretty much left guessing as to what the numbers are and
what they mean. Personally, I think Result is probably Return Code. Yep,
here's an event showing "completed" with return=11, reason="item not found".
It's a backup stg schedule where the stgpool was deleted. Messy, messy. I
should probably clean that up. Anyway, I don't think you can get a list of
all possible values for Return Codes in the events.result column, and even
if you did, it would have to evolve with every single release where there
are new return codes.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
TABSCHEMA: ADSM
TABNAME: EVENTS
COLNAME: RESULT
COLNO: 7
INDEX_KEYSEQ:
INDEX_ORDER:
TYPENAME: INTEGER
LENGTH: 0
SCALE: 0
NULLS: TRUE
REMARKS: Result
-----Original Message-----
From: Tom�s Hrouda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 3:18 AM
To: [EMAIL PROTECTED]
Subject: Re: TSM DB detailed description
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
=
