Are you a DB2 10 user thinking about implementing 1MB page frames?
By Julian Stuhler If you already have page-fixed buffer pools and can convince your sysprog that the potential benefits are worth it (up to 6% CPU savings have been seen), you'll need to decide how big to make the large page frame area. This is set by the LFAREA parameter in IEASYSnn PARMLIB, and can be expressed as a % of the total available storage, or as an absolute value in MB or GB (subject to a maximum of 80% of available storage on the LPAR). This setting needs an IPL to take effect, so it's important to get it right first tim...[more about Are you]
Published 6 August 2013 - by Iqbal Goralwalla
DB2 10.5 for Linux, Unix and Windows features exciting and ground breaking data management innovation for analytic processing. The addition of IBM's BLU Acceleration technology makes it easier, cheaper and faster to analyse massive amounts of data. The seven big ideas of DB2 with BLU Acceleration aim to provide extreme performance, lower operating costs and hardware optimisation. Let's take a look in more detail:1. Simple to Implement and UseWith BLU Acceleration, the complexity of analytic database design and tuning which involves tedious...[more about Less Caffeine,]