The problem is this is the SQL statement from hell for the server to process
and it will likely never complete even if it was possible.  You have to
create a "NOT IN" subselect table from the BACKUPS table of INACTIVE backups
to verify the ACTIVE files against using all three key fields filespace,
hl_name, and ll_name, which is not possible with TSM.  The NOT IN only
supports one field.

Normal SQL would support an outer join of two subselects of the ACTIVE and
INACTIVE table subsets in a way that this could be done, but TSM does not
support this.

So, what you will have to do is select the information from the backups
table and post process it with a program or script.  This could still take a
long time to get.  If you know MS-Access or have access to a DB2 or Oracle
Database you could load the extraction into there and perform what you want.

Sorry, I do not have a good answer for you.

Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180