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:
- Click .
- On the service menu, select Advanced options section. and go to the
- 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.