DSXchange

Hi... I am getting a very unusual error and the error is throwing from main program not from any stage I used in the job. Let me explain what I am doing in my job

1. DS --------> DB2 EnterpriseStage.
2. My target table is a partitioned table. The data from my DS is correct and all are with in the partion limits. but error is throwing.

Note: To test any pblm in my connection, I created a simple partioned test table and write data to it and its working no problem. I even test with data taht is outbound to the partion still no abort only the job gracefully ignoring records.

But not sure why my orginal job is not running. The error it throws is given below Please help me .The sad part is, its not giving any clue why this error is coming, the only word tht throws some light is "db2parutils"

"main_program: Internal Error: (k == numNodes): db2partutils.C: 772
Traceback: pureAssertion__13APT_FatalPathFPCcT1i() at 0x9000000022600d8
groupNodes__11APT_DB2InfoFPCUsT1P12APT_DB2UtilsP12APT_ErrorLogT1() at 0x900000009bb732c
getTableDB2NodeMap__12APT_DB2UtilsFPCUsPP8APT_NodePiPP14APT_DB2NodeSetP12APT_ErrorLogT1() at 0x900000009bb7c50
describeOperator__21APT_Db2UpsertOperatorFv() at 0x900000009ba696c
wrapDescribeOperator__15APT_OperatorRepFv() at 0x9000000015ffdd4
check1a__15APT_OperatorRepFv() at 0x9000000016014a4
sequenceAndCheck1Operators__11APT_StepRepFR12APT_ErrorLog() at 0x900000001863a88
check__11APT_StepRepFv() at 0x9000000018635b0
check__8APT_StepFv() at 0x90000000185a6a8
createAndCheckStep__7APT_OSLFP20APT_OSL_SIL_StepSpecR12APT_ErrorLog() at 0x900000007e86804
.() at 0x1000069e8
APT_PMconductorMain__FPFiPPc_i() at 0x900000001bd7240
APT_SharedMain__FiPPcPFiPPc_i() at 0x900000001bd5a1c
.() at 0x10000ea74"

viewtopic.php?t=123474&start=0&postdays ... 61310eae57

When your support provider gives you a reason for the issue, it would be nice if you posted it back here for some resolution.

Does the db2nodes configuration file have the same number (and names) of nodes as does the parallel execution configuration file? Are you working in a DPF environment?

ray.wurlod wrote:Does the db2nodes configuration file have the same number (and names) of nodes as does the parallel execution configuration file? Are you working in a DPF environment?

spot on ... that was the issue db2nodes.cfg , I was missing the dbserver entry.

Sad that Datastage should have thorwn some meaningful connectivity error than this no clue error

You may find a more meaningful error message in the node agent log.