Hi Bryan,

thank you, I was hoping for an easier way but I will try your suggestion.

Thank you again.

Best regards, Lars

2007/8/20, Bryan Pendleton < bpendleton@amberpoint.com>:
> always the same. Now I want to identify the files which are still used

In the database folder, each file corresponds to a "conglomerate". Each user table,
system table, and each index on a table is a conglomerate. You can
figure out how conglomerates map to underlying operating system files
by using the information in SYSCONGLOMERATES:

http://db.apache.org/derby/docs/dev/ref/rrefsistabs39391.html

Here's how to use that to find the file info:
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury/#cs_map_filename

thanks,

bryan