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

BACKUP FAILS SQL2079N AN ERROR WAS REPORTED BY THE SHARED LIBRARY
"DB2COMPR.DLL". RETURN CODE: "1".

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Backup with compress option might fail with 
 
SQL2079N  An error was reported by the shared library 
"db2compr.dll". 
Return code: "1". 
 
The following messages will be seen in the db2diag.log 
 
FUNCTION: DB2 UDB, database utilities, 
sqlubManageCompressedObject, probe:1002 
MESSAGE : Compression library returned tgtAct > tgtSize.  tgtAct 
/ tgtSize: 
DATA #1 : signed integer, 4 bytes 
127573 
DATA #2 : signed integer, 4 bytes 
127570    << Note these values could be different 
 
FUNCTION: DB2 UDB, database utilities, 
sqlubManageCompressedObject, probe:1006 
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes 
-2079 
DATA #2 : Hexdump, 21 bytes^M 
0x0000001661F90BF8 : E1F7 FFFF 6462 3263 6F6D 7072 2E64 6C6C 
....db2compr.dll 
0x0000001661F90C08 : 0001 0000 00 
..... 
 
FUNCTION: DB2 UDB, database utilities, 
sqlubManageCompressedObject, probe:1006 
MESSAGE : SQL2079N  An error was reported by the shared library 
"".  Return 
          code: "". 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2079   sqlerrml: 
14 
 sqlerrmc: db2compr.dll 1 
 sqlerrp : sqlubMan 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0x00000000      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
 
Note this is a very rare case and unlikely to be hit. It is not 
the same as APAR IT03814 (note that in this APAR tgtSize value 
is < 5, example: 
MESSAGE : Compression library returned tgtAct > tgtSize.  tgtAct 
/ tgtSize: 
DATA #1 : signed integer, 4 bytes 
5 
DATA #2 : signed integer, 4 bytes 
3)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 11                   * 
****************************************************************
Local-Fix:
Lösung
Problem was first fixed in DB2 Version 9.7 and Fix Pack 11
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.03.2015
08.10.2015
08.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.11 FixList