Re: Help Loading table from flat file.
Just a guess, but are you running into a long transaction?
Check your online log file. The fact that you can break it into
pieces and it works amkes this smell like a long transaction.
You can use dbload and have it commit after X number of rows
as an alternatative solution if this is in fact a long transaction.
Also, the brute force solution would be to increase your logical
logs by 4 times.
-Bill
}
} I am currently trying to move the contents of a table from one database
} to another. The way I am doing this is I've created a duplicate of the table
} in database1 in database2 then I unloaded the table from database1 into a
} flat file. Then I plan on loading the flat file into the table in database2.
} The problem I am having is this: The load from the flat file into the table
} on database2 fails with the following error:
} 847: Error in load file line 862.
} The line number changes every time I try. I looked at the file, but don't see
} any problems. The table has 1852 rows and is over 5MB in size. I split the file
} up into 4 flat files. When I loaded from the 4 flat files, everything worked
} and loaded OK. I see this as a problem. Informix should be able to handle a
} 5MB file of 1852 rows. Could it be a configuration setting? I'm running
} On-Line Dynamic Server Version 7.2. Any Ideas out there?
}
} Thanks in advance,
} Ernst Graeler egraeler@commvault.com
}
} --
} Ernst F. Graeler
} +----------------------------------------------+
} | You from Joisey!? ...Yeah I'm from Joisey!!! |
} | Oh Yeah! What Exit? ernieg@exit109.com |
} +----------------------------------------------+
}
--
Bill Ennis Voice: 312-474-7516
SSA Fax: 312-474-7460
500 W. Madison email: ennis@ssax.com ennis@accesschicago.net