You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by bruehlicke <br...@gmail.com> on 2009/09/02 04:33:42 UTC

Any mapping from cxyz.dat to Entities ?

Havn't been down in the details for a while but my Derby Db has 4 .dat
files of sizes between 100 to 200 MB.  I now wonder what those are ?

Anyway to figure out which object (Table/row?) is holding this space ?

B-)

Re: Any mapping from cxyz.dat to Entities ?

Posted by bruehlicke <br...@gmail.com>.

BRILLIANT !!!

Thanx a lot.

B-)

On Tue, Sep 1, 2009 at 9:51 PM, Bryan
Pendleton<bp...@amberpoint.com> 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
>       from sys.systables t,sys.sysconglomerates c
>       where t.tableid = c.tableid
>         and c.conglomeratenumber=DDD;
>
> 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 2448
> in decimal, so you can run
>
> select t.tablename, c.conglomeratenumber
>       from sys.systables t,sys.sysconglomerates c
>       where t.tableid = c.tableid
>         and c.conglomeratenumber=2448;
>
> thanks,
>
> bryan
>
>

Re: Any mapping from cxyz.dat to Entities ?

Posted by Bryan Pendleton <bp...@amberpoint.com>.

> 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
        from sys.systables t,sys.sysconglomerates c
        where t.tableid = c.tableid
          and c.conglomeratenumber=DDD;

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 2448
in decimal, so you can run

select t.tablename, c.conglomeratenumber
        from sys.systables t,sys.sysconglomerates c
        where t.tableid = c.tableid
          and c.conglomeratenumber=2448;

thanks,

bryan