Yeah thanks guys. 8mb did the trick.

I've just been trying out some of these things as the pass by, see if
they're any use to me.

One thing I'm struggling on just now is:

I've got an NDMP job scheduled for our NetApp filers:

The monthly is a full backup, I've got:
versions data exists 12
versions deleted 12
Retain extra 12
Retain only 12

I believe the version deleted & retain only parametres aren't supported
for NetApp NMDP dump backups, so with the two other settings, versions
data exists 12 & retain extra 12, what I'm hoping I'm achieving is that
I'd be able to restore data for up to 12 months from these monthly
backups.
Am I right in thinking that?


Once the monthly backup has run, I "move media" so that TSM marks the
media as being in the firesafe and "mountablenotinlib". These tapes
having been ejexted from the library are stored in the firesafe.
What I'd like to find out is find out which tape contains which
volumes/filespaces data.



Regards,

Iain Barnetson
IT Systems Administrator
UKN Infrastructure Operations

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andreas Priebe
Sent: 07 March 2005 15:29
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] LTO Volume

Hi Iain

> tsm: ABZBKUP001>SELECT STGPOOL_NAME AS "        STORAGE POOL
",
> -
> cont>   CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL",
-
> cont>   DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CHAR(ACCESS,11) AS
> "ACCESS", -
> cont>   LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE    " -
> cont>   FROM VOLUMES WHERE STATUS='FILLING' ORDER BY STGPOOL_NAME
> ANR2948E The value '4096000.0' can not be assigned or converted to SQL

> data type DECIMAL(7,1).
>
>                                  |
>
........................V......................................
>          ED as "PCT UTIL",   DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY",
CH
>
> ANS8001I Return code 26.

Yours said: value '4096000.0', mine said: value '381468.0', so counting
megabytes suggests, maybe in your case it should be at least

DEC(EST_CAPACITY_MB,8)

?

Regards,

Andreas