2010 Mar 08 8:55 AM
Hi there,
I have a question concerning the meaning of status "pending" in the buffer overview transactions (AL12, ST02).
In one of our systems, we have a bunch of some hundred generic key and full table buffers in status "pending". Many of these objects are really unsuspicious (customizing tables like T005T or T023, or mini-tables with only ten entries).
The meaning of status "pending" is not clear to us. From the word's meaning, it could mean that the table is about to be loaded into the buffer, but the process is not yet completed. But this can't be the case, since the tables remain in status "pending" for days.
Could somebody please explain the meaning of status "pending" or refer to a documentation? Should we be concerned about the "pending" objects? Is there an impact on the overall performance if there are many "pending" objects?
Thanks and regards,
Rüdiger
2010 Mar 08 9:33 AM
the status 'pending' appears after the buffer was invalidated.
It was decided that the buffer will not be loaded directly with the next access to that table (better generic area), because there are often further changes. The status 'pending' remains for 5 accesses.
Access number 6 changes the status to 'loadable'. And access number seven to valid.
You should be aware of this behavior, when you want to measure performance, because some buffers can be absent for a while.
Siegfried
see also [http://www.dpunkt.de/buecher/3096.html] page number 234
2022 Dec 25 3:31 AM
2010 Mar 08 2:20 PM
pending tables are not so much an issue.
You should have an eye on the invalidations, buffered tables should rarely be invalidated. Invalidations of buffered content can be frequent is development systems by direct changes or transports. There it is unavoidable.
In production systems the numbrer of invalidations should be rather small. Invalidations lead of cause all to pending states, but the new loads, synchronsisation etc. are the real issues with the invalidations.