DB2 - Problem description
| Problem IT09391 | Status: Closed |
CREATING A DATABASE WITH NAME TCP FAILS WITH SQL0104 IN DB2 CLP V10.5 | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
Creating a database named TCP fails with error SQL0104N. This is because DB2 CLP treats TCP as a reserverd word as of V10.5. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 Fix Pack 7 * **************************************************************** | |
| Local Fix: | |
db2 "CREATE DB 'TCP'" will create a database named TCP as expected. | |
| Solution | |
First Fixed in DB2 10.5 Fix Pack 7 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.06.2015 09.05.2017 09.05.2017 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|