How to know your version of DB2 in Mainframe

A tricky question for Mainframe DB2 programmers. Question is where I get information about DB2 version of sub system. The below post answers to this question.


Secondly, each DB2 sub system can have different version of DB2.

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 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
Image courtesy|Stocksnap.io

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

2 Ways you Can Use to DB2 Version in Mainframe.

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). Issue the following new V8 GET VARIABLE statement:

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

Author: Srini

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