DB2 - L

Expand all | Collapse all

Function Levels required for specific PTFs

  • 1.  Function Levels required for specific PTFs

    Posted 6 days ago
    When we apply specific PTFs how can we find what Function Level is required for that PTF?
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------


  • 2.  RE: Function Levels required for specific PTFs

    Posted 6 days ago

    My understanding that there is NO FUNCTION LEVEL *EVER* required to deploy a PTF (any PTF can be deployed at ANY FL)

    There is, however, certain PTFs required to activate a function level – is that what you meant?

    If so ... https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/wnew/src/tpc/db2z_db2functionlevels.html

    This documents details the features activated at each FL *and the ptf required to enable the function level*

     

     

     

    Chris Hoelscher

    Lead Sys DBA

    IBM Global Technical Services on assignmemt to Humana Inc.

    T 502.476.2538  or 502.407.7266

     






  • 3.  RE: Function Levels required for specific PTFs

    Posted 3 days ago

    Hi Bill,

    Here are some facts about PTFs and Db2 function levels:



    ------------------------------
    Paul McWilliams
    IBM Db2 for z/OS
    Information Developer
    ------------------------------



  • 4.  RE: Function Levels required for specific PTFs

    This message was posted by a user wishing to remain anonymous
    Posted 3 days ago
    This post was removed


  • 5.  RE: Function Levels required for specific PTFs

    Posted 2 days ago
    > When you apply a PTF for code to support new function in a higher function level, you cannot tell from the PTF itself which function level will activate the new function.

    I think you meant "... you cannot tell from the PTF itself which code level the PTF
    establishes" - or something on those lines.

    In my experience, DSNARIB will be updated to contain the code's function level. And the
    PTF comments (which seem to be copied from the the APAR) does include that information.
    Although not every update of DSNARIB is for a new function level.

    The EIB part of DSNARIB is mapped in SDSNMACS(DSNDEIB). My eyes also do a good
    job of interpreting the characters.

    James Campbell


    On 3 May 2021 at 17:36, Paul McWilliams via Internati wrote:

    > Hi Bill,
    >
    >
    > Here are some facts about PTFs and Db2 function levels:
    >
    >
    > You can apply any PTF at any function level.
    > When you apply a PTF for code to support new function in a higher function level, you cannot tell from the PTF itself which function level will activate the new function.
    > When a PTF enables activation of a function level, the APAR closing text indicates which function level it enables you to activate.
    > IBM Documentation indicates the APAR for the PTF that enables activation of each function level, in https://www.ibm.com/docs/en/db2-for-zos/12?topic=12-db2-function-levels
    > To check which function levels you can activate with the PTFs that you have applied, use the DISPLAY GROUP command. See https://www.ibm.com/docs/en/db2-for-zos/12?topic=ancid1cd-determining-db2-code-level-catalog-level-function-level.
    > Some APARs introduce new function that takes effect immediately as soon as the PTF is applied; the details for these are in the closing text, and many of these are described in https://www.ibm.com/docs/en/db2-for-zos/12?topic=12-recent-enhancements-db2
    >
    >
    > ------------------------------
    > Paul McWilliams
    > IBM Db2 for z/OS
    > Information Developer
    > ------------------------------
    > -------------------------------------------
    > Original Message:
    > Sent: Apr 30, 2021 07:05 PM
    > From: william giannelli
    > Subject: Function Levels required for specific PTFs
    >
    > When we apply specific PTFs how can we find what Function Level is required for that PTF?
    > thanks
    > Bill
    >
    > ------------------------------
    > williamgiannelliMe
    > ------------------------------


    --
    This email has been checked for viruses by AVG.
    https://www.avg.com




  • 6.  RE: Function Levels required for specific PTFs

    Posted 16 hours ago

    >> When you apply a PTF for code to support new function in a higher function level, you cannot tell from the PTF itself which function level will activate the new function.

    >I think you meant "... you cannot tell from the PTF itself which code level the PTF
    establishes" - or something on those lines.

    I believe that a new code level is established when you apply several PTFs that deliver deactivated new-function code, plus  a single PTF  that enables activation of the corresponding function level.

    I meant that the closing text and ++HOLD for the PTFs that deliver deactivated new-function code generally don't indicate which function level will activate the new features that will use the code. 

    Perhaps that could also be re-phrased as, "When you apply a PTF that delivers deactivated new-function code for a future function level, you cannot tell which code level the PTF is helping to establish."



    ------------------------------
    Paul McWilliams
    IBM Db2 for z/OS
    Information Developer
    ------------------------------



  • 7.  RE: Function Levels required for specific PTFs

    Posted 8 hours ago
    As Chris Hoelscher said, no PTF ever requires you to activate a function level. With Db2 12 Continuous Delivery, there is a single maintenance stream containing both preventive/corrective maintenance and new function. Some of that new function is only available when you activate a function level. Activating a function level also activates all lower function levels.

    There are four levels related to new function:
    • Maintenance level
    • Catalog level
    • Function level
    • Application compatibility level (APPLCOMPAT)
    Applying maintenance can advance your maintenance level, depending on which PTFs you apply. The link to Db2 12 function levels on the IBM Documentation web site supplied by Paul McWilliams identifies which APARs are required to be able to activate any given maintenance level. For example, APAR PH24371 is required to be able to activate function level 507. If you read the APAR text, it tells you that you need to apply PTF UI70063 to be able to activate function level 507.
    If you apply UI70063, then you will advance the maintenance level to 121507 (or 507 for short). This is listed in the DB2 LVL column output of the -DISPLAY GROUP command. The IBM documentation site tells you that to be able to activate function level 507, you first of all need to advance the catalog level to V12R1M507.

    Once you have done this, you are then in the postition to activate function level 507 should you choose to do so. This is not mandatory unless you plan to migrate to the next version of Db2, which requires you to be at Db2 12 function level 510. Activation of a function level does not result from simply applying maintenance.

    To answer the original question, applying DB2 12 PTFs does not require you to have activated any function level. You can apply all Db2 12 PTFs and remain at function level 100. Attempting to exclude PTFs which enable the activation of function levels from your SMP/E APPLY process will cause you to miss out critical Db2 maintenance.

    ------------------------------
    Gareth Copplestone-Jones
    Triton Consulting
    ------------------------------