Backup failing in Db2 11.5.4 on RedHat 8.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?2.3KViews0likes3Comments