Dear All,
Could anyone please enlighten me the importance of creating the tablespace with BufferPool size of BP0 ? Does it mean if a table space with BP0 would consume more Auxiliary storage when a millions of records are loaded ?
Could anyone please explain me the above fundamental of having BP0 ? Is it good to have BP0 for a small shop ?
Jaggz
Buffer Pool Tuning
Previous topic • Next topic • 2 posts
• Page 1 of 1
Re: Buffer Pool Tuning
by GuyC » Thu Jun 14, 2012 12:21 pm
the 0 in BP0 is not the size, it is just a number.
bufferpool tuning is not something to explain in a forum post.
bufferpool tuning is not something to explain in a forum post.
I can explain it to you, but i can not understand it for you.
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Buffer pool full
by kranthi_2k11 » Sat Nov 12, 2011 1:13 pm - 8 Replies
- 2674 Views
- Last post by dick scherrer
Tue Nov 15, 2011 11:11 pm
- Buffer pool full
-
- DB2 Buffer pools
by adurthisridhar » Tue Sep 28, 2010 5:39 pm - 1 Replies
- 1559 Views
- Last post by Robert Sample
Tue Sep 28, 2010 7:29 pm
- DB2 Buffer pools
-
- DB2 Performance Tuning
by kk12345 » Thu Jan 06, 2011 7:17 pm - 4 Replies
- 3434 Views
- Last post by dick scherrer
Fri Jan 07, 2011 3:39 am
- DB2 Performance Tuning
-
- Fine tuning a SQL??
by sinmani » Fri Mar 23, 2012 5:57 pm - 6 Replies
- 2751 Views
- Last post by Robert Sample
Fri Mar 23, 2012 11:47 pm
- Fine tuning a SQL??
-
- DB2 performance tuning
by diamond12 » Fri Oct 10, 2014 10:09 am - 3 Replies
- 2870 Views
- Last post by diamond12
Sat Oct 25, 2014 12:22 pm
- DB2 performance tuning