db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: SYSIBM schema
Date Fri, 24 Apr 2009 15:43:43 GMT
Kathey Marsden wrote:
> Rick Hillegas wrote:
>> Can someone shed some light on the purpose of the SYSIBM schema? It 
>> appears to hold a table called "SYSDUMMY1". What is this table used for?
>>
> The SYSIBM schema is used for the network server metadata queries.  I 
> see SYSDUMMY1 referenced in org.apache.derby.client.am.DatabaseMetaData.
>
Thanks Kathey. In the metadata queries it seems to be used to construct 
empty results sets of specific shapes. That is, its contents are not 
examined. Those usages could be replaced with a vacuous vti.

Thanks,
-Rick

Mime
View raw message