Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+SQL\s+SELECT\s+to\s+show\s+what\'s\s+mounted\s+and\s+why\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+SQL\s+SELECT\s+to\s+show\s+what\'s\s+mounted\s+and\s+why\s*$/: 6 ]

Total 6 documents matching your query.

1. [ADSM-L] SQL SELECT to show what's mounted and why (score: 1): Author: Roger Deschner <rogerd AT UIC DOT EDU>; Date: Thu, 12 Feb 2009 12:15:32 -0600; I'm looking for an SQL SELECT that will display a list of what tape is mounted on each drive, and which session or process it's mounted for. I've looked at SHOW ASMOUNTED, SHOW ASVOL, SHOW MP and the; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-02/msg00206.html (11,570 bytes)
2. Re: [ADSM-L] SQL SELECT to show what's mounted and why (score: 1): Author: "Huebschman, George J." <GJHuebschman AT LMUS.LEGGMASON DOT COM>; Date: Thu, 12 Feb 2009 13:24:21 -0500; Have you considered the SUMMARY table. The is are columns for ACTIVITY (Session or Process) and VOLUME_NAME. I have not tried to build anything like that, but it could be interesting. I'm looking for; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-02/msg00207.html (12,993 bytes)
3. Re: [ADSM-L] SQL SELECT to show what's mounted and why (score: 1): Author: Fred Johanson <Fred AT UCHICAGO DOT EDU>; Date: Thu, 12 Feb 2009 12:28:33 -0600; We use this for sessions. It ought to be easy to add processes. select client_name as "Client",session_id as "Session",substr(output_vol_access,3,6) as "Tape Volume" from sessions - where output_vol_; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-02/msg00208.html (12,437 bytes)
4. Re: [ADSM-L] SQL SELECT to show what's mounted and why (score: 1): Author: "Colwell, William F." <bcolwell AT DRAPER DOT COM>; Date: Thu, 12 Feb 2009 13:51:28 -0500; Roger, I have a script called 'qdr' to show the drives and the tapes on each. The script also executes scripts in the library manager client servers to get details of the usage. The scripts and sampl; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-02/msg00209.html (12,541 bytes)
5. Re: [ADSM-L] SQL SELECT to show what's mounted and why (score: 1): Author: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>; Date: Fri, 13 Feb 2009 07:20:53 -0500; I don't know of a simple way to get a overview of tape drive activity from TSM, especially if you have a library sharing environment and storage agents. Frustrated, I wrong a script to give an overvi; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-02/msg00230.html (18,062 bytes)
6. Re: [ADSM-L] SQL SELECT to show what's mounted and why (score: 1): Author: Roger Deschner <rogerd AT UIC DOT EDU>; Date: Mon, 16 Feb 2009 11:20:06 -0600; Thanks Bill! (and also Fred Johanson of uchicago.edu for a simpler one) That's just what I was looking for, and now I don't have to reinvent it. Roger Deschner University of Illinois at Chicago roger; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-02/msg00269.html (12,986 bytes)

Current List: 1 - 6
Page: [1]