Use of DB2_INLIST_TO_NLJN

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?


bengoalAsked:
Who is Participating?
 
momi_sabagCommented:
db2 creates an in-memory table that holds the values from your in list and then joins this table
0
 
bengoalAuthor Commented:
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
0
 
bengoalAuthor Commented:
[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
0
 
bengoalAuthor Commented:
Any idea what is the impact of the Registry variables I mentioned.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.