Re: dbload question

Ralph.Halter@pac.panmail.com wrote: > > > Someone had the following problem: > > We are using dbload to import 25,000 records to a new Informix database. > > Platform is Windows NT 4.0 Beta. After about 1,000 records, the status screen > > (i.e. "100 records loaded" etc) stops and the server is locked up. If we > > restart the server we are now locked out of the tables. > > Just some hints: > - drop all indexes before loading (dbschema -d db_name gives you the > commands to re-create the indexes after loading) > - if possible create the database with no log (CREATE DATABASE db_name > IN dbs_name) - this will ease and speed up the load process considerably > - if your database must use a log then make sure your log-files are big > enough to take the logging of you inserts from dbload (or back them up > continuously and set ltapedev to /dev/null in order not to run out of > log-space) > - check in your onconfig file that your values for max locks, etc. are > really high so you don't run into trouble there > These are a few "obvious" things to consider, hope this helps. > (If not I'm afraid you would have to be more specific to attract the > attention of the REAL gurus ...). > > Cheers. > Ralph. > ________________________________________________________________________ > Never attribute to malice that which is adequately explained by stupidity. > ____________________ ralph.halter@pac.panmail.com ________________________ I can't seem to access the original message to reply to it. Wouldn't dbload in be worth considering as a possible solution? Neil Truby London trubyn@aol.com