DB2 UDB Admin Interview Questions

1/09/2010 No Comment

DB2 UDB Admin Interview Questions.

  1. If you are given with a query, how you tune it?
  2. Does runstats do a sort?
  3. Explain the steps of Server Installation?
  4. Explain the steps of Disaster Recovery?
  5. What is Incremental /Delta Back up ? 
  6. What are the db cfg parameters which affect the back up strategy?
  7. Have you worked in partitioned DB ?
  8. How to check no of active connections to the DB >> db2 list active databases 
  9. The Application team contacts saying DB response is very low what would you do ? 
  10. What is a Global Declared Temporary table ? How to use it ?
  11. What is runstats ? how it improves performance ? 
  12. What is HADR ? How to load data to a HADR Server ?
  13. SMS table space is full, file system is also full , Cannot add SAN what would you do ?
  14. Have you worked in Partitioned DB ?
  15. What are the tables spaces that get created when a DB is initially created,?
  16. What is the use of SYSCAT SPACE ?
  17. What is the use of buffer pools ? 
  18. What is buffer pool hit ratio ? 
  19. How would you see the buffer pool usage? 
  20. How do you find out deadlock transaction ? 
  21. What is Reorg check? 
  22. Whats are the different Back up types ? 
  23. Do you write shell scripts ? 
  24. Other than space utilization what is the difference between DMS and SMS ?
  25. How do you find containers that are in error with out looking into dialog ?
  26. What DB parameter must be set to allow to take incremental back up ?
Related Posts


No comments :

 

Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer