known problem....


Item IC33890

  APAR Identifier ...... IC33890       Last Changed..02/07/04
  OUTPUT FROM SELECT COMMAND FOR THE DRIVES TABLE WILL NOT RETURN
  A DEVICE VALUE IF THE DEVICE_TYPE IS NOT SPECIFIED/REQUESTED.

  Symptom ...... IN INCORROUT         Status ........... CLOSED  UR1
  Severity ................... 4      Date Closed ......... 02/07/04
  Component .......... 5698TSMAX      Duplicate of ........
  Reported Release ......... 420      Fixed Release ............ 999
  Component Name TSM AIX SERVER       Special Notice
  Current Target Date ..              Flags
  SCP ................... AIXRSC
  Platform ............ AIX

  Status Detail: Not Available

  PE PTF List:

  PTF List:
  Release 420   : PTF not available yet


  Parent APAR:
  Child APAR list:


  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.


  PROBLEM CONCLUSION:


  TEMPORARY FIX:


  COMMENTS:


  MODULES/MACROS:   NONE


  SRLS:      NONE


  RTN CODES:


  CIRCUMVENTION:


  MESSAGE TO SUBMITTER:


For IBMLink customer support in the U.S, call 1-800-543-3912.

[ IBM Home | Shop | Contact | Search | Priv

-----Original Message-----
From: David Stabler [mailto:dstabler AT MORRISONHOMES DOT COM]
Sent: Thursday, September 19, 2002 8:26 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: 4.2.x selects from DRIVE table


gotta be a bug....it's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.....  WEIRD.....

-drs-

>>> xjolliff AT TI DOT COM 09/19/02 09:13AM >>>
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'?