help with parsing query in unix

[cougartrace]

I have this DB2 UDB query:

db2 -x "select tsname,pct_free from db2admin.ts_free_space where size_meg > 1 and type = 'DMS' and pct_free <= 97" > show.lst

Can someone help me with the unix scripting to parse out the tablespace name and pct free and send a page for each tablespacename?

 

[KarveR]

what do you mean send a page ?


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.