Thanks Steven from your answer, Can I use truncate for all work order related table. (WORKORDER+WPMATERiAL+LABTRAN) Actually we have a non-production environment and storage, so we nee free up some space. -Naveed ------------------------------ ...

Hi JustIn So, I stand confused. You want to null out a field that is captured by the audit. That nodoes not make sense to me. The whole purpose of auditing is to capture data that has been changed. Q: Do you want the field itself to be one of the ...

I have an escalation that has three "setvalue" actions (two YORN and a date/time of now()). The "Repeat?" flag is not set in the escalation point definition, but the actions are executed every time the escalation runs. The problem is the date/time is ...

Hi Maximo Open Forum, What is one of the best ways to message all or certain users in your Maximo system? Some like to say it is Maximo's Bulletin Board feature. This feature typically either is widely used by an organization, or not at all. The ...

If you don't need the data, the best way is absolutely to truncate the table (TRUNCATE TABLE A_WORKORDER IMMEDIATELY). To get the total size of the table in DB2 you can use something like this: SELECT (data_object_p_size + index_object_p_size ...