SQL Warehouse Cleanup Methods
16 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

  • 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?

  • 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?

    <p>System state upon failure of the PS Engine state</p> Signup and view all the answers

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

    <p>You may need to kill the sessions holding the locks</p> Signup and view all the answers

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

    <p>Increase the memory allocated to the Murex Warehouse or increase the number of processing units</p> Signup and view all the answers

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

    <p>Insufficient resources</p> Signup and view all the answers

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

    <p>Kill the sessions holding the locks</p> Signup and view all the answers

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

    <p>Updating the engine table to the stopped state</p> Signup and view all the answers

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

    <p>Increase consolidation date to reduce the number of entries</p> Signup and view all the answers

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

    <p>Debugging the cleanup script</p> Signup and view all the answers

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

    <p>Reviewing configuration settings of cleanup script</p> Signup and view all the answers

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

    <p>Updating the engine table to stopped state</p> Signup and view all the answers

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

    <p>Increasing number of processing units</p> Signup and view all the answers

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

    <p>Increasing memory allocated to Murex Warehouse</p> Signup and view all the answers

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

    <p>Insufficient resources</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser