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 ?
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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...