Db2 for z/OS & Db2ZAI

 View Only
  • 1.  DSNTID parameter RTM05PKO

    Posted Tue January 03, 2023 10:31 AM

    Happy new year to all of you!

    I notice that every time I pass through the DB2 V12 install panels the DSNTID parameter RTM05PKO gets set to my userid.

    Does anybody happen to know what the purpose is for this behavior? It seems odd, but no other parm exhibits comparable behavior. Was this created with a purpose in mind? Or is it a quirk/bug after all?

    Thanks in advance

    Abe Kornelis



    ------------------------------
    Abe Kornelis
    ------------------------------


    #Db2forz/OS


  • 2.  RE: DSNTID parameter RTM05PKO

    Posted Thu January 05, 2023 05:26 PM
    Edited by System Fri January 20, 2023 04:38 PM

    Hi Abe,

    Happy New Year to you!

    Here is what I found about the parameter RTM05PKO in Optimization Routine.

    PACKAGE OWNER

    Specify the ID that should own the package when it is bound (the value for the OWNER parameter of the BIND PACKAGE command). The default for most routines is blank, meaning that no OWNER parameter is included in the BIND PACKAGE command. This field does not display for routines that do not have package.

    The setting user-id is the TSO user ID used to run the installation CLIST.

    Acceptable values: blank, or a valid authorization ID
    Default: user-id
    DSNZPxxx: none

    Here is the document link incase you need it.

    For optimization routine, if the package owner is undefined, assign the current user ID.

    That is why when you run Db2 V12 install panels, it sets to your user-id.



    ------------------------------
    TRAN LAM
    ------------------------------



  • 3.  RE: DSNTID parameter RTM05PKO

    Posted Fri January 06, 2023 04:11 AM

    Hi, thanks for your explanation. 

    In my DSNTID member I count 95 parameters ending in PKO, they are all just like RTM05PKO intended to encode a package owner.

    Yet RTM05PKO is the only one in this set that gets set to my userid every time I pass through the panels. So I have to manually edit it afterwards every time, which is pretty annoying.

    I think this is a bug in the clist. Where / how do I report this to the DB2 support team?



    ------------------------------
    Abe Kornelis
    ------------------------------



  • 4.  RE: DSNTID parameter RTM05PKO

    Posted Mon January 09, 2023 03:01 PM
    Edited by System Fri January 20, 2023 04:39 PM

    Hi Abe,

    According to the IBM Db2 document, only PACKAGE OWNER RTM05PKO of Optimization Routines has the default is user-id.

    https://www.ibm.com/docs/en/db2-for-zos/12?topic=dsntipra-db2-optimization-routines-panel-dsntiprm

    Acceptable values:

    blank, or a valid authorization ID

    Default:

    user-id

    DSNZPxxx:

    none



    Other uses of PACKAGE OWNER (other PKOs) generally use blank as the default, such as for the following:

    https://www.ibm.com/docs/en/db2-for-zos/12?topic=dsntipra-db2-administration-routines-panel-dsntiprl

     PACKAGE OWNER

    Specify the ID that should own the package when it is bound (the value for the OWNER parameter of the BIND PACKAGE command). The default for most routines is blank, meaning that no OWNER parameter is included in the BIND PACKAGE command. This field does not display for routines that do not have package.

    Acceptable values:

    blank, or a valid authorization ID

    Default:

    blank

    DSNZPxxx:

    none

     Similarly, these other panels also have blank as the default:

    https://www.ibm.com/docs/en/db2-for-zos/12?topic=dsntipra-text-search-routines-panel-dsntiprj

    https://www.ibm.com/docs/en/db2-for-zos/12?topic=dsntipra-database-metadata-routines-panel-dsntiprk

    https://www.ibm.com/docs/en/db2-for-zos/12?topic=dsntipra-xml-processing-routines-panel-dsntipri

    https://www.ibm.com/docs/en/db2-for-zos/12?topic=dsntipra-utility-invocation-routines-panel-dsntiprc

    and so on.

    The CLIST matches with the current IBM Doc.

    If you think the default of RTM05PKO should be blank, you can open a Case or contract Db2 Client Success Team.  Then, it will be assigned to a more appropriate person. 

    Regards,


    ------------------------------
    TRAN LAM
    ------------------------------