Maximo

Maximo-ICON.png

Maximo

Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.

Maximo-ICON.png

TRIRIGA

Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.

Maximo-ICON.png

Engineering

Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

how to increase Maximum length DATATYPE ALN over 4000

Jump to Best Answer
  • 1.  how to increase Maximum length DATATYPE ALN over 4000

    Posted Thu August 27, 2020 11:45 AM
    In IBM Maximo 76 installed on IBM DB2 database I have the WHERE column of MAXVIEWCFG table that I can't extend over 4000 characters through ALTER TABLE.
    Below is a table of the IBM link that shows that it could be increased beyond 30K.

    ALN

    Alphanumeric characters, mixed case

    Maximum length depends on the database:
    • Oracle = 4000 characters
    • SQL Server = 8000 characters
    • DB2® = 32672 characters
    How can I do it?
    Thank you

    ------------------------------
    Giovanni Mininni
    ------------------------------


  • 2.  RE: how to increase Maximum length DATATYPE ALN over 4000
    Best Answer

    Posted Fri August 28, 2020 06:47 AM
    MAXVIEWCFG is an internal table (flagged as internal=1 on the maxobject/maxobjectcfg tables). Any core table like this you shouldn't adjust. It's not officially supported and you run the risk that your changes will be lost on an upgrade or where clause truncated inside of the code base because they aren't expect something greater than 4000 characters. Similar situation goes for attributes that are flagged as MUSTBE. 

    What I would suggest instead is creating a database view in DB2 directly and then creating a view in Maximo that queries your other view. It's hacky, but it's something we've had to do before to get around the size limitations.

    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------



  • 3.  RE: how to increase Maximum length DATATYPE ALN over 4000

    Posted Mon August 31, 2020 04:17 AM
    Hi,

    This technote may help you.

    https://www.ibm.com/support/pages/changes-specifying-size-field-displays-ui-maximo-7#:~:text=The%20field%20display%20size%20is,the%20column%20in%20the%20database.

    Thanks

    ------------------------------
    Zarinah Jalani
    ------------------------------



  • 4.  RE: how to increase Maximum length DATATYPE ALN over 4000

    Posted Mon August 31, 2020 04:35 AM
    Hi Zarinah and thanks for the support but I need to extend the field to database level and not UI.

    Thanks again

    ------------------------------
    Giovanni Mininni
    ------------------------------



  • 5.  RE: how to increase Maximum length DATATYPE ALN over 4000

    Posted Mon August 31, 2020 04:39 AM
    Hi Steven,
    I think I will definitely try your solution.
    Thanks to all.

    Regards

    ------------------------------
    Giovanni Mininni
    ------------------------------