If you are using DB2 Connect to connect to Linux DB2 from DTS package running DTS Data pump it happens because by default StaticCursor is selected and DB2 does not allow StaticCursor for Update\Inser\Delete.

You need to

1. Go to DB2 Connect Configuration Assistant

2. Right click on Alias

3. Select CLI Settings

4. Select SETTINGS tab

5. If you do not have CursorTypes property already click Add and select it from the list uncheking

STATIC checkbox

6. If you have it already click on current value and then uncheck STATIC box on pop up screen.

7. Exit saving everything

There is another way to do it thru DB2CMD utility commands. Change value to 6 or 7. Search for this command syntax on Google...

Note: On my workstation change was in effect imidiately, but on the server it required reboot. I do not know why...