RE: dbload question

> 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 ________________________