Hello,
for tables, I can choose buffering or not and the buffering type as well.
An example: In a system with two ore more application servers, a buffered table is read for the first time and thus loaded to one application server. Thus the table (or individual tuples)is buffered in this application server. Although the table was not requested by clients logged on other application servers, do all other application servers load this table from the database as well?
What happens if a buffered table is only hold on one application server and changend. This change is written into the DDLOG file. Other application servers read this. Althoug they have not buffered that table yet, do they now load it into their buffer...
This would make no sense, but I did not find the clear message anywhere that application servers only load the tables that are requested from it...
Thanks,
holger