APAR= IC33890  SER=                            IN INCORROUT
ACTIVE
OUTPUT FROM SELECT COMMAND FOR THE DRIVES TABLE WILL NOT RETURN
OPTIONS   ARE:
A DEVICE VALUE IF THE DEVICE_TYPE IS NOT SPECIFIED/REQUESTED.
ROUTE
STAT= CLOSED  UR1  FESN0907536-     CTID= TU0290 ISEV= 4
TRANS
SB02/06/13  RC02/06/14  CL02/07/04  PD           SEV= 4
S2UPDATE
PE=                       TYPE= F
EDIT
RCOMP= 5698TSMAX    TSM AIX SERVER  RREL= R420
SEDIT
FCOMP= 5698TSMAX    TSM AIX SERVER  PFREL= F     TREL= T999
FLAGSET
ACTION=             SEC/INT=                     DUP/
PRINT
USPTF=              PDPTF=                       DUPS 0
.
SYSRES=      SYSIN=      SYSOUT=      CPU=             RE-IPL=
OPTYPE=                 SPECIAL ACTIVITY=          REGRESSION=
PRE-SCREEN NO.=          RSCP= RS420
ERROR DESCRIPTION:
The output from a select statement against the TSM drives table
in TSM 4.2 does not return a value in the device column unless
the device_type is specified in the select command. If select
* is used the device is returned. If select device_type, device
is used then the device is returned. Or if device_type is part
of the where predicate then the device is returned.
With the code/function changes occuring in the code with the
introdction of the path defintion the device is returned in
the select statements from the paths table. In TSM 5.1 this will
be the only table that the device will be in (it is no longer in
the drive definition).
.
LOCAL FIX:
Us the paths table to find the device if a select statement
is needed without specifying the device_type.
PROBLEM SUMMARY:
****************************************************************
* USERS AFFECTED: All Solaris, HP, AIX and Windows 4.2 TSM     *
*                 users.                                       *
****************************************************************
* PROBLEM DESCRIPTION: DEVICE field does not contain data in   *
*                      the output of a SELECT from the DRIVES  *
*                      table unless the DEVICE_TYPE field is   *
*                      selected either by name or by the use   *
*                      of * to select all fields.  The         *
*                      DEVICE_TYPE field does not need to be   *
*                      one of the displayed fields, but it     *
*                      does need to be referenced in the       *
*                      SELECT statement for the DEVICE field   *
*                      to contain data.                        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
Make sure to include the DEVICE_TYPE field somewhere in the
SELECT statment to get the DEVICE field included.  No code
change is being made for this APAR as in the V5 server the
DEVICE field is no longer part of the DRIVES table and is only
available in the PATHS table, and there is a simple
circumvention to obtain the data in the V4.2 server.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180