Re: crash with big data loads
From: <nsouto_at_acay.com.au>
Date: 1995/12/30
Message-ID: <4c36j5$g1m_at_www.acay.com.au>#1/1
Date: 1995/12/30
Message-ID: <4c36j5$g1m_at_www.acay.com.au>#1/1
Any suggestions?????
>
A few. You may be loading into a table that already has indexes defined.
This means your space calculations for RLB may be off by the index amount.
Also, if you have concurrent access to this table while loading, you're bound
to get this message.
Try doing this at an off-line time and dropping all indexes before the big load and re-creating them at the end.
Also, try to commit every few thousand rows loaded to reduce the strain on the RLBsegs, if this is possible in the logic of your loads.
HTH. Received on Sat Dec 30 1995 - 00:00:00 CET