DSXchange

Posted: **Sun Mar 01, 2015 12:58 am**

Hi Team ,

We have migrated the db2 database and while pointing ETl to new database we are facing below error

The connector was not able to obtain partitioning information for the table <TABLE NAME> in the database <DATABASE NAME> The method sqlugtpi returned reason code 0, SQLCODE -551. Ensure that the table exists and that it can be accessed. (CC_DB2Adapter::obtainPartitioningInfoForTable, file CC_DB2Adapter.cpp, line 1,661)

Please Suggest.

Thanks

Posted: **Sun Mar 01, 2015 5:34 am**

whats the point on re activating a 5 year old post where the answer would still be the same. talk to your DBA to get correct permission granted.

Posted: **Sun Mar 01, 2015 8:34 am**

Agreed so off you go to your own post but linked back to the original. Please come back and let us know your resolution.

Posted: **Sun Mar 01, 2015 3:58 pm**

This may also require SELECT privilege on the system table(s) in which partitioning information is recorded.

Posted: **Tue Mar 03, 2015 1:11 am**

Team,
We have resolved the issue after executing below two commands.

db2 bind @db2ubind.lst blocking all grant public
db2 bind @db2cli.lst blocking all grant public

Thanks

DSXchange

Unable to obtain DB2 partition information

Unable to obtain DB2 partition information