Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 43491 invoked from network); 5 Dec 2007 18:03:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Dec 2007 18:03:28 -0000 Received: (qmail 75666 invoked by uid 500); 5 Dec 2007 18:03:16 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 75211 invoked by uid 500); 5 Dec 2007 18:03:15 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Delivered-To: moderator for derby-user@db.apache.org Received: (qmail 52774 invoked by uid 99); 5 Dec 2007 12:26:34 -0000 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) From: Suman N To: "derby-user@db.apache.org" Date: Wed, 5 Dec 2007 12:26:06 +0000 Subject: Migrating from DB2 to Derby. Need similar/equivalent commands in Derby Thread-Topic: Migrating from DB2 to Derby. Need similar/equivalent commands in Derby Thread-Index: Acg3Cpf/OX6+UVelTaKyFoHjjP679QAJushQAAINCHA= Message-ID: <86E8DA9E18BC2344BD0218BF23C88DF35ECA8330A7@MAIL06.curamsoftware.com> Accept-Language: en-US, en-IE Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US, en-IE Content-Type: multipart/alternative; boundary="_000_86E8DA9E18BC2344BD0218BF23C88DF35ECA8330A7MAIL06curamso_" MIME-Version: 1.0 X-OriginalArrivalTime: 05 Dec 2007 12:26:12.0579 (UTC) FILETIME=[05D8E330:01C8373A] X-Virus-Checked: Checked by ClamAV on apache.org --_000_86E8DA9E18BC2344BD0218BF23C88DF35ECA8330A7MAIL06curamso_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 t= o 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 pr= operties to be set in derby.properties file? Please let me know equivalent derby commands/properties for all of these li= sted below if they are available in Derby. Even if I could get alternatives in Derby for some of these would be greatl= y useful. Is it possible to create a BUFFERPOOL and TABLESPACE in Derby? Performance tuning parameters * LOCKTIMEOUT to be 30 seconds. * Update the APPLHEAPSZ - Application Heap Size to be 1024. * Update the DBHEAP - Database Heap to be 600 * Set the AUTORESTART - Auto Restart to be On After configuring the database I create the Bufferpool and tablespaces requ= ired * db2 CREATE BUFFERPOOL highmem SIZE 50 PAGESIZE 32K * db2 connect reset * db2 create tablespace Table_space_L PAGESIZE 32K MANAGED BY SYSTEM usi= ng ('') BUFFERPOOL highmem * db2 create temporary tablespace Table_space_T PAGESIZE 32K MANAGED BY = SYSTEM using ('') BUFFERPOOL Highmem * db2 connect reset * db2 grant use of tablespace Table_space_L to user with gra= nt option Thanks, Suman The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail. Thank you. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail. Thank you. --_000_86E8DA9E18BC2344BD0218BF23C88DF35ECA8330A7MAIL06curamso_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I am currently working with DB2 database and wish to mig= rate 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 comman= ds 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 <= st1:City w:st=3D"on">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?<= /span>

 

Performance tuning parameters

 

  • LOCKTIMEOUT to be 30 seconds.
  • Upd= ate the APPLHEAPSZ - Applic= ation Heap Size to be 1024.
  • Upd= ate the DBHEAP - Database Heap  to be = 600
  • Set= the AUTORESTART - Auto = Restart to be On<= /font>

 =

After configuring= the database I create the Bufferpool and tablespaces required

 =

  • db2 CREATE BUFFERPOOL highmem SIZE 50 PAGESIZE 32K

=  

  • db2 connect reset

=  

  • db2 create tablespace Table_space_L PAGESIZE 32K MANAGED BY SYST= EM using (’<dir_name_A>’) BUFFERPOOL highmem=

=  

  • db2 create temporary tablespace Table_space_T PAGESIZE 32K MANAG= ED BY SYSTEM using (’<dir_name_B>’) BUFFERPOOL Highmem<= o:p>

=  

  • db2 connect reset

 =

  • db2 grant use of tablespace Table_space_L to user <user_name&= gt; with grant option

 

Thanks,

Suman=

 

<=
o:p> 
 <=
/o:p>
The informat=
ion in this email is confidential and may be legally privileged.=

It is intend=
ed solely for the addressee. Access to this email by anyone else=

is unauthori=
zed. If you are not the intended recipient, any disclosure,
copying, dis=
tribution or any action taken or omitted to be taken in reliance=

on it, is pr=
ohibited and may be unlawful. If you are not the intended=

addressee pl=
ease contact the sender and dispose of this e-mail. Thank you.

The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful. If you are not the intended
addressee please contact the sender and dispose of this e-mail. Thank you.
--_000_86E8DA9E18BC2344BD0218BF23C88DF35ECA8330A7MAIL06curamso_--