---
title: "5 Key DB2 Topics to Read Before Your Interview"
description: "Touch base the given DB2 key sections before going for any interview. I am confidently saying you will get sure success."
url: https://srinimf.com/2018/04/28/5-top-db2-sections-you-need-to-touch/
date: 2018-04-28
modified: 2020-06-18
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2018/04/pexels-photo-321339-e1524896417167.jpeg?fit=500%2C371&ssl=1
categories: ["Categories", "DB2"]
tags: ["Db2 Tips", "Interview Questions"]
type: post
lang: en
---

# 5 Key DB2 Topics to Read Before Your 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

## Subscribe to Blog via Email

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

Email Address

Subscribe

***References***

- [Mainframe material downloads](https://srinimf.com/2015/11/28/mainframe-self-study-materials-with-complex-interview-questions/)

### Share this:

-
- [Tweet](https://twitter.com/share)
- [![](https://i0.wp.com/assets.pinterest.com/images/pidgets/pinit_fg_en_rect_gray_20.png)](https://www.pinterest.com/pin/create/link/?url=https%3A%2F%2Fsrinimf.com%2F2018%2F04%2F28%2F5-top-db2-sections-you-need-to-touch%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2018%2F04%2Fpexels-photo-321339-e1524896417167.jpeg%3Ffit%3D500%252C371%26ssl%3D1&description=5%20Key%20DB2%20Topics%20to%20Read%20Before%20Your%20Interview)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2018/04/28/5-top-db2-sections-you-need-to-touch/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2018/04/28/5-top-db2-sections-you-need-to-touch/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2018/04/28/5-top-db2-sections-you-need-to-touch/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2018/04/28/5-top-db2-sections-you-need-to-touch/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%205%20Key%20DB2%20Topics%20to%20Read%20Before%20Your%20Interview&body=https%3A%2F%2Fsrinimf.com%2F2018%2F04%2F28%2F5-top-db2-sections-you-need-to-touch%2F&share=email)
-

### Like this:

Like Loading…