About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Last updated: Nov 26, 2024
The
page automatically excludes tables from the system, tools, and application schemas of the remote sources. You can override this default by specifying a list of schemas to reveal.Symptoms
The Virtualize page does not show tables from system, known tools, or application schemas.
Resolving the problem
- Use the
API to determine the CID and DV agent name, labeledCALL DVSYS.LISTRDBCDETAILS
in the result output, under which you want to reveal some schemas (groupings of tables).GDB_NODE
- In the SQL editor, reveal schemas by using the following example API invocation.
Substitute your own details for:
- <cid>
- <agent_name>
- <schema_names>, a comma-separated list of schema names.
CALL DVSYS.SETCONFIGPROPERTY('RELOADTABLES_SCHEMAS_REVEALED_<cid>', '<schema_names>', '<agent_name>', ?, ?)
See the following example.
CALL DVSYS.SETCONFIGPROPERTY('RELOADTABLES_SCHEMAS_REVEALED_DB210041', 'SYSCAT', 'qpendpoint_1:6415', ?, ?)
Was the topic helpful?
0/1000