Error attempting to Virtualize a Table in Data Virtualization in a browser session

Troubleshooting

Problem

When attempting to virtuallize a table in the a browser (using the GUI) the process fails with an error.

It is possible to virtualize a table using the API call DVSYS.VIRTUALIZETABLE

Symptom

Error seen

[IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001 sqlstate = 07001

Cause

Checking the list of Stored Procedures it was discovered that the VIRTUALIZETABLE Stored Procedure with the specific name DV_VIRTUALIZE_TABLE_OLD had been deleted

Diagnosing The Problem

There are two Stored Procedures named DVSYS.VIRTUALIZETABLE each with it's own Specific Name.

The GUI using the stored procedure with the specific name DV_VIRTUALIZE_TABLE_OLD.

The API call uses the stored procedure with the specific name DV_VIRTUALIZE_TABLE.

Resolving The Problem

Recreate the VIRTUALIZETABLE Stored Procedure with the specific name DV_VIRTUALIZE_TABLE_OLD

CREATE OR REPLACE PROCEDURE DVSYS.VIRTUALIZETABLE(IN TNAME VARCHAR(128), IN TDEF VARCHAR(32672), IN VIRTSCHEMA VARCHAR(128), IN VIRTNAME VARCHAR(128), IN VIRTDEF VARCHAR(32672), IN SOURCELIST VARCHAR(2000), IN REPLACE CHAR(1), IN OPTIONSCSV VARCHAR(32672), IN TCARD BIGINT, IN COLSTATS VARCHAR(32672), OUT DIAGS VARCHAR(32672)) SPECIFIC DV_VIRTUALIZE_TABLE_OLD DYNAMIC RESULT SETS 0 NOT DETERMINISTIC EXTERNAL ACTION LANGUAGE JAVA PARAMETER STYLE JAVA NO DBINFO FENCED THREADSAFE MODIFIES SQL DATA PROGRAM TYPE SUB EXTERNAL NAME 'DVSYS.QUERYPLEX_ADMIN:com.ibm.confluence.apps.DB2AdminStoredProcedures.virtualizeTable'

GRANT EXECUTE ON SPECIFIC PROCEDURE DVSYS.DV_VIRTUALIZE_TABLE_OLD TO ROLE DV_ADMIN, ROLE DV_ENGINEER

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSK1AQ","label":"IBM Data Virtualization"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]

Was this topic helpful?

Document Information

More support for:
IBM Data Virtualization

Document number:
7233246

Modified date:
13 May 2025

UID

ibm17233246

IBM Support

Tips