Re: Number of scratch tapes?

2001-05-06 Thread Mark Stapleton

> From: Arshad Sheikh [mailto:[EMAIL PROTECTED]]
>>I am a newbie. We have TSM 3.7. running. I want to run a batch command from
>>my root prompt which give me the number of scratch tapes, I will put it in
>>cron to mail me every morning as to how much scratch tapes I have in my lib.
>>How can I do that?  I don't want to go to interactive mode to run it.
>
"PINNI, BALANAND (SBCSI)" wrote:
> Use pre and post schedule cmd under dsm.sys

I've got a *whole* lot easier way.

dsmadmc -id= -pass= select count(*) as 'Scratch Count'
from libvolumes where status='Scratch' > /tmp/scratchcount
mail -s "Daily scratch count" [EMAIL PROTECTED] < /tmp/scratchcount

Now, if your TSM server runs Windows, you'll have to get yourself a
decent scripting language and a command-line mail transport. ;o)

--
Mark Stapleton ([EMAIL PROTECTED])



Re: Number of scratch tapes?

2001-05-06 Thread PETER GRIFFIN

To simply get a count of the number of scratches

select count(*) from libvolumes where upper(status)= 'SCRATCH'


>>> [EMAIL PROTECTED] 05/05/01 01:13am >>>
Hi:
Here the select part running from a script.

/home/root/bin/dsmcmd "SELECT LIBVOLUMES.VOLUME_NAME, LIBVOLUMES.STATUS FROM LIB
Volumes where libvolumes.status = 'Scratch'"

[backup] /home/root/bin # more dsmcmd
dsmadmc -id=admin -pa= -displaymode=table $1

>>> [EMAIL PROTECTED] 05/04/01 10:57AM >>>
Hi there,

I am a newbie. We have TSM 3.7. running. I want to run a batch command from
my root prompt which give me the number of scratch tapes, I will put it in
cron to mail me every morning as to how much scratch tapes I have in my lib.
How can I do that?  I don't want to go to interactive mode to run it.

Thanks for help

Arshad



_
Get your FREE download of MSN Explorer at http://explorer.msn.com



Re: Number of scratch tapes?

2001-05-04 Thread Poland, Neil

>From your prompt: dsmadmc -id=yourid -pa=yourpass q libvol |grep -i scratch
|wc -l

-Original Message-
From: Arshad Sheikh [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 9:57 AM
To: [EMAIL PROTECTED]
Subject: Number of scratch tapes?


Hi there,

I am a newbie. We have TSM 3.7. running. I want to run a batch command from
my root prompt which give me the number of scratch tapes, I will put it in
cron to mail me every morning as to how much scratch tapes I have in my lib.
How can I do that?  I don't want to go to interactive mode to run it.

Thanks for help

Arshad



_
Get your FREE download of MSN Explorer at http://explorer.msn.com



Re: Number of scratch tapes?

2001-05-04 Thread Lawrence Clark

Hi:
Here the select part running from a script.

/home/root/bin/dsmcmd "SELECT LIBVOLUMES.VOLUME_NAME, LIBVOLUMES.STATUS FROM LIB
Volumes where libvolumes.status = 'Scratch'"

[backup] /home/root/bin # more dsmcmd
dsmadmc -id=admin -pa= -displaymode=table $1

>>> [EMAIL PROTECTED] 05/04/01 10:57AM >>>
Hi there,

I am a newbie. We have TSM 3.7. running. I want to run a batch command from
my root prompt which give me the number of scratch tapes, I will put it in
cron to mail me every morning as to how much scratch tapes I have in my lib.
How can I do that?  I don't want to go to interactive mode to run it.

Thanks for help

Arshad



_
Get your FREE download of MSN Explorer at http://explorer.msn.com



Re: Number of scratch tapes?

2001-05-04 Thread PINNI, BALANAND (SBCSI)

Use pre and post schedule cmd under dsm.sys

-Original Message-
From: Arshad Sheikh [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 9:57 AM
To: [EMAIL PROTECTED]
Subject: Number of scratch tapes?


Hi there,

I am a newbie. We have TSM 3.7. running. I want to run a batch command from
my root prompt which give me the number of scratch tapes, I will put it in
cron to mail me every morning as to how much scratch tapes I have in my lib.
How can I do that?  I don't want to go to interactive mode to run it.

Thanks for help

Arshad



_
Get your FREE download of MSN Explorer at http://explorer.msn.com