ArraySize/Transaction Size
Posted: Wed Sep 05, 2007 7:51 pm
I have a target DB2 Stage with the Array size Set to 1 and Transaction size set to 100. when I set a the array size to 50 I get a warning in the director log. the update action s set to " Update or insert" .
What would be a reccomended setting for these two sizes to get a decent performance?
Would it be different for a Stage with update action "Clear and Insert" ?
What would be a reccomended setting for these two sizes to get a decent performance?
Would it be different for a Stage with update action "Clear and Insert" ?