StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>These functional modes are basically just ways to do your planned upgrades. Both DB2/z v8 and v9 (and probably all the ones to come) have three modes:</p> <ul> <li>compatibility (CM).</li> <li>enable new function (ENFM).</li> <li>new function (NFM).</li> </ul> <p>It's used to ensure there's a smooth transition between versions. For example, all DBMS' in a group must be upgraded to v8 CM before any of them can be switched to v8 ENFM.</p> <p>Compatibility mode for <code>vX</code> means you're using <code>vX</code> but with none of the new function (in other words, equivalent to <code>v(X-1)</code>. If you're running v7 at the moment, you're unsupported - you <em>should</em> really be running v8 in CM (if you care about support and, believe me, if you're paying IBM those huge license fees, you should care :-).</p> <p>Enable new function mode is when the database system tables have been updated to use new function but not user tables.</p> <p>New function mode means that new functionality has been enabled for both system and user tables.</p> <p>The actual content of the new function depends on the version.</p> <p>See here for the <a href="http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNWNJ11/CCONTENTS?SHELF=DSNSHJA6&DN=GC18-7428-01&DT=20061212110132" rel="nofollow noreferrer">v8 What's New</a> information. Basically chapter 2 lists all the new functionality:</p> <ul> <li>More SQL goodies.</li> <li>More security.</li> <li>Better compatibility with DB2/z's smaller siblings (LUW), including Unicode.</li> <li>Scalability/Performance.</li> <li>Availability (very important in the mainframe world).</li> </ul> <p>By the way, IBM makes all its documentation available on the web for perusal, the top level of the public libraries being found <a href="http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/library" rel="nofollow noreferrer">here</a>.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload