ADSM-L

Re: [ADSM-L] TSM v5 SQL help

2010-11-18 10:19:55
Subject: Re: [ADSM-L] TSM v5 SQL help
From: "Prather, Wanda" <wPrather AT ICFI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 18 Nov 2010 15:18:45 +0000
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
David E Ehresman
Sent: Thursday, November 18, 2010 10:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
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

<Prev in Thread] Current Thread [Next in Thread>