The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
with Tags:
fscr
X
X
When is space from a deleted row reused by DB2
Space from a deleted row is eligible for reuse as soon as the transaction with the delete statement is committed. When that space is reused for future inserts depends on how DB2 searches for free space. DB2 searches for free space by taking advantage of Free Space Control Records (FSCR). Each FSCR tracks the free space for 500 pages. By default DB2 will search 5 FSCR records. That means a total of 2500 pages will be searched before giving up the search for free space and just appending the row to the... [More]
Tags: reused db2 fscr delete |
DB2 Insert Performance due to FSCR and how to identify that
It's well documented that one of the major reasons for DB2's slow insert performance is how the Free Space Cache Record (FSCR) are searched before a record is inserted. This Technote explains it very well, http://www-01.ibm.com/support/docview.wss?uid=swg21984112 Also, a nice description in the DB2's Knowledge Center, http://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.perf.doc/doc/c0009677.html But, how to... [More]
Tags: insert fscr db2maxfscrsearch db2luw |
