Suman N <[EMAIL PROTECTED]> 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
