| 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 IC65438 | Status: Closed |
DB2 TEXT SEARCH CREATE INDEX COMMAND RETURNS IQQR0007E ERROR WHEN LOCAL DB HAS THE SAME DB NAME AS REMOTE DB | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problem description: | |
"SQL20427N error with message IQQR0007E collection cannot be
created" is returned from DB2 text search create index command
when there is remote db with the same database name as a local
db
example as follow
List database directory
LIST DB DIRECTORY
System Database Directory
Number of entries in the directory = 2
Database 1 entry:
Database alias = L97_257
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 6 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>)', 'format inso update frequency D(*) H(*) M(0,30)
update
minimum 1',
'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 950 for LUW *
****************************************************************
* PROBLEM DESCRIPTION: *
* "SQL20427N error with message IQQR0007E collection cannot be *
* *
* created" is returned from DB2 text search create index *
* command *
* when there is remote db with the same database name as a *
* local *
* db *
* *
* *
* *
* example as follow *
* *
* *
* *
* List database directory *
* *
* LIST DB DIRECTORY *
* *
* *
* *
* System Database Directory *
* *
* *
* *
* Number of entries in the directory = 2 *
* *
* *
* *
* Database 1 entry: *
* *
* *
* *
* Database alias = L97_257 *
* *
* 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 6 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>)', 'format inso update frequency D(*) H(*) *
* M(0,30) *
* update *
* *
* minimum 1', *
* *
* *
* *
* '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.5 fixpak 6 *
**************************************************************** | |
| Local Fix: | |
avoid using the same database name for local database | |
| available fix packs: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
| Solution | |
Fisx provided in v9.5 fixpak 6 | |
| 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.5. | |
| Problem solved according to the fixlist(s) of the following version(s) | |