Podcast
Questions and Answers
What happens when the CLEANUP script is configured to run on all entities in the DB?
What happens when the CLEANUP script is configured to run on all entities in the DB?
- It slows down considerably
- It replaces truncate statements with delete statements
- It adds more entities into the DB
- It truncates the Warehouse tables and finishes quickly (correct)
Why does adding entities into the DB cause the CLEANUP script to run drastically slower?
Why does adding entities into the DB cause the CLEANUP script to run drastically slower?
- Because it causes the script to replace truncate statements with delete statements
- Due to insufficient memory allocated to the Murex Warehouse
- It has no impact on the speed of the cleanup script
- Because it introduces new entities that need to be cleaned up (correct)
What could be a potential cause if the cleanup process is hanging or taking a long time to complete?
What could be a potential cause if the cleanup process is hanging or taking a long time to complete?
- Not enough processing units
- The addition of new entities into the DB
- Locks on the PS_%_EGC tables
- Insufficient resources like memory or CPU time (correct)
In what system state does All engines are up (depending whether it is run before or after the stop engines) occur?
In what system state does All engines are up (depending whether it is run before or after the stop engines) occur?
What will happen if there are locks on the PS_%_EGC tables in the database during the cleanup process?
What will happen if there are locks on the PS_%_EGC tables in the database during the cleanup process?
What can be done if the cleanup process is resource-intensive and needs more memory or CPU time?
What can be done if the cleanup process is resource-intensive and needs more memory or CPU time?
What can be a possible cause if the Stop Engine process is hanging or taking a long time to complete?
What can be a possible cause if the Stop Engine process is hanging or taking a long time to complete?
What might need to be done if there are locks on the PS_%_EGC tables during the Stop Engine process?
What might need to be done if there are locks on the PS_%_EGC tables during the Stop Engine process?
In case the STOPENGINE processing unit fails with a specific error related to a particular engine, what action can be taken?
In case the STOPENGINE processing unit fails with a specific error related to a particular engine, what action can be taken?
What should be done if the rebuild process is hanging due to a large number of entries in the PS_%_E tables?
What should be done if the rebuild process is hanging due to a large number of entries in the PS_%_E tables?
If the cleanup script has errors or is configured incorrectly, what action is suggested?
If the cleanup script has errors or is configured incorrectly, what action is suggested?
What action should be taken if there are hanging or performance problems related to the stop script?
What action should be taken if there are hanging or performance problems related to the stop script?
What step can be taken if the Stop Engine process is unable to stop a specific engine?
What step can be taken if the Stop Engine process is unable to stop a specific engine?
How can excessive resource consumption during the rebuild process be addressed?
How can excessive resource consumption during the rebuild process be addressed?
What is suggested if there are performance issues due to insufficient resources during the Stop Engine process?
What is suggested if there are performance issues due to insufficient resources during the Stop Engine process?
What would be a potential cause of hanging or performance problems during the rebuild process?
What would be a potential cause of hanging or performance problems during the rebuild process?