thanks to you both, richard and gary,
this was useful to me, maybe it would have taken
some more weeks to see that there is segment column ......
> -----Ursprüngliche Nachricht-----
> Von: Gary Ison [SMTP:Gary.Ison AT MAIL.STATE.KY DOT US]
> Gesendet am: Freitag, 28. April 2000 16:06
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: Re: chained volumes (how to query)
>
> Bruno,
>
> This is a script for determining if a volume has split files. You
> could probably modify it to do the reverse - find volumes containing a
> file
> by changing the where clause to search by file name.
>
> del scr file-seg
> def script file-seg desc='Show segmented file names on a tape volume'
> upd script file-seg '/* -----------------------------------------*/'
> upd script file-seg '/* Script Name: file-seg */'
> upd script file-seg '/* Description: Show segmented files on a */'
> upd script file-seg '/* tape volume. */'
> upd script file-seg '/* Parameter: Volume name */'
> upd script file-seg '/* Example: run file-seg n....n */'
> upd script file-seg '/* -----------------------------------------*/'
> upd script file-seg 'select cast (file_name as character(65)) -'
> upd script file-seg ' as " File Name
> ", -'
> upd script file-seg ' cast (volume_name as character(6)) -'
> upd script file-seg ' as "Volume", -'
> upd script file-seg ' cast (segment as character(5)) as "Seg." -'
> upd script file-seg ' from contents -'
> upd script file-seg ' from contents -'
> upd script file-seg " where volume_name=upper('$1') -"
> upd script file-seg " and segment <> '1/1' -"
> upd script file-seg ' order by 1,3,2'
> Gary L. Ison
> Governor's Office for Technology
> 101 Cold Harbor Drive
> Frankfort, Ky. 40601
> Phone: (502) 564-8724
> Fax: (502) 564-6856
> E-mail: Gary.Ison AT mail.state.ky DOT us <mailto:Gary.Ison AT mail.state.ky
> DOT us>
>
> -----Original Message-----
> From: Bruno Calce [SMTP:Bruno.Calce AT BEDAG DOT CH]
> Sent: Friday, April 28, 2000 9:54 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: chained volumes (how to query)
>
> hi,
> when RECLAIMing volumes or MOVing DATA, it happens that ADSM mounts
> more than only the expected volume. this is the case when files are
> spanned
> from one volume to the other (i suppose). for example, i found three files
> having
> only one entry in the BACKUPS table, but having two in CONTENTS (with
> different VOLUME_NAMEs). these files seemed to be in the same aggregate.
>
> does anybody know a fast and easy way to find out chained volumes, or do i
> really have
> to combine some complex sql statements ?
>
> regards,
> bruno
|