On Aug 26, 2008, at 17:42 , Evans, Bill wrote:
what about just this: TSM> select PCT_UTILIZED from DB
which part of this statement puts the pct_utilized in a variable that
can be used again later in the script? That is the essence of what I
want to do.
Bill Evans
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of
Remco Post
Sent: Tuesday, August 26, 2008 8:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] select and script
On 26 aug 2008, at 17:04, Kauffman, Tom wrote:
You mean something like this?
Yes, something like that, but entirely within TSM, so a real TSM
server script ;-)
#!/bin/sh
DBUTIL=`dsm_cmd.pl "select pct_utilized from db" | tail -2`
echo "Database is $DBUTIL% full\n"
exit 0
columbia:-:/home/kauffmant > ./dbutil.sh
Database is 67.0% full
Just a two-minute hack, could use a bit of cleanup.
Dsm_cmd.pl is part off the adsm.pm perl interface to adsm found
here: http://www.io.com/~ocrow/ADSM/Adsm.html
Tom Kauffman
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On
Behalf Of Remco Post
Sent: Tuesday, August 26, 2008 9:45 AM
To: ADSM-L@VM.MARIST.EDU
Subject: select and script
Hi all,
I'm convinced that it should be possible in TSM to do something like
the following in a TSM server script:
select into %1 pct_utilized from db
issue message I REMCO001 datbase for server is %1 percent full
But I can't anything anywhere on the web or the TSM manuals to point
me in the right direction. Am I mistaking, can't this be done? Or
am I
not looking in the right places?
--
Met vriendelijke groeten/Kind regards,
Remco Post, PLCS
+31624821622
--
Met vriendelijke groeten/Kind regards,
Remco Post, PLCS
+31624821622
--
Met vriendelijke groeten,
Remco Post
[EMAIL PROTECTED]
+31 6 248 21 622
