ERROR in DB2 stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
ERROR in DB2 stage
Hi
I have parallel job as...
dataset---->transformer---->db2 stage
I tried to update the record with few key column's. And i'm getting the error as....
main_program: Internal Error: (k == numNodes): db2partutils.C: 726
Traceback: pureAssertion__13APT_FatalPathFPCcPCci() at 0xd97c8554
groupNodes__11APT_DB2InfoFPCwPCwP12APT_DB2UtilsP12APT_ErrorLogPCw() at 0xdab5c5e8
getTableDB2NodeMap__12APT_DB2UtilsFPCwPP8APT_NodePiPP14APT_DB2NodeSetP12APT_ErrorLogPCw() at 0xdab5cc04
describeOperator__21APT_Db2UpsertOperatorFv() at 0xdaba3240
wrapDescribeOperator__15APT_OperatorRepFv() at 0xd90cec68
check1a__15APT_OperatorRepFv() at 0xd90cf818
sequenceAndCheck1Operators__11APT_StepRepFR12APT_ErrorLog() at 0xd911437c
check__11APT_StepRepFv() at 0xd911398c
check__8APT_StepFv() at 0xd910aa20
createAndCheckStep__7APT_OSLFP20APT_OSL_SIL_StepSpecR12APT_ErrorLog() at 0xda63499c
Thanks & Regards..
JIM
I have parallel job as...
dataset---->transformer---->db2 stage
I tried to update the record with few key column's. And i'm getting the error as....
main_program: Internal Error: (k == numNodes): db2partutils.C: 726
Traceback: pureAssertion__13APT_FatalPathFPCcPCci() at 0xd97c8554
groupNodes__11APT_DB2InfoFPCwPCwP12APT_DB2UtilsP12APT_ErrorLogPCw() at 0xdab5c5e8
getTableDB2NodeMap__12APT_DB2UtilsFPCwPP8APT_NodePiPP14APT_DB2NodeSetP12APT_ErrorLogPCw() at 0xdab5cc04
describeOperator__21APT_Db2UpsertOperatorFv() at 0xdaba3240
wrapDescribeOperator__15APT_OperatorRepFv() at 0xd90cec68
check1a__15APT_OperatorRepFv() at 0xd90cf818
sequenceAndCheck1Operators__11APT_StepRepFR12APT_ErrorLog() at 0xd911437c
check__11APT_StepRepFv() at 0xd911398c
check__8APT_StepFv() at 0xd910aa20
createAndCheckStep__7APT_OSLFP20APT_OSL_SIL_StepSpecR12APT_ErrorLog() at 0xda63499c
Thanks & Regards..
JIM
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
Hi
My data stage configuration file looks like...
main_program: APT configuration file: /dsadm/Ascential/DataStage/Configurations/GlxDB2ETL_Small.apt
{
node "etl_8005"
{
fastname "dbsp8005"
pools "" "etl"
resource disk "/pxwork" {pools "" "export"}
resource scratchdisk "/pxscratch" {pools ""}
}
node "db2_8003"
{
fastname "dbsp8003"
pools "db2"
resource disk "/pxwork" {pools "" "export"}
resource scratchdisk "/pxscratch" {pools ""}
}
node "db2_8004"
{
fastname "dbsp8004"
pools "db2"
resource disk "/pxwork" {pools "" "export"}
resource scratchdisk "/pxscratch" {pools ""}
}
}
Can you please tell me how to find the db2 nodes configuration file...?
Thanks,
JIM
My data stage configuration file looks like...
main_program: APT configuration file: /dsadm/Ascential/DataStage/Configurations/GlxDB2ETL_Small.apt
{
node "etl_8005"
{
fastname "dbsp8005"
pools "" "etl"
resource disk "/pxwork" {pools "" "export"}
resource scratchdisk "/pxscratch" {pools ""}
}
node "db2_8003"
{
fastname "dbsp8003"
pools "db2"
resource disk "/pxwork" {pools "" "export"}
resource scratchdisk "/pxscratch" {pools ""}
}
node "db2_8004"
{
fastname "dbsp8004"
pools "db2"
resource disk "/pxwork" {pools "" "export"}
resource scratchdisk "/pxscratch" {pools ""}
}
}
Can you please tell me how to find the db2 nodes configuration file...?
Thanks,
JIM
The db2nodes dataset is in the sqllib directory.
Check your db2 path. The file will have the node, host, and partition number. The host, has to exactly match your specifications of fastname.
Some files have more that one name specified and that's okay, as long qs you have a fastname matching that specifies each node.
Ande
Check your db2 path. The file will have the node, host, and partition number. The host, has to exactly match your specifications of fastname.
Some files have more that one name specified and that's okay, as long qs you have a fastname matching that specifies each node.
Ande
Ande
"So, you think this will work?"
"So, you think this will work?"
-
- Participant
- Posts: 32
- Joined: Wed Dec 28, 2005 9:02 pm
My understanding on your explaination:The db2nodes dataset is in the sqllib directory.
Check your db2 path. The file will have the node, host, and partition number. The host, has to exactly match your specifications of fastname.
Some files have more that one name specified and that's okay, as long qs you have a fastname matching that specifies each node.
When i look on db2nodes.cfg, it contains
0 example001 0
0 - node
example001 - host
0 - partition number
I search my configuration files,
{
node "sample001"
{
fastname "example001"
pools ""
resource disk "/home/dsadm/Ascential/DataStage/Datasets" {pools ""}
resource scratchdisk "/home/dsadm/Ascential/DataStage/Scratch" {pools ""}
}
}
The "example001" which i bold it must be the same.
Please correct me if i'm wrong.
![Wink :wink:](./images/smilies/icon_wink.gif)
I have one more doubt, does "node sample001" use in any configuration files?
![Embarassed :oops:](./images/smilies/icon_redface.gif)
Thank you
-
- Participant
- Posts: 34
- Joined: Thu Feb 16, 2006 8:34 am
- Location: mumbai
well, if all you have on DB2 is some example data, you're fine. Now if you really have a partitioned db2 database, your path is wrong an pointing to the wrong set of db2 libraries and sqllib.
Partition number 0 is usually used for the DB2 catalog.
One partition does not make a partitioned database. It's not that you can't have a partitioned database with one partition, but what's the point?
I think you need to talk to your DBA.
Partition number 0 is usually used for the DB2 catalog.
One partition does not make a partitioned database. It's not that you can't have a partitioned database with one partition, but what's the point?
I think you need to talk to your DBA.
Ande
"So, you think this will work?"
"So, you think this will work?"