Symptom
When LOAD_STRIPE_WIDTH parameter is configured to a value n > 1 in RSDANLCON, it directs the IQ DBSL to write and append all data records of a Data Package round-robin to those n files (.dat) in the local file system of the current application server. You would like to understand why those .dat temporary files created have a large size.
As sample: loading big data around 600 GB and LOAD_STRIPE_WIDT=4, it generates more than 588GB of temporary files with each of these files with 147GB size.
Read more...
Environment
- SAP Business Warehouse - All versions
- SAP IQ - All versions
- SAP BW/4HANA - All versions
Product
Keywords
IQ, data load, LOAD_STRIP_WIDTH, RSDANLCON, ADSO , , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , BW4-DM-DTO , Data Tiering Optimization , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.