DB2 - Problembeschreibung
Problem IC65438 | Status: Geschlossen |
DB2 TEXT SEARCH CREATE INDEX COMMAND RETURNS IQQR0007E ERROR WHEN LOCAL DB HAS THE SAME DB NAME AS REMOTE DB | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
"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-Zusammenfassung: | |
**************************************************************** * 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 | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Fisx provided in v9.5 fixpak 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 06.01.2010 19.07.2010 19.07.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5. | |
Problem behoben lt. FixList in der Version |