SQL Warehouse Cleanup Methods

16 Questions

What happens when the CLEANUP script is configured to run on all entities in the DB?

It truncates the Warehouse tables and finishes quickly

Why does adding entities into the DB cause the CLEANUP script to run drastically slower?

Because it introduces new entities that need to be cleaned up

What could be a potential cause if the cleanup process is hanging or taking a long time to complete?

Insufficient resources like memory or CPU time

In what system state does All engines are up (depending whether it is run before or after the stop engines) occur?

System state upon failure of the PS Engine state

What will happen if there are locks on the PS_%_EGC tables in the database during the cleanup process?

You may need to kill the sessions holding the locks

What can be done if the cleanup process is resource-intensive and needs more memory or CPU time?

Increase the memory allocated to the Murex Warehouse or increase the number of processing units

What can be a possible cause if the Stop Engine process is hanging or taking a long time to complete?

Insufficient resources

What might need to be done if there are locks on the PS_%_EGC tables during the Stop Engine process?

Kill the sessions holding the locks

In case the STOPENGINE processing unit fails with a specific error related to a particular engine, what action can be taken?

Updating the engine table to the stopped state

What should be done if the rebuild process is hanging due to a large number of entries in the PS_%_E tables?

Increase consolidation date to reduce the number of entries

If the cleanup script has errors or is configured incorrectly, what action is suggested?

Debugging the cleanup script

What action should be taken if there are hanging or performance problems related to the stop script?

Reviewing configuration settings of cleanup script

What step can be taken if the Stop Engine process is unable to stop a specific engine?

Updating the engine table to stopped state

How can excessive resource consumption during the rebuild process be addressed?

Increasing number of processing units

What is suggested if there are performance issues due to insufficient resources during the Stop Engine process?

Increasing memory allocated to Murex Warehouse

What would be a potential cause of hanging or performance problems during the rebuild process?

Insufficient resources

Test your knowledge about the two different methods used to clean up Warehouse tables in SQL scripts. Learn about the impact of configurations on the cleanup process and how it can affect the performance of the script.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.