CacheUsrLibL IBM data server driver configuration keyword

The CacheUsrLibL keyword changes the caching behavior of the user library list (*USRLIBL), when your application is connecting to the Db2® for IBM® i server.

Equivalent CLI keyword
Equivalent IBM Data Server Provider for .NET connection string keyword
db2dsdriver.cfg configuration syntax
<parameter name="CacheUsrLibL" value="true | false"/>
Default setting:
The *USRLIBL value is cached
Usage notes:
When the CacheUsrLibL keyword is set to TRUE, the *USRLIBL value that is retrieved from the server, on the first catalog function call, is cached. The same *USRLIBL value is used for all subsequent catalog function calls in the same connection handle.

If the CacheUsrLibL keyword is set to FALSE, the *USRLIBL value is not cached. If the *USRLIBL value is specified in the schema list, the current *USRLIBL value is retrieved whenever a catalog function call is made. Every catalog function call requires an additional call to the metadata procedure on the database server.