---
title: "How to know Your Version of DB2 in Mainframe"
description: "DB2 Version in Mainframe"
url: https://srinimf.com/2015/08/31/how-to-know-your-version-of-db2-in-mainframe/
date: 2015-08-31
modified: 2026-10-10
author: "Srini"
image: https://i0.wp.com/srinimf.com/wp-content/uploads/2015/08/pexels-photo-4555524.jpeg?fit=1880%2C1253&ssl=1
categories: ["DB2"]
tags: ["DB2 Tips and Solutions", "How to find DB2 version in mainframe"]
type: post
lang: en
---

# How to know Your Version of DB2 in Mainframe

Here’re ways to find DB2 version information in Mainframe. It’s also tricky interview question. So helpful for interviews and project.

AS DB2 goes through V8, V9, and now V10 with different mode levels (Compatibility mode, Enabling New Function mode, and New Function mode), it is important [to know](https://srinimf.com/2016/01/07/how-to-know-new-ispf-version-changes-with-sarea-command/) which version is running in the subsystem you are working in. Many shops have different subsystems in different versions, especially in their test environment.

![DB2 version](https://i0.wp.com/d2lm6fxwu08ot6.cloudfront.net/img-thumbs/960w/MG5FWY43TN.jpg?resize=480%2C408&ssl=1)*Image courtesy|Stocksnap.io*

It is very important for developers to know the DB2 Version. So that they can use features or functions correctly.

## Here’re 2 Ways to Find DB2 Version

### 1. Choose DISPLAY GROUP from the DB2I menu

```
DISPLAY GROUP (DB2)
```

The DB2® command DISPLAY GROUP displays information about the data sharing group to which a DB2 subsystem belongs.

```
-DISPLAY GROUP
```

DISPLAY GROUP DETAIL displays the DB2 subsystem and group mode (conversion mode, enabling new function mode, or DB2 Version 8 new-function mode or later).

**Abbreviation**:

```
-DIS GROUP
```

---

---

## 2. Run the GETVARIABLE SQL query

```
SELECT GETVARIABLE('SYSIBM.VERSION')
FROM 
SYSIBM.SYSDUMMY1
```

**A string comes back with the following:**

- PPP is the product string, set to:   **DSN**
- VV is a two-digit version identifier, such as: **09**.
- RR is a two-digit release identifier, such as: **01.**
- M is a one-digit maintenance-level identifier, such as **5**.

You can execute either of these in the subsystem you’re currently working in. **Remember that each subsystem could be under different versions and releases.**

Related Posts

- [Top DB2 DBA Tricky Interview Questions](https://srinimf.com/2015/07/09/mainframe-top-db2-dba-interview-questions-1-of-5/)DateJuly 9, 2015
- [DB2 Distributed Computing – How it Works](https://srinimf.com/2015/11/30/everything-you-need-to-know-about-db2-distributed-computing/)DateNovember 30, 2015
- [How to Fix Sqlcode 204 Sqlstate 42704 in DB2](https://srinimf.com/2023/07/03/what-is-the-204-error-in-db2-how-to-resolve-it/)DateJuly 3, 2023

### 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%2F2015%2F08%2F31%2Fhow-to-know-your-version-of-db2-in-mainframe%2F&media=https%3A%2F%2Fi0.wp.com%2Fsrinimf.com%2Fwp-content%2Fuploads%2F2015%2F08%2Fpexels-photo-4555524.jpeg%3Ffit%3D1200%252C800%26ssl%3D1&description=How%20to%20know%20Your%20Version%20of%20DB2%20in%20Mainframe)
-
- [Share on Tumblr](https://www.tumblr.com/share)
- [Share on WhatsApp (Opens in new window) WhatsApp](https://srinimf.com/2015/08/31/how-to-know-your-version-of-db2-in-mainframe/?share=jetpack-whatsapp)
- [More](#)
-

- [Print (Opens in new window) Print](https://srinimf.com/2015/08/31/how-to-know-your-version-of-db2-in-mainframe/?share=print)
- [Share on Reddit (Opens in new window) Reddit](https://srinimf.com/2015/08/31/how-to-know-your-version-of-db2-in-mainframe/?share=reddit)
- [Share on Telegram (Opens in new window) Telegram](https://srinimf.com/2015/08/31/how-to-know-your-version-of-db2-in-mainframe/?share=telegram)
- [Email a link to a friend (Opens in new window) Email](mailto:?subject=%5BShared%20Post%5D%20How%20to%20know%20Your%20Version%20of%20DB2%20in%20Mainframe&body=https%3A%2F%2Fsrinimf.com%2F2015%2F08%2F31%2Fhow-to-know-your-version-of-db2-in-mainframe%2F&share=email)
-

### Like this:

Like Loading…