Thank you rBatte1,
I tried this so far

db2 -x "select substr(TBSPACE,1,20) TABLESPACE from syscat.tables where tabschema = 'SCHEMA' and tabname like '%XXXX' group by TBSPACE order by TBSPACE" | awk '{print $1}' | while read tablespace
do
db2 "list tablespaces show detail" |grep -p -w $tablespace |egrep "Name|Total pages|Free pages|Page size" |awk '{print $1 " " $2 " " $3 " " $4 " " $5}' | while read a b c d e
do
done
done


and the output is this:
Code:
Name = TSADOR Total pages = 14991360 Free pages = 5345152 Page size (bytes) = 32768 Name = TSHISTNEW Total pages = 4186112 Free pages = 1276544 Page size (bytes) = 32768 Name = TSHISTTI Total pages = 6279168 Free pages = 1991168 Page size (bytes) = 32768
The output desired is this:
Tableaspace Total Pages Free Pages Page Zise
TSADOR 14991360 5345152 32768
TSHISTNEW 4186112 1276544 32768
TSHISTTI 6279168 1991168 32768
T O T A L ------------- ------------
25456640 8612864

if you can give me a script so be it.