|
Problem IC63068
|
Status: Closed |
SETTING DATABASE_MEMORY TO COMPUTED VIA ADMIN_CMD PROCEDURE FAILS WITH SQL0104N |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
Executing the following update db cfg command via admin_cmd
fails:
db2 "call admin_cmd('update db cfg for sample using
DATABASE_MEMORY COMPUTED')"
SQL0104N An unexpected token "COMPUTED" was found following
"DATABASE_MEMORY". Expected tokens may include:
"<unsigned-long-number>".
SQLSTATE=42601 |
| Problem Summary: |
USERS AFFETCED:
All
PROBLEM DESCRIPTION:
See ERROR DESCRIPTION
PROBLEM SUMMARY:
See ERROR DESCRIPTION |
| Local Fix: |
Use DB2 CLP:
db2 update db cfg for sample using database memory computed |
| available fix packs: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Problem was first fixed in Version 9.1 Fix Pack 9. |
| Workaround |
See LOCAL FIX. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC63069 IC63070
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.09.2009
16.04.2010
16.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
