DB2 FOR LUW / DB2FORLUW / A50 - DB2

SYSPROC.ADMIN_CMD works properly when updated with an integer 
value but fails with SQL0104N when updated with an 'AUTOMATIC' 
value for UTIL_HEAP_SZ or HADR_SPOOL_LIMIT 
 
 
Steps to reproduce the problem: 
 
$ db2 "CALL SYSPROC.ADMIN_CMD ('UPDATE DATABASE CONFIGURATION 
FOR <dbname> USING UTIL_HEAP_SZ automatic')" 
SQL0104N An unexpected token "automatic" was found following 
"UTIL_HEAP_SZ". 
Expected tokens may include: "<identifier>". SQLSTATE=42601 
 
$ db2 "CALL SYSPROC.ADMIN_CMD ('UPDATE DATABASE CONFIGURATION 
FOR <dbname> USING UTIL_HEAP_SZ 3000')" 
 
Return Status = 0 
 
 
 
$ db2 "CALL SYSPROC.ADMIN_CMD ('UPDATE DATABASE CONFIGURATION 
FOR <dbname> USING HADR_SPOOL_LIMIT automatic')" 
SQL0104N  An unexpected token "automatic" was found following 
"HADR_SPOOL_LIMIT".  Expected tokens may include: 
"<identifier>". SQLSTATE=42601 
 
$ db2 "CALL SYSPROC.ADMIN_CMD ('UPDATE DATABASE CONFIGURATION 
FOR sample USING HADR_SPOOL_LIMIT 3000')" 
 
  Return Status = 0

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Recommendation                                               * 
****************************************************************

n/a

Problem Conclusion

keiner bekannt / siehe Local-Fix

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

04.03.2015
22.01.2016
22.01.2016