db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Any mapping from cxyz.dat to Entities ?
Date Wed, 02 Sep 2009 02:51:50 GMT
> 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