dbschema -
Hi,
When doing 'dbschema' on a table, our developers run into the catalog being
locked. Anyone know of an environment variable that will allow dbschema to
wait, or do the command with a dirty read isolation. Most likely the cause
of the lock is an update statistics ...
Thanks for any help.
--0__=09BBFAD0DFC257F78f9e8a93df938690918c09BBFAD0DFC257F7
Content-type: multipart/alternative;
Boundary="1__=09BBFAD0DFC257F78f9e8a93df938690918c09BBFAD0DFC257F7"
--1__=09BBFAD0DFC257F78f9e8a93df938690918c09BBFAD0DFC257F7
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Available in 9.4:
1. -it option :
Isolation type can be DR, CS, CR or RR for the following functionality =
:
DR : for setting isolation type to Dirty read.
CS : for setting isolation type to Cursor Stability.
CR : for setting isolation type to Committed Read.
RR : for setting isolation type to Repeatable Read.
2. -l option :
Usage for this is :
-l : set lock mode to wait
-l <number> : set lock mode to wait
Thanks and Regards,
Gaurav
=
"Peter_Logan...." =
<Peter_Logan@spar =
tanstores.com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
dbschema - [5459] =
07/19/2005 09:41 =
AM =
=
=
=
=
Hi,
When doing 'dbschema' on a table, our developers run into the catalog b=
eing
locked. Anyone know of an environment variable that will allow dbschem=
a to
wait, or do the command with a dirty read isolation. Most likely the c=
ause
of the lock is an update statistics ...
Thanks for any help.
=
--1__=09BBFAD0DFC257F78f9e8a93df938690918c09BBFAD0DFC257F7
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Available in 9.4:<br>
<br>
1. -it option :<br>
Isolation type can be DR, CS, CR or RR for the following functionality =
:<br>
<br>
DR : for setting isolation type to Dirty read.<br>
CS : for setting isolation type to Cursor Stability.<br>
CR : for setting isolation type to Committed Read.<br>
RR : for setting isolation type to Repeatable Read.<br>
<br>
2. -l option :<br>
Usage for this is :<br>
<br>
-l : set lock mode to wait<br>
-l <number> : set lock mode to wait <br>
<br>
Thanks and Regards,<br>
Gaurav<br>
<img src=3D"cid:10__=3D09BBFAD0DFC257F78f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Peter_Logan..=
.." <Peter_Logan@spartanstores.com>">"Peter_Logan....&q=
uot; <Peter_Logan@spartanstores.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBFAD=
0DFC257F78f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Peter_Logan...." <Peter_Logan@spa=
rtanstores.com></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">07/19/2005 09:41 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBFAD0DFC257F78f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBFAD0DFC257F78f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBFAD0DFC257F78f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBFAD0DFC257F78f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBFAD0DFC257F78f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D09BBFAD0DFC257F78f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">dbschema - [5459]</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBFAD0DFC2=
57F78f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBFAD0DFC257F78f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt><br>
Hi,<br>
<br>
When doing 'dbschema' on a table, our developers run into the catalog b=
eing<br>
locked. Anyone know of an environment variable that will allow db=
schema to<br>
wait, or do the command with a dirty read isolation. Most likely =
the cause<br>
of the lock is an update statistics ...<br>
<br>
Thanks for any help.<br>
<br>
<br>
<br>
</tt><br>
</body></html>=
--1__=09BBFAD0DFC257F78f9e8a93df938690918c09BBFAD0DFC257F7--
--0__=09BBFAD0DFC257F78f9e8a93df938690918c09BBFAD0DFC257F7
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=09BBFAD0DFC257F78f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=09BBFAD0DFC257F78f9e8a93df938690918c09BBFAD0DFC257F7
Content-type: image/gif;
name="pic21215.gif"
Content-Disposition: inline; filename="pic21215.gif"
Content-ID: <20__=09BBFAD0DFC257F78f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQm
'dbschema -it DR' should do the trick - but this
option became available in
9.4 I believe...
----- Original Message -----
From: "Peter_Logan...." <Peter_Logan@spartanstores.com>
To: <ids@iiug.org>
Sent: Tuesday, July 19, 2005 10:41 AM
Subject: dbschema - [5459]
>
> Hi,
>
> When doing 'dbschema' on a table, our developers run into the catalog
> being
> locked. Anyone know of an environment variable that will allow dbschema
> to
> wait, or do the command with a dirty read isolation. Most likely the
> cause
> of the lock is an update statistics ...
>
> Thanks for any help.
>
>
>