Listing of virtual objects in Data Virtualization is slow

Last updated: Nov 26, 2024

The process of listing virtual objects in your Data Virtualization service is slow.

Symptoms

You try to list or retrieve virtualized tables and views in Data Virtualization, but the process is taking too long.

Causes

By default, the Restrict visibility option is enabled in Data Virtualization. If you do not have SELECT access to a virtualized table or view, you don't see this table or view when you list virtual objects in your Data Virtualization service.

Before it returns a complete list of virtual objects 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

Take the following steps to try to resolve the problem:

Add WHERE predicate to your query to request a subset of tables or views. If this option does not help resolve this issue, change the setting that restricts users access to Db2® catalog.
Data Virtualization administrators can change the access restriction 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.