If you are just needing to know if reclamation is running, you might just
look at the adsm.processes table...

tsm: TSMSRV02>select * from processes

    PROCESS_NUM: 2193
        PROCESS: Space Reclamation
     START_TIME: 2002-12-19 07:31:00.000000
FILES_PROCESSED: 5831
BYTES_PROCESSED: 4798075822
         STATUS: Volume AAD615 (storage pool 3590P1), Moved Files: 6098,
Moved
                  Bytes: 4,798,478,585, Unreadable Files: 0, Unreadable
Bytes:
                  0. Current Physical File (bytes): None

                  Current input volume: AAD615.

                  Current output volume: AAE514.




Dwight


-----Original Message-----
From: Christian Sandfeld [mailto:csa AT FERROSAN DOT COM]
Sent: Thursday, December 19, 2002 6:34 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SELECT statement to determine if any drives available


Hi list,

Does anybody know of a SELECT statement that will show if any drives are
available for use (not in use by another process or session)?

I need this for scripting purposes as I have only two drives in my library,
and while doing reclamation both drives are in use.


Kind regards,

Christian