Updating Partition Key with Before Trigger

[jbaker]

We are looking at the possibility of using a before trigger to provide
the value for the partitioning key of a table. It strikes me as
something that would not work, but I have been surprised before. Does
anyone know whether this is allowed with DB2 8.2 or not?

thanks

Jack

[mirof007]

Why not simply try it? ;-) Yes, this is allowed both in before and in
after triggers. Has been since DB2 UDB for L/U/W Version 8.1.

Regards,
Miro

[jbaker]

Well, in case anyone is interested, I did try it. It does seem to
work, I am surprised. I would have expected the before trigger to be
executed after the insert was routed to a partition. Obviously, that
is not exactly what it happening.

Jack

mi******@gmail.com wrote:

Why not simply try it? ;-) Yes, this is allowed both in before and in
after triggers. Has been since DB2 UDB for L/U/W Version 8.1.

Regards,
Miro

[Mark A]

<jb****@marketron.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...

Well, in case anyone is interested, I did try it. It does seem to
work, I am surprised. I would have expected the before trigger to be
executed after the insert was routed to a partition. Obviously, that
is not exactly what it happening.

Jack

Somehow I am thinking this is not very efficient since the partition that
gets the row, then has to then send it to another partition. There are
better ways to force data to be loaded on a specific partition, unless
performance is not at all an issue (in which case I wonder why you are using
DPF).