Db2 for z/OS & Db2ZAI

Db2 for z/OS and its ecosystem

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Thu July 10, 2025 08:20 AM

    Hi All!

     Sorry to bother everone again but after the responses from my last Aha i thought I would risk another....

    Check out: DB24ZOS-I-1782

    Basically, the idea is to reverse engineer the current running ZPARM into an ASM format like DSNTIJUZ. We have all had the "Where in the wide wide world of sports is the DSNTIJUZ for my sub-system xyzz?" moment!!! Wouldn't it be great if you could issue a command/run a job/shoot off a RESTful service - whatever - That simply generates the ASM format that is required in the DSNTIJUZ. The output of the DSNTXAZP just doesn't hack it...

    Cheers!



    ------------------------------
    Roy Boxwell
    Senior Software Architect
    Software Engineering GmbH
    Duesseldorf
    +4921196149675
    ------------------------------


  • 2.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Fri July 11, 2025 04:11 AM

    But then if you ran the output from DSNTXAZP through DSNTIJBC - a new DSNTIJUZ and DSNTIJUA.



    ------------------------------
    James Campbell
    ------------------------------

    Original Message


  • 3.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Fri July 11, 2025 04:26 AM

    Have you actually done that? (asking for a friend)

    I have never got the batch running of the install clist to actually complete successfully... Probably a problem between keyboard and chair...



    ------------------------------
    Roy Boxwell
    Senior Software Architect
    Software Engineering GmbH
    Duesseldorf
    +4921196149675
    ------------------------------

    Original Message


  • 4.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Fri July 11, 2025 10:16 PM

    Yes, I have used DSNTIJBC for function level upgrades.  

    Took a couple of goes to get DSNTIDOA (or whatever you specify in DSNTIJBC) correctly set up.  

    The one problem that I bang my head against every time (one day I'll remember) is that I edit NEW.SDSNSAMP(dsntijbc) and submit from there, swap to SDSF and find my job has failed on an enqueue error against my edit session.  Duh!



    ------------------------------
    James Campbell
    ------------------------------

    Original Message


  • 5.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Sun July 13, 2025 12:11 PM

    I also use the DSNTIJBC,and I really like it, specially for saving its output instead of the CLIST screenshots.

    But I never thought about this possibility of using it instead of picking my last DSNTIJUZ when I just want to change a ZPARM, that's a very good point to always be sure you are picking the last one.

    Thanks!



    ------------------------------
    Soledad Martinez
    Db2 z/OS System Programmer
    Volkswagen Group Services
    Salinas - Asturias
    ------------------------------

    Original Message


  • 6.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Fri July 11, 2025 10:22 PM

    Also, you could take the output from ADMIN_INFO_SYSPARM - which has the macro/parameter/value for the zparms, and rebuild from that 



    ------------------------------
    James Campbell
    ------------------------------

    Original Message


  • 7.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Fri July 11, 2025 07:28 AM

    Something like you are asking for is available thru:

    DB2 Administration Tool - Manage system parameters 

      1  - Display Parameters/Generate DSNZPARM source
      2  - Assemble and Linkedit DSNZPARM module      
     3A  - SET SYSPARM LOAD(          )               
     3B  - SET SYSPARM RELOAD                         
     3C  - SET SYSPARM STARTUP                        



    ------------------------------
    John Totzke
    ------------------------------

    Original Message


  • 8.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Sat July 12, 2025 07:29 AM

    worth it or not?



    ------------------------------
    Alex409 Alex409
    ------------------------------

    Original Message


  • 9.  RE: Another Aha Idea... this time - Reverse engineer the DSNZPARM to ASM format

    Posted Mon July 14, 2025 09:40 AM

    Hello 

    If you have Db2 Admin Tool , there is an option which allows to rebuild the dsnzparm and dsnhdecp in assembler for the current system running within option Z and 2Z with



    ------------------------------
    Alain Piraux
    ------------------------------

    Original Message


Related Content