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:[EMAIL PROTECTED] On Behalf Of Andreas Priebe Sent: 07 March 2005 15:29 To: ADSM-L@VM.MARIST.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
