Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Light Append Buffers

  • 1.  Light Append Buffers

    Posted Tue December 01, 2020 07:34 PM

    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
    ------------------------------


  • 2.  RE: Light Append Buffers

    Posted Wed December 02, 2020 07:40 AM
    "Light Append Buffers" ?

    Where would you see those? What are you doing, what do you need?


    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: Light Append Buffers

    Posted Wed December 02, 2020 10:31 AM

    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
    ------------------------------



  • 4.  RE: Light Append Buffers

    Posted Wed December 02, 2020 10:41 AM
    Nope, hard-coded to 4 buffers.

    ------------------------------
    Andreas Legner
    ------------------------------



  • 5.  RE: Light Append Buffers

    Posted Wed December 02, 2020 10:45 AM
    Thanks Andreas .. appreciate it.

    ------------------------------
    Mark Scranton
    ------------------------------



  • 6.  RE: Light Append Buffers

    Posted Thu December 03, 2020 06:04 PM
    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
    ------------------------------



  • 7.  RE: Light Append Buffers

    Posted Thu December 03, 2020 09:29 PM
    Thanks Fernando. Appreciate it. Will dig into it as an option. Sounds very possible. 

    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.