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.
DB2partutil Error
Moderators: chulett, rschirm, roy
DB2partutil Error
Arvind
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
:D
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
another solution for
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
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