Bookmark and Share
RSS

Recent Posts

Subsystem Parameter Changes in DB2 12

June 27, 2017

Following up on last week's post about new and changed with DB2 11 for z/OS subsystem parameters, here's an update about DB2 12 zparms. It’s important to note that, starting with DB2 12, zparms become available at function level at which they're introduced (e.g., function level V12R1M500, V12R1M501, etc.).

Here are the new zparms for DB2 12 function level V12R1M500. As you can see from the links, the IBM Knowledge Center has more details about everything. In some cases I’ve added my own comments on usage based on what's delivered in the DB2 12 Technical Workshop.
Here are the changed subsystem parameters:
Finally, here are the zparms that have been removed from DB2 12:
  • ALCUNIT
  • CACHE_DEP_TRACK_STOR_LIM
  • CACHEDYN_FREELOCAL
  • CATALOG (in DSN6ARVP)
  • CHECKSETCHKP
  • CONTSTOR
  • DB2SORT
  • EDMPOOL
  • INDIX_IO_PARALLELISM
  • LEMAX
  • LOBVALA
  • LOBVALS
  • MINSTOR
  • REORG_IGNORE_FREESPACE
  • RRF
  • SQWIDSC
  • UTSORTAL
  • XMLVALA
  • XMLVALS

Posted June 27, 2017 | Permalink

comments powered by Disqus