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

DB2TRCSTARTUPSIZE HAS NO EFFECT - PERF ISSUE WITH CLIENTS, IF
NO'DB2TRC ALLOC' ISSUED ON AIX

Produkt:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problembeschreibung:
Application running on a DB2 client performs poorly due to low 
level semget calls issued by DB2 
https://www-304.ibm.com/support/docview.wss?uid=swg21209523 
 
We found the same issue on AIX for instance less clients. Poor 
performance. Setting db2trcStartupSize in db2dsdriver.cfg file 
has no effect. Because, after issuing a 'db2trc alloc' the 
performance was as good as with the instance based client.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* 1) Non-instance based clients on AIX.                        * 
* 2) Remote instance based clients on AIX                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97fp7 or later releases.                         * 
****************************************************************
Local-Fix:
issue "db2trc alloc" to fix the performance issue.
verfügbare FixPacks:
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
db2_v97fp7 fixes this issue.
Workaround
run "db2trc alloc"
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC85794 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.08.2012
20.10.2012
20.10.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
9.7.0.7 FixList