[ADSM-L] TSM v5 SQL help
2010-11-18 10:16:10
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] TSM v5 SQL help,
David E Ehresman <=
|
|
|