DB2 Partition Load Issue - Errors

[dtatem]

Good Day:

In PX, I am trying to load from a dataset into a DB2 table using the upsert mode. The property I have set for the DB2 table partition type- it defaults to DB2.

The job aborts on the following reason(s) and I am clue less on this one. Has anyone run into this before? Thanks in advance

ERROR MSG - FROM Datastage Director
main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel STD_INVOC_MTD_SUM.
The number of partitions is already constrained to 1,
but an eSame partitioned input virtual dataset produced by
parallel PDS_DATA_IN has 3.

[roy]

Hi,
Please fill in the DS version and OS your on.
Also supply the configuration your DB is on

[dtatem]

My DB2 version is 8.2.7 and OS is Unix

I hope that helps

thanks

Derrick

[DSguru2B]

How many nodes did you use to create your dataset? And how many nodes are you using in your load job?

[dtatem]

I am not familiar on how to figure out "how many nodes did I use to create your dataset? And how many nodes are you using in your load job?"

I would greatly provide the answers to you, if you can point me where to look for each one.

Thanks

dtatem

[DSguru2B]

Look in the log file of both the jobs (the job that created this dataset and the load job). Look at the 5th or 6th entry I believe, the entry will start with the line 'main_program: APT configuration file: '.

[dtatem]

Hi, thanks again for replying:

Here is what I have...I hope I provided the correct information to you...

The job that created the dataset:
node "node1"

node "node2"

node "db2node1"

The job that load the job

node "node1"

node "node2"

node "db2node1"

I hope this helps. Thanks for your time and effort

--dtatem