One other reference point that I have used, apart from all the excellent
previous suggestions, is the TSM Operational Reporting (if you run it).
Drill down through Reports-->Operational Reports-->Custom Report.
Select the Properties of the Custom Report and then settings. This will
show a large number of very useful select statements. They are mostly
for monitoring/reporting purposes, but I found them useful in coming to
terms with the constructs and syntax. Also good for getting to
understand substr and cast.
The actual raw text files with all the select commands are macro files
".mac" and the path is as follows;
C:\Program Files\Tivoli\TSM\console
Leigh
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Laura Mastandrea
Sent: 25 May 2006 21:09
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [SPAM: 3.700] Re: [ADSM-L] Select Statements
Where do you get the syntax information for the select statement? i.e.
substr , etc.
Thank you.
To
ADSM-L AT VM.MARIST DOT EDU
cc
From
Sent
by
Leigh Reed <L.Reed AT MDX.AC DOT UK> on 05/25/2006 05:04 AM
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Subject
Re: [ADSM-L] Select Statements
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Roger
I recently had to query the summary table for info regarding the
database backups. My requirement was to report how long the database
backups were taking. I found that the following select query sufficed.
select substr(char(end_time-start_time),3,8) as backup_duration from
summary where activity='FULL_DBBACKUP'
I know this is not exactly what you are asking, but from the construct,
you should be able alter it to do exactly the things you require.
Also, the following query will return all the fields that are available
for database backups in the summary table
select * from summary where activity='FULL_DBBACKUP'
HTH
Leigh
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Roger Silva
Sent: 24 May 2006 21:24
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select Statements
Hi,
I am new to the this list and need some advice.
I am trying to create a select statement I can run to monitor the
Database Backups of our TSM Servers. I know there are fields in the
SUMMARY portion of the table that has Start Time, End Time, Activity,
Entity, Volume Name and Successful fields, but I am not sure as to how
to put all this together in a nice script that can email to a group of
individuals the status. I am not sure if I need to query several
parts of the database in order to compile this info or not.
Can anyone help me out?
Thank You,
Roger
DISCLAIMER:
This communication, along with any documents, files or attachments, is
intended only for the use of the addressee and may contain legally
privileged and confidential information. If you are not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of any information contained in or attached to this
communication is strictly prohibited. If you have received this message
in error, please notify the sender immediately and destroy the original
communication and its attachments without reading, printing or saving in
any manner. This communication does not form any contractual obligation
on behalf of the sender or, the sender's employer, or the employer's
parent company, affiliates or subsidiaries.
|