Load error to DB2 partiotioned table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
myukassign
Premium Member
Premium Member
Posts: 238
Joined: Fri Jul 25, 2008 8:55 am

Load error to DB2 partiotioned table

Post by myukassign »

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"
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Re: Load error to DB2 partiotioned table

Post by kwwilliams »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
myukassign
Premium Member
Premium Member
Posts: 238
Joined: Fri Jul 25, 2008 8:55 am

Post by myukassign »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You may find a more meaningful error message in the node agent log.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply