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 IC77846 Status: Geschlossen

SEG-V DURING CREATION SQL PROCEDURE IF CREATED FROM A NON-CATALOG PARTITION
AND WITH AUDIT CHECKING EVENTS ENABLED

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In a DPF instance, the creation of an SQL procedure from a 
partition that is not the catalog partition can result in a 
segmentation fault if 
the db2audit facility is active and 'checking events' are 
enabled. 
 
A representative stack would include: 
 
setAuthid 
sqlr_audit 
sqlr_audit_checking 
sqlrlCheckSchemaPriv 
sqlrlgsa 
sqlrl_rpc_cat_router 
sqlrr_rpc_router
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Partitioned Database environment                             * 
* Audit Checking enabled                                       * 
* creation of SQL procedures from non-catalog partition        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Seg-v during creation of SQL procedure                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Move to DB2 for LUW version 9.7, fixpack 5                   * 
****************************************************************
Local-Fix:
avoid this by creating sql procedures from a connection at the 
catalog partition or disable db2audit checking events
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Fixed in DB2 for LUW version 9.7, fixpack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
29.07.2011
19.01.2012
19.01.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList