DB2 for z/OS Customer zPARM Survey Results
Paul_McWilliams 110000JT36 Comments (4) Visits (6974)
By Chris Crone.
We recently surveyed close to 80 Db2 for z/OS customers about their Db2 subsystem parameter (zPARM) and application programming default settings (DECP). We collected the results in a report that summarizes the settings from more than 400 production environments and more than 800 development, test, and QA systems, including data from Db2 11 and Db2 12.
Our goal for this effort is to enable Db2 development to better understand how our customers configure and use Db2, and enable you to compare your Db2 settings to those of other customers. The Db2 development team can also use this data as we continue to simplify Db2.
Although the survey gathered data about for all of the Db2 zPARMs and DECP values, the initial survey report covers only a subset, focusing on the most important parameters. Let us know if you want to see the data for other particular zPARMs or DECP values. We have the data. Also let us know you want to see other statistical analysis (such as CROSSTABS). We welcome and encourage your feedback! Add your comments below, or send me an email, at the address in the report.
For the survey report, see: Db2
Chris Crone is an IBM Distinguished Engineer in Db2 for z/OS Development at IBM Silicon Valley Laboratory in San Jose, California.