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 2 days ago

    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 yesterday

    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 yesterday

    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 19 hours ago

    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 19 hours ago

    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


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

    Posted yesterday

    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


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

    Posted 10 hours ago

    worth it or not?



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

    Original Message


Related Content