IBM Maximo: System Properties: Difference between revisions

From Wiki
No edit summary
No edit summary
Line 1: Line 1:
= Query to list all System Properties=


select MP.PROPNAME, MP.DESCRIPTION, MPV.PROPVALUE
from MAXPROP MP, MAXPROPVALUE MPV
where MP.PROPNAME = MPV.PROPNAME
and MPV.PROPVALUE IS NOT NULL
order by MP.PROPNAME
order by WFCONDITION.PROCESSNAME, WFCONDITION.NODEID;
Tip from: [https://www.youtube.com/watch?v=PL0WWmiCnY4 Maximo Listing all System Properties for easy viewing]
= System Properties =




Revision as of 11:45, 21 January 2022

Query to list all System Properties

select MP.PROPNAME, MP.DESCRIPTION, MPV.PROPVALUE
from MAXPROP MP, MAXPROPVALUE MPV
where MP.PROPNAME = MPV.PROPNAME 
and MPV.PROPVALUE IS NOT NULL
order by MP.PROPNAME

order by WFCONDITION.PROCESSNAME, WFCONDITION.NODEID;

Tip from: Maximo Listing all System Properties for easy viewing

System Properties

Variable Description Articles
mxe.mbocount

Provê os seguintes valores (por minuto):

  • Maximo Business Objects (MBOs) loaded
  • Total users
  • Users connected to each JVM in the system
  • Cron Tasks Running on JVMs
  • Total memory allocated and memory available
mxe.db.FetchResultLogLimit Example
mxe.db.logSQLPlan (Oracle only) Registrar plano de execução para varreduras de tabelas completas
mxe.db.logSQLTimeLimit Registrar as operações SQL que excedem o limite de tempo (milissegundos)
mxe.db.sqlTableScanExclude (Oracle only)
Example Example Example
Example Example Example

Ver também

Retrieved from "https://ebasso.net/wiki/index.php?title=IBM_Maximo:_System_Properties&oldid=7333"