DSXchange

Posted: **Thu Jul 28, 2016 4:37 am**

Dear All,

I'm testing the result of number of tables output by using CheckSum(ComputationMode=Use All columns) , and the source DB2 Connector setup as RCP (Runtime Column Propagation) and its work fine.

Db2Connector --> CheckSum-- SequentialFile

The above is working fine, the problem is in follow using NZ connector

Now the same test when I used for Netezza Connector using RCP and using CheckSum feed into file its generate the following error:

Code: Select all

Netezza_Connector_0: None of the columns from the output link schema matched any of the columns in the table PP_STAGING_.TestTable (CC_NZMetadataHelper::reconcileOutputLinkSchema, file CC_NZMetadataHelper.cpp, line 1,258)

Using the Datastagate 8.7, Parallel Job

Appreciate your help

Posted: **Fri Jul 29, 2016 2:37 am**

As i've found Netezza Connector giving problem. I've replaced with ODBC Connector and its work
Comparing two database output result

Code: Select all

DB2_Connector ----->CheckSum--->SequFile [Already Working]
Netezza_Connector---->CheckSum--->SeqFile [ Not Working ]
ODBC_Connector----->CheckSum--->SeqFile [Working ]

I simply validate/check the output table resulf of Migrated database into Netezza from DB2 check of each table contents. Further I'm checking using md5Sum functionality to compare the output result

Code: Select all

c:\>md5sum - b db2f_ile.csv nz_file.csv

Don't know whyt it not working with Netezza Connector
Thanks
Farhan

Posted: **Fri Jul 29, 2016 6:21 am**

Support.

DSXchange

Netezza_Connector RCP CheckSum

Netezza_Connector RCP CheckSum

Use the ODBC Connector