| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC65439 | Status: Closed |
DB2 Text Search: The 'create index' command returns an IQQR0007E error when the database name is not unique on the local system | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
A SQL20427N error with message "IQQR0007E collection cannot be
created" is returned from the DB2 Text Search 'create index'
command, when the same database name is used for a local and a
remote database in the local database directory.
LIST DB directory
System Database Directory
Number of entries in the directory = 2
Database 1 entry:
Database alias = ABC
Database name = LOCAL
Node name = DB2_01_2
Database release level = d.00
Comment =
Directory entry type = Remote
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
Database 2 entry:
Database alias = LOCAL
Database name = LOCAL
Local database directory = C:
Database release level = d.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
C:\temp2\temp1208>db2 "connect to local"
Database Connection Information
Database server = DB2/NT 9.7.1
SQL authorization ID = <user name>
Local database alias = LOCAL
C:\temp2\temp1208>db2 "CALL SYSPROC.SYSTS_CREATE('<index
schema>', '<index name>', '<table name>( <column name>)', '',
'en_US', ?)"
SQL20427N An error occurred during a text search administration
procedure or command. The error message is ""IQQR0007E The
DB2_<dbname>_<TS_IDX_name>_0000 collection cannot be created. ".
SQLSTATE=38H14 | |
| Problem Summary: | |
****************************************************************
* USERS AFFECTED: *
* DB2 LUW V9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* A SQL20427N error with message "IQQR0007E collection cannot *
* be *
* created" is returned from the DB2 Text Search 'create index' *
* *
* command, when the same database name is used for a local and *
* a *
* remote database in the local database directory. *
* *
* *
* *
* LIST DB directory *
* *
* *
* *
* System Database Directory *
* *
* *
* *
* Number of entries in the directory = 2 *
* *
* *
* *
* Database 1 entry: *
* *
* *
* *
* Database alias = ABC *
* *
* Database name = LOCAL *
* *
* Node name = DB2_01_2 *
* *
* *
* *
* Database release level = d.00 *
* *
* Comment = *
* *
* *
* *
* Directory entry type = Remote *
* *
* Catalog database partition number = -1 *
* *
* Alternate server hostname = *
* *
* Alternate server port number = *
* *
* *
* *
* Database 2 entry: *
* *
* *
* *
* Database alias = LOCAL *
* *
* *
* *
* Database name = LOCAL *
* *
* Local database directory = C: *
* *
* Database release level = d.00 *
* *
* Comment = *
* *
* *
* *
* Directory entry type = Indirect *
* *
* Catalog database partition number = 0 *
* *
* Alternate server hostname = *
* *
* Alternate server port number = *
* *
* *
* *
* C:\temp2\temp1208>db2 "connect to local" *
* *
* *
* *
* Database Connection Information *
* *
* *
* *
* Database server = DB2/NT 9.7.1 *
* *
* SQL authorization ID = <user name> *
* *
* Local database alias = LOCAL *
* *
* *
* *
* C:\temp2\temp1208>db2 "CALL SYSPROC.SYSTS_CREATE('<index *
* *
* schema>', '<index name>', '<table name>( <column name>)', *
* '', *
* 'en_US', ?)" *
* *
* *
* *
* SQL20427N An error occurred during a text search *
* administration *
* procedure or command. The error message is ""IQQR0007E The *
* *
* DB2_<dbname>_<TS_IDX_name>_0000 collection cannot be *
* created. ". *
* SQLSTATE=38H14 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 fixpack 2. *
**************************************************************** | |
| Local Fix: | |
Make sure that a unique database name is used for the local database. | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
| Solution | |
Fix included in v9.7 fixpack 2 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.01.2010 19.07.2010 19.07.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.2 |
|