Light Append Buffers
Mark Scranton asked whether the number of light append buffers can be increased; he saw only 4 during express loads with external tables. Andreas Legner said the count is hard-coded at 4. Fernando Nunes suggested loopback ER as a way to reorganise very large tables if space allows, which Mark said he would look into.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I thought back in the day we could increase the number of light append buffers. Anyone recall that option? I get 4 buffers know matter how any threads are running or fragments involved in source or target. Thanks! ------------------------------ Mark Scranton mark@markscranton.com ------------------------------ #Informix
" Light Append Buffers" ? Where would you see those? What are you doing, what do you need? ------------------------------ Andreas Legner ------------------------------
Andreas -
Using the ploader (external tables) for bulk loads, etc. During an express load onstat -g lap shows the light appends and the buffer count. Have a very large reorg coming up and just turning knobs for tuning if possible on smaller tests. Do you know what factors determine the light append buffer count and size? I may be wrong about being able to change these settings - just can't remember back from the XPS days.
------------------------------
Mark Scranton
mark@markscranton.com
------------------------------
Nope, hard-coded to 4 buffers. ------------------------------ Andreas Legner ------------------------------
Thanks Andreas .. appreciate it. ------------------------------ Mark Scranton ------------------------------
Depending on the version you're using, loopback ER seems a very nice way to reorg tables.... if you can spare the space. No real life experience with is at this moment... Regards. ------------------------------ FERNANDO NUNES ------------------------------
Thanks Fernando. Appreciate it. Will dig into it as an option. Sounds very possible. Get Outlook for iOS This email, including attachments, may contain information that is private or confidential. If you received this communication in error, please delete it from your system without copying it and notify sender by reply communication. ADT Security Services and its affiliates reserve the right to monitor communications handled by its data communications systems to help ensure compliance with ADT's policies, confidentiality obligations, and applicable laws.