Re: Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread David Bronder
I use the following select statement in a server script for figuring out this
kind of information (was more useful in 5.5 and earlier when the REMARKS
field had nice descriptions for each field, too):

   select colname from columns where tabname=upper('$1')

In this case:

   tsm: SERVER>run tbl-desc volumes
   ...
   COLNAME: READ_ERRORS
   ...
   COLNAME: WRITE_ERRORS
   ...

As with the mount count, the error counts and many other values for a volume
are lost/reset when it returns to scratch.

=Dave


On 07/28/2016 10:42 AM, Lamb, Charles P. wrote:
> Would anyone know what the volume I/O error table labels are so the below 
> script could be run on volume I/O errors??
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, 
> Gary
> Sent: Thursday, July 28, 2016 10:21 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape 
> volume
>
> Yes, mount count resets to zero when it returns to scratch.
>
>
> -Original Message-
> From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
> David Bronder
> Sent: Thursday, July 28, 2016 11:11 AM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape 
> volume
>
> Charles,
>
> Note that this number may not mean what you expect it to.  The help for 
> "query volume" notes that this value is the number of times the server opened 
> the volume, which may be more than once per physical mount.  Also, if you use 
> scratch tapes, I'm pretty sure that the value gets discarded when the tape 
> returns to the scratch pool and resets to zero when it's defined to a storage 
> pool again.
>
> =Dave
>
>
> On 07/28/2016 08:45 AM, Koos Rietveld wrote:
>> select char(volume_name, 30) as VOLUME_NAME, times_mounted from
>> volumes where stgpool_name='VDP-DAT' order by times_mounted desc
>>
>>
>>
>> From:"Lamb, Charles P." <cpl...@nppd.com>
>> To:ADSM-L@VM.MARIST.EDU
>> Date:28-07-2016 15:27
>> Subject:[ADSM-L] TSM script for the number of tape mounts per tape
>> volume
>> Sent by:        "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
>>
>> --
>> ---
>>
>>
>>
>> Hi...
>>
>> Could someone share a TSM script for the number of tape mounts per
>> tape volume from highest to lowest??  Tnx's a bunch
>>
>>
>
>

--
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu


Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread Lamb, Charles P.
Would anyone know what the volume I/O error table labels are so the below 
script could be run on volume I/O errors?? 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, 
Gary
Sent: Thursday, July 28, 2016 10:21 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape 
volume

**WARNING** This message originated outside of NPPD. DO NOT click on any links 
or attachments unless you have confirmed that it is from a trusted sender.

--
Yes, mount count resets to zero when it returns to scratch.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David 
Bronder
Sent: Thursday, July 28, 2016 11:11 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape 
volume

Charles,

Note that this number may not mean what you expect it to.  The help for "query 
volume" notes that this value is the number of times the server opened the 
volume, which may be more than once per physical mount.  Also, if you use 
scratch tapes, I'm pretty sure that the value gets discarded when the tape 
returns to the scratch pool and resets to zero when it's defined to a storage 
pool again.

=Dave


On 07/28/2016 08:45 AM, Koos Rietveld wrote:
> select char(volume_name, 30) as VOLUME_NAME, times_mounted from 
> volumes where stgpool_name='VDP-DAT' order by times_mounted desc
>
>
>
> From:"Lamb, Charles P." <cpl...@nppd.com>
> To:ADSM-L@VM.MARIST.EDU
> Date:        28-07-2016 15:27
> Subject:[ADSM-L] TSM script for the number of tape mounts per tape
> volume
> Sent by:"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
>
> ------
> ---
>
>
>
> Hi...
>
> Could someone share a TSM script for the number of tape mounts per 
> tape volume from highest to lowest??  Tnx's a bunch
>
>

--
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu


Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread David Bronder
Charles,

Note that this number may not mean what you expect it to.  The help for
"query volume" notes that this value is the number of times the server opened
the volume, which may be more than once per physical mount.  Also, if you use
scratch tapes, I'm pretty sure that the value gets discarded when the tape
returns to the scratch pool and resets to zero when it's defined to a storage
pool again.

=Dave


On 07/28/2016 08:45 AM, Koos Rietveld wrote:
> select char(volume_name, 30) as VOLUME_NAME, times_mounted from volumes where
> stgpool_name='VDP-DAT' order by times_mounted desc
>
>
>
> From:"Lamb, Charles P." <cpl...@nppd.com>
> To:ADSM-L@VM.MARIST.EDU
> Date:        28-07-2016 15:27
> Subject:[ADSM-L] TSM script for the number of tape mounts per tape
> volume
> Sent by:"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
>
> ---------
>
>
>
> Hi...
>
> Could someone share a TSM script for the number of tape mounts per tape
> volume from highest to lowest??  Tnx's a bunch
>
>

--
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu


Re: Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread Lee, Gary
Yes, mount count resets to zero when it returns to scratch.


-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David 
Bronder
Sent: Thursday, July 28, 2016 11:11 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Re: TSM script for the number of tape mounts per tape 
volume

Charles,

Note that this number may not mean what you expect it to.  The help for
"query volume" notes that this value is the number of times the server opened
the volume, which may be more than once per physical mount.  Also, if you use
scratch tapes, I'm pretty sure that the value gets discarded when the tape
returns to the scratch pool and resets to zero when it's defined to a storage
pool again.

=Dave


On 07/28/2016 08:45 AM, Koos Rietveld wrote:
> select char(volume_name, 30) as VOLUME_NAME, times_mounted from volumes where
> stgpool_name='VDP-DAT' order by times_mounted desc
>
>
>
> From:"Lamb, Charles P." <cpl...@nppd.com>
> To:ADSM-L@VM.MARIST.EDU
> Date:        28-07-2016 15:27
> Subject:[ADSM-L] TSM script for the number of tape mounts per tape
> volume
> Sent by:"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
>
> ---------
>
>
>
> Hi...
>
> Could someone share a TSM script for the number of tape mounts per tape
> volume from highest to lowest??  Tnx's a bunch
>
>

--
Hello World.David Bronder - Systems Architect
Segmentation Fault  ITS-EI, Univ. of Iowa
Core dumped, disk trashed, quota filled, soda warm.   david-bron...@uiowa.edu


Re: TSM script for the number of tape mounts per tape volume

2016-07-28 Thread Koos Rietveld
select char(volume_name, 30) as VOLUME_NAME, times_mounted from volumes 
where stgpool_name='VDP-DAT' order by times_mounted desc

Kind regards/Cordialement/Mit freundlichen Grüßen/Met vriendelijke groet



Koos Rietveld
Senior Network/System/Storage Administrator
Contract Logistics Northern Europe

Geodis Logistics Netherlands B.V.
Columbusweg 16
5928 LC VENLO / Netherlands
Tel. : + 31 77 389 97 68 - Mob. : + 31 6 538 716 28
koos.rietv...@geodis.com | geodis.nl





From:   "Lamb, Charles P." <cpl...@nppd.com>
To: ADSM-L@VM.MARIST.EDU
Date:   28-07-2016 15:27
Subject:        [ADSM-L] TSM script for the number of tape mounts per tape 
volume
Sent by:"ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>



Hi.......

Could someone share a TSM script for the number of tape mounts per tape 
volume from highest to lowest??  Tnx's a bunch




TSM script for the number of tape mounts per tape volume

2016-07-28 Thread Lamb, Charles P.
Hi...

Could someone share a TSM script for the number of tape mounts per tape volume 
from highest to lowest??  Tnx's a bunch


Help with tsm script

2011-06-07 Thread Lee, Gary D.
I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable space for 
the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as Pool, - 
count(volume_name) as No. Volumes, - 
cast(sum(cast((est_capacity_mb / 1024 *  - 
(pct_utilized / 100)) - 
as decimal(9,3))) as decimal(9,3)) - 
as GB Reclaimable - 
 FROM   volumes - 
 WHERE  pct_reclaim$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives the 
exception.
Thanks for any help you can give.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 

Re: Help with tsm script

2011-06-07 Thread Vandeventer, Harold [BS]
Do you have the document Changes to the SELECT command from 
http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/index.jsp?topic=/com.ibm.itsm.srv.upgrd.doc/r_srv_upgrd_cmd_select.html?

The last section is Data types for arithmetic operations.  Compare your 
cast(sum(cast((est_capacity_mb / 1024 * (pct_utilized / 100)) string to last 
example in the article.

The example has two as decimal strings; you might need an as decimal spec 
on the pct_utilized /100?


Harold Vandeventer
Systems Programmer
State of Kansas - DISC
harold.vandeven...@da.ks.gov
(785) 296-0631

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, 
Gary D.
Sent: Tuesday, June 07, 2011 9:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help with tsm script

I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable space for 
the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as Pool, - 
count(volume_name) as No. Volumes, - 
cast(sum(cast((est_capacity_mb / 1024 *  - 
(pct_utilized / 100)) - 
as decimal(9,3))) as decimal(9,3)) - 
as GB Reclaimable - 
 FROM   volumes - 
 WHERE  pct_reclaim$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives the 
exception.
Thanks for any help you can give.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 


Re: Help with tsm script

2011-06-07 Thread Schneider, Jim
I have a script that lists reclaimable space by volume for a given
storage pool.  I've added line numbers so I can see how many tapes would
be reclaimed at a given percentage.  It runs on Unix from a command
prompt.

===
#!/usr/bin/ksh
#
# This script checks reclaimable space in a tape storage pool
# The list is displayed with line numbers and is sorted by
# reclaimable space in descending order.


# Check that a parameter is passed
if [[ $# != 1 ]]
then
   echo Usage: cr \storage_pool_name\
   exit 4
fi

dsmadmc -id=user id -pass=password -displ=list q vol stg=$1 f=d |
grep Reclaimable | sort -n -r -k 4  $1.usage
cat -n $1.usage | more
rm $1.usage
===
Sample output:
ch2uptsm1 $ ./cr ch2win_offsite
 1  Pct. Reclaimable Space: 99.3
 2  Pct. Reclaimable Space: 98.7
 3  Pct. Reclaimable Space: 98.1
 4  Pct. Reclaimable Space: 97.9
 5  Pct. Reclaimable Space: 97.5
 6  Pct. Reclaimable Space: 97.4
 7  Pct. Reclaimable Space: 96.8
 8  Pct. Reclaimable Space: 93.1
 9  Pct. Reclaimable Space: 88.9
10  Pct. Reclaimable Space: 87.8
11  Pct. Reclaimable Space: 86.9
12  Pct. Reclaimable Space: 86.3
13  Pct. Reclaimable Space: 86.0
14  Pct. Reclaimable Space: 84.6
15  Pct. Reclaimable Space: 83.9
16  Pct. Reclaimable Space: 80.9
17  Pct. Reclaimable Space: 79.0
18  Pct. Reclaimable Space: 77.9
19  Pct. Reclaimable Space: 77.1
20  Pct. Reclaimable Space: 76.0

Hope this helps,
Jim Schneider

-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of
Lee, Gary D.
Sent: Tuesday, June 07, 2011 9:24 AM
To: ADSM-L@vm.marist.edu
Subject: [ADSM-L] Help with tsm script

I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable
space for the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as Pool, - 
count(volume_name) as No. Volumes, - 
cast(sum(cast((est_capacity_mb / 1024 *  - 
(pct_utilized / 100)) - 
as decimal(9,3))) as decimal(9,3)) - 
as GB Reclaimable - 
 FROM   volumes - 
 WHERE  pct_reclaim$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives
the exception.
Thanks for any help you can give.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 


Re: Help with tsm script

2011-06-07 Thread Prather, Wanda
This works:

select distinct stgpool_name as Pool, count(volume_name) as No. 
Volumes,  cast( sum(est_capacity_mb / 1024 * pct_utilized/100) as 
decimal(9,3))as GB Reclaimable  FROM   volumes   WHERE  
pct_reclaim
 $1 GROUP BY stgpool_name

I don't know why.

May be a bug:
https://www-304.ibm.com/support/docview.wss?uid=swg1IC61919



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, 
Gary D.
Sent: Tuesday, June 07, 2011 10:24 AM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] Help with tsm script

I have a script which under tsm 5.5.4 server gives a report of

The storage pool name, count ov reclaimable volumes, and reclaimable space for 
the specified percentage.
You execute as follows:

Run reclaim-check 55

Under tsm 6.2.2, I get an arithmetic exception sqlstate 22003.
I don't see the problem.

Script follows:

 SELECT distinct stgpool_name as Pool, - 
count(volume_name) as No. Volumes, - 
cast(sum(cast((est_capacity_mb / 1024 *  - 
(pct_utilized / 100)) - 
as decimal(9,3))) as decimal(9,3)) - 
as GB Reclaimable - 
 FROM   volumes - 
 WHERE  pct_reclaim$1 - 
 GROUP BY stgpool_name 


Any ideas?
The error message gives no help as to what part of the expression gives the 
exception.
Thanks for any help you can give.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 


Help with tsm script

2011-06-07 Thread Lee, Gary D.
Thanks to all  I got the script working.
Harrold sennt me the link to the select changes doc, and after casting all the 
subresults to decimal, things worked out.

I don't understand, as all the specified columns are defined as decimal, but it 
is as it is.

Thanks to all, richard, Wanda, etc. for your assistances as well.
I filed all away for future reference.
Now to fix the rest of the scripts.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 

How do I email from a TSM script

2007-03-26 Thread RODOLFICH, NICHOLAS
Hello All,

I can't seem to find any information on how to email from a TSM script
or call a script to email from TSM. Either will work for me. 

Thanks for your help!!

Regards,
 
Nicholas Rodolfich  
POOLCORP
Desk: (985)801-3038
Cell:   (228)223-6777
mailto:[EMAIL PROTECTED]

 




This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager. This 
message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail.


Re: How do I email from a TSM script

2007-03-26 Thread Richard Sims

Accomplish that via Define Clientaction, to have a client's OS
command do it.

  Richard Sims


Re: How do I email from a TSM script

2007-03-26 Thread Remco Post
Richard Sims wrote:
 Accomplish that via Define Clientaction, to have a client's OS
 command do it.

   Richard Sims

or call tsm from a script, parse the output and call eg. mailx to send
your email.

--
Met vriendelijke groeten,

Remco Post

SARA - Reken- en Netwerkdiensten  http://www.sara.nl
High Performance Computing  Tel. +31 20 592 3000Fax. +31 20 668 3167
PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16  B3F6 048A 02BF DC93 94EC

I really didn't foresee the Internet. But then, neither did the
computer industry. Not that that tells us very much of course - the
computer industry didn't even foresee that the century was going to
end. -- Douglas Adams


Re: How do I email from a TSM script

2007-03-26 Thread RODOLFICH, NICHOLAS
Thanks Guys,

I need the server to send the email, not the client. I am trying to send
a message to the operations staff when it is time to pull tapes. I
already have shell scripts that do the DRM rotations and eject the tapes
but I have to pick a time to notify the operator which causes the script
to run before the daily maintenance is complete some times so if the
script runs long then all of today's tapes don't get pulled until the
next day. I would like to eject tapes and send the email at the end of
the daily maintenance script  when I know the daily maintenance is
complete.

Regards,
 
Nicholas Rodolfich  
POOLCORP
Desk: (985)801-3038
Cell:   (228)223-6777
mailto:[EMAIL PROTECTED]

 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Monday, March 26, 2007 10:10 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How do I email from a TSM script

Accomplish that via Define Clientaction, to have a client's OS
command do it.

   Richard Sims




This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager. This message contains confidential information and is
intended only for the individual named. If you are not the named
addressee you should not disseminate, distribute or copy this e-mail.





This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager. This 
message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail.


Re: How do I email from a TSM script

2007-03-26 Thread Richard Sims

On Mar 26, 2007, at 12:09 PM, RODOLFICH, NICHOLAS wrote:


I need the server to send the email, not the client. I am trying to
send
a message to the operations staff when it is time to pull tapes. ...


Yes, I understand, and thus I suggested DEFine CLIENTAction, which I
use in my daily admin script to notify our operators of tasks to
perform.
DEFine CLIENTAction is a server command which can be generated from a
server script to do a variety of things, including sending email.
You can choose whichever client you want to perform the action -
where that can include the system in which the TSM server is operating.

   Richard Sims


Re: How do I email from a TSM script

2007-03-26 Thread RODOLFICH, NICHOLAS
Thanks for your help guys. The def clienta worked great for what I
needed. 

Thanks you very much!!

Regards,
 
Nicholas 

 

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Sims
Sent: Monday, March 26, 2007 11:38 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] How do I email from a TSM script

On Mar 26, 2007, at 12:09 PM, RODOLFICH, NICHOLAS wrote:

 I need the server to send the email, not the client. I am trying to
 send
 a message to the operations staff when it is time to pull tapes. ...

Yes, I understand, and thus I suggested DEFine CLIENTAction, which I
use in my daily admin script to notify our operators of tasks to
perform.
DEFine CLIENTAction is a server command which can be generated from a
server script to do a variety of things, including sending email.
You can choose whichever client you want to perform the action -
where that can include the system in which the TSM server is operating.

Richard Sims




This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the
system manager. This message contains confidential information and is
intended only for the individual named. If you are not the named
addressee you should not disseminate, distribute or copy this e-mail.





This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager. This 
message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail.


tsm script continuation character

2006-05-01 Thread Timothy Hughes
Hello,

I have the script below setup to run on Sunday. I understand
the dash (-) is a continuation character that is placed at the end of
the
line, But I saw in the server log it did not accept the dash, Should
there be a space on the next line before the continuation of a script?

Administrator XXissued command: BACKUP DB
devclass=BKP type=full scratch=yes -= wait=yes  (SESSION:

ANR2020E BACKUP DB: Invalid parameter - -. (SESSION: 988)

This is the way it looks way when I click on the script

serial
backup db devclass=bkp type=full scratch=yes - wait=yes
serial
BA STG backuppool remotepool maxpr=2 wait=yes
serial
migrate stgpool backuppool lowmig=0 wait=yes
serial
Ba STG LTOpool REMOTEpool maxpr=2 wait=yes



This is the way it looks when I update date the the script

serial
backup db devclass=bkp type=full scratch=yes  -
wait=yes
serial
BA STG backuppool remotepool maxpr=2 wait=yes
serial
migrate stgpool backuppool lowmig=0 wait=yes
serial
Ba STG LTOpool REMOTEpool maxpr=2 wait=yes




Thanks in Advance!


Re: tsm script continuation character

2006-05-01 Thread Allen S. Rout
 On Mon, 1 May 2006 11:31:10 -0400, Timothy Hughes [EMAIL PROTECTED] said:


 I have the script below setup to run on Sunday. I understand the
 dash (-) is a continuation character that is placed at the end of
 the line, But I saw in the server log it did not accept the dash,
 Should there be a space on the next line before the continuation of
 a script?


 Administrator XXissued command: BACKUP DB
 devclass=BKP type=full scratch=yes -= wait=yes  (SESSION:

 ANR2020E BACKUP DB: Invalid parameter - -. (SESSION: 988)


As a 'continuation character', it needs to come at the end of a line.

The way to think about it is that the byte sequence -[newline] is
magically removed from the script stream.  Therefore a '-' other than
before a newline is a syntax error.


 Thanks in Advance!

You're welcome, a posteriori.


- Allen S. Rout


Re: tsm script continuation character

2006-05-01 Thread Timothy Hughes
Richard, Allen Thanks,

I retyped that line a couple of times and I finally think it's correct.
I did a run script preview and it showed the script to run as the
following so I think it's correct now.


 RUN: Executing command script SUN_TSM_TASKS.
 Line 1 : serial.
 Line 5 : backup db devclass=bkp type=full scratch=yes  wait=yes.
 Line  15 : serial.
 Line 20 : BA STG backuppool remotepool maxpr=2 wait=yes.
 Line 25 : serial.
 Line 30 : migrate stgpool backuppool lowmig=0 wait=yes.
 Line 35 : serial.
 Line 40 : Ba STG LTOpool remotepool maxpr=2 wait=yes.
 SUN_TSM_TASKS completed successfully (PREVIEW mode).








Richard Sims wrote:

 Tim - Perhaps there's an inadvertent space after the hyphen?

Richard


Re: Way to do comparison in a TSM script?

2003-11-13 Thread Paul Bergh
Paul,

you may need a 2nd party code, try OPT COMM,
they offer dependency/ conditional scheduling.


PB
Paul Zarnowski wrote:

 Is there a way to do a comparison in a TSM script?
 Specifically, I want to run code conditionally based on how many sessions
 are active (for example).  I don't see an immediately obvious way to do this.

 Thanks.
 ..Paul
begin:vcard
n:Bergh;Paul
tel;fax:
tel;work:518-928-9413
x-mozilla-html:FALSE
org:Northwood Information Solutions
version:2.1
email;internet:[EMAIL PROTECTED]
title:President - Consultant
adr;quoted-printable:;;17 Northwood Drive =0D=0A;Ballston Spa;New York;12020;
note;quoted-printable:IBM Business Partner=0D=0ACertified for Tivoli Storage Manager=0D=0ASales and Installation Services
fn:Paul Bergh
end:vcard


Re: Way to do comparison in a TSM script?

2003-11-13 Thread Prather, Wanda
We just use host scripts, and call dsmadmc for the TSM commands from within
the script.

- perl scripts from Windows (free and harmless to install)

- perl or Kornshell from AIX.

-Original Message-
From: Paul Bergh [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: Re: Way to do comparison in a TSM script?


Paul,

you may need a 2nd party code, try OPT COMM,
they offer dependency/ conditional scheduling.


PB
Paul Zarnowski wrote:

 Is there a way to do a comparison in a TSM script?
 Specifically, I want to run code conditionally based on how many sessions
 are active (for example).  I don't see an immediately obvious way to do
this.

 Thanks.
 ..Paul


Re: Way to do comparison in a TSM script?

2003-11-13 Thread Bill Boyer
Try:

select count(*) from sessions having count(*)5
if(RC_NOTFOUND) goto notfound
exit
notfound: do something here...
exit


You can even add a WHERE clause to further refine the type of sessions
you're looking to 'count'.

Bill Boyer
DSS, Inc.

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Paul Zarnowski
Sent: Thursday, November 13, 2003 3:30 PM
To: [EMAIL PROTECTED]
Subject: Way to do comparison in a TSM script?


Is there a way to do a comparison in a TSM script?
Specifically, I want to run code conditionally based on how many sessions
are active (for example).  I don't see an immediately obvious way to do
this.

Thanks.
..Paul


Re: Way to do comparison in a TSM script?

2003-11-13 Thread Paul Zarnowski
Thanks Bill, and everyone else.   This is what I was looking for.  I've
written lots of host-based scripts, but was trying to do something simple
in a TSM script.  I'll give this a try.
At 04:08 PM 11/13/2003 -0500, you wrote:
Try:

select count(*) from sessions having count(*)5
if(RC_NOTFOUND) goto notfound
exit
notfound: do something here...
exit
You can even add a WHERE clause to further refine the type of sessions
you're looking to 'count'.
Bill Boyer
DSS, Inc.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
Paul Zarnowski
Sent: Thursday, November 13, 2003 3:30 PM
To: [EMAIL PROTECTED]
Subject: Way to do comparison in a TSM script?
Is there a way to do a comparison in a TSM script?
Specifically, I want to run code conditionally based on how many sessions
are active (for example).  I don't see an immediately obvious way to do
this.
Thanks.
..Paul


--
Paul Zarnowski Ph: 607-255-4757
719 Rhodes Hall, Cornell UniversityFx: 607-255-8521
Ithaca, NY 14853-3801  Em: [EMAIL PROTECTED]


Re: Way to do comparison in a TSM script?

2003-11-13 Thread Coats, Jack
Within a TSM script, nope, now what you do.

To effectively do this, you can schedule an external script that can have
some
branching/comparison/looping intelligence added, and have this script run
TSM command line commands.

I fought with this for quite a while.  But I am happy to be told I am all
wet!

 -Original Message-
 From: Paul Zarnowski [SMTP:[EMAIL PROTECTED]
 Sent: Thursday, November 13, 2003 2:30 PM
 To:   [EMAIL PROTECTED]
 Subject:  Way to do comparison in a TSM script?

 Is there a way to do a comparison in a TSM script?
 Specifically, I want to run code conditionally based on how many sessions
 are active (for example).  I don't see an immediately obvious way to do
 this.

 Thanks.
 ..Paul


Re: Calling external commands from TSM script

2003-07-05 Thread Richard Sims
Is it possible to call external DOS/Windows commands from inside of a
TSM script?  Is there an exec command in TSM script language like there
is in C?=

Maria - Server Scripting remains essentially as it was when introduced in
ADSMv3: a modest convenience akin to TSO CLISTs of the mid-1970s.
(My, um, heritage is showing.)  Because the facility is so rudimentary,
achieving anything more involves employing some tricks.  As I noted under
topic Server Script, issue OS command from in
http://people.bu.edu/rbs/ADSM.QuickFacts, getting from server script to OS
command can be achieved via a client schedule, most conveniently performed
via DEFine CLIENTAction - a one-time client schedule.  Note that some
commands, like 'Query MEDia' and 'Query DRMedia', can generate commands
which can be written to an OS file, which can then be defined and run as a
script invoked from the running script, to for example send email about a
certain volume.  I employ this technique in my morning-admin script.
Conversely, you can invoke server functions from outside the server, as
in having a Perl script run dsmadmc, and thereby achieve more sophisticated
processing.

  Richard Sims, BU


Calling external commands from TSM script

2003-07-04 Thread Maria Waern
Hi

Is it possible to call external DOS/Windows commands from inside of a TSM script?  Is 
there an exec command in TSM script language like there is in C? 

Maria


Housekeeping through a TSM script

2002-08-02 Thread Loon, E.J. van - SPLXM

Hi TSM-ers!
At this moment al my maintenance processing is scheduled at specific hours.
I'm thinking about creating a script which starts all maintenance, one after
the other. The only problem I have is that I cannot find a way to see if
reclamation has finished. Most of the administrative task have the wait=yes
parameter, so the script waits until the task is finished, but since you
schedule reclamation through the update stgpool command one can't use that
trick here.
I thought about issuing a q proc command every 10 minutes and capturing the
return code 11 (no processes found) but a sleep 600 or something like that
is not supported in a TSM script.
Does anybody else have an idea how to do this? AIX scripts are not an option
due to security reasons (userid and passwords in the script).
Thanks in advance!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**
For information, services and offers, please visit our web site: http://www.klm.com. 
This e-mail and any attachment may contain confidential and privileged material 
intended for the addressee only. If you are not the addressee, you are notified that 
no part of the e-mail or any attachment may be disclosed, copied or distributed, and 
that any other action related to this e-mail or attachment is strictly prohibited, and 
may be unlawful. If you have received this e-mail by error, please notify the sender 
immediately by return e-mail, and delete this message. Koninklijke Luchtvaart 
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for 
the incorrect or incomplete transmission of this e-mail or any attachments, nor 
responsible for any delay in receipt.
**



Re: Housekeeping through a TSM script

2002-08-02 Thread Ford, Phillip

We use the following:  this is the macro to update the actual macro:

--
delete script reclaim_check
def script reclaim_check desc='Check if space reclamation is finished'
upd script reclaim_check select * from processes where process='Space
Reclamation'
upd script reclaim_check 'if(rc_ok) goto resch'
upd script reclaim_check 'delete schedule reclaim_check t=a'
upd script reclaim_check 'run set_reclaim_primary 100'
upd script reclaim_check 'run set_reclaim_copy 100'
upd script reclaim_check select * from script_names where
name='DO_RECLAIM_STOP'
upd script reclaim_check 'if(rc_ok) goto stop'
upd script reclaim_check 'exit'
upd script reclaim_check 'resch:'
upd script reclaim_check 'delete schedule reclaim_check t=a'
upd script reclaim_check define schedule reclaim_check t=a cmd='run
reclaim_check' -
upd script reclaim_check '  startt=now+0:15 dur=15 duru=m per=1 peru=h
active=yes'
upd script reclaim_check 'exit'
upd script reclaim_check 'stop:'
upd script reclaim_check 'rename script do_reclaim_stop do_reclaim_ok'
--
This has a few points.  The macro that starts reclaim does several things:
1)starts reclaim using macro set_reclam_copy 55 and set_reclaim_primary 45,
2) creates a schedule for script reclaim_check above, and 3) creates a
schedule for the macro reclsim_stop (used to try and stop reclaim after so
many hours, set copy and primary pools to 100 reclaim).

The heart of it bolls down to the following:

do a select and see if processes are still running.
if they are then delete this schedule and create a new one in the future and
end this macro - see
  first select and resch: in above macro
if here then process is finished: delete this schedule and do what you must
for next step which
 is usually start next process and create checker schedule for it.


We have a complete set of these that does the daily processing.  They each
start a process and schedule a checker to watch for it to finish.  The
checker keeps scheduling itself until the process is finished.  Then it runs
the next step process which in turn creates a checker schedule.  This
continues until we do reclaim which is our last one.  Thus in the above
macro, you do not see the start of a new step because reclaim is our last.
The processes are as follows:

do backup primary disk to tape copy
do backup primary tape to tape copy
do backup the database
do migrate
do expire
do reclaim

They all follow the design of the above script.


--
Phillip Ford
Senior Software Specialist
Corporate Computer Center
Schering-Plough Corp.
(901) 320-4462
(901) 320-4856 FAX
[EMAIL PROTECTED]



-Original Message-
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 6:00 AM
To: [EMAIL PROTECTED]
Subject: Housekeeping through a TSM script


Hi TSM-ers!
At this moment al my maintenance processing is scheduled at specific hours.
I'm thinking about creating a script which starts all maintenance, one after
the other. The only problem I have is that I cannot find a way to see if
reclamation has finished. Most of the administrative task have the wait=yes
parameter, so the script waits until the task is finished, but since you
schedule reclamation through the update stgpool command one can't use that
trick here.
I thought about issuing a q proc command every 10 minutes and capturing the
return code 11 (no processes found) but a sleep 600 or something like that
is not supported in a TSM script.
Does anybody else have an idea how to do this? AIX scripts are not an option
due to security reasons (userid and passwords in the script).
Thanks in advance!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may
be disclosed, copied or distributed, and that any other action related to
this e-mail or attachment is strictly prohibited, and may be unlawful. If
you have received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message. Koninklijke Luchtvaart
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be
liable for the incorrect or incomplete transmission of this e-mail or any
attachments, nor responsible for any delay in receipt.
**

***
 This message and any attachments is solely for the intended recipient. If
you are not the intended recipient, disclosure, copying, use, or
distribution of the information included in this message is prohibited --
please immediately and permanently delete this message.



Re: Housekeeping through a TSM script

2002-08-02 Thread Ramnarayan, Sean A [EDS]

Hi

IF you have root authority on AIX, you can change the permissions to 700 so that root 
user can only view your files and so on, so I do not see a problem with this as I am 
currently using a AIX script to do the below procudure you require , let me know if 
you need the script and I will forward this to you.

Thks
Sean 

-Original Message-
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 02, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject: Housekeeping through a TSM script


Hi TSM-ers!
At this moment al my maintenance processing is scheduled at specific hours.
I'm thinking about creating a script which starts all maintenance, one after
the other. The only problem I have is that I cannot find a way to see if
reclamation has finished. Most of the administrative task have the wait=yes
parameter, so the script waits until the task is finished, but since you
schedule reclamation through the update stgpool command one can't use that
trick here.
I thought about issuing a q proc command every 10 minutes and capturing the
return code 11 (no processes found) but a sleep 600 or something like that
is not supported in a TSM script.
Does anybody else have an idea how to do this? AIX scripts are not an option
due to security reasons (userid and passwords in the script).
Thanks in advance!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


**
For information, services and offers, please visit our web site: http://www.klm.com. 
This e-mail and any attachment may contain confidential and privileged material 
intended for the addressee only. If you are not the addressee, you are notified that 
no part of the e-mail or any attachment may be disclosed, copied or distributed, and 
that any other action related to this e-mail or attachment is strictly prohibited, and 
may be unlawful. If you have received this e-mail by error, please notify the sender 
immediately by return e-mail, and delete this message. Koninklijke Luchtvaart 
Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for 
the incorrect or incomplete transmission of this e-mail or any attachments, nor 
responsible for any delay in receipt.
**


MMS caltex.com made the following
 annotations on 08/02/2002 01:18:18 PM
--
DISCLAIMER
This message may contain confidential information that is legally privileged and is 
intended only  for the use of the parties to whom it is addressed. If you are not an 
intended recipient, you are hereby notified that any disclosure, copying, distribution 
or use of any information in this message is strictly prohibited. If you have received 
this message in error, please notify the sender immediately and delete the message. 
Thank you.

==



Re: Anyone know how to have TSM script read an input file?

2002-04-02 Thread Cook, Dwight E

Try
select node_name,filespace_name,cast((backup_end) as varchar(10)) as Date
from adsm.filespaces where (cast((current_timestamp-backup_end)day as
decimal(18,0))2 )

or

select node_name,filespace_name,cast((backup_end) as varchar(10)) as Date
from adsm.filespaces where (cast((current_timestamp-backup_end)day as
decimal(18,0))2 and cast((current_timestamp-backup_end)day as
decimal(18,0))7 )

the first will give you any file space that hasn't backed up in the last 2
days
this can get long due to excluded file spaces and the such
thus the second will list file spaces that haven't backed up between -2  -7
days, this will get rid of excluded file spaces (once the box has been
backing up for a week

Dwight E. Cook
Software Application Engineer III
Science Applications International Corporation
509 S. Boston Ave.  Suit 220
Tulsa, Oklahoma 74103-4606
Office (918) 732-7109



-Original Message-
From: MC Matt Cooper (2838) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:18 AM
To: [EMAIL PROTECTED]
Subject: Anyone know how to have TSM script read an input file?


Hello all,
In the life of ever changing requirements... I must include in an
e-mail sent to a PC user that they missed a backup, exactly how long it has
been since they were backed up.
I am scanning the log to see what schedules were MISSED.  But
now for each node that was missed I need to know the last date of a backup,
not a 'accessed by TSM' (which is in the NODE DB) .  I see that the SUMMARY
DB has ALL the backups start and end dates.  But what would be the logical
way to approach this?  I would think list off the nodes that failed and do
some sort of select of the SUMMARY DB to find the last successful backup.
1) I am not sure how to ask for JUST the last successful backup of 1 node.
2) I am truly at a loss to figure out how to have this script read in a list
of nodes to find out there last successful backups

Has anyone done anything like this?  An example could take me a long way.
I am using TSM 4.1.5 on z/OS 1.1.   If I can get all the info into records I
am using SAS to format the e-mail messages.   My TSM system has about 230
nodes in an 80% full 25GB data base.  Hopefully I can do this in an
efficient manner...
Thanks in advance for all your help!
Matt



Anyone know how to have TSM script read an input file?

2002-04-02 Thread MC Matt Cooper (2838)

Hello all,
In the life of ever changing requirements... I must include in an
e-mail sent to a PC user that they missed a backup, exactly how long it has
been since they were backed up.
I am scanning the log to see what schedules were MISSED.  But
now for each node that was missed I need to know the last date of a backup,
not a 'accessed by TSM' (which is in the NODE DB) .  I see that the SUMMARY
DB has ALL the backups start and end dates.  But what would be the logical
way to approach this?  I would think list off the nodes that failed and do
some sort of select of the SUMMARY DB to find the last successful backup.
1) I am not sure how to ask for JUST the last successful backup of 1 node.
2) I am truly at a loss to figure out how to have this script read in a list
of nodes to find out there last successful backups

Has anyone done anything like this?  An example could take me a long way.
I am using TSM 4.1.5 on z/OS 1.1.   If I can get all the info into records I
am using SAS to format the e-mail messages.   My TSM system has about 230
nodes in an 80% full 25GB data base.  Hopefully I can do this in an
efficient manner...
Thanks in advance for all your help!
Matt



Re: Anyone know how to have TSM script read an input file?

2002-04-02 Thread Jane Bamberger

- Original Message -
From: MC Matt Cooper (2838) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 02, 2002 11:18 AM
Subject: Anyone know how to have TSM script read an input file?


 Hello all,
 In the life of ever changing requirements... I must include in an
 e-mail sent to a PC user that they missed a backup, exactly how long it
has
 been since they were backed up.
 I am scanning the log to see what schedules were MISSED.  But
 now for each node that was missed I need to know the last date of a
backup,
 not a 'accessed by TSM' (which is in the NODE DB) .  I see that the
SUMMARY
 DB has ALL the backups start and end dates.  But what would be the logical
 way to approach this?  I would think list off the nodes that failed and do
 some sort of select of the SUMMARY DB to find the last successful backup.
 1) I am not sure how to ask for JUST the last successful backup of 1 node.
 2) I am truly at a loss to figure out how to have this script read in a
list
 of nodes to find out there last successful backups

 Has anyone done anything like this?  An example could take me a long way.
 I am using TSM 4.1.5 on z/OS 1.1.   If I can get all the info into records
I
 am using SAS to format the e-mail messages.   My TSM system has about 230
 nodes in an 80% full 25GB data base.  Hopefully I can do this in an
 efficient manner...
 Thanks in advance for all your help!
 Matt




Re: Anyone know how to have TSM script read an input file?

2002-04-02 Thread Mr. Lindsay Morris

We put this feature (user notification of failed backups) into our
Servergraph/TSM product a while ago.  Some gotchas you might want to think
about, if you're developing it yourself:

  --for laptops, you don't want to send this notification immediately. Maybe
the user is out of town for a few days.  So each node needs a delay-time:
for critical servers, delay zero days; desktops, 2 days; laptops, 7 days, or
something like that.

  --the notification ought to give the user a way to fix the easy problems
(e.g., is the scheduler running? etc.)

  --if the situation continues for too long, an escalation message ought to
be sent to you, the TSM administrator.

  --you want to ignore antique filespaces, like the one containing an old
retired PC that the user keeps around just in case I need a file from it.

Just food for thought. Maybe you don't need these features.


Mr. Lindsay Morris
CEO
Applied System Design
www.servergraph.com
859-253-8000 ofc
425-988-8478 fax



 -Original Message-
 From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
 Jane Bamberger
 Sent: Tuesday, April 02, 2002 3:09 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Anyone know how to have TSM script read an input file?


 - Original Message -
 From: MC Matt Cooper (2838) [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, April 02, 2002 11:18 AM
 Subject: Anyone know how to have TSM script read an input file?


  Hello all,
  In the life of ever changing requirements... I must
 include in an
  e-mail sent to a PC user that they missed a backup, exactly how long it
 has
  been since they were backed up.
  I am scanning the log to see what schedules were
 MISSED.  But
  now for each node that was missed I need to know the last date of a
 backup,
  not a 'accessed by TSM' (which is in the NODE DB) .  I see that the
 SUMMARY
  DB has ALL the backups start and end dates.  But what would be
 the logical
  way to approach this?  I would think list off the nodes that
 failed and do
  some sort of select of the SUMMARY DB to find the last
 successful backup.
  1) I am not sure how to ask for JUST the last successful backup
 of 1 node.
  2) I am truly at a loss to figure out how to have this script read in a
 list
  of nodes to find out there last successful backups
 
  Has anyone done anything like this?  An example could take me a
 long way.
  I am using TSM 4.1.5 on z/OS 1.1.   If I can get all the info
 into records
 I
  am using SAS to format the e-mail messages.   My TSM system has
 about 230
  nodes in an 80% full 25GB data base.  Hopefully I can do this in an
  efficient manner...
  Thanks in advance for all your help!
  Matt
 




Re: Anyone know how to have TSM script read an input file?

2002-04-02 Thread StorageGroupAdmin StorageGroupAdmin

For the exclusion of 'old' filespaces and for clients not be checked we
utilise the 'Contact' column in the nodes table.

To excluded a filespace(s) the contact details will be prefixed with
XFS1,3,4. where the numeric represents the filespace  id.

To exclude the entire clilent from being checked the contact details
will be prefixed with 'NOCHECK'.

We run the following SQLs to list all clients and then individually
check the status of the last incremental backup (based upon a
standardised naming convention for the client schedule.)  when the
filespaces were last backed up.

To list all nodes (the dummy col is used to simplify the extraction of
the actual line I am looking for, ie ignore the SQL header info):

select substr(domain_name,1,3) as dummy, nodes.node_name, nodes.contact
from nodes where upper(nodes.contact) is NULL or upper(nodes.contact)
not like 'NOCHECK%' and NODETYPE= 'CLIENT'

For each node in the list;

To extact the details of the last incrmental process;

select summary.schedule_name, sum(summary.failed) as failures,
sum(summary.bytes) amount, summary.successful,
sum(cast((summary.end_time-summary.start_time)minutes as decimal(18,0)))
from summary where summary.schedule_name like 'INCR%' and
summary.entity='$node_name' and
cast((current_timestamp-summary.end_time)days as decimal(18,0)) 1 group
by summary.successful, summary.schedule_name


To list the max number of days since a non exlcuded filespace has been
backed up (note the variable X_FSID is set to 0 if nothing is to be
exlcuded since a FSID of 0 will never exist)

 select distinct substr(nodes.domain_name,1,3),
max(cast((current_timestamp-filespaces.backup_end)days as
decimal(18,0))) from filespaces, nodes where
(filespaces.node_name='$node_name' and filespace_id not in ($x_fsid))
group by nodes.domain_name



I use a pearl script to extract the info a create a html file with what
are deemded failures highlighted in an alternate colour.



Peter Griffin

Sydney Water



 [EMAIL PROTECTED] 04/03/02 02:18am 
Hello all,
In the life of ever changing requirements... I must include in
an
e-mail sent to a PC user that they missed a backup, exactly how long it
has
been since they were backed up.
I am scanning the log to see what schedules were MISSED.
But
now for each node that was missed I need to know the last date of a
backup,
not a 'accessed by TSM' (which is in the NODE DB) .  I see that the
SUMMARY
DB has ALL the backups start and end dates.  But what would be the
logical
way to approach this?  I would think list off the nodes that failed and
do
some sort of select of the SUMMARY DB to find the last successful
backup.
1) I am not sure how to ask for JUST the last successful backup of 1
node.
2) I am truly at a loss to figure out how to have this script read in a
list
of nodes to find out there last successful backups

Has anyone done anything like this?  An example could take me a long
way.
I am using TSM 4.1.5 on z/OS 1.1.   If I can get all the info into
records I
am using SAS to format the e-mail messages.   My TSM system has about
230
nodes in an 80% full 25GB data base.  Hopefully I can do this in an
efficient manner...
Thanks in advance for all your help!
Matt


---
This message has been scanned by MailSweeper.
---



---
This e-mail is solely for the use of the intended recipient
and may contain information which is confidential or
privileged. Unauthorised use of its contents is prohibited.
If you have received this e-mail in error, please notify
the sender immediately via e-mail and then delete the
original e-mail.
---



TSM Script

2002-03-19 Thread Tony Jules

I am trying to create a script to find out if the log reaches 80% and
Expiration is running to cancel the expiration process. My question is how
do I pass the process number as a parameter and cancel it. My script goes
like this.

select pct_utilized from log where pct_utilized  80%
 if (rc_ok) goto claim
claim: select process, process_num as Numbrers from processes where
process='Expiration'
 if (rc_ok) cancel process Numbers

The second if statement does not work because I can't pass Numbers as a
parameter. What is the best way to do this?

Thank you



Tony Jules
ITS / Olympus America Inc.
631-844-5887
[EMAIL PROTECTED]



Re: TSM Script

2002-03-19 Thread Steve Roder

 I am trying to create a script to find out if the log reaches 80% and
 Expiration is running to cancel the expiration process. My question is how
 do I pass the process number as a parameter and cancel it. My script goes
 like this.

No need to do this with expiration, just issue can expiration.


 select pct_utilized from log where pct_utilized  80%
  if (rc_ok) goto claim
 claim: select process, process_num as Numbrers from processes where
 process='Expiration'
  if (rc_ok) cancel process Numbers

 The second if statement does not work because I can't pass Numbers as a
 parameter. What is the best way to do this?


Steve Roder, University at Buffalo
HOD Service Coordinator
VM Systems Programmer
UNIX Systems Administrator (Solaris and AIX)
TSM/ADSM Administrator
([EMAIL PROTECTED] | (716)645-3564 | http://ubvm.cc.buffalo.edu/~tkssteve)



Re: Run OS command from inside TSM script?

2002-03-02 Thread ARhoads

I think the point of the question was to use the administrative command line
client.
- Original Message -
From: John Monahan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 9:35 AM
Subject: Re: Run OS command from inside TSM script?


 You can use an immediate client action to run OS commands within a TSM
 script.  You just have to setup the TSM client and scheduler, with
 schedmode prompted, on your AIX system if you haven't done so already.

 Here's a couple examples:

 Sleep script (this script takes the number of seconds as a parameter):
 define clientaction NODENAME action=command -
  objects='sleep $1' wait=yes
 i.e. RUN SLEEP 30

 Mail script (this script takes the subject of the mail as a parameter)
 define clientaction NODENAME action=command  -
  objects='mail -s $1 [EMAIL PROTECTED] /dev/null /dev/null' wait=no
 i.e. RUN MAIL This script has started


 ===
   John Monahan
   Senior Consultant Enterprise Solutions
   Computech Resources, Inc.
   Office: 952-833-0930 ext 109
   Cell: 952-484-5435
   http://www.compures.com
 ===





 Kliewer, Vern [EMAIL PROTECTED]
 Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
 02/28/2002 04:03 PM
 Please respond to ADSM: Dist Stor Manager


 To: [EMAIL PROTECTED]
 cc:
 Subject:Run OS command from inside TSM script?


 We run a TSM server on an AIX system. Is there a way to issue an operating
 system command ie. ls, tar ... from inside a TSM script? Yes, I know I can
 run a TSM script from the AIX command line, using dsmadmc ... but I have a
 need to run an one or more AIX commands from inside a TSM script, if there
 is a way.



Re: Run OS command from inside TSM script?

2002-03-01 Thread John Monahan

You can use an immediate client action to run OS commands within a TSM
script.  You just have to setup the TSM client and scheduler, with
schedmode prompted, on your AIX system if you haven't done so already.

Here's a couple examples:

Sleep script (this script takes the number of seconds as a parameter):
define clientaction NODENAME action=command -
 objects='sleep $1' wait=yes
i.e. RUN SLEEP 30

Mail script (this script takes the subject of the mail as a parameter)
define clientaction NODENAME action=command  -
 objects='mail -s $1 [EMAIL PROTECTED] /dev/null /dev/null' wait=no
i.e. RUN MAIL This script has started


===
  John Monahan
  Senior Consultant Enterprise Solutions
  Computech Resources, Inc.
  Office: 952-833-0930 ext 109
  Cell: 952-484-5435
  http://www.compures.com
===





Kliewer, Vern [EMAIL PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
02/28/2002 04:03 PM
Please respond to ADSM: Dist Stor Manager


To: [EMAIL PROTECTED]
cc:
Subject:Run OS command from inside TSM script?


We run a TSM server on an AIX system. Is there a way to issue an operating
system command ie. ls, tar ... from inside a TSM script? Yes, I know I can
run a TSM script from the AIX command line, using dsmadmc ... but I have a
need to run an one or more AIX commands from inside a TSM script, if there
is a way.



Run OS command from inside TSM script?

2002-02-28 Thread Kliewer, Vern

We run a TSM server on an AIX system. Is there a way to issue an operating
system command ie. ls, tar ... from inside a TSM script? Yes, I know I can
run a TSM script from the AIX command line, using dsmadmc ... but I have a
need to run an one or more AIX commands from inside a TSM script, if there
is a way.