MxLoader

 View Only
  • 1.  MXLoader Update Row Limitation

    Posted 08-13-2024 16:28

    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
    ------------------------------



  • 2.  RE: MXLoader Update Row Limitation

    Posted 08-16-2024 16:29

    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
    ------------------------------



Newest Episode
Ep. 10 | How Naviam DataStudio Makes Data Imports Easier with Lee Daley

Steven Shull and Lee Daley explore how Naviam DataStudio helps IBM Maximo teams simplify bulk data imports, validate information before loading, and improve data quality and management.

MORE by Naviam Episode 10: How Naviam DataStudio Makes Data Imports Easier with Lee Daley
Watch Episode 10
Also available: Ep. 9 | Best Maximo Resources to Stay Informed