Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

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
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.