DB2 AWE configuration Error.

[maheshbhalerao]

Hi i am having DB2 v8.1.4 version installed on my server.
but everyday in the eventlog entry i found the similar kind of error mentioned below.

"ADM6027E AWE is not being used for buffer pool "IBMDEFAULT BP" (ID "1") due to
an AWE initialization failure. Ensure that AWE is configured correctly on the
operating system platform and for use with DB2."


Could anyone please tell me the cause and solution for the above error?

thanks in advance.

[docdiesel]

Hi,

check your AWE-Setup (Windows) and the DB2_AWE variable of DB2 (type db2set in a db2 command window). It should be set to something like 2,100,50.

If not set, configure it with

db2set DB2_AWE=nr_of_b ufferpool,numbe r_of_bufferpage s,awe_window_si ze

where

• nr_of_bufferpoo l may be found as BUFFERPOOLID column in the table SYSCAT.BUFFERPO OLS
• number_of_buffe rpages refers to the pagesize of your bufferpool which may be 4K or a multiple
• awe_window_size should be equal or less to (number_of_buff erpages * bufferpagesize) , and less then 2 GB.

Perhaps you'd like to read this article of IBM about using AWE. Besides, since real 64bit architecture is available for hard- and software, the AWE technique is deprecated and not used (because not necessary) in newer versions of DSB2 any longer.

Regards,

Bernd