Re: Logical Logs Filling Up
dbload -d <database>
-c <command file>
-l <error log file>
-e <num of errors(bad-row limits)>
-i <num of rows ignored>
-n <num of rows to commit(default 100)> -r do not to lock table
-k lock table exclusively
$INFORMIXDIR/bin/dbload -d databasename -c tableload.sql -l
tableload.err -n 100 -r
tableload.sql would be the command file, with this for example :
FILE "stock.unl" DELIMITER "|" 6;
INSERT INTO stock;
Check this :
Avoiding Long Transactions (LTX) :
http://www.tek-tips.com/gfaqs.cfm/pid/179/fid/2537
----- Original Message -----
From: "Sudhir Sambrani" <sudhir@epscor2.phys.lsu.edu>
To: "Francisco Roldan" <f_roldan@admcentralagricola.com.gt>
Cc: "Sudhir Sambrani" <sudhir@laregents.org>; <informix-list@iiug.org>
Sent: Saturday, June 05, 2004 12:05 AM
Subject: Re: Logical Logs Filling Up
> Thanks for ur help on the
> ontape -c>
>
> yup i made that mistake of using load from
>
> this was b'cos dbexport gave me errors and
> i had to recreate the entire database manually
>
> cud i still use dbload and what wud be the input file
> if i hvent got one from dbexport
>
> Thanks
> Sudhir
>
>
> On Fri, 4 Jun 2004, Francisco Roldan wrote:
>
> > Run Continuos log backup : ontape -c
> > while you are loading data .
> > You did not indicate how are you loading data,
> > but the best way is using dbload command in order
> > to avoid the famous Long Transaction problem when loading
> > data with sql's "load from ... " .
> >
> > I hope this helps you.
> >
> > Regards
> >
> > ----- Original Message -----
> > From: Sudhir Sambrani
> > To: informix-list@iiug.org
> > Sent: Friday, June 04, 2004 10:49 PM
> > Subject: Reg: Logical Logs Filling Up
> >
> >
> > Hi,
> >
> > I am trying to migrate and existing databse to
> > IDS
> > i recreated the database and dbschema
> > on loading the data in the tables my logical logs
> > get filled up and IDS hangs
> >
> > onstat -l shows 100% useage on all logical logs> >
> >
> > how do i free these logs
> > do i have archive them is there any other way ?
> >
> > how does the checkpoint interval affect the
> > the freeing up of these files
> >
> >
> > Thanks for any help
> > Sudhir
> >
> >
>
>
sending to informix-list