Viewing of objects in your cart in Data Virtualization 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 Data Virtualization. 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 Data Virtualization, 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
Data Virtualization administrators can change the setting that restricts users access to the Db2® catalog by following these steps:
- Click .
- On the service menu, select and go to the Advanced options section.
- 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.