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
Expand all | Collapse all

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

  • 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 outDB24ZOS-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
    ------------------------------



  • 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
    ------------------------------



  • 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
    ------------------------------



  • 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
    ------------------------------



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

    Posted 5 days ago

    Hello

    First time using DSNTIJBC was not easy, there was an error on the input file with WLM_ENV names were we had them duplicate and the output of DSNTIJBC simply doesn't show where the error is... So the solution was to run the classic DSNTINST clist and bang, I got the error message for the WLM_ENV. Once we fixed, DSNTIJBC run smoothly.

    So, maybe try to run classic CLIST to see what could be preventing the CLIST to run... DSNTIJBC is quite new, so we may still expect a lot of improvements on the horizon :)



    ------------------------------
    Ellen França
    Sr. Db2 System Programmer
    Kyndryl
    Czech Republic
    ------------------------------



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

    Posted 20 hours ago

    Hi Roy,
    I just want to provide more information about the Batch CLIST. Currently, the Batch CLIST supports migration and function level (FL) activation. 
    - Migration: DSNTIDOM (NDS or 1st member) and DSNTIJBC needs to be updated to run. The input for DSNTIDOM is similar the panel DSNTIPA1. If it is for a subsequent member, DSNTIDON should be used instead of DSNTIDOM.
    - FL activation: DSNTIDOA and DSNTIJBC needs to be updated to run. The input for DSNTIDOA is similar the panel DSNTIPA1 with TARGET_FUNCTION_LEVEL.

    Because it is new, people may need time to get used to the set up and the error handling maybe not perfect. However, if you hit any problem, you can contact IBM Support for help.
    I think when you can make DSNTIJBC  (Batch CLIST) run successfully 1 time then it will help to save a lot of time for future runs (especially for the migration).



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



  • 8.  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
    ------------------------------



  • 9.  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
    ------------------------------



  • 10.  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
    ------------------------------



  • 11.  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
    ------------------------------