Re: Reg: Logical Logs Filling Up
On Fri, 4 Jun 2004 15:49:41 -0500, "Sudhir Sambrani"
<sudhir@laregents.org> wrote:
onstat -l always shows 100%
with
onstat -m
if you see message "log file is full backup is needed " or similarly
you have to do backup with
ontape -c
if you change tape parameters to /dev/null you don't have to do
backup of transactions.
checkpoint define period beetween checking consistency of transaction
and there in not corelation
>
>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