Docs
...
TOGGLEPERSONALCREDENTIALSUSEINCACHE stored procedure

TOGGLEPERSONALCREDENTIALSUSEINCACHE stored procedure in Data Virtualization

Last updated: Mar 17, 2025
TOGGLEPERSONALCREDENTIALSUSEINCACHE stored procedure in Data Virtualization

Allow caches to be created for data sources that use personal credentials when pass-through authentication is enabled. The schema is DVSYS.

When pass-through authentication is enabled, caches (including user and auto-cache generated caches) can not be created for data sources that use personal credentials. You can enable the creation of caches by using this stored procedure. For more information on pass-through authentication, see Adding data source connections to Data Virtualization to connect with personal credentials.

Authorization

To run the TOGGLEPERSONALCREDENTIALSUSEINCACHE stored procedure, you must be the db2inst1 user.

Input parameters

BOOLEAN
This type of parameter is boolean (TRUE/FALSE).
  • TRUE: Do not allow the creation of caches for data sources that use personal credentials.
  • FALSE: Allow the creation of caches for data sources that use personal credentials.
Note: This parameter is set to TRUE as the default for Cloud Pak for Data version 5.0.3 and onwards.

Examples

Run the following stored procedure to disable caching of data sources that use personal credentials:
call dvsys.TOGGLEPERSONALCREDENTIALSUSEINCACHE('TRUE')
Run the following stored procedure to enable caching of data sources that use personal credentials:
call dvsys.TOGGLEPERSONALCREDENTIALSUSEINCACHE('FALSE')