Here's a select/script that I use to pull that info...not perfect, but it
does the job.
You'll have to change the devclass name to match what you are using:
DEFINE SCRIPT SHOWME_SESSION_MOUNTS DESC="Show sequential vols in use by
a session"
"/* Show Tape mounts: */"
"set sqldisplaymode narrow"
"select -"
"client_name as ""Client"", -"
"session_id as ""Session"", -"
"substr(output_vol_access,3,6) as ""Tape Volume"" -"
"from sessions -"
"where -"
"output_vol_access is not null and -"
"substr(output_vol_access,3,6) -"
"in -"
"(select -"
"volume_name from volumes -"
"where devclass_name in -"
"(select -"
"devclass_name from devclasses -"
"where lower(devtype) like 'lto'-"
")-"
")"
"/* Show File Mounts: */"
"set sqldisplaymode wide"
"select -"
"client_name as ""Client"", -"
"session_id as ""Session"", -"
"left(substr(output_vol_access,3,90), - "
"posstr(substr(output_vol_access,3,90),',-') -1) -"
"as ""File Volume"" -"
"from sessions -"
"where -"
"output_vol_access is not null and -"
"left(substr(output_vol_access,3,90), -"
"posstr(substr(output_vol_access,3,90),',-') -1) -"
"in -"
"(select -"
"volume_name from volumes -"
"where devclass_name in -"
"(select -"
"devclass_name from devclasses -"
"where lower(devtype) like 'file'-"
")-"
")"
Regards,
-Lloyd
On Sun, 09 Jan 2005 22:29:07 +0100
Martin Trcka <trcka AT GCSYSTEM DOT CZ> wrote thusly:
> Hello list members,
> is there a way to identify which session is holding particular drive ?
>
> I've been playing with "show asm, show asq" commands recently which
> report some kind of session numbers in the output, but unfortunately
> they do not match session IDs presented when issuing "q ses".
>
> Maybe I'm missing st.
>
> TIA,
>
> --
>
> S pozdravem / Best Regards,
>
> Martin Trcka, IT Consultant
> Tech. Support Department
> GC System a.s., Spitalka 41, 60200 Brno, Czech Rep.
> mob: +420 602 452 361
> fax: +420 543 537 333
> email: trcka AT gcsystem DOT cz
--
|