Hi Tom,

sorry for answering so late but there have been problems.

The sql-query which should work is the following:

select
contents.file_name,contents.file_size,backups.node_name,backups.class_name
from contents,backups where contents.file_name =
concat(backups.hl_name,backups.ll_name) and backups.node_name='NODENAME'
and backups.class_name='MC'

BUT I RAN INTO SERIOUS PROBLEMS:
The query was tested on a running ADSM-Server - the warning:
ANR2963W This SQL query may produce a very large result table, or may
require a
significant amount of time to compute.

Do you wish to proceed? (Yes/No)

appears and I answered y -

this causes any library operations to hang, backups weren't processed,
storage pool queries hang up.
After 22 hours I had to cancel the session without having a result
(Therefore I'm not quite sure whether
hl_name and ll_name must have a ' ' between to be the appropriate
expression to file_name).

Tests afterwards showed that the sql-query concerning table contents hung
up the actions.


Regards
     Mecki