We saw the same thing.  You have to "select device, device_type, ...", not
just "select device".
Has to do with some database changes made in TSM - not sure what.

---------------------------------
Mr. Lindsay Morris
Lead Architect, Servergraph
859-253-8000 ofc
425-988-8478 fax


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Jolliff, Dale
> Sent: Thursday, September 19, 2002 9:14 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: 4.2.x selects from DRIVE table
>
>
> Something odd I noticed this morning about 4.2.x servers on AIX
> and Solaris
> -
>
> "query drive f=d"
> and
> "select * from drives"
>
> Displays values in the Device field, whereas a
>
> "select device from drives"
>
> displays a blank device field.
>
> This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on AIX.
>
> I went back to an older server (3.x) on AIX, and a "select device from
> drives"  shows the devices, as I expected.
>
> Anyone else able to reproduce this?  Is this WAD or a new 'feature'?
>