Re: HELP: dbimport problem

On 30 Sep 1995 17:28:05 GMT, you wrote: >I am using Online 5.03 on an HP with hp-ux v 9.04. I have done a >dbexport to tape and modified the import file to include extent >sizes. dbimport runs for about 10 minutes and then does a >rollback work. The logical log is only 10 % full, I'm not doing >transaction logging and I'm not reaching my max number of locks. >The rollback always occurs at the same row in the same table. >I know I must be doing something wrong. >I'll entertain any and all ideas. >This is no way to spend a weekend! >Thanks >-- >Bob Smith >Supreme Court of Virginia >75151.765@compuserve.com Hello Bob Are any other error messages displayed ??? I've experienced many problems with dbimport with Informix Turbo and Online (Version 3, 4 and 5 ) using medium to large databases. Here's some things to check out first !! 1) Are you restoring into the correct DBSPACE ? 2) Check that the environment variable 'DBTEMP' is pointing to a large free directory/mount point to allow for sorting. 3) Try removing the 'create index' statements from the ?.sql script and create them later. 4) You may have a corrupt row in a table ? 5) Check the syntax of your ?.sql script. Personally I never use dbexport to tape because of the problems I've experienced over the years. At least when the data is in filestore you can edit it or load it in a bit at a time using 'load' or dbload'. Regards <><><><><><><><><><><><><><><><><><><><><> <> Cliff Warrington <> <> KTL Partnership <> <> Tel : +44 (0)161 763 1286 <> <> Fax : +44 (0)161 763 1180 <> <> Email : cliff@ktl.u-net.com <> <><><><><><><><><><><><><><><><><><><><><>