ADSM-L

[ADSM-L] TSM v5 SQL help

2010-11-18 10:16:10
Subject: [ADSM-L] TSM v5 SQL help
From: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 18 Nov 2010 10:13:52 -0500
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>