Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 26864 invoked from network); 20 Aug 2007 19:46:01 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Aug 2007 19:46:01 -0000 Received: (qmail 55929 invoked by uid 500); 20 Aug 2007 19:45:58 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 55599 invoked by uid 500); 20 Aug 2007 19:45:58 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 55588 invoked by uid 99); 20 Aug 2007 19:45:58 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Aug 2007 12:45:58 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [63.82.107.6] (HELO red.amberpoint.com) (63.82.107.6) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Aug 2007 19:45:55 +0000 Received: from [127.0.0.1] (bpendleton-dsk2.edgility.com [10.10.11.13]) by red.amberpoint.com (8.14.0/8.12.11) with ESMTP id l7KJjXJW004401 for ; Mon, 20 Aug 2007 12:45:33 -0700 (PDT) Message-ID: <46C9EF5C.6050609@amberpoint.com> Date: Mon, 20 Aug 2007 12:45:32 -0700 From: Bryan Pendleton User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Derby Discussion Subject: Re: Create Copy of Database with the necessary files References: <8e9490260708201146s7a15c68j56e8dbd777955fc1@mail.gmail.com> In-Reply-To: <8e9490260708201146s7a15c68j56e8dbd777955fc1@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org > 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