dbschema when the table is locked.
This is a multi-part message in MIME format.
--------------2880FF469E7C205499F8BAAA
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi all,
Could anybody there help me with a dbschema problem.
When ever I run a dbschema on a database and if one table is locked in
the database, the dbschema does not give full schema. It comes out and
say that the table is locked. And it will be an incomplete schema. How
to get around this problem?
Thanks in advance.
Aboo
--------------2880FF469E7C205499F8BAAA
Content-Type: text/x-vcard; charset=us-ascii;
name="aboo.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Aboobacker Valappil
Content-Disposition: attachment;
filename="aboo.vcf"
begin:vcard
n:Valappil;Aboobacker
tel;cell:0412 979 008
tel;home:02 9897 7461
tel;work:02 9317 8807
x-mozilla-html:TRUE
org:DHL International Pty Ltd.;IT Department
version:2.1
email;internet:aboo@syd-co.au.dhl.com
title:Unix and Database Analyst
adr;quoted-printable:;;163, O'Riordan St.=0D=0A=0D=0A;Mascot;NSW;2020;Australia
fn:Aboobacker Valappil
end:vcard
--------------2880FF469E7C205499F8BAAA--
Aboo VADAKKUMURI VALAPPIL wrote:
> This is a multi-part message in MIME format.
> --------------2880FF469E7C205499F8BAAA
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi all,
>
> Could anybody there help me with a dbschema problem.
>
> When ever I run a dbschema on a database and if one table is locked in
> the database, the dbschema does not give full schema. It comes out and
> say that the table is locked. And it will be an incomplete schema. How
> to get around this problem?
Get my dbschema replacement, myschema, which, as the Clown pointed out, is part
of the package utils2_ak in the IIUG Software Repository ESQL/C and DBA
sections. Note that a major update to that package and myschema in particular will
be posted in a few days (just doing some final testing) so look for the later
version
(source version 2.47 or later) then.
Art S. Kagel