Reg: Logical Logs Filling Up
This is a multi-part message in MIME format.
------=_NextPart_000_004D_01C44A4B.8CB521A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I am trying to migrate and existing databse to=20
IDS=20
i recreated the database and dbschema
on loading the data in the tables my logical logs=20
get filled up and IDS hangs
onstat -l shows 100% useage on all logical logs
how do i free these logs=20
do i have archive them is there any other way ?
how does the checkpoint interval affect the=20
the freeing up of these files
Thanks for any help
Sudhir
------=_NextPart_000_004D_01C44A4B.8CB521A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I am trying to migrate and existing =
databse to=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>IDS </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>i recreated the database and =
dbschema</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>on loading the data in the tables my =
logical logs=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>get filled up and IDS =
hangs</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>onstat -l shows 100% useage on all =
logical=20
logs</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>how do i free these logs </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>do i have archive them is there any =
other=20
way ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>how does the checkpoint interval affect =
the=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>the freeing up of these =
files</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for any help</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Sudhir</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_004D_01C44A4B.8CB521A0--
sending to informix-list