cancel
Showing results for 
Search instead for 
Did you mean: 

Backup failing in Db2 11.5.4 on RedHat 8.2

angoca
Level 2

I want to perform a backup in Db2, to store it in Netbackup, but it fails. It used to work before the migration to these recent versions.

  • Db2: 11.5.4
  • RedHat: 8.2

db2.conf in the Db2 instance home:

DATABASE sample
OBJECTTYPE DATABASE
POLICY BD_DB2_DEV
SCHEDULE Default-Application-Backup
ENDOPER

When executing the following command:

 

$ db2 BACKUP DATABASE testconn LOAD /usr/openv/netbackup/bin/nbdb2.so64
SQL2079N  An error was reported by the shared library
"/usr/openv/netbackup/bin/nbdb2.so64".  Return code: "30".

The only Netbackup log generated under /usr/openv/netbackup/logs/bpdb2/db2inst1.100520_00001.log contains:

 

 

15:06:53.007 [2131215] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set.
15:07:38.198 [2131515] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set.
15:09:28.080 [2132336] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set.
15:21:08.837 [2135496] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set.
15:42:54.874 [2137047] <2> bsa_CloseDebugFD: DBG - bCloseDebug flag is set.

And the db2diag.log contains:

 

2020-10-05-15.42.54.783252-300 I1485538E3968         LEVEL: Error
PID     : 2135289              TID : 140074704430848 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 72                   EDUNAME: db2med.47.0 (SAMPLE) 0
FUNCTION: DB2 UDB, oper system services, sqloReadVendorRC, probe:30
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
          DIA8506C Unexpected end of file was reached.
DATA #1 : Codepath, 8 bytes
19
DATA #2 : Hexdump, 1 bytes
0x00007F65AEFFC740 : 00                                         .
DATA #3 : unsigned integer, 8 bytes
0
DATA #4 : Hexdump, 624 bytes
0x00007F654F0CC060 : C0CD 0C4F 657F 0000 60DC FFAE 657F 0000    ...Oe...`...e...
0x00007F654F0CC070 : 005E A74A 657F 0000 CD9B 2000 0000 0000    .^.Je..... .....
0x00007F654F0CC080 : 2100 0000 0200 0000 0010 0000 0000 0000    !...............
0x00007F654F0CC090 : 0000 0000 0000 0000 2F64 6232 2F69 6E73    ......../db2/ins
0x00007F654F0CC0A0 : 7461 6E63 6961 732F 6465 7361 7272 6F6C    stances/db2inst1
0x00007F654F0CC0B0 : 2F73 716C 6C69 622F 746D 702F 4442 3256    /sqllib/tmp/DB2V
0x00007F654F0CC0C0 : 454E 442E 5354 4449 4E2E 302E 3732 2E31    END.STDIN.0.72.1
0x00007F654F0CC0D0 : 3630 3139 3330 3537 3231 3837 3139 3400    601930572187194.
0x00007F654F0CC0E0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC0F0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC100 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC110 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC120 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC130 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC140 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC150 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC160 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC170 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC180 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC190 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC1A0 : 2200 0000 0100 0000 0010 0000 0000 0000    "...............
0x00007F654F0CC1B0 : 0000 0000 0000 0000 2F64 6232 2F69 6E73    ......../db2/ins
0x00007F654F0CC1C0 : 7461 6E63 6961 732F 6465 7361 7272 6F6C    stances/db2inst1
0x00007F654F0CC1D0 : 2F73 716C 6C69 622F 746D 702F 4442 3256    /sqllib/tmp/DB2V
0x00007F654F0CC1E0 : 454E 442E 5354 444F 5554 2E30 2E37 322E    END.STDOUT.0.72.
0x00007F654F0CC1F0 : 3136 3031 3933 3035 3732 3138 3731 3934    1601930572187194
0x00007F654F0CC200 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC210 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC220 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC230 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC240 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC250 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC260 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC270 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC280 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC290 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC2A0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC2B0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CC2C0 : 0000 0000 0100 0000 0100 0000 0000 0000    ................
DATA #5 : signed integer, 4 bytes
0

2020-10-05-15.42.54.783545-300 I1489507E571          LEVEL: Error
PID     : 2135289              TID : 140074704430848 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 72                   EDUNAME: db2med.47.0 (SAMPLE) 0
FUNCTION: DB2 UDB, oper system services, sqloInvokeVendorFunction, probe:30
MESSAGE : ZRC=0x800F00AF=-2146500433=SQLO_PROG_ERR "Unknown"
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x800F00AF

2020-10-05-15.42.54.784481-300 I1490079E1371         LEVEL: Error
PID     : 2135289              TID : 140074704430848 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 72                   EDUNAME: db2med.47.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluVendorCallWrapper, probe:337
MESSAGE : ZRC=0x800F00AF=-2146500433=SQLO_PROG_ERR "Unknown"
DATA #1 : String, 19 bytes
Signal encountered.
DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x0000001E=30 -- see DB2 API Guide for meaning.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x00007F65CC209A34 _Z21sqluVendorCallWrapperP18SQLO_VENDOR_HANDLEP23sqluFencedVendorCommBufjP28sqluFencedVendorProcessStateiP12SQLU_BAGT_CB + 0x204
  [1] 0x00007F65CC161E5B _Z20sqluInitVendorDeviceP13SQLUMC_IBLK_T + 0x7B
  [2] 0x00007F65CC151BD2 _Z18sqluMCInitBackupMCP13SQLUMC_IBLK_T + 0xD2
  [3] 0x00007F65CC153CF8 _Z25sqluMCProcessBackupStatesP13SQLUMC_IBLK_T + 0x438
  [4] 0x00007F65CC15445D _Z32sqluMCStartBackupMediaControllerPcj + 0x2ED
  [5] 0x00007F65CDCEC396 sqloEDUEntry + 0x2A6
  [6] 0x00007F65D41B72DE /lib64/libpthread.so.0 + 0x82DE
  [7] 0x00007F65C311AE83 clone + 0x43

2020-10-05-15.42.54.790986-300 I1491451E898          LEVEL: Error
PID     : 2135289              TID : 140074704430848 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 72                   EDUNAME: db2med.47.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:687
DATA #1 : String, 135 bytes
Vendor error: rc = 30 returned from function sqluvint.
Return_code structure from vendor library /usr/openv/netbackup/bin/nbdb2.so64:

DATA #2 : Hexdump, 48 bytes
0x00007F654F0CCD70 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CCD80 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0x00007F654F0CCD90 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

2020-10-05-15.42.54.791083-300 E1492350E500          LEVEL: Error
PID     : 2135289              TID : 140074704430848 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 72                   EDUNAME: db2med.47.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:880
MESSAGE : Media controller -- Generic error

2020-10-05-15.42.54.791140-300 E1492851E553          LEVEL: Error
PID     : 2135289              TID : 140074704430848 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 72                   EDUNAME: db2med.47.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:880
MESSAGE : SQL2079N  An error was reported by the shared library "".  Return
          code: "".

2020-10-05-15.42.54.791233-300 E1493405E522          LEVEL: Error
PID     : 2135289              TID : 140074704430848 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 72                   EDUNAME: db2med.47.0 (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:880
DATA #1 : String, 38 bytes
/usr/openv/netbackup/bin/nbdb2.so64.30

2020-10-05-15.42.54.791334-300 E1493928E768          LEVEL: Severe
PID     : 2135289              TID : 140074809288448 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 47                   EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1137
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2079
DATA #2 : Hexdump, 43 bytes
0x00007F65501ADC68 : E1F7 FFFF 2F75 7372 2F6F 7065 6E76 2F6E    ..../usr/openv/n
0x00007F65501ADC78 : 6574 6261 636B 7570 2F62 696E 2F6E 6264    etbackup/bin/nbd
0x00007F65501ADC88 : 6232 2E73 6F36 34FF 3330 00                b2.so64.30.

2020-10-05-15.42.54.791455-300 E1494697E1007         LEVEL: Severe
PID     : 2135289              TID : 140074809288448 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 47                   EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1137
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: 38
sqlerrmc: /usr/openv/netbackup/bin/nbdb2.so64 30
sqlerrp : sqlubMWR
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:

2020-10-05-15.42.54.791592-300 E1495705E585          LEVEL: Error
PID     : 2135289              TID : 140074809288448 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 47                   EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1139
MESSAGE : SQL2079N  An error was reported by the shared library
          "/usr/openv/netbackup/bin/nbdb2.so64".  Return code: "30".

2020-10-05-15.42.54.783425-300 E1496291E442          LEVEL: Error
PID     : 2135287              TID : 140157621626624 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1             NODE : 000
HOSTNAME: db2server
EDUID   : 2                    EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:9180
DATA #1 : <preformatted>
Beginning cleanup of Process id: 2137037, OSS term code: 0x101, signal: 11

2020-10-05-15.42.54.833714-300 E1496734E468          LEVEL: Error
PID     : 2135287              TID : 140157621626624 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1             NODE : 000
HOSTNAME: db2server
EDUID   : 2                    EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:9352
DATA #1 : <preformatted>
A fenced vendor process crashed. Process id: 2137037, OSS term code: 0x101, signal: 11, bringDown: 0

2020-10-05-15.42.54.833845-300 I1497203E802          LEVEL: Event
PID     : 2135287              TID : 140157621626624 PROC : db2wdog 0 [db2inst1]
INSTANCE: db2inst1             NODE : 000
HOSTNAME: db2server
EDUID   : 2                    EDUNAME: db2wdog 0 [db2inst1]
FUNCTION: DB2 UDB, oper system services, sqlossig, probe:10
MESSAGE : Sending SIGKILL to the following process id
DATA #1 : signed integer, 4 bytes
2137037
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x00007F79226B85DA sqlossig + 0x7A
  [1] 0x00000000004173FA _Z12sqleWatchDogm + 0xA6A
  [2] 0x00000000004199A4 DB2main + 0x1374
  [3] 0x00007F79227F11C2 sqloEDUEntry + 0xD2
  [4] 0x00007F7928CBC2DE /lib64/libpthread.so.0 + 0x82DE
  [5] 0x00007F7917C1FE83 clone + 0x43

2020-10-05-15.42.54.874812-300 I1498006E986          LEVEL: Error
PID     : 2135289              TID : 140074809288448 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 47                   EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubDeleteVendorImage, probe:618
MESSAGE : SQL2062N  An error occurred while accessing media "".  Reason code:
          "".
DATA #1 : String, 27 bytes
Error returned by sqluvdel.
DATA #2 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x0000001A=26 -- see DB2 API Guide for meaning.
DATA #3 : Hexdump, 48 bytes
0x00007F654F0C1B10 : F901 0000 4E65 7442 6163 6B75 7020 4442    ....NetBackup DB
0x00007F654F0C1B20 : 3220 496E 7075 7420 496E 7661 6C69 6400    2 Input Invalid.
0x00007F654F0C1B30 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

2020-10-05-15.42.54.875598-300 E1498993E644          LEVEL: Error
PID     : 2135289              TID : 140074809288448 PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000            DB   : SAMPLE
APPHDL  : 0-12                 APPID: *LOCAL.db2inst1.201005204251
AUTHID  : DB2INST1             HOSTNAME: db2server
EDUID   : 47                   EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:768
MESSAGE : SQL2062N  An error occurred while accessing media "".  Reason code:
          "".
DATA #1 : String, 63 bytes
Could not delete partial backup image created on vendor device.

Ports are open, file system backup can be performed.

What can be wrong? Is Veritas Netbackup supported in RedHat 8.2 and Db2 11.5.4?

 

IBM Champion 2015-2020
3 REPLIES 3

X2
Moderator
Moderator
   VIP   

On the database compatiblity checker https://sort.veritas.com/nbu_checkers/db_scl_checker it shows only RHEL 7 is supported with Db2 11.5

 

Ok, I see that. However Red Hat 8 was released in may 2019, and 8.2 was released in apr 2020. Thus, these are not "new" versions.

When Veritas has plan to release an updated version for RedHat?

The only recent document about a roadmap I found is this: https://sort.veritas.com/nbufutureplans Most recent update was in Sep 2020, but the previous one on Jan 2018.

 

IBM Champion 2015-2020

Tape_Archived
Moderator
Moderator
   VIP