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
------------------------------
Original Message:
Sent: Wed December 02, 2020 10:31 AM
From: Mark Scranton
Subject: Light Append Buffers
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
Original Message:
Sent: Wed December 02, 2020 07:40 AM
From: Andreas Legner
Subject: Light Append Buffers
"Light Append Buffers" ?
Where would you see those? What are you doing, what do you need?
------------------------------
Andreas Legner
Original Message:
Sent: Tue December 01, 2020 07:34 PM
From: Mark Scranton
Subject: Light Append Buffers
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