I wanted to talk about the DSNZPARM keys deprecated in DB2 10. And yes I do realize that I listed them out in a previous post. However, this time I wanted to discuss why it’s important today, maybe even before migrating to DB2 10, to plan on how their eventual departure from DB2 may affect you.
Then someone pointed out to me that sometimes when we say something is “deprecated” in a future release of DB2, it can sometimes get misinterpreted, or misunderstood. In fact, there has been extra verbiage added to the DB2 10 Installation and Migration Guide (GC19-2974) to help alleviate future misunderstandings…… Continue reading »
Well over a year ago (Feb 2011) I blogged about the addition of the PARALLEL keyword that was made available on the REORG TABLESPACE LIST utility control statement. (See “APAR Friday: Another great REORG enhancement” )
As a result of the group of fixes mentioned in the above blog post, a single execution of REORG happens with a list of partitions. It does happen in parallel; that’s good news. However, sometimes, someone may want to still run the list of partitions serially… one partition at a time……. Continue reading »
Back on July 11, 2011 ( I can’t believe it’s been a year almost already) I wrote about a new DSNZPARM keyword that was introduced that applied a timeout controls on DDL, different from the rest of the timeout knobs that already existed in DB2. That post along with all the details about the ZPARM can be found at “An additional timeout control is added to DB2 for z/OS” …… Continue reading »
There is a correction in DB2 9 and DB2 10 to how DB2 automatically converts from index based partitioning to table based partitioning using the system parameter IX_TB_PART_CONV_EXCLUDE (introduced by APAR PM45829, see below). The system parameter controls whether all columns are used during the conversion or only significant columns are used. The cover contains a nice explanation that includes examples…… Continue reading »
I’ve been messing around with ZPARMs again. Between recent data warehousing on System z testing and trying to write a new DSNZPARM presentation based on the changes in DB2 9 and DB2 10, I’ve come across a few interesting tidbits I thought I should share…… Continue reading »