Error Loading with HPL

Hi Solaris 10 IDS 9.40FC9W2 we have to migrate some rather big tables (about 800.000.000 rows) from one server to another. We unload the tables with HPL in flat files, copy them to the other server and load them with HPL. The tables are fragmented. The table structure is identical on both servers. No problems occured with one of the tables, although even bigger. With another the load alwway stopped with the messages: Fatal error getting stream buffer from server Fatal error in server row processing - SQL error -271 ISAM error -131 Database Load Completed -- Processed 76156665 Records Records Inserted-> 0 Detected Errors--> 0 Engine Rejected--> 0 Repeating unload and copy had no effect. Since it's urgent to load the tables any help is highly appreciated. Reinhard.

Hello Reinhard, $ finderr 271-271 Could not insert new row into the table. This problem has many possible causes, including a locked table or a full disk. Check the accompanying ISAM error code for more information. $ finderr 131-131 ISAM error: no free disk space. Not enough contiguous free disk space is available to complete the current operation. For C-ISAM programs, if transaction logging is in use, roll back the current transaction. Make some disk space available, and run the program again. For SQL products, roll back the current transaction, if possible. Contact the system administrator about acquiring more disk space for databases. Your target dbspace is full. add some chunks. Superboer. way fast=http://www.clipjes.nl/clip/nederlands/n/normaal_- _oerend_hard.html On 3 mrt, 08:29, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi > > Solaris 10 > IDS 9.40FC9W2 > > we have to migrate some rather big tables (about 800.000.000 rows) from one > server to another. We unload the tables with HPL in flat files, copy them to > the other server and load them with HPL. > > The tables are fragmented. The table structure is identical on both servers. > > No problems occured with one of the tables, although even bigger. With > another the load alwway stopped with the messages: > > Fatal error getting stream buffer from server > Fatal error in server row processing - SQL error -271 ISAM error -131> > Database Load Completed -- Processed 76156665 Records > Records Inserted-> 0 > Detected Errors--> 0 > Engine Rejected--> 0 > > Repeating unload and copy had no effect. > > Since it's urgent to load the tables any help is highly appreciated. > > Reinhard.