Re: ISQL "LOAD FROM" command

> is there any bug known with the above command when loading larger tables? > I just tried to load about 75000 records which i unloaded prevoiusly with > the"UNLOAD TO" command. > ISQL reports a syntax error in the load file after about 55000 records. > But everything seems to be ok and i had no problems to load all records > with dbload. > Environment: Online 5.0, ISQL 4.1 on a Siemens RM400 Check the LOCKS parameter in your tbconfig file. Then do a "tbstat -u" and see how many locks the tbload process is holding. You might be running out of locks. If that's the case, then increase your locks. (check the OnLine message file also for a "lock table overflow" situation). tbload has a "feature" where it does row-level locking on a table that it's trying to load. Also, if you are loading a table which contains BLOBS, tbload locks BLOBpages as well. Since OnLine is limited to only 256,000 locks, there is a limitation on how big a table you can tbload with it. ############################################################## David Nguyen Internet: davidn@geis.geis.com GE Information Services UUCP: uunet!ge!davidn 401 North Washington Street Voice: 1-301-340-5461 Rockville, MD 20850 USA ##############################################################