Unable to obtain DB2 partition information

[chandra.shekhar@tcs.com]

Hi Team ,

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

Code: Select all

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

[priyadarshikunal]

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.

[chulett]

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

[ray.wurlod]

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

[chandra.shekhar@tcs.com]

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