Database Management for Db2 for z/OS determine Function Level of Db2
Article ID: 139060
Updated On: 03-12-2025
Products
Issue/Introduction
While using the Database Management for Db2 for z/OS tools it is often useful to know what function level of Db2 is being used. This is because the level of Db2
that is defined to the tools has an impact on the behavior of the tools. Some tools that generate Db2 DDL can generate different code depending on the function
level of Db2. Some of the products that observe the operation of Db2 may display different information depending on the level. It may also be information that is
requested as part of a support ticket. Being able to identify the Db2 version and function level can assist in troubleshooting a problem or unexpected behavior.
Resolution
The Db2 version and function level can be found is various ways.
1. Use the new "DB2L" command on the command line to display the settings that are set by the product configuration.
PTPDB2L ------------ DB2 Continuous Delivery levels ------------
DB2 SSID ==> ssid
DB2 SETUP00
Catalog Level : V12R1M500 SSIDVER : V12
Function Level : V12R1M500 SSIDMODE : NFM
Previous Highest : V12R1M500
2. DB2 Command Processor
Value Pack
_ B Batch Processor
S C DB2 Command Processor
DG Group command
¦ -DISPLAY GROUP ¦
¦ ¦
¦ ¦
¦ ¦
********************************* TOP OF DATA ***************************
DSN7100I !ssid DSN7GCMD
*** BEGIN DISPLAY OF GROUP(DSNSSID ) CATALOG LEVEL(V12R1M500)
CURRENT FUNCTION LEVEL(V12R1M500)
HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M500)
HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M501)
PROTOCOL LEVEL(2)
GROUP ATTACH NAME(xxxx)
3. Batch Processor Displays Db2 12 Function Level
The Batch Processor now displays the current Db2 12 function level during execution of the R20 Database Management Solutions for DB2 for z/OS.
When connected to Db2 12 subsystems, the Batch Processor now displays the current function level during execution of batch processor script.
.CONNECT ssid
BPA0198I: CURRENT FUNCTION LEVEL IS V12R1M500
RETCODE = 0
SET CURRENT SQLID = 'authid';
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
CREATE DATABASE xxxxxxx
BUFFERPOOL BP0
INDEXBP BP0
STOGROUP SYSDEFLT
CCSID EBCDIC;
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
4. The DB2L command can also be run in Batch with Batch Processor after r20 PTF SO15980 has been installed.
The report produced in SYSOUT is the same as the above sample as the online report.
The Db2L command runs in batch using BATCH PROCESSOR with these parms:
.CALL DB2L
.DATA
ssid1
ssid2
.ENDDATA
The output looks like this:
.CALL DB2L
.DATA
ssid1
ssid2
.ENDDATA
------------------ DB2 CONTINUOUS DELIVERY LEVELS ------------------
DB2 SSID ==> ssid1
DB2 RUNTIME SETUP00
CATALOG LEVEL : V12R1M500 SSIDVER : V12
FUNCTION LEVEL : V12R1M500 SSIDMODE : NFM
PREVIOUS HIGHEST LEVEL : V12R1M500
CODE LEVEL : V12R1M510
------------------ DB2 CONTINUOUS DELIVERY LEVELS ------------------
DB2 SSID ==> ssid2
DB2 RUNTIME SETUP00
CATALOG LEVEL : V11R1M5 SSIDVER : V11
FUNCTION LEVEL : V11R1M5 SSIDMODE : NFM
PREVIOUS HIGHEST LEVEL : V11R1M5
CODE LEVEL : V11R1
----------------------- DB2 TOOLS LEVEL SETS -----------------------
MAINTENANCE LEVEL SET : 20.0.08
ACTIVE LEVEL SET : 20.0.05
--------------------------------------------------------------------
RETCODE = 0
5. hlq.CDBAPARM(SETUPxx)
Examine the parameters used in the hlq.CDBAPARM(SETUPxx) looking for the SSIDVERF and SSIDVERC values for Db2 12 and SSIDVER and SSIDMODE for pre-Db2 12 releases.
Compare and check the above values for a given subsystem to ensure that they match.
Additional Information
Feedback
