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

> > 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. Not sure why you'd want to do this...onpload isn't really designed to be run in parallel, as they'd be competing with each other for system resources. You can achieve better performance by spreading out your device arrays and tuning the HPL config file, but I wouldn't recommend to anyone that they run multiple onpload jobs at once. Side note - you don't actually HAVE to run the level 0...you can fake a level 0 with "onbar -b -F" (or "onbar -B -f", I forget). --Chuck