Hi David,

[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
> 
> I am importing data from csv files, and am trying to figure 
> out (related to
> last question) what will happen if it is too large to fit 
> into the data volumes I have allocated.
> 
> Will it just fill it to 100% and then fail?  Is there any way 
> to handle this gracefully?
> 
The volumes will indeed fill up. The Loader then (supposing you're using
the Loader to import the data) will idle (actually it
will wait in 'receive' for an answer from the kernel that won't
come; this simply means the Loader sends a packet with data and
the kernel will try to include it in it's structures and realize
there is no space left, it'll then not send an answer and the Loader
would wait and wait and ...), but it won't stop working/waiting.
YOU may then realize that the volumes
filled up to the maximum and decide to add a new volume (assuming the
parameter MAXDATAVOLUMES/MAXDATADEVSPACES is set accordingly to allow
adding new volumes on the fly). After the new volume is added
the Loader will continue to import.
The same applies if the LOG filles up.
HTH.
Regards,
 Steffen
-- 
Steffen Schildberg
SAP DB Team
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to