home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC96573 Status: Geschlossen

DB2 CRASHES WHEN THREE PART NAME IS USED ON NON-CATALOG NODE.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
When a three part name is used from a non-catalog node in a DPF 
configuration, DB2 could crash with following stack: 
 
 
 
sqloEDUCodeTrapHandler 
sqlnq_resolve_systype_name 
sqlrl_create_nickname_cd 
sqlrl_create_nickname_pd 
sqlrlc_fed_fetch_3pn_pd 
sqlrlc_fed_load_entry 
sqlrlc_load_entry 
sqlrlc_request_ulock 
sqlrlc_find_request_usage_lock 
sqlrlc_fetch_router 
sqlrlc_rpc_router 
sqlrr_rpc_router 
sqlrr_subagent_router 
 
For example,  assuming node 0 is the catalog node,  server2 is 
the server object for a remote data source, following command 
could trigger the crash: 
 
export DB2NODE=1 
db2 connect to <db> 
db2 "select count(*) from sysibm.syscolumns c, 
SERVER2.SYSIBM.SYSTABLES t where c.tbname = t.name "
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* users on DPF instances.                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the database server to v10.5 Fix Pack 3              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
This problem has first been fixed in V10.5 Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.10.2013
27.02.2014
27.02.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList