Skip to Content
0
Aug 10, 2016 at 10:06 AM

Error in configuring CIS on ASIQ-Part 2

39 Views

Dear all,


Thanks for your help in -- -- Now the CIS has been configured successfully and the test is OK--

(DBA)> forward to r1 {select count(*) from spxtest.dba.load_test};

count()

--------------------

0

(1 rows)

But still some problem in CIS -- when I create a proxy table with --

(DBA)> create existing table pr_spx_load_test at 'r1.spxtest.dba.load_test';

Could not execute statement.

The remote table 'r1.spxtest.dba.load_test' could not be found

SQLCODE=-666, ODBC 3 State="HY000"

Line 1, column 1

create existing table pr_spx_load_test at 'r1.spxtest.dba.load_test'

Press ENTER to continue...

But as my previous test -- we can see the CIS can access that load_test on remote server r1...I don't know why the "create existing table" statement can't find that remote object.

Please kind help again. Thanks


Regards

Eisen