what about just this:  TSM> select PCT_UTILIZED from DB



Bill Evans 


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Remco Post
Sent: Tuesday, August 26, 2008 8:14 AM
To: ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On
> Behalf Of Remco Post
> Sent: Tuesday, August 26, 2008 9:45 AM
> To: ADSM-L AT VM.MARIST DOT 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