Re: Generting Commands from a Script

2001-01-25 Thread Thierry ITTY
what i'd do : select the volume names, then for each one call dsmcadm move data command on it step 1 : dsmadmc -id=adminname -pass=adminpass -outfile "select 'EYECATCHER', volume_name from volumes where-condition..." will output something like : eyecatcher VOLUME_NAME -- --

Re: Generting Commands from a Script

2001-01-24 Thread Richard Sims
>My question is how can I generated MOVE DATA commands using the >VOLUME_NAMEs in the results of the above SCRIPT Joe - I don't see a practical way to do that, other than redirecting the output to a file and having a shell script massage it into Move Data commands. In any case, I'd recomme

Re: Generting Commands from a Script

2001-01-24 Thread Thomas A. La Porte
select 'move data ' || volume_name - from volumes - where upper(stgpool_name)='LNTAPECO' - or upper(stgpool_name)='LNTAPENO' - or upper(stgpool_name)='UNTAPECO' - or upper(stgpool_name)='UNTAPENO' - or upper(stgpool_name)='NTTAPECO' - or upper(stgpool_name)='NTTAPENO' and pct_ut

Generting Commands from a Script

2001-01-24 Thread Joseph Marchesani
Group I have created a script name VOLUME_PCT with the following results: ANR1461I RUN: Executing command script VOLUME_PCT. ANR1466I RUN: Command script VOLUME_PCT, Line 5 : select volume_name, stgpool_name,pct_utilized from volumes where upper(stgpool_name)='LNTAPECO' and pct_utilized <50 or