Troubleshooting
Problem
With IS 11.7.1.3 ( to be specific with JR65023), the update and update then insert jobs are not giving expected results, when the Record Count and Array Size values of the ODBC Connector stage properties are not the same and there are any problems in doing the bulk operations.
Symptom
Not all records were updated or update then inserted.
Cause
When Record Count and Array Size values are not same, the update/update then insert jobs do not work as expected.
Environment
IS 11.7.1.3 or JR65023 patch level, on all platforms.
Diagnosing The Problem
There could be difference in the actual rows to be updated or inserted, versus expected number.
Resolving The Problem
Apply the patch DT143715 and set ISBatchSizeForUpdate connection parameter in respective ODBC DSN as shown below.
Added new DSN property “ISBatchSizeForUpdate” where customer can add “ISBatchSizeForUpdate”to the respective ODBC DSN stanza and set the value which will be used for ArraySize and RecordCount.
For example:
[MSSQL]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls00.so
Description=DataDirect SQL Server Native Wire Protocol
AEKeystoreLocation=
AEKeystoreSecret=
...
...
...
ISBatchSizeForUpdate=2000 set the desired value for update/update then insert statements.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"ARM Category":[{"code":"a8m50000000L0y3AAC","label":"DataStage-\u003EJob Stages-\u003EDatabase Stages-\u003EODBC Connector"}],"ARM Case Number":"TS009032182","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.1"}]
Historical Number
JR65023
Product Synonym
Not updating all records.
Was this topic helpful?
Document Information
Modified date:
06 September 2022
UID
ibm16615967