Thank you Wanda! Excellent idea!
John G. Talafous IS Technical Principal
The Timken Company Global Software Support
P.O. Box 6927 Data Management
1835 Dueber Ave. S.W. Phone: (330)-471-3390
Canton, Ohio USA 44706-0927 Fax : (330)-471-4034
[EMAIL PROTECTED] http://www.timken.com
-----Original Message-----
From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 11:08 AM
To: [EMAIL PROTECTED]
Subject: Re: DEF ASSOC domain_name sched_name * - ARRGGHHH
When I have to do something like that, I have TSM generate the commands I
need by putting fixed text into an SQL select statement. For example:
select 'delete association', node_name , domain_name, schedule_name from
associations where CHG_TIME>'2001-04-17 00:00'
That SELECT generates output with the "delete association" text at the
beginning of each linet. Pipe the output into a file. Edit the file to
delete the header lines, and VIOLA, you have a list of commands ready to
execute as a macro.
You will have to adjust the WHERE statements to make sure it pulls out just
the stuff you want to undo.
Hope that helps....
************************************************************************
Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
[EMAIL PROTECTED]
"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert
************************************************************************
-----Original Message-----
From: Talafous, John G. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 10:55 AM
To: [EMAIL PROTECTED]
Subject: DEF ASSOC domain_name sched_name * - ARRGGHHH
I had an administrator 'play' with the concept of running the subject
command against a domain with over 1000 nodes and 5 backup schedules. So,
this administrator ran this command against each schedule expecting it to
function like the QUERY command. (I know, some people shouldn't be allowed
close to computers. But..) Now, every node in the domain will backup on all
5 schedules.
Does anyone know of any way I can undo this mess? Tivoli, is this a feature?
John G. Talafous IS Technical Principal
The Timken Company Global Software Support
P.O. Box 6927 Data Management
1835 Dueber Ave. S.W. Phone: (330)-471-3390
Canton, Ohio USA 44706-0927 Fax : (330)-471-4034
[EMAIL PROTECTED] http://www.timken.com
