dbimport Questions/Problems

Hi, 1) Does anyone have any recommendations to speed up a 'dbimport' ? 2) Does the 'dbimport' build any files on filesystems ? I was trying to data and it failed after a day and a half with an 131 error , "load_cur failed". DBSPACETEMP is set to three dbspaces with adequate space in them. TIA Sathish Sadagopan

Sadagopan, Sathish, CFCTR wrote: > > Hi, > 1) Does anyone have any recommendations to speed up a 'dbimport' ? > > 2) Does the 'dbimport' build any files on filesystems ? I was trying to data > and it failed after a day and a half with an 131 error , "load_cur failed". > DBSPACETEMP is set to three dbspaces with adequate space in them. I do not think it ran out of temp space but table space. -131 is "No free disk space" and the text indicates that insufficient contiguous space is available. As to the run speed before it crashed - you might try setting the environment variable FET_BUF_SIZE to increase the communication buffer size from the default of 4096 to the maximum of 32767. This can make a significant improvement. Art S. Kagel