CacheUsrLibL CLI/ODBC configuration keyword
The CacheUsrLibL keyword
is used to change the caching behavior of the user library list (*USRLIBL),
when your application is connecting to the Db2® for IBM® i server.
- db2cli.ini keyword syntax:
- CacheUsrLibL = TRUE | FALSE
- Default setting:
- The *USRLIBL value is cached
- Equivalent environment or connection attribute:
- SQL_ATTR_CACHE_USRLIBL
- 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. When 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.