There is an efix available for this. You need to get a PMR opened and escalated. They told me 5.5.5.1 isn't due until mid/late Q1
Regards, Shawn ________________________________________________ Shawn Drew Internet [email protected] Sent by: [email protected] 11/18/2010 10:13 AM Please respond to [email protected] To ADSM-L cc 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 This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc.
