suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT28801 Status: Closed

BACKUP WITH AIX COMPRESSION NX842 RETURN SQL2079 GETMAXCOMPRESSEDSIZE
PROMISED THAT THIS BUFFER WOULD BE BIG ENOUGH

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
When using NX842 on AIX either during log archive compression or
during backup compression either by specifying the compression
library libdb2nx842.a or through the registry variable
DB2_BCKP_COMPRESSION=NX842 SQL error -2079 can be returned and
the backup fails with the following message:

2019-03-24-21.45.34.212841+060 E9253174A650         LEVEL: Error
PID     : 8389064              TID : 15632          PROC :
db2sysc 1
INSTANCE: uipm7201             NODE : 001           DB   :
DBPM7201
APPHDL  : 1-13167              APPID: *N1.uipm7201.190324204533
AUTHID  : UIPM7201             HOSTNAME: SPA04R00
EDUID   : 15632                EDUNAME: db2bm.17516.0 (DBPM7201)
1
FUNCTION: DB2 UDB, database utilities,
sqlubManageCompressedObject, probe:1434
DATA #1 : String, 86 bytes
GetMaxCompressedSize promised that this buffer would be big
enough.
srcSize / tgtSize:
DATA #2 : signed integer, 4 bytes
17
DATA #3 : signed integer, 4 bytes
20

2019-03-24-21.45.34.213683+060 E9253825A693         LEVEL:
Severe
PID     : 8389064              TID : 15632          PROC :
db2sysc 1
INSTANCE: uipm7201             NODE : 001           DB   :
DBPM7201
APPHDL  : 1-13167              APPID: *N1.uipm7201.190324204533
AUTHID  : UIPM7201             HOSTNAME: SPA04R00
EDUID   : 15632                EDUNAME: db2bm.17516.0 (DBPM7201)
1
FUNCTION: DB2 UDB, database utilities,
sqlubManageCompressedObject, probe:1440
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2079
DATA #2 : Hexdump, 22 bytes
0x0000000113102A18 : FFFF F7E1 6C69 6264 6232 6E78 3834 322E
....libdb2nx842.
0x0000000113102A28 : 6100 0000 0001
a.....

2019-03-24-21.45.34.214146+060 E9254519A995         LEVEL:
Severe
PID     : 8389064              TID : 15632          PROC :
db2sysc 1
INSTANCE: uipm7201             NODE : 001           DB   :
DBPM7201
APPHDL  : 1-13167              APPID: *N1.uipm7201.190324204533
AUTHID  : UIPM7201             HOSTNAME: SPA04R00
EDUID   : 15632                EDUNAME: db2bm.17516.0 (DBPM7201)
1
FUNCTION: DB2 UDB, database utilities,
sqlubManageCompressedObject, probe:1440
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: 15
sqlerrmc: libdb2nx842.a 1
sqlerrp : sqlubMan
sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6)
0x00000001
sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
           (7)      (8)      (9)      (10)        (11)
sqlstate:
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1.4.5 or later                             *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : 
follow-up : IT30804 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.04.2019
31.10.2019
31.10.2019
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)