DB2 - Problembeschreibung
Problem IT04915 | Status: Geschlossen |
DB2BATCH HAS ITS DEFAULT ISOLATION LEVEL AS RR WHICH MAY CAUSE PERFORMANCE ISSUES/LOCKS ON PRODUCTION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When no option for the isolation level is used when running db2batch, RR (Repeatable Read) is being used as its default isolation. This may cause performance impact on running production systems. Ex: db2batch -d <dbname> -f <sql_file> -o r 1 p 5 e 2 -i complete -r <output_file> This APAR is to change the default isolation level of db2batch to UR. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users on DB2 v97 FP10 and lower * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v97 FP11 or see local fix * **************************************************************** | |
Local-Fix: | |
As a local fix, specify -iso option of db2batch: db2batch -d <dbname> -f <sql_file> -o r 1 p 5 e 2 -i complete -iso UR -r <output_file> | |
Lösung | |
First Fixed in DB2 v97 FP11 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.10.2014 07.10.2015 07.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |