Nice. Is it anywhere list of undocumented 'show something' list?
On 3/11/06, Josh-Daniel Davis <xaminmo AT omnitech DOT net> wrote:
> 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
> >
>
--
--w
|