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
- CacheUsrLibL
- Equivalent IBM Data Server Provider for .NET connection string keyword
- CacheUSRLIBLValue
- 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.