DB2 - L

 View Only
Expand all | Collapse all

Db2 z/OS use of SYS1.PARMLIB, etc

  • 1.  Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 18, 2022 12:25 PM
    We have a new sysprog, and they are questioning our use of SYS1.PARMLIB and other system libraries.

    I have put Db2 specific entries in IEFSSN00, IEAAPF00, LNKLST00, etc.....
    Do you add the entries to parmlib or have another library that is concatenated @ IPL time.


    Thanks in advance.






    ------------------------------
    Natalie Faulkner State of WV - OT Data Center
    ------------------------------


  • 2.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 22, 2022 01:55 AM
    Edited by Manoj Jadwani Apr 22, 2022 01:54 AM
    If your shop follows segregation of duties , then you provide these Db2 specific entries to z/OS Team and they add it for you whichever parmlib is used by OS for that LPAR. You will need to tell them where/which PARMLIB member you need to add these entries.

    What goes where ? refer DSNTIJMV job
    https://www.ibm.com/docs/en/db2-for-zos/11?topic=mydscm-migration-step-13-define-db2-11-zos-dsntijmv

    Regards,
    Manoj K Jadwani

    ------------------------------
    ManojJadwaniTCS
    ------------------------------



  • 3.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 22, 2022 10:12 AM
    Hi Natalie,

    Almost all customers I've worked with keep the IBM defaults in SYS1.** and have one or more libraries concatenated with their own values, e.g., SYS2.**, COMPANY.**, PLEX1.**, or similar.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2022 IBM Champion
    ------------------------------



  • 4.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 22, 2022 10:23 AM

    Jørn,

    Does Rocket or IBM have best-practices recommendations concerning how far "up the stack" to break up the parameter libraries? Should there be libraries specific to the DB2 codebase, IMS, the COBOL compiler? Online, versus batch?

     

    /phil

     

     

    Philip Sevetson

    Computer Systems Manager

    FISA-OPA

    5 Manhattan West

    New York, NY 10001

    psevetson@fisa-opa.nyc.gov

    917-991-7052 m

    212-857-1659 f

    image001.png@01D261E4.BE68E970

     






  • 5.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 22, 2022 10:39 AM
    Hi Phil,

    I don't know :) I am not a sysprog in my day-job, but when I help customers install our solutions it is extremely rare stuff are copied into SYS1.PARMLIB or SYS1.PROCLIB. Almost all customers I've worked with keep their own members in other libraries, e.g., SYS2.PROCLIB or PROD.DB2.PROCLIB.

    On my own demo system there are four libraries in the PARMLIB concatenation:
    One user library -- this is a bit unusual because this is a demo system, but it allows me to deploy JCL procs and parmlib updates without asking for help :)
    SYS1.PARMLIB - with the IBM defaults
    Two libraries for Rocket stuff: the first has members that are shared across all our sysplexes whereas the other has sysplex specific parmlib members.

    The PROCLIB concatenation has nine (!) libraries in the concatenation.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2022 IBM Champion
    ------------------------------



  • 6.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 22, 2022 10:51 AM

    Okay, so "no consensus, except not putting it all in the IBM-distributed libraries."  I can live with that (and I'm pretty sure my sysprogs are compliant with that minimal standard). 

     

    Thanks for your input :-)

     

     

    Philip Sevetson

    Computer Systems Manager

    FISA-OPA

    5 Manhattan West

    New York, NY 10001

    psevetson@fisa-opa.nyc.gov

    917-991-7052 m

    212-857-1659 f

    image001.png@01D261E4.BE68E970

     






  • 7.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 25, 2022 04:25 AM

    "Almost all customers I've worked with keep the IBM defaults in SYS1.** and have one or more libraries concatenated with their own values, e.g., SYS2.**, COMPANY.**, PLEX1.**, or similar"

    Where I've worked, it's tended to be the reverse of that :)

    All "real" system-wide config members, including those used for DB2, are in SYS1.PARMLIB, with LPAR-specific equivalents if required. The DB2 team have read-only access to these datasets and the z/OS guys make any changes for us..
    We only have 4 datasets in the PROC00 concatenation, so the LPAR specific members are at the top of the list.



    ------------------------------
    Steven Lamb
    ------------------------------



  • 8.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 27, 2022 12:40 PM
    Tangential question...has anyone ever configured their automation to dynamically install their Db2 using SETSSI and SETPROG?

    Always something I wanted to try. :) The "separation of duties" has always been awkward between MVS systems and Db2 systems...changes to actual PARMLIB datasets usually take change records, scheduling, etc, and the MVS guys are always nervous about SET commands, particularly in Production.

    The ability to "self-install" using automation seems like it'd allow for maximum versatility.

    In fact...I know IBM won't do it, but allowing Db2 to "self-install" its subsystem would result in one fewer step to installation and one fewer group that needs to configure their environment to accommodate Db2.




    ------------------------------
    Mark Wieczorkowski
    ------------------
    Db2 Systems Programmer, SSA/DCS
    Principal - Solipsistic, LLC
    ------------------------------



  • 9.  RE: Db2 z/OS use of SYS1.PARMLIB, etc

    Posted Apr 27, 2022 11:16 PM
    The essential problem is that whoever issues the SETSSI, SETPROG or updates PARMLIB
    has to be authorised. If it is Db2 doing that, then Db2 needs to be authorised - which it isn't
    until the SETPROG is issued.

    If you get your automation software to do it, then what authority do you ( or your z/OS
    Sysprogs ) want your automation software to have?

    James Campbell


    On 27 Apr 2022 at 16:40, Mark Wieczorkowski via Intern wrote:

    > Tangential question...has anyone ever configured their automation to dynamically install their Db2 using SETSSI and SETPROG?
    >
    > Always something I wanted to try. :) The "separation of duties" has always been awkward between MVS systems and Db2 systems...changes to actual PARMLIB datasets usually take change records, scheduling, etc, and the MVS guys are always nervous about SET commands, particularly in Production.
    >
    > The ability to "self-install" using automation seems like it'd allow for maximum versatility.
    >
    > In fact...I know IBM won't do it, but allowing Db2 to "self-install" its subsystem would result in one fewer step to installation and one fewer group that needs to configure their environment to accommodate Db2.
    >
    >
    >
    >
    > ------------------------------
    > Mark Wieczorkowski
    > ------------------
    > Db2 Systems Programmer, SSA/DCS
    > Principal - Solipsistic, LLC
    > ------------------------------
    > -------------------------------------------
    > Original Message:
    > Sent: Apr 18, 2022 12:24 PM
    > From: Natalie Faulkner
    > Subject: Db2 z/OS use of SYS1.PARMLIB, etc
    >
    > We have a new sysprog, and they are questioning our use of SYS1.PARMLIB and other system libraries.
    >
    > I have put Db2 specific entries in IEFSSN00, IEAAPF00, LNKLST00, etc.....
    > Do you add the entries to parmlib or have another library that is concatenated @ IPL time.
    >
    >
    > Thanks in advance.
    >
    >
    >
    >
    >
    >
    > ------------------------------
    > Natalie Faulkner State of WV - OT Data Center
    > ------------------------------
    >
    >




  • 10.  RE: Db2 z/OS use of SYS1.PARMLIB, etc