From derby-user-return-8167-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Dec 05 07:07:14 2007 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 47045 invoked from network); 5 Dec 2007 07:07:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Dec 2007 07:07:14 -0000 Received: (qmail 59387 invoked by uid 500); 5 Dec 2007 07:07:01 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 59357 invoked by uid 500); 5 Dec 2007 07:07:01 -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 45186 invoked by uid 99); 5 Dec 2007 06:47:09 -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 (nike.apache.org: local policy) From: Suman N To: "derby-user@db.apache.org" Date: Wed, 5 Dec 2007 06:46:41 +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+UVelTaKyFoHjjP679Q== Message-ID: <86E8DA9E18BC2344BD0218BF23C88DF35ECA832F1C@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_86E8DA9E18BC2344BD0218BF23C88DF35ECA832F1CMAIL06curamso_" MIME-Version: 1.0 X-OriginalArrivalTime: 05 Dec 2007 06:46:46.0118 (UTC) FILETIME=[9A7D9060:01C8370A] X-Virus-Checked: Checked by ClamAV on apache.org --_000_86E8DA9E18BC2344BD0218BF23C88DF35ECA832F1CMAIL06curamso_ 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. 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 Curam_L to user with grant opt= ion 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. --_000_86E8DA9E18BC2344BD0218BF23C88DF35ECA832F1CMAIL06curamso_ 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 Derby.

 

 

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 Curam_L to user <user_name> wi= th grant 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.
--_000_86E8DA9E18BC2344BD0218BF23C88DF35ECA832F1CMAIL06curamso_--