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.
***********************************************************************************
|