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