Page 1 of 1
Trying to understand the warning message...
Posted: Tue Apr 05, 2011 5:32 pm
by kaps
I have a job to do vertical pivot meaning converting rows to columns and the Job design is as follows:
Code: Select all
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 ?
Posted: Tue Apr 05, 2011 8:22 pm
by chulett
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.
Posted: Tue Apr 05, 2011 8:48 pm
by ray.wurlod
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.
Posted: Wed Apr 06, 2011 10:23 am
by kaps
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...
Posted: Wed Apr 06, 2011 3:20 pm
by ray.wurlod
If you read my whole message you will find that I do know.
