Thank you, Lloyd.
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
Lloyd Dieter napsal(a):
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
--
|
