Trying to understand the warning message...

kaps · Post by **kaps** » Tue Apr 05, 2011 5:32 pm

I have a job to do vertical pivot meaning converting rows to columns and the Job design is as follows:

DB2 stage----Xfmr-------dedup------Db2 stage

I am sorting in DB2 stage itself and in xfmr-input partitioning, I have selected SAME as the partition type which works fine but throws the following warning message.

trn_pivot: Input dataset 0 has a partitioning method other than entire specified; disabling memory sharing.

If I select entire I am not getting the expected results. Can someone please explain why I get the warning ?

chulett · Post by **chulett** » Tue Apr 05, 2011 8:22 pm

Did you try searching the forums here? An exact search for "has a partitioning method other than entire specified; disabling memory sharing" returned over 20 matches.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 05, 2011 8:48 pm

You really need to study partitioning in greater depth.

The alert message can safely be ignored (for example demoted to Informational using a message handler). Entire partitioning uses shared memory on SMP architecture; the alert message is telling you that that can't happen because Entire is not the partitioning algorithm. I really don't know why they put that message in, to be honest.

kaps · Post by **kaps** » Wed Apr 06, 2011 10:23 am

I have already demoted it and moved the Local.msh to next environment but was wondering about the reason for the warning. It seems even Ray does not know it so I am ignoring it...

ray.wurlod · Post by **ray.wurlod** » Wed Apr 06, 2011 3:20 pm

If you read my whole message you will find that I do know.