Hi Zoltan,
Why don't you run the tso batch interface - seeing that your current way
does not work as you've indicated.
The sample JCL I sent you uses IKJEFT01 utility which gives you a
batch interface into TSO - which in turn gives you an interface into the
admin client - as far as I can make out this is what you want to achieve.
Seeing that the + works in batch why not go for it - you have nothing to
loose.
Cheers
Christo
> Thanks for the many answers about using "+". However, it doesn't work.
>
> I guess I didn't make my self clear. I am running ADSM in batch, not
> "TSO in BATCH" !!
>
> The only reason the "+" works is because it is TSO in BATCH ! Here is
> what I am trying to do:
>
> file://STEP1 EXEC PGM=DSMADMC,PARM='-ID=BATCHADM -PASSWORD=BATCHADM'
> file://STEPLIB DD DSN=TIVOLI.SANRLOAD,DISP=SHR
> file://DSCLANG DD DSN=TIVOLI.SANSMSG(ANSMENU),DISP=SHR
> file://DSCOPT DD DSN=TIVOLI.BATCH.OPTIONS(DSMOPT),DISP=SHR
> file://SYSPRINT DD SYSOUT=*
> file://SYSIN DD *
> select volume_name,stgpool_name,pct_utilized from volumes where
> pct_utilized<40 order by pct_utilized > forray.volutil
> /*
>
> I have tried "-", "+" and even "/" as was suggested by a co-worker ! Still
> nothing. I get:
>
> adsm> ANR2907E Unexpected SQL operator token - '/'.
> |
> ..............................................................V
> lect volume_name,stgpool_name,pct_utilized from volumes where /
>
> ANS8001I Return code 3.
>
> Note, this works for almost everything else TSM allows as a command.
>
>
>
>
>
> Luuk Kleibrink <[EMAIL PROTECTED]>
> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
> 07/13/2001 02:46 AM
> Please respond to "ADSM: Dist Stor Manager"
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: Re: SQL on OS390
>
>
> Zoltan,
>
> This works (NOTE: don't put spaces around the comma's, this might be your
> problem):
>
> file://TSO1 EXEC PGM=IKJEFT01
> file://SYSPRINT DD SYSOUT=X
> file://SYSTSPRT DD SYSOUT=X
> file://SYSTERM DD SYSOUT=X
> file://SYSOUT DD SYSOUT=X
> file://SYSTCPD DD DSN=SYS1.TCPPARMS(TCPDATA),DISP=SHR
> file://DSCOPT DD DSN=SYP.TSM.TSOADMIN.OPTIONS,DISP=SHR
> file://DSCLANG DD DSN=SYS2.TSM.SANSMSG(ANSMENU),DISP=SHR
> file://SYSTSIN DD *
> DSMADMC -ID=id -PA=password -OUT='OS390 data set name' +
> SELECT STGPOOL_NAME,SUM(NUM_FILES) AS FILES, +
> SUM(LOGICAL_MB) AS MB,NODE_NAME FROM OCCUPANCY +
> GROUP BY STGPOOL_NAME,NODE_NAME ORDER BY NODE_NAME,STGPOOL_NAME
>
> Luuk Kleibrink
> Delta Lloyd Nuts Ohra
