Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 6922 invoked from network); 2 Sep 2009 02:58:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Sep 2009 02:58:24 -0000 Received: (qmail 64910 invoked by uid 500); 2 Sep 2009 02:58:23 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 64834 invoked by uid 500); 2 Sep 2009 02:58:23 -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 64822 invoked by uid 99); 2 Sep 2009 02:58:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Sep 2009 02:58:23 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of bruehlicke@gmail.com designates 209.85.220.205 as permitted sender) Received: from [209.85.220.205] (HELO mail-fx0-f205.google.com) (209.85.220.205) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Sep 2009 02:58:14 +0000 Received: by fxm1 with SMTP id 1so546436fxm.7 for ; Tue, 01 Sep 2009 19:57:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=qAUFrze25w3Oj/jJiTU+sBgbzhNnm37nKSBgKFuEm0k=; b=I+DbKr3j9Kf6mPvqI9+w69ZSP9ZVN2fgxcNoomjZqSAVTYCX2O/2v+TPls07fOKsOg 8zbajMuVNS+mjyzRwSGi+y/u2reHE1uIMGJhEIEtP7yxiEOf4OjH5nSW3noPCv82Qrzp 8fT5LogV1p8jOjIqEKaTHfqv4gumvKJ135KBk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=ceEC1DzJ4WP1ap3q1ZxnGh2nlz3gdvS0Kiku2Akkg1Cku7bSfaUG9XMrJ7KpEpgoDD j33cccwuomYO/eQQ9/iHze3c6Gb7bvy73n6eQ3P3t28yLhyzoWqLU5RNwsfJgXsP9/mo xpZWzQEg4ZtquQwj5oIGQMdAIts3hXCNW/4pc= MIME-Version: 1.0 Received: by 10.204.154.213 with SMTP id p21mr6197620bkw.163.1251860273910; Tue, 01 Sep 2009 19:57:53 -0700 (PDT) In-Reply-To: <4A9DDDC6.3040802@amberpoint.com> References: <6ac05c90909011933u2d52c778sf458d545d2fccadb@mail.gmail.com> <4A9DDDC6.3040802@amberpoint.com> Date: Tue, 1 Sep 2009 21:57:53 -0500 Message-ID: <6ac05c90909011957n4de79ac5if998f2845f9ad126@mail.gmail.com> Subject: Re: Any mapping from cxyz.dat to Entities ? From: bruehlicke To: Derby Discussion Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org BRILLIANT !!! Thanx a lot. B-) On Tue, Sep 1, 2009 at 9:51 PM, Bryan Pendleton wrote: >> Anyway to figure out which object (Table/row?) is holding this space ? > > For a file named cNNN.dat, the NNN is in hex. Convert it to decimal DDD, > and plug it into this query: > > select t.tablename, c.conglomeratenumber > =A0 =A0 =A0 from sys.systables t,sys.sysconglomerates c > =A0 =A0 =A0 where t.tableid =3D c.tableid > =A0 =A0 =A0 =A0 and c.conglomeratenumber=3DDDD; > > Or just skip the second 'and' clause and convert the conglomeratenumber > to hex and look for a matching cNNN.dat. > > So, for example, if you're interested in C990.DAT, since 990 in hex is 24= 48 > in decimal, so you can run > > select t.tablename, c.conglomeratenumber > =A0 =A0 =A0 from sys.systables t,sys.sysconglomerates c > =A0 =A0 =A0 where t.tableid =3D c.tableid > =A0 =A0 =A0 =A0 and c.conglomeratenumber=3D2448; > > thanks, > > bryan > >