|When you attempt to use one SQL statement to select data from a data source |and insert, update, or delete the data directly in an MPP partitioned table on |your DB2 federated server, you will receive the SQL0901N error. The |federated functionality does not allow you to select from a nickname and |insert into an MPP partitioned table.
|Once you apply FixPak 4 (or above), you can use these steps to select data |and insert the data into an MPP partitioned table: |
| EXPORT DB2NODE=x
|where x is a node number.
| CREATE NODEGROUP nodegroup_name ON NODE(x)
|where x is the node number.
|CREATE TABLESPACE tablespace_name IN NODEGROUP nodegroup_name
|CREATE TABLE temp_table_name IN tablespace_name
|Dividing the INSERT statement into two statements changes the statement |level commit and rollback semantics. For example, instead of rolling |back one statement, you will now have to rollback two statements. |Additionally, if you change the node number associated with the DB2NODE |environment variable, you must invalidate the application package and |rebind.
|These steps allow you to select data from data sources and insert the data |into an MPP partitioned table. You will still receive the SQL0901N |error when you attempt to use one statement to select data from a data source |and update or delete the data in an MPP partitioned table. This |restriction will be elimiated in DB2 Universal Database Version 8.