Below is the top summary of which DB2 sections you need to touch before your interview. The best method is reading questions and answers using mobile phone. The selected area here really good to revise your knowledge.
Tuning DB2
- Use of buffer pools
- Use of TableSpaces
- Tuning of SQL queries
- DB2 Optimizer
DB2 Architecture
- Plan, Bind, Packages and Collections
- Storage areas or groups
Utilities
- Load utility
- Unload utility
- Check pending, Copy pending and errors
SQL error codes
- Common error codes
- Error resolutions
- Basic SQL queries
- Writing SQL query
- Cursors
- Latest in Cursors
- JOINS
- Functions, Stored Procedure and Triggers
Application Development
- Steps to integrate DB2 in COBOL program
- Host variables
- Char and VarChar
References
