MxLoader

Hi,  Our Maximo Admins have run into issues updating a field for a table with 250,000+ rows.  Is there something in MXLoader configuration to accommodate large number of records to update?  I have "heard" there is.

Thank you,

Claudia Cox

------------------------------
Claudia Cox
City of Henderson
------------------------------

Hi @Claudia Cox 

I see 2 parameters that are: 

Maximum objects: Maximum number of rows that can be retrieved with a Query request. Set to 0 to disable (not recommended).

Batch size: If you want to split the updates that MxLoader sends to the server you can set this value to 1 or more. Set it to 0 to disable (default). This setting is used only for Sync and Delete operations.

Since there are 250,000, you could create batches of 10,000 each (25 batches).

Regards!

------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------