Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2255818572 for ; Thu, 17 Dec 2015 14:41:09 +0000 (UTC) Received: (qmail 22730 invoked by uid 500); 17 Dec 2015 14:41:09 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 22702 invoked by uid 500); 17 Dec 2015 14:41:08 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 22692 invoked by uid 99); 17 Dec 2015 14:41:08 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Dec 2015 14:41:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 3F798C8405 for ; Thu, 17 Dec 2015 14:41:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.991 X-Spam-Level: ** X-Spam-Status: No, score=2.991 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, T_KAM_HTML_FONT_INVALID=0.01, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id sggh6HPEh2ok for ; Thu, 17 Dec 2015 14:40:57 +0000 (UTC) Received: from eu-smtp-delivery-106.mimecast.com (eu-smtp-delivery-106.mimecast.com [207.82.80.106]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 93CFE42A43 for ; Thu, 17 Dec 2015 14:40:57 +0000 (UTC) Received: from na01-bn1-obe.outbound.protection.outlook.com (mail-bn1blp0188.outbound.protection.outlook.com [207.46.163.188]) (Using TLS) by eu-smtp-1.mimecast.com with ESMTP id uk-mta-10-WsMZFFv2T2-Ao_5hRr6BtQ-1; Thu, 17 Dec 2015 14:40:45 +0000 Received: from SN1PR0601MB1614.namprd06.prod.outlook.com (10.163.202.28) by SN1PR0601MB1615.namprd06.prod.outlook.com (10.163.202.29) with Microsoft SMTP Server (TLS) id 15.1.355.16; Thu, 17 Dec 2015 14:40:42 +0000 Received: from SN1PR0601MB1614.namprd06.prod.outlook.com ([10.163.202.28]) by SN1PR0601MB1614.namprd06.prod.outlook.com ([10.163.202.28]) with mapi id 15.01.0355.012; Thu, 17 Dec 2015 14:40:42 +0000 From: Anjana Prakash To: Rick Hillegas CC: "derby-dev@db.apache.org" Subject: RE: freeze database during export Thread-Topic: freeze database during export Thread-Index: AdE4LJAlu98W/X4MT52FUnqPldoifQARK5EAAAN8khAAFSmfgAABPdOQ Date: Thu, 17 Dec 2015 14:40:42 +0000 Message-ID: References: <56721B80.6070200@gmail.com> <5672C0EB.7080608@gmail.com> In-Reply-To: <5672C0EB.7080608@gmail.com> Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [122.167.151.183] x-microsoft-exchange-diagnostics: 1;SN1PR0601MB1615;5:2smqoqBBxZoxgKEEdXVIh0VsU/TlzW/6Np7eNxOIIFt24b8+nQTQUKmPUnNN3W3hSNk58dqSvGx5038bkNPiDxgkLgKC4mV2+d43BjurvFqNra1+9fwex7ED70H/kbfYk86tu/8h9G2snjPpAymbVQ==;24:f9Bs6mlFtt6aXb1S1YUSa0vmTMfSIZDmKpQQbaPcZB9e73RQPEVyFhZc7usvx5I0jaufxcQBTIhiLiVqsfdnkCcQhHerdhMAQjxevzhvL2g=;20:UwNnjRdvw7DLyTJcR7XAjx4eJ6o3AZlEPdHgQotERzETXdrtsAbo8d3u58K3pdJO/lEFHDDo55i0WlqUMWGhVPBc7xY792VKGQnxzaYW8d81p6+1wPsxlfJNQ/S9IHUhn81FazdrQ+ATRLx4MKGOuFZmUI4ybjIH3bq1/+EU1P8= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:SN1PR0601MB1615; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(56277945015701); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(2401047)(520078)(5005006)(8121501046)(3002001)(10201501046);SRVR:SN1PR0601MB1615;BCL:0;PCL:0;RULEID:;SRVR:SN1PR0601MB1615; x-forefront-prvs: 07935ACF08 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(377454003)(164054003)(199003)(24454002)(129404003)(479174004)(189002)(5008740100001)(81156007)(101416001)(11100500001)(33656002)(5002640100001)(99286002)(5003600100002)(92566002)(76576001)(189998001)(50986999)(122556002)(97736004)(66066001)(105586002)(5004730100002)(2900100001)(106356001)(5001960100002)(2950100001)(15975445007)(40100003)(76176999)(77096005)(19625215002)(1096002)(93886004)(19580405001)(1220700001)(19300405004)(74316001)(54356999)(110136002)(16236675004)(3846002)(586003)(6116002)(87936001)(790700001)(102836003)(10400500002)(86362001)(19580395003);DIR:OUT;SFP:1102;SCL:1;SRVR:SN1PR0601MB1615;H:SN1PR0601MB1614.namprd06.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM MIME-Version: 1.0 X-OriginatorOrg: actian.com X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Dec 2015 14:40:42.8967 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 20057ce9-1386-4770-8b04-e7824ef632be X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1PR0601MB1615 X-MC-Unique: WsMZFFv2T2-Ao_5hRr6BtQ-1 Content-Type: multipart/alternative; boundary="_000_SN1PR0601MB1614F319F0FCD583D6ADD11EF2E00SN1PR0601MB1614_" --_000_SN1PR0601MB1614F319F0FCD583D6ADD11EF2E00SN1PR0601MB1614_ Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Hi Rick, Thanks for follow-up will do as directed. Thanks, Anjana. From: Rick Hillegas [mailto:rick.hillegas@gmail.com] Sent: Thursday, December 17, 2015 7:34 PM To: Anjana Prakash Cc: derby-dev@db.apache.org Subject: Re: freeze database during export On 12/16/15 8:01 PM, Anjana Prakash wrote: Hi Rick, Thanks for follow-up. I found the issue. The export block was raising excep= tion due to incorrect table name. In that exception had missed to call unfr= eeze Hence db never came out of freeze mode. On that note Is there way to detect if db is in freeze mode? Thanks, Anjana. I don't know of any way to get this information through the public api. You= can file an enhancement request for this feature. Thanks, -Rick From: Rick Hillegas [mailto:rick.hillegas@gmail.com] Sent: Thursday, December 17, 2015 7:49 AM To: derby-dev@db.apache.org Cc: Anjana Prakash Subject: Re: freeze database during export On 12/16/15 10:18 AM, Anjana Prakash wrote: Hi, Can derby system procedure SYSCS_FREEZE_DATABASE use before SYSCS_EXPORT_T= ABLE and then SYSCS_UNFREEZE_DATABASE After export table. Will there be any impacts. Appreciate help on same. Thanks, Anjana The following script runs fine for me. Have you encountered a problem with = this approach? connect 'jdbc:derby:memory:db;create=3Dtrue'; create table t1( a int primary key ); insert into t1 values ( 1 ); call syscs_util.syscs_freeze_database(); -- succeeds call syscs_util.syscs_export_table ( 'APP', 'T1', 't1.dat', null, null, nul= l ); -- this would hang if we attempted it -- insert into t1 values ( 2 ); call syscs_util.syscs_unfreeze_database(); -- succeeds now insert into t1 values ( 2 ); Hope this helps, -Rick --_000_SN1PR0601MB1614F319F0FCD583D6ADD11EF2E00SN1PR0601MB1614_ Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable

Hi Rick,

 

Thanks for follow-up w= ill do as directed.

 

Thanks,

Anjana.

 

From: Rick Hillegas [mailto:rick.hille= gas@gmail.com]
Sent: Thursday, December 17, 2015 7:34 PM
To: Anjana Prakash <anjana.prakash@actian.com>
Cc: derby-dev@db.apache.org
Subject: Re: freeze database during export

 

On 12/16/15 8:01 PM, Anjana Prakash wrote:

Hi Rick, <= /o:p>

 

Thanks for follow-up. = I found the issue. The export block was raising exception due to incorrect = table name. In that exception had missed to call unfreeze=

Hence db never came ou= t of freeze mode.

 

On that note Is there = way to detect if db is in freeze mode?

 

Thanks,

Anjana.

I don't know of any w= ay to get this information through the public api. You can file an enhancem= ent request for this feature.

Thanks,
-Rick

 

F= rom: Rick Hilleg= as [mailto:rick.hillegas@gmail.c= om]
Sent: Thursday, December 17, 2015 7:49 AM
To: derby-dev@db.apache.o= rg
Cc: Anjana Prakash <= anjana.prakash@actian.com>
Subject: Re: freeze database during export

 

On 12/16/15 10:18 AM, Anjana Prakash wrote:

Hi,

 

Can derby system procedure SYSCS_FREEZE_DATABASE use= before  SYSCS_EXPORT_TABLE and then SYSCS_UNFREEZE_DATABASE

After export table.

 

Will there be any impacts.

 

Appreciate help on same.

 

Thanks,

Anjana

The follo= wing script runs fine for me. Have you encountered a problem with this appr= oach?

connect 'jdbc:derby:memory:db;create=3Dtrue';

create table t1( a int primary key );
insert into t1 values ( 1 );

call syscs_util.syscs_freeze_database();

-- succeeds
call syscs_util.syscs_export_table ( 'APP', 'T1', 't1.dat', null, null, nul= l );

-- this would hang if we attempted it
-- insert into t1 values ( 2 );

call syscs_util.syscs_unfreeze_database();

-- succeeds now
insert into t1 values ( 2 );

Hope this helps,
-Rick

 

--_000_SN1PR0601MB1614F319F0FCD583D6ADD11EF2E00SN1PR0601MB1614_--