http://www-01.ibm.com/support/docview.wss?uid=swg1PM24818
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Prather, Wanda Sent: Thursday, November 18, 2010 10:19 AM To: [email protected] Subject: Re: [ADSM-L] TSM v5 SQL help -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of David E Ehresman Sent: Thursday, November 18, 2010 10:14 AM To: [email protected] Subject: [ADSM-L] TSM v5 SQL help The following script worked at TSM v5.5.3.0: Q_OFFLINE 1 select cast(drives.library_name as char(6)) as "LIB", - 5 cast(drives.drive_name as char(10)) as "DRIVE", - 10 cast(source_name as char(15)) as "PATH", - 15 cast(drives.online as char(5)) as "DRIVE ONLINE?", - 20 cast(paths.online as char(5)) as "PATH ONLINE?" - 25 from drives,paths where - 30 drives.library_name=paths.library_name and - 35 drives.drive_name=paths.destination_name - 40 and (paths.online='NO' or drives.online='NO') At TSM v5.5.5.0 it produces the following error: tsm: LIBMGR>run q_offline ANR2914E SQL identifier token 'DRIVES.LIBRARY_NAME' is too long; name or component exceeds 18 characters. | ............V.................................................. select cast(drives.library_name as char(6)) as "LIB", cast(driv ANR1463E RUN: Command script Q_OFFLINE completed in error. ANS8001I Return code 3. Any idea on how to fix this? David
