Facing a problem in Informix HPL .. can you help ?

> Hi there, > > First let me explain what setup we maintined here in informix : > > # IDS 7.31 versioned Informix is installed on HP-UX 11.0 > # Database is created by informix > # User 'Baan5" is created with role - Informix User > # Express mode is used for Load > # The onpload command exactly used (by taking a table > tppdm000) is " onpload -m tppdm000 -d tppdm000.dat -fvl > tppdm000.log " > > > > We used the single loader to load the data (say scenario 1), i.e., > single invocation of the onpload (utility of HPL to load data) command to > load 1 datafile at a time into one table. So, after completion of load for > one table the next load starts, this situtation works fine. > > But when we consider the case of multiple loaders (say Scenario 2) , > onpload command is invoked mutliple times to load data into different > tables, i.e , which ever finishes the load first it will pick up another > table form the pool and start loading the data for that table, now in this > case we are encountering a problem, we get an error message, that says : " > Error accessing table 'sysconstraints', SQL error -243,ISAM , error -113 " > in one of the log files, one more important thing i forgot to mention we > are giving "SET LOCK MODE TO WAIT" on the target database before the > loading starts and after the load we issued the "ontape -s -L 0" (which is > mandatory for express mode) from Informix user. > > Anybody knows the solution ? ... plz reply me ASAP thanks and regards > Poovannan >