db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: freeze database during export
Date Thu, 17 Dec 2015 02:18:40 GMT
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 following script runs fine for me. Have you encountered a problem 
with this approach?

connect 'jdbc:derby:memory:db;create=true';

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, 
null );

-- 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


Mime
View raw message