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
------------------------------
Original Message:
Sent: Thu August 27, 2020 11:32 AM
From: Giovanni Mininni
Subject: how to increase Maximum length DATATYPE ALN over 4000
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
------------------------------
#Maximo
#AssetandFacilitiesManagement