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.  Full PROFILE support for Db2 for z/OS Optimizer relevant ZPARMs

    Posted 20 hours ago

    Hi all!

     I just open an AhA idea DB24ZOS-I-1781 and would love for you to read and vote accordingly! Here's my text from the Aha Idea:

    While modelling a production system it was noticed that the PROFILE support is not 100% up to date and compatible with the actual ZPARMs that the Db2 Optimizer uses. I opened a case and they said "Yes, it is missing, please open an AHA Idea" so here I am!

    The ZPARMs for tuning/modelling a production system that are correctly supported are:

    MAXRBLK maps to MAX_RIDBLOCKS and is OK

    SJTABLES maps to MIN STAR JOIN TABLES and is OK

    SRTPOOL maps to SORT POOL SIZE and is OK

    NPGTHRSH maps to NPAGES THRESHOLD and is OK

    Values slightly wrong are:

    STARJOIN maps to STAR JOIN but the required numeric range 1 - 32768 is missing (This was the orginal thing that was noticed being missing)

    Value completely missing are:

    MAXSORT_IN_MEMORY is a numeric value from 1000 to the value of SRTPOOL

    MXDTCACH is a numeric value from 0 to 512

    PARAMDEG is a numeric value from 0 to 254

    PARAMDEG_DPSI is DISABLE or a numeric value 0 to 254



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


  • 2.  RE: Full PROFILE support for Db2 for z/OS Optimizer relevant ZPARMs

    Posted 57 minutes ago

    I read it, I liked it, so ... just voted!



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