DSXchange

Hello to everyone!! Thanks for reading this post!!

Parallel - 7.0 - Unix

This is the most difficult error I have tried to debug. Any help would be greatly appreciated. I get this error when I try to use a udb stage on server A and remotely connect to server B to read a table. We are able to remotley connect to other tables, but not this table. All authorities check out and are as expected. Does anyone know what this error message is trying to tell me?

main_program: Internal Error: (k == numNodes): db2partutils.C: 713
Traceback: pureAssertion__13APT_FatalPathFPCcPCci() at 0xd4a7155c
groupNodes__11APT_DB2InfoFPCwPCwP12APT_DB2UtilsP12APT_ErrorLogPCw() at 0xd5f4236c
getTableDB2NodeMap__12APT_DB2UtilsFPCwPP8APT_NodePiPP14APT_DB2NodeSetP12APT_ErrorLogPCw() at 0xd5f429b4
describeOperator__19APT_DB2ReadOperatorFv() at 0xd5f6d358
wrapDescribeOperator__15APT_OperatorRepFv() at 0xd427cc18
check1a__15APT_OperatorRepFv() at 0xd427d7c8
sequenceAndCheck1Operators__11APT_StepRepFR12APT_ErrorLog() at 0xd4448abc
check__11APT_StepRepFv() at 0xd44480bc
check__8APT_StepFv() at 0xd4466c44
createAndCheckStep__7APT_OSLFP20APT_OSL_SIL_StepSpecR12APT_ErrorLog() at 0xd58d6a14

Morning RStone,

Can you import table MetaData from the Manager? Can you do a View-Data from the designer? If not, are the error message any clearer or different? If you can connect to other tables in the same instance but not this one then I would grab a DB/2 DBA to examine this table - does it have triggers or constraints with different grants?

This error usually mean that your metadata from that table is different. Something went wrong when you're trying to pull data, and thus...

Check your metadata.

Hi
You are saying this is a parallel job. You may want to take a look at the db2nodes.cfg. Can you tell about the partitioning info of the remote table??
Thanks