Database Management for Db2 for z/os: Find out the function level of Db2
Article ID: 139060
Updated On:
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.
Environment
Release: R20
Component: Database Management for DB2 for Z/OS
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 !SS32 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(SSGP)
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 SS32
BPA0198I: CURRENT FUNCTION LEVEL IS V12R1M500
RETCODE = 0
SET CURRENT SQLID = 'authid';
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
CREATE DATABASE DBCORP2
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.
DB2L Batch Execution Support (SO15980). 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 parms used in the hlq.CDBAPARM(SETUPxx) looking for the SSIDVERF and SSIDVERC values for db2v12 and SSIDVER and SSIDMODE for pre-DB2 v 12 releases.
Compare and check the above values for a given subsystem to ensure that they match.
Additional Information
Feedback
