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

AUTOCONFIGURE MAY FAIL WITH SQL0802N IF THE SUM OF THE SIZES OF ALL TABLE
PACKED DESCRIPTORS EXCEEDS 2147483647

Produkt:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problembeschreibung:
On a very large database, where the sum of the sizes of all
table packed descriptors exceeds 2147483647 (i.e. 0x7FFF FFFF),
AUTOCONFIGURE command may fail with SQL0802N error.  db2diag.log
also reports -802 at probe 500 of DatabaseInfo::sqlSelect(), as
shown below.

2018-06-17-22.16.41.682474-240 I362841680E863        LEVEL:
Warning
PID     : 9136                 TID : 140736901146368 PROC :
db2sysc
INSTANCE: db2inst1             NODE : 000            DB   :
SAMPLE
APPHDL  : 0-7                  APPID:
*LOCAL.db2inst1.180618021622
AUTHID  : DB2INST1             HOSTNAME: hotel
EDUID   : 18                   EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, config/install, DatabaseInfo::sqlSelect,
probe:500
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -802   sqlerrml: 0
 sqlerrmc:
 sqlerrp : SQLRI6C2
 sqlerrd : (1) 0x80160010      (2) 0x00000010      (3)
0x00000000
           (4) 0x00000000      (5) 0xFFFFFCE3      (6)
0x00000000
 sqlwarn : (1) W    (2)      (3) W    (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
 sqlstate: 22003
Problem-Zusammenfassung:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 Version 11.1 Fix Pack 4                       *
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
18.07.2018
04.12.2018
04.12.2018
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version