db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bruehlicke <bruehli...@gmail.com>
Subject Re: Any mapping from cxyz.dat to Entities ?
Date Wed, 02 Sep 2009 02:57:53 GMT
BRILLIANT !!!

Thanx a lot.

B-)

On Tue, Sep 1, 2009 at 9:51 PM, Bryan
Pendleton<bpendleton@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
>
>

Mime
View raw message