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 "IBMDEFAULTBP" (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_bufferpool,number_of_bufferpages,awe _window_size

where

• nr_of_bufferpool may be found as BUFFERPOOLID column in the table SYSCAT.BUFFERPOOLS
• number_of_bufferpages 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_bufferpages * 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