It's a big hammer, but this is the only thing I've found for this type of
thing. It could be made into a separate macro and a series of calls could
be made for each percentage level to test.
/* Display message for DB utilization */
90:
select pct_utilized from db where pct_utilized > 90
if (rc_notfound) goto 80
issue message I "REMCO001 datbase for server is 90 percent full"
goto exit
80:
select pct_utilized from db where pct_utilized > 80
if (rc_notfound) goto 70
issue message I "REMCO001 datbase for server is 80 percent full"
goto exit
70:
select pct_utilized from db where pct_utilized > 70
if (rc_notfound) goto ok
issue message I "REMCO001 datbase for server is 70 percent full"
goto exit
ok:
issue message I "REMCO001 datbase for server is less than 70 percent full"
exit:
Exit
Bob.
-----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 11:18 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] select and script
On Aug 26, 2008, at 17:17 , Kauffman, Tom wrote:
> It would be nice -- maybe after the DB2 conversion we'll get a genuine
> TSM server-side command language and scripting facility.
>
> Until then I do a lot of admin work from the outside with a mix of
> perl and shell scripts.
>
Unfortunately, for most TSM admins it's much easier to distribute a server
script to all TSM servers than to run a set of scripts against all server
instances on all servers (or even get the scripts there and be able run them
in cron).
As for TSM 6.1, I'd expect nothing more than current 5.5 functionality WRT
the scripting engine.
> TK
>
> -----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 11:14 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: 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
--
Met vriendelijke groeten,
Remco Post
remco AT pipsworld DOT nl
This electronic transmission and any documents accompanying this electronic
transmission contain confidential information belonging to the sender. This
information may be legally privileged. The information is intended only for
the use of the individual or entity named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or the taking of any action in reliance on or regarding the contents of this
electronically transmitted information is strictly prohibited.
|
