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 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.
DB2 10.5 for Linux, UNIX, and Windows