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