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