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” …… Well turns out there is a small oops if you decided to use the keyword DDLTOX (DSN6SPRM macro).  It seems it’s possible that DB2 will not honor the value of DDLTOX under certain conditions that involve the dynamic statement cache, DML, and DDL all running at the same time.   To make everyone play nicely together, APAR PM46707 was closed a few weeks ago on March 23, 2012.  There’s no special handling for this APAR.

If it’s of interest, or you just want to read more about it, you can find it at

PM46707: ADD A NEW SUBSYSTEM PARAMETER (ZPARM) AS TIME OUT FACTOR FOR DDL AND DCL WHEN USING DYNAMIC STATEMENT CACHING

This APAR is superseded by PTFs UK77337 for DB2 9 and UK7736 for DB2 10.