Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.