In DB2, you need to know Rusnstats utility when it has to run. Ideas that are given in this post help you to make a decision.
Category: Mainframe
DB2 Collects Table statistics in an automated way. This post tells you how Optimizer uses the Statistics for a better SQL query execution plan.
Domain knowledge in auto insurance very much useful for software developers working in insurance domain. Try understand domain knowledge quickly.
Popular terms you need to know their meaning before write SAS macros. Read more.
Do review your SQL query program before put it into application program with these ideas. Read more.
DB2 host variables are really need to get data from database to application program. Read these key points.
Distributed systems all real time examples for your knowledge.
Touch base the given DB2 key sections before going for any interview. I am confidently saying you will get sure success.
