The use of DB2_EVALUNCOMMITTED=YES_DEFERISCANFETCH in DB2 LUW
What are the values for DB2_EVALUNCOMMITTED?
Setting for DB2_EVALUNCOMMITTED
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.
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: