I'm having a problem executing a query. Here is the query I'm executing as
the root user on the TSM server machine:

dsmadmc -id=admin -pa=**** -commadelimited "select a.volume_name,
a.filespace_n
ame, b.access from volumeusage a, volumes b where
a.volume_name=b.volume_name or
der by b.access, a.volume_name"  >> audit_info_050824.out

The Admin Guide said to make sure there is at least 4M of temporary space
by looking at the Maximum Reduction file after issuing the "q db" command.
Here is the result of that query:

Available Assigned   Maximum   Maximum    Page     Total      Used   Pct
Max.
    Space Capacity Extension Reduction    Size    Usable     Pages  Util
Pct
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages Util
--------- -------- --------- --------- ------- --------- --------- -----
-----
   59,692   59,692         0     6,372   4,096 15,281,15 8,011,456  52.4
52.4
                                                       2

Once I start my query, the Maximum Reduction field immediately goes to
"0".  Does anyone else execute queries like this?

 I'm trying to get some information for auditors which includes a list of
onsite and offsite tapes, as well as their contents. Any advice or
suggestions would be appreciated.

Our TSM server level is 5.1


Thanks,
Debbie