db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Migrating from DB2 to Derby. Need similar/equivalent commands in Derby
Date Thu, 06 Dec 2007 10:00:53 GMT
Suman N <Suman.V@curamsoftware.com> writes:

> Hi,
>
> I am currently working with DB2 database and wish to migrate to Derby-10.3.1.4.
> I have certain performance parameters to be tuned and tablespaces created to work with
huge volume of data.
> I am finding difficulty in finding the equivalent commands or properties to be set in
derby.properties files.
> I have listed down all the post installation steps I do in DB2. Can anyone identify the
equivalent command to be executed in ij command console, or properties to be set in derby.properties
file?
> Please let me know equivalent derby commands/properties for all of these listed below
if they are available in Derby.
>
> Even if I could get alternatives in Derby for some of these would be greatly useful.
> Is it possible to create a BUFFERPOOL and TABLESPACE in Derby?
>
> Performance tuning parameters
>
>
>  *   LOCKTIMEOUT to be 30 seconds.

You can set the lock timeout with the derby.locks.waitTimeout property.
http://db.apache.org/derby/docs/dev/tuning/rtunproper46141.html

-- 
Knut Anders

Mime
View raw message