AW: chained volumes (how to query)

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