<div>
what are the pros and cons, using a registry variable.<br />
<br />
I have the following set of registry variables :<br />
<br />
[i] DB2_SKIPINSERTED=ON<br />
[i] DB2_USE_ALTERNATE_PAGE_CLE<wbr />ANING=ON<br />
[i] DB2_INLIST_TO_NLJN=YES<br />
[i] DB2_ALLOCATION_SIZE=134217<wbr />728<br />
[i] DB2_EVALUNCOMMITTED=ON<br />
[i] DB2_EXTENDED_OPTIMIZATION=<wbr />ON<br />
[i] DB2_SKIPDELETED=ON<br />
[i] DB2_NEW_CORR_SQ_FF=ON<br />
[i] DB2_STRIPED_CONTAINERS=ON
</div>


what are the pros and cons, using a registry variable.

I have the following set of registry variables :

[i] DB2_SKIPINSERTED=ON
[i] DB2_USE_ALTERNATE_PAGE_CLEANING=ON
[i] DB2_INLIST_TO_NLJN=YES
[i] DB2_ALLOCATION_SIZE=134217728
[i] DB2_EVALUNCOMMITTED=ON
[i] DB2_EXTENDED_OPTIMIZATION=ON
[i] DB2_SKIPDELETED=ON
[i] DB2_NEW_CORR_SQ_FF=ON
[i] DB2_STRIPED_CONTAINERS=ON

<div>
[i] DB2_SKIPINSERTED=ON<br />
[i] DB2_USE_ALTERNATE_PAGE_CLE<wbr />ANING=ON<br />
[i] DB2_INLIST_TO_NLJN=YES<br />
[i] DB2_MINIMIZE_LISTPREFETCH=<wbr />YES<br />
[i] DB2_ALLOCATION_SIZE=134217<wbr />728<br />
[i] DB2_EVALUNCOMMITTED=ON<br />
[i] DB2_EXTENDED_OPTIMIZATION=<wbr />ON<br />
[i] DB2_SQLROUTINE_PREPOPTS=RE<wbr />OPT{ALWAYS<wbr />}<br />
[i] DB2_SKIPDELETED=ON<br />
[i] DB2_NEW_CORR_SQ_FF=ON<br />
[i] DB2_STRIPED_CONTAINERS=ON<br />
[i] DB2BIDI=YES<br />
[i] DB2_RR_TO_RS=YES<br />
[i] DB2COMM=tcpip<br />
[i] DB2CODEPAGE=1208<br />
[i] DB2_PARALLEL_IO=*<br />
[i] DB2AUTOSTART=YES<br />

</div>


[i] DB2_SKIPINSERTED=ON
[i] DB2_USE_ALTERNATE_PAGE_CLEANING=ON
[i] DB2_INLIST_TO_NLJN=YES
[i] DB2_MINIMIZE_LISTPREFETCH=YES
[i] DB2_ALLOCATION_SIZE=134217728
[i] DB2_EVALUNCOMMITTED=ON
[i] DB2_EXTENDED_OPTIMIZATION=ON
[i] DB2_SQLROUTINE_PREPOPTS=REOPT{ALWAYS}
[i] DB2_SKIPDELETED=ON
[i] DB2_NEW_CORR_SQ_FF=ON
[i] DB2_STRIPED_CONTAINERS=ON
[i] DB2BIDI=YES
[i] DB2_RR_TO_RS=YES
[i] DB2COMM=tcpip
[i] DB2CODEPAGE=1208
[i] DB2_PARALLEL_IO=*
[i] DB2AUTOSTART=YES


<div>
Any idea what is the impact of the Registry variables I mentioned.
</div>


Any idea what is the impact of the Registry variables I mentioned.

<div>
<div class="content wysiwyg-content">
DB2_INLIST_TO_NLJN --- &nbsp;the registry variable <br />
<br />
&quot;db2set DB2_INLIST_TO_NLJN=TRUE <br />
<br />
This will convert the IN List to a NLJN and can force the usage of the index&quot;<br />
<br />
What is the internal structure of this registry variable. Does it creat a temp table for the IN predicted values on the fly. <br />
<br />
How does it works?<br />
<br />
<br />

</div>
</div>


DB2_INLIST_TO_NLJN ---  the registry variable 

"db2set DB2_INLIST_TO_NLJN=TRUE 

This will convert the IN List to a NLJN and can force the usage of the index"

What is the internal structure of this registry variable. Does it creat a temp table for the IN predicted values on the fly. 

How does it works?




Use of DB2_INLIST_TO_NLJN

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.