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 tracylists AT YAHOO DOT COM wrote:

Date: Fri, 10 Mar 2006 07:56:52 -0800
From: T. Lists <tracylists AT YAHOO DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT 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