Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

WARNING: Buffer pool size is too small for read ahead operation

  • 1.  WARNING: Buffer pool size is too small for read ahead operation

    Posted 5 hours ago

    When I am loading millions of records into a database and I occasionally see a warning message about the buffer pool size being "too small for read ahead operation", should my reaction be: (a) ignore the warning because it only occurs with unusually large loads of data, or (b) increase the size of the buffer pool?



    ------------------------------
    John Dargan
    ------------------------------