Sreenivas,
Nice enhancement to help people understand the environments.
Jeff Gross
Db2 Logical DBA, Global Technical Services
Ensono.com
© 2021 Ensono, LP. All rights reserved. Ensono is a trademark of Ensono, LP. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Original Message:
Sent: 1/6/2021 10:07:00 AM
From: Sreenivas Javvaji
Subject: DB2L command to Display Db2 Continuous Delivery Levels
Introduction
In January 2020, a global primary command DB2L was introduced via SO10173, which displays the Db2 continuous delivery runtime values of catalog level, function level, and prior function level in case of fallback. Moreover, it also displays the values the user has in the SETUPxx CDBAPARM member (SSIDVERF and SSIDVERC), which need to be in sync with the runtime values. This was meant for our L1 support to identify problems with mismatched SETUPxx and runtime values more easily.
Online
As DB2L is a global primary command, this can be used from (almost) any product panel within the CA Database Management Solutions for DB2 for z/OS.
The online command:
In the output panel, the left column (DB2) shows the runtime values from the subsystem, while the right column (SETUPxx) shows the values in the SETUP member. The SETUP values are displayed even if you are not connected to that subsystem.
Batch
Now in January 2021, the feature to execute the DB2L command through batch processor interface has been introduced via SO15980.
The DB2L command can be executed in batch using the .CALL Batch Processor command, which provides the same results of the global command DB2L.
Below are two ways to execute the DB2L command in batch environment.
Method 1: Display the continuous delivery levels of the currently connected Db2 subsystem through .CONNECT ssid
Batch output 1:
Note: In this method, the .CONNECT ssid statement does not have to be right before the .CALL DB2L command.
Method 2: Display the continuous delivery levels of multiple Db2 subsystems between .DATA and .ENDDATA block
Note: In this method, if there is a .CONNECT ssid statement before .CALL DB2L, the ssid in .CONNECT will be ignored for output.
As DB2L is only a reporting facility to display the Db2 continuous delivery levels, the maximum return code in case of errors/warnings in batch environment is 4 and continues to execute the remaining batch processor statements.