If you look up message ANR2948E, it will tell you what the trouble is. You
can either look it up in the Messages manual, or type "HELP ANR2948E" (or
just "HELP 2948") from the Admin CLI.
Regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-03-07
07:24:28:
> Richard,
> Sorry.
> The error msg was:
>
> tsm: ABZBKUP001>SELECT STGPOOL_NAME AS " STORAGE POOL ",
> CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PC
> T UTIL", DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY", CHAR(ACCESS,11) AS
> "ACCESS", LEFT(CHAR(LAST_WRITE_DATE),19)
> AS "LAST_WRITE_DATE" FROM VOLUMES WHERESTATUS='FILLING' ORDER BY
> STGPOOL_NAME
> ANR2907E Unexpected SQL operator token - '='.
>
> |
> ...............................V...............................
> _DATE" FROM VOLUMES WHERESTATUS='FILLING' ORDER BY STGPOOL_NAME
>
> ANS8001I Return code 3.
>
>
> And right enough, I'd entered it as one line. I tried again with the
> continuation characters and it errored out, then I tried chaning the
> est_capacity to 7 as suggested, but got the same error:
>
> SELECT STGPOOL_NAME AS " STORAGE POOL ", -
> cont> CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL", -
> cont> DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY", CHAR(ACCESS,11) AS
> "ACCESS", -
> cont> LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE " -
> cont> FROM VOLUMES WHERE STATUS='FILLING' ORDER BY STGPOOL_NAME
> ANR2948E The value '381468.0' can not be assigned or converted to SQL
> data type DECIMAL(6,1).
>
> |
> ........................V......................................
> ED as "PCT UTIL", DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY", CH
>
> ANS8001I Return code 26.
>
> tsm: ABZBKUP001>SELECT STGPOOL_NAME AS " STORAGE POOL ",
> -
> cont> CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL", -
> cont> DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CHAR(ACCESS,11) AS
> "ACCESS", -
> cont> LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE " -
> cont> FROM VOLUMES WHERE STATUS='FILLING' ORDER BY STGPOOL_NAME
> ANR2948E The value '4096000.0' can not be assigned or converted to SQL
> data type DECIMAL(7,1).
>
> |
> ........................V......................................
> ED as "PCT UTIL", DEC(EST_CAPACITY_MB,7) AS "MB_CAPACITY", CH
>
> ANS8001I Return code 26.
>
>
>
>
>
> Regards,
>
> Iain Barnetson
> IT Systems Administrator
> UKN Infrastructure Operations
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> Richard Sims
> Sent: 07 March 2005 12:54
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] LTO Volume
>
> On Mar 7, 2005, at 6:25 AM, Iain Barnetson wrote:
>
> > Ruichard,
> > I tried the SQL query below that you gave, but got an error "where
> > status='filling'" at the '=' bit
>
> And the error was... ?
>
> The Select is tried-and-true, and works well.
> Perhaps you tried to string the whole command out on one line, rather
> than using continuation characters so that the length of each physical
> line was less than the 256 char maximum?
>
> Below is the Select in its original macro form, which includes
> continuation chars. (I wish I could send it as an attachment, to assure
> format preservation, but the ADSM-L listserver is configured to reject
> such attachments.)
>
> Richard
>
> /* ADSM macro 'filling'
> */
> /*
> */
> /* To display volumes in Filling state.
> */
> /*
> */
> /* INVOCATION: macro filling
> */
> /*
> */
> /* NOTES: -
> */
> /*
> */
> /* HISTORY:
> */
> /*
> */
> /* 2003/05/06 Written by Richard Sims
> */
> /*
> */
> SELECT STGPOOL_NAME AS " STORAGE POOL ", -
> CHAR(VOLUME_NAME,6) AS "VOLNAME", PCT_UTILIZED as "PCT UTIL", -
> DEC(EST_CAPACITY_MB,6) AS "MB_CAPACITY", CHAR(ACCESS,11) AS "ACCESS",
> -
> LEFT(CHAR(LAST_WRITE_DATE),19) AS "LAST_WRITE_DATE " -
> FROM VOLUMES WHERE STATUS='FILLING' ORDER BY STGPOOL_NAME
|
