Warning in DB2 Stage

[jseclen]

Hi Forum,

In my job process reads records from a sequential file and validate this record in a db2 table, if exists perform an updated operation else insert the new record.

After run, in the director log appear this message

'DM_FCV_PROMEDIO..DB2_D_FCV_CONVERSION: This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.'

Both operation, insert and update are in the same db2 stage, with the array size 50 and transaction size 100.

Is incompatible use a same stage for both operations???

Thnks for your help.

[DSguru2B]

You cannot have array size greater than 1 for either "Update then Insert" or "Insert then Update". The array size is set to 1 and you are warned about it.
Set the array size to 1 and the warning will go away.

[jseclen]

Hi DSGuru,

This job has 2 links to the db2 stage, one for the insert and another for the update, i know there is an operation 'Update existing or insert new rows' or viceversa but im not using it.

[DSguru2B]

'DM_FCV_PROMEDIO..DB2_D_FCV_CONVERSION: This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.'

Are you sure. Double check the update action for both your links. Your error message indicates that one of them is set to 'Update Or Insert'.

[jseclen]

Yes master, i verified and anylink is seted with that Update action. Is necessary separate in two diferents db2 stages or not?

[DSguru2B]

Try with two seperate stages. Maybe db2 stage is treating two seperate links of insert and update as 'insert or update single link'. Try with two and see what happens.

[jseclen]

Ok i will change the job and apply your recommendation.

Thanks.