DB2 Warehouse on cloud currently decides the best key to use to distribute the data on event monitor tables and DOES NOT use the PARTITION_KEY column. In some circumstances the user may wish to have control over the distribution key applied.
This will avoid the user having to use ADMIN_MOVE_TABLE to redefine the distribution key straight after creating the event monitor.
Why is it useful?
|Who would benefit from this IDEA?||All users|
How should it work?
The user specifies the required distribution key within the create event monitor WRITE TO TABLE construct.
|Customer Name||Lloyds Banking Group|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions