I think this is an excellent idea, but I'd much rather see "result set
processing" supported in a new scripting language - let's say REXX. The
world is already too complex and REXX is simple yet powerful enough to
provide everything one could ever - ...well, let's not go that far... - but
you get my drift, right?
Never-the-less, as a less desirable (but very utilitarian and quite
flexible) alternative, I would gratefully accept your suggested enhancement.
It is also elegant - and most software should be, but isn't...
-----Original Message-----
From: Steve Harris
To: [EMAIL PROTECTED]
Sent: 3/10/2004 9:44 PM
Subject: Cancel process enhancement.
Hi All,
I'd like to propose a change to the cancel process syntax to allow a
select statement as a part of it.
The reasoning for this is that there are often situations where we need
to cancel a process to ensure that there are resources for other
scheduled processes. For example I may have a long running reclaim
happening that was kicked off by changing the reclaim percentage on a
storage pool. I know that this reclaim will run into my overnight backup
window, but, there is no way of cancelling the process automatically
from within TSM.
Yes, there are many was to do this externally to TSM, but these all
involve running scripts and exposing powerful passwords to prying eyes.
To address this issue, I suggest the the cancel syntax be modified to
allow the process number of the processes to be cancelled to be
supplied using a select on the process table. This would also require
that the cancel command could cancel more than one process at once.
To use the reclaim issue as an example
The process table contains
PROCESS_NUM: 745
PROCESS: Space Reclamation
START_TIME: 2004-03-11 12:15:27.000000
FILES_PROCESSED: 0
BYTES_PROCESSED: 0
STATUS: Volume R00232 (storage pool TAPEPOOL-B), Moved Files: 0, Moved
Bytes: 0, Unreadable Files: 0, Unreadable Bytes: 0.
Current
Physical File (bytes): 412,501,966
Waiting for multiple mount
points in device class ATL3590E (494 seconds).
cancel process where process_num in (select process_num from processes
where process='Space Reclamation' and status like '% TAPEPOOL-B)%')
Does anyone think this is a good idea? Comments?
Steve Harris
AIX and TSM Admin
Queensland Health
Brisbane Australia
************************************************************************
***********
This email, including any attachments sent with it, is confidential and
for the sole use of the intended recipient(s). This confidentiality is
not waived or lost, if you receive it and you are not the intended
recipient(s), or if it is transmitted/received in error.
Any unauthorised use, alteration, disclosure, distribution or review of
this email is prohibited. It may be subject to a statutory duty of
confidentiality if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this
email in error, you are asked to immediately notify the sender by
telephone or by return email. You should also delete this email and
destroy any hard copies produced.
************************************************************************
***********
