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.

It is very important for developers to know this so they do not get confused with what looks like an SQL error but is actually an error specific to not being on the right version to handle a particular function.

You can use the below 2 ways to get version information:

  • 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

  • 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.

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.