-197 Error !

I am getting -197 Error. How can I solve this problem? What could be the reason. How can I check the partitions? -197 ISAM error: Partition recently appended to; can't open for write or logging. If this internal error recurs, please note all circumstances and contact Informix Technical Support. Thanks in advance. == Olcay Sarioglu

Olcay, This error is generally seen after a High Performance Load in Express mode. The only way to correct this is to do a level 0 archive of the effectted dbspaces. Express mode HPL loads data into a new extent and then appends the extent to the table when the entire load is complete. That is why it is able to load all the rows with no logging. Greg Olcay Sarioglu wrote: > I am getting -197 Error. How can I solve this problem? What could be > the reason. How can I check the partitions? > > -197 ISAM error: Partition recently appended to; can't open for > write or logging. > > If this internal error recurs, please note all circumstances and > contact Informix Technical Support. > > Thanks in advance. > > == Olcay Sarioglu