Touch base the given DB2 key sections before going for any interview. I am confidently saying you will get sure success.
In DB2 database there are many ways to achieve performance. I explained one way here. Read more.
Index is popular object in DB2 SQL. Popular questions to your instant knowledge given for quick reference.
All you need to know about Cursor the real use and how it works on commit or Rollback scenarios. Really useful information for SQL professionals.
Database administrator’s function is not cakewalk. It is involved many functions starting from creating a database to maintain its objects. DBA has to monitor all of its objects such as Tables, Views, Indexes, Triggers, Stored procedures etc. Any database these are comman.
DBA primary role is access- control. DB2 has many in-built security features and authority controls. These questions really good to know by DBA.
REORG is a useful utility in DB2. While Loading or Unloading, you get different errors. Run this utility to resolve your errors.
DB2 Load utility with example and explained the key phrases. These are really good to have knowledge before you start working on it.