These are pulled by the server during startup and stored in temporary
tables that are inaccessible by SQL commands.
You can get the WWN from SHOW LIBR.
-Josh
On 06.03.10 at 07:56 [EMAIL PROTECTED] wrote:
Date: Fri, 10 Mar 2006 07:56:52 -0800
From: T. Lists <[EMAIL PROTECTED]>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU>
To: ADSM-L@VM.MARIST.EDU
Subject: What table is the "q drive" WWN and Serial number stored in?
Q drive gives a WWN and serial number, however if you
just select from the DRIVES table you don't get that.
What table is that information stored in?
tsm: TSM02>q drive * drive01 f=d
Library Name: 3584LIB
Drive Name: DRIVE01
Device Type: LTO
On-Line: Yes
Read Formats:
ULTRIUM2C,ULTRIUM2,ULTRIUMC,ULTRIUM
Write Formats:
ULTRIUM2C,ULTRIUM2,ULTRIUMC,ULTRIUM
Element: 270
Drive State: EMPTY
Allocated to:
* WWN: 500507630001F012
* Serial Number: 9110108472
Last Update by (administrator): STACY
Last Update Date/Time: 03/09/06 16:16:17
Cleaning Frequency
(Gigabytes/ASNEEDED/NONE): NONE
tsm: TSM02>select * from drives where
drive_name='DRIVE01'
LIBRARY_NAME: 3584LIB
DRIVE_NAME: DRIVE01
DEVICE_TYPE: LTO
ONLINE: YES
READ_FORMATS: ULTRIUM2C,ULTRIU
WRITE_FORMATS: ULTRIUM2C,ULTRIU
ELEMENT: 270
ACS_DRIVE_ID:
DRIVE_STATE: EMPTY
ALLOCATED_TO:
LAST_UPDATE_BY: STACY
LAST_UPDATE: 2006-03-09 16:16:17.000000
CLEAN_FREQ:
DRIVE_SERIAL:
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
