Db2 Tools

Enhancement to DB2L Global Primary Command

  • 1.  Enhancement to DB2L Global Primary Command

    Broadcom Employee
    Posted 06-16-2021 07:25 AM
    Edited by Sreenivas Javvaji 06-16-2021 07:29 AM

    DB2L Command Now Displays the Db2 Code Level

    As part of continuous improvements to the CA Database Management Solutions for DB2 for z/OS, the global primary command DB2L has been enhanced to display the code level. The previous Db2 tools community blog about DB2L global primary command is here.

    The DB2L global primary command lets you display Db2 continuous delivery runtime values catalog level, function level, prior function level in case of fallback, and now code level. It also displays the catalog/function or version/mode values that have been specified in the SETUPxx CDBAPARM member, which need to be in sync with the runtime values. This feature helps you to identify problems with mismatched SETUPxx and runtime values more easily.

    The DB2L command can be executed in both online and batch environments.

    Online

    As DB2L is a global primary command, it can be used from (almost) any product panel within the CA Database Management Solutions for DB2 for z/OS.

    Output of the DB2L command in online environment:

    Output panel of DB2L command in online environment

     

    Batch

    The DB2L command can be executed through the batch processor interface in the batch environment. The .CALL Batch Processor command, which provides the same results of the online global DB2L command.

    Output of the DB2L command in batch environment:

    Output of DB2L command in batch environment

     

    Additional Resource

    • Please find more information about DB2L batch processor interface in techdocs:
      .CALL Command -- Call the Execution Program
    • Broadcom DB2 Tools Community blog about DB2L global primary command
    • DB2L PTFs
      • SO10173 - Introduction of DB2L primary command (online)
      • SO15980 - Enhancement of  DB2L command to batch processor interface (batch)
      • LU01526 - Enhancement of DB2L command to add code level 

    For additional info, contact us:  db2-experts@broadcom.com