|
Problem IC84862
|
Status: Closed |
DB2 DROP STOGROUP <SGNAME> RESTRICT RETURNS SQL0104N AN UNEXPECTED TOKEN "RESTRICT" WAS FOUND |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When the "restrict" keyword is used with the "drop stogroup"
statement an error "SQL0104N AN UNEXPECTED TOKEN "RESTRICT" WAS
FOUND" is returned.
db2 drop stogroup sg1 restrict
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "restrict" was found following
"drop stogroup
sg1 ". Expected tokens may include: "END-OF-STATEMENT".
SQLSTATE=42601 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 Galileo users on all platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to product DB2 version 10 Fixpack 1 *
**************************************************************** |
| Local Fix: |
Using "drop stogroup <sgname>" has the same behavior as "drop
stogroup <sgname> restrict". Remove the keyword 'restrict' from
the syntax. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
The problem is fixed in DB2 version 10 Fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.06.2012
31.10.2012
31.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
