Query fails and I am not sure why

[rallingham]

Here is the query I am running. IT fails with ANR2004E missing value for keyword parameter -itemcommit
Any one know why?

dsmadmc -tcps=SERVER1 -id=ADMIN -pa=xxxxx -itemcommit -commadelimit
ed -dataonly=yes "Select FS.NODE_NAME, substr(FS.FILESPseleACE_NAME,1,35) as FIL
ESPACE_NAME, cast(sum(FS.CAPACITY*FS.PCT_UTIL/100)/1024/1024 as decimal(9,3)) as
TB from FILESPACES FS where FS.NODE_NAME is not null AND FS.FILESPACE_NAME is n
ot null AND (FS.FILESPACE_NAME like '%.DOMDBS' OR (FS.FILESPACE_TYPE not like 'A
PI:%' AND FS.FILESPACE_TYPE not like 'TDP%' AND FS.FILESPACE_TYPE not like 'VSS'
AND FS.FILESPACE_NAME not in ('DocAve','ADSM.SERVER'))) group by FS.NODE_NAME,
FS.FILESPACE_NAME order by NODE_NAME, FILESPACE_NAME" > C:\BIN\TSM\server1_BA_Dat
a.csv

 

[marclant]

-Itemcommit
Specifies that Tivoli Storage Manager commits commands inside a script or a macro as each command is processed.

source: http://www.ibm.com/support/knowledg...srv.reference/r_cmdline_adclient_options.html

You don't have a macro or a script, so you don't need that option.

 

[rallingham]

Many thanks. I will remove it and see how it runs.

 

[rallingham]

The query continues to fail. Removing the itemcommit is fine but then it fails on the commadelimited. Bummer

 

[marclant]

What's the error?

 

[rallingham]

ANR2004E Missing value for keyword parameter - Select FS.NODE_NAME, substr(FS.FILESPseleACE_NAME,1,35) as FILESPACE_NAME, cast(sum(FS.CAPACITY*FS.PCT_UTIL/100)/1024/1024 as decimal(9,3)) as TB from FILESPACES FS where FS.NODE_NAME is not null AND FS.FILESPACE_NAME is not null AND (FS.FILESPACE_NAME like '%.DOMDBS' OR (FS.FILESPACE_TYPE not like 'API:%' AND FS.FILESPACE_TYPE not like 'TDP%' AND FS.FILESPACE_TYPE not like 'VSS' AND FS.FILESPACE_NAME not in ('DocAve','ADSM.SERVER'))) group by FS.NODE_NAME, FS.FILESPACE_NAME order by NODE_NAME, FILESPACE_NAME.

 

[marclant]

What was the full command you used?

 

[marclant]

Also, sometimes a copy/paste from a rich text editor will cause that. If you are going to copy, make sure the text is valid all on one line in a plain text editor like Notepad, then copy/paste that.
http://www-01.ibm.com/support/docview.wss?uid=swg21450021

 

[rallingham]

I knew that. Just getting old and don't remember much any more.