IBM Support

The use of DB2_EVALUNCOMMITTED=YES_DEFERISCANFETCH in DB2 LUW

Technote (FAQ)


Question

What are the values for DB2_EVALUNCOMMITTED?
Setting for DB2_EVALUNCOMMITTED

Answer

In Version 9.1 and above the DB2 registry variable DB2_EVALUNCOMMITTED is documented with these two values (NO, YES).
Prior to Version 9.1, some users may have also used YES_DEFERISCANFETCH as a valid value.

The value YES_DEFERISCANFETCH is still valid in Version 9.1 and above, but the behavior that it represented will also be seen by simply selecting YES.

If your setting for DB2_EVALUNCOMMITTED in the past was YES_DEFERISCANFETCH, then you can either leave it that way or change it to YES, as either setting is valid in Version 9.1 and above.

Document information

More support for: DB2 for Linux, UNIX and Windows
Database Objects/Config - Instance

Software version: 9.1, 9.5

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Enterprise Server, Express, Personal, Personal Developer's, Workgroup Server

Reference #: 1380637

Modified date: 17 August 2013


Translate this page: