May 15

Deprecated: Such a cool word yet a word so misunderstood

By Willie DB2 for z/OS (General), DSNZPARM, Migration Comments Off

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 »

Share
Tagged with: • • • • • •
May 11

APAR Friday: Another parallel REORG enhancement

By Willie APAR Friday, DB2 10 for z/OS, DB2 Utilities, DSNZPARM, Maintenance, Performance Comments Off

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 »

Share
Tagged with: • • • • • • •
May 04

APAR Friday: Small glitch with DSNZPARM keyword DDLTOX

By Willie APAR Friday, DB2 10 for z/OS, DB2 9 for z/OS, DSNZPARM, Maintenance Comments Off

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 »

Share
Tagged with: • • • • •
Nov 09

Some new function, a new DSNZPARM keyword for index based partitioning conversion, and a ZPARM fix

By Willie DB2 10 for z/OS, DB2 9 for z/OS, DSNZPARM, Maintenance 2 Comments »

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 »

Share
Tagged with: • • • • • •
May 12

One possible reason for increasing DSNZPARM MXDTCACH

By Willie DB2 9 for z/OS Comments Off

 
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 »

Share
Tagged with: • • • • • • •
preload preload preload