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

LOAD command writes row data into a transaction log when the row size
exceeds the pagesize.

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
When the row expansion is enabled(i.e. the row size is larger 
than the tablespace pagesize) and the actual row data size is 
larger than the page size, the varchar or vargraphic columns 
data will be logged during LOAD. 
 
This may have an impact when many rows exceed the page size, but 
please note that extended row size support is effective when 
most of data rows can fit on a smaller page, but the table 
definition requires a bigger page size. If most of data rows 
cannot fit, then the table should be defined in larger page size 
tablespace appropriately. 
If most of data rows can fit within the page size, then this 
problem does not have a noticeable impact.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 7.                      * 
****************************************************************
Local-Fix:
Create the table in a tablespace with larger pagesize if most of 
data rows exceed the current pagesize.
Lösung
First fixed in DB2 Version 10.5 Fix Pack 7.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.09.2014
29.02.2016
29.02.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList