DSXchange

Hi,

I am trying to load data from a sequential file into a remote DB2 database table using a parallel job on aix platform. When I ran the job, I got the below error.

------------------------------------------------------------------------
main_program: Internal Error: (k == numNodes): db2partutils.C: 747
Traceback: pureAssertion__13APT_FatalPathFPCcPCci() at 0xd17db31c
groupNodes__11APT_DB2InfoFPCwPCwP12APT_DB2UtilsP12APT_ErrorLogPCw() at 0xd3d65ca8
getTableDB2NodeMap__12APT_DB2UtilsFPCwPP8APT_NodePiPP14APT_DB2NodeSetP12APT_ErrorLogPCw() at 0xd3d662c4
describeOperator__19APT_DB2LoadOperatorFv() at 0xd3da21d0
wrapDescribeOperator__15APT_OperatorRepFv() at 0xd240bb08
check1a__15APT_OperatorRepFv() at 0xd240c6cc
sequenceAndCheck1Operators__11APT_StepRepFR12APT_ErrorLog() at 0xd23cf17c
check__11APT_StepRepFv() at 0xd23ce78c
check__8APT_StepFv() at 0xd23c5780
createAndCheckStep__7APT_OSLFP20APT_OSL_SIL_StepSpecR12APT_ErrorLog() at 0xd38a26a4
------------------------------------------------------------------------

Please note that my DB2 database is partioned. I consulted my DBA and he told me to make entry of remote nodes into db2nodes.cfg file.

After making the nodes entry into db2nodes.cfg file, I also updated default.apt file to include the remote nodes and then re-ran the job and got another kind of error as given below.

STAGE_LOAN_ACCOUNT: Error Idx = 1;
DB2 Driver Embedded SQL message: SQL6031N Error in the db2nodes.cfg file at line number "". Reason code "".
;
sqlcode = -6031;
sqlstate =
Failed to connect to the database


Here is my db2nodes.cfg file.

0 ADMINBCU 0
1 DATABCU01 0
2 DATABCU01 1
3 DATABCU01 2
4 DATABCU01 3
5 DATABCU01 4
6 DATABCU01 5
7 DATABCU01 6
8 DATABCU01 7
9 DATABCU02 0
10 DATABCU02 1
11 DATABCU02 2
12 DATABCU02 3
13 DATABCU02 4
14 DATABCU02 5
15 DATABCU02 6
16 DATABCU02 7


In this file ADMINBCU, DATABCU01 and DATABCU02 are the machine names where my DB2 database is partioned with 8 partions on each DATABCU01 and DATABCU02.

Please let me know how to fix this issue. Any help on this is appreciated.

Is there a line terminator on the final line of the db2nodes.cfg file?

Hi Ray,

I appreciate your quick response. No, there is no line terminator after the final line.

Regards
Arvind

Make sure that the final line is terminated.

Added a new line character after the last line but getting the same error message again.

We have replicated the /etc/services file's servicename/port number entries of remote DB2 machine(specific to partioned database) onto local datastage server machine's /etc/services file. And then our problem was resolved.

I guess we ought not to have assumed that that configuration step had been done. Well done for solving, and well done again for a lucid post containing that solution.
:D

Hi all.

Only for information:

We had the same error message, after adding a new partition to the database (remote DB2).
After adding the new partition node to the db2nodes.cfg on the DataStage Server all jobs are running as before.

Hope that this will help someone in future cases

regards,

Sven