Do you want to learn why Database backups are different from file backups? Click HERE to find out.
Do you want to learn why
Database backups
are different from file backups?
Click HERE to find out.
IBM Spectrum Protect Scripting Hints
Send offsite and recall Copy tapes
To move tapes offsite schedule this command daily
Command: update vol * access=offsite
where access=readwrite
where stg=copy_pool location='offsite_location'
where status=full
{just send out full tapes}
To recall back onsite schedule this command weekly
Command: update vol * access=readwrite
where access=offsite
where stg='offsite_location='
where status=empty
{recall empty tapes}
back to top
Free up tapes which are almost empty
This script is a combination of TSM queries and unix scripting
for volume in
$(dsmadmc -id=adminname -pass=adminpass -outfile
"select 'MARKER', volume_name from volumes
where pct_utilized >20 " | grep '^MARKER' | cut -b 12-) ;
do dsmadmc -id=adminname -pass=adminpass -outfile
'move data ${volume} options..' ; done
Explanation : Use an SQL query to generate a list of almost empty tapes
SELECT 'MARKER', volume_name stgpool_name,pct_utilized from volumes WHERE PCT_UTILIZED < 10
will output something like :
Use the grep command to extract lines we want
grep 'MARKER'
gives
MARKER A40012
MARKER A40015
use cut to extract the tape volsers
cut -b 12-
gives
A40012
A40015
back to top
Multiple macro commands
If you specify several commands in a macro, sometimes the macro does not seem to get past the first command. Try using 'commit' after each statement:
q vol access=destroyed
commit
q vol access=unavail
commit
back to top
Exporting scripts
The query script command will list out the names of all your scripts and their descriptions like this
If you want to export your scripts, say to build another server, then you need to know the details. The command to use is
Q script f=macro
which will produce output in a format that can be executed as a macro. If you pipe that command to a file, the file can be copied to another server for execution.
back to top