onsmsync runs in long transaction
Hello,
we are using IDS7.31.UD2 on AIX4.3.3 with Legato Networker
I want to clean out the bar_action and other bar-tables in sysutils.
Unfortunatly this was not done during 2,5 years.
The onsmsync has a lot to do and I have interrupted the command because it
seems to run out in a long transaction.
Is there another way to clean this tables ?
Can I find the objects older than this year with ::
select ins_oid from bar_instance, bar_action, bar_object
where ins_oid = act_oid
and obj_oid = act_oid
and act_start < datetime (2004-01-01) year to day
Thanks for help,
Yves
------_=_NextPart_001_01C422DD.38EADF50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>onsmsync runs in long transaction</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Hello,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">we are using IDS7.31.UD2 on AIX4.3.3 =
with Legato Networker</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I want to clean out the bar_action =
and other bar-tables in sysutils.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Unfortunatly this was not done during =
2,5 years.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">The onsmsync has a lot to do and I =
have interrupted the command because it seems to run out in a long =
transaction.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Is there another way to clean this =
tables ?</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Can I find the objects older than =
this year with ::</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">select ins_oid from bar_instance, =
bar_action, bar_object </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> where ins_oid =
=3D act_oid </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> =
and obj_oid =3D act_oid</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> =
and act_start < datetime (2004-01-01) year to day</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks for help,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Yves</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C422DD.38EADF50--