DB2 policy restore error (2812)

Question

Hi All Expert,Hope you have experience and share it.We try redirect restore DB2 and always failed same error.=Master is Media Server too=Windows Server 2016 Standard, NBU version 8.3.0.2=Source&nbsp; client ggpdbsprd02=*Linux Suse SLES 11.4*DB2 tokens are "DB2 v10.5.0.8", "special_36677", "IP23993_36677", and Fix Pack "8".=Target&nbsp; client ggp-firedrill=*Linux Suse SLES 11.5*DB2 tokens are "DB2 v10.5.0.8", "special_36677", "IP23993_36677", and Fix Pack "8".And always error after 2 hours in activity monitorJul 29, 2024 2:11:20 PM - started process bptm (pid=17144)Jul 29, 2024 2:11:20 PM - begin readingJul 29, 2024 4:02:09 PM - Info bptm (pid=12888) waited for empty buffer 4 times, delayed 433192 timesJul 29, 2024 4:02:09 PM - end reading; read time: 1:50:49Jul 29, 2024 4:02:09 PM - Info bptm (pid=12888) completed reading backup imageJul 29, 2024 4:02:09 PM - Info bptm (pid=12888) EXITING with status 0 &lt;----------Jul 29, 2024 4:12:05 PM - Info dbclient (pid=26863) done. status: 41: network connection timed outJul 29, 2024 4:12:05 PM - Error bpbrm (pid=1804) client restore EXIT STATUS 41: network connection timed outJul 29, 2024 4:12:06 PM - restored from image ggpdbsprd02_1720435442; restore time: 2:00:50Jul 29, 2024 4:12:07 PM - end Restore; elapsed time 2:00:52DB2 policy restore error &nbsp;(2812)db2diag show:2024-07-30-15.45.55.336621+420 E74368E518 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: ErrorPID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140289440212736 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 1082 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EDUNAME: db2med.487.0 (PRD) 0FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1868MESSAGE : Media controller -- problem reading from vendor device2024-07-30-15.45.55.336781+420 E74887E550 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: ErrorPID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140289440212736 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 1082 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EDUNAME: db2med.487.0 (PRD) 0FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1868MESSAGE : SQL2079N &nbsp;An error was reported by the shared library "". &nbsp;Return&nbsp; code: "".2024-07-30-15.45.55.337050+420 E75438E519 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: ErrorPID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140289440212736 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 1082 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EDUNAME: db2med.487.0 (PRD) 0FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1868DATA #1 : String, 38 bytes /usr/openv/netbackup/bin/nbdb2.so64.302024-07-30-15.45.55.337263+420 E75958E577 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: ErrorPID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140287909291776 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 487 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EDUNAME: db2agent (PRD) 0FUNCTION: DB2 UDB, database utilities, sqludMRResponse, probe:981MESSAGE : SQL2079N &nbsp;An error was reported by the shared library&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "/usr/openv/netbackup/bin/nbdb2.so64". &nbsp;Return code: "30".2024-07-30-15.45.55.337278+420 E76536E594 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: SeverePID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140288290973440 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 1080 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EDUNAME: db2bm.487.0 (PRD) 0FUNCTION: DB2 UDB, database utilities, sqludBMCont, probe:1373DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes -2054DATA #2 : Hexdump, 8 bytes0x00007F979DAD0298 : FAF7 FFFF 1600 0000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;........2024-07-30-15.45.55.338601+420 E77131E924 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: SeverePID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140288290973440 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 1080 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EDUNAME: db2bm.487.0 (PRD) 0FUNCTION: DB2 UDB, database utilities, sqludBMCont, probe:1373MESSAGE : SQL2054N &nbsp;The backup or copy image is corrupted.DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes&nbsp;sqlcaid : SQLCA &nbsp; &nbsp; sqlcabc: 136 &nbsp; sqlcode: -2054 &nbsp; sqlerrml: 2&nbsp;sqlerrmc: 22&nbsp;sqlerrp : sqludBMC&nbsp;sqlerrd : (1) 0x00000000 &nbsp; &nbsp; &nbsp;(2) 0x00000000 &nbsp; &nbsp; &nbsp;(3) 0x00000000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(4) 0x00000000 &nbsp; &nbsp; &nbsp;(5) 0x00000000 &nbsp; &nbsp; &nbsp;(6) 0x00000000&nbsp;sqlwarn : (1) &nbsp; &nbsp; &nbsp;(2) &nbsp; &nbsp; &nbsp;(3) &nbsp; &nbsp; &nbsp;(4) &nbsp; &nbsp; &nbsp; &nbsp;(5) &nbsp; &nbsp; &nbsp; (6)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(7) &nbsp; &nbsp; &nbsp;(8) &nbsp; &nbsp; &nbsp;(9) &nbsp; &nbsp; &nbsp;(10) &nbsp; &nbsp; &nbsp; &nbsp;(11)&nbsp;sqlstate:2024-07-30-15.45.55.387385+420 E78056E467 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: SeverePID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140287909291776 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 487 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EDUNAME: db2agent (PRD) 0FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:896MESSAGE : Restore Terminated.Terima kasih.

garyy · Answer

Hi Jhony_LMB&nbsp;
Error from db2diag happens before 2 hours.
2024-07-30-15.45.55.337263+420 E75958E577 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEVEL: ErrorPID &nbsp; &nbsp; : 21348 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TID : 140287909291776 PROC : db2sysc 0INSTANCE: db2prd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NODE : 000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DB &nbsp; : PRDAPPHDL &nbsp;: 0-4074 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; APPID: *LOCAL.db2prd.240729071117AUTHID &nbsp;: DB2PRD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; HOSTNAME: ggp-firedrillEDUID &nbsp; : 487 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EDUNAME: db2agent (PRD) 0FUNCTION: DB2 UDB, database utilities, sqludMRResponse, probe:981MESSAGE : SQL2079N &nbsp;An error was reported by the shared library&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "/usr/openv/netbackup/bin/nbdb2.so64". &nbsp;Return code: "30".
Return code 30 usually occurs due to permission issues or incorrect library versions being used. Make sure the correct version of the NetBackup DB2 extension library is being used. If the server is running a 32-bit version of NetBackup, it should use the 32-bit library (nbdb2.sl) instead of the 64-bit library (nbdb2.so64).If not this, check the permissions of the /usr/openv/netbackup/bin/nbdb2.so64 file. Make sure at least 755There is a known issue with db2 11.1 version with same error, but looks like you have db2 version 10.5. Please run db2level to confirmThanksGary
&nbsp;

will_hunting · Answer

Jul 29, 2024 4:02:09 PM - Info bptm (pid=12888) waited for empty buffer 4 times, delayed 433192 times

There are too many delayed times, I think there must be something wrong with the network.

Forum Discussion

DB2 policy restore error (2812)

Related Content

Re: Duplication job is failing with status code 228

Windows backup is failing with 13 status

How to install netbackup client on windows server 2012

Backup failing with exit status 42

bprestore issues while extracting db2 archive logs

Recent Discussions

NBU 10.3.0.1 Protection Plan doesnt let you add asset

setup Malware Scanning

Data migration for LTR images of 3 clients

restoring file from linux source to windows target; is possible?

Installing a New Media Server and Transferring the Media Server Role