ADSM-L

Re: Identifying session holding a drive

2005-01-12 07:28:19
Subject: Re: Identifying session holding a drive
From: Lloyd Dieter <ldieter AT ROCHESTER.RR DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 12 Jan 2005 07:28:03 -0500
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

--

<Prev in Thread] Current Thread [Next in Thread>