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 | |
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 |