0 / 0
Viewing of objects in your cart in Watson Query is slow

Viewing of objects in your cart in Watson Query is slow

The process of listing virtual objects in your cart is slow.

Symptoms

You are trying to view the cart after selecting tables to virtualize, but objects are unavailable and the Virtualize page displays Validating for too long.

Causes

By default, the Restrict visibility option is enabled in Watson Query. The check for duplicate objects is slower because the system must verify the access settings of each virtual object.

Before it returns your cart in Watson Query, the system must verify access settings of each virtual object. This process might take several minutes to complete, especially in user environments where the total number of virtual objects is high.

Resolving the problem

Watson Query administrators can change the setting that restricts users access to the Db2® catalog by following these steps:

  1. Click Data > Data virtualization.
  2. On the service menu, select Settings > Service settings and go to the Advanced options section.
  3. Disable the Restrict visibility option to allow users to see column and table names of virtual objects that they cannot access.
    Note: Disabling access to the catalog makes all virtual objects visible to all users. However, the content of these tables and views is only visible to users that are granted the corresponding permission. For more information, see Managing virtual objects.
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more