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:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 8:26 AM To: [EMAIL PROTECTED] 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- >>> [EMAIL PROTECTED] 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'?
