5 top DB2 sections surely you need to touch before interview

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

Enter your email address to follow this blog and receive notifications of new posts by email.

References

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.