DB2 FOR LUW / DB2FORLUW / 970 - DB2

The db2 update command options using 'm' off/on results in 
SQL0104N error. 
 
Example 1: 
 
> db2  update command options using m off 
SQL0104N  An unexpected token "off" was found following "OFF". 
Expected tokens 
may include:  "A".  SQLSTATE=42601 
 
Example 2: 
 
> db2  update command options using m on 
SQL0104N  An unexpected token "on" was found following "ON". 
Expected tokens 
may include:  "A".  SQLSTATE=42601

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5                        * 
****************************************************************

You could issue the command through an initeractive mode or 
through a script. 
 
db2 => update command options using m on 
Then you can see that all the changes done to the command option 
will be retained, because the frontend (db2=>) 
"db2 command line" process is still alive.

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

01.06.2011
07.03.2012
07.03.2012

9.7.FP5