Forum Discussion

prabhjotsingh's avatar
4 years ago

bprestore issues while extracting db2 archive logs

bplist command is listing the archive logs related to a policy for db2 

[auto1111@ip-10-113-248-26 home]$ /usr/openv/netbackup/bin/bplist -C tsm-king.yahoo.co -S nbu-80-master.yahoo.co -t 18 -k DB2-LOGS -s 10/01/2020 -e 10/20/2020 -U -l -Listseconds -R /
-rw-rw-r-- auto1111 db2iadm1 4104192 1602985011 1602985011 61 /DB2/R74D111A/LOGFILE/node0000/auto1111/C0000000_S0000064.LOG

/usr/openv/netbackup/bin/bprestore -B -L /tmp/bkup.log -C tsm-king.yahoo.co -D nbu-stg-server.yahoo.co -t 18 -p DB2-LOGS -s 10/01/2020 00:00:00 -e 10/20/2020 00:00:00 /DB2/R74D111A/LOGFILE/node0000/auto1111/C0000000_S0000064.LOG  << It is failing 

Oct 22, 2020 6:12:28 AM - begin Restore
Oct 22, 2020 6:12:28 AM - Info bprd (pid=20416) Found (47) files in (47) images for Restore Job ID 141743.xxx
Oct 22, 2020 6:12:28 AM - restoring from image tsm-king.yahoo.co_1602511308
Oct 22, 2020 6:12:29 AM - Info bprd (pid=20416) Searched ( 1) files of (47) files for Restore Job ID 141743.xxx
Oct 22, 2020 6:12:29 AM - Info bprd (pid=20416) Restoring from copy 1 of image created Mon Oct 12 14:01:48 2020 from policy DB2-LOGS
Oct 22, 2020 6:12:29 AM - Info bpbrm (pid=20431) nbu-stg-server.yahoo.co is the host to restore to
Oct 22, 2020 6:12:29 AM - Info bpbrm (pid=20431) reading file list for client
Oct 22, 2020 6:12:29 AM - Info bpbrm (pid=20431) listening for client connection
Oct 22, 2020 6:17:29 AM - Error bpbrm (pid=20431) listen for client timeout during accept from data listen socket after 60 seconds
Oct 22, 2020 6:17:29 AM - Info dbclient (pid=0) done. status: 54: timed out connecting to client
Oct 22, 2020 6:17:29 AM - Error bpbrm (pid=20431) client restore EXIT STATUS 54: timed out connecting to client
Oct 22, 2020 6:17:29 AM - restored from image tsm-king.yahoo.co_1602511308; restore time: 0:05:01
Oct 22, 2020 6:17:30 AM - end Restore; elapsed time 0:05:02
DB2 policy restore error  (2812)



  • This looks like a Client Connect timeout. Default timeout is 5 min (300).

    I have seen with SQL and Oracle restores that Client Connect and Client Read timeouts need to be increased on the media server.

    Please increase thes 2 timeouts to 1800.
    Ensure that bpbrm and bptm folders exist on the media servers and bpcd log folder on the client.
    Set logging to level 3 on media server and client.

    If restore still fails, start with bpbrm log on the media server to track client connection attempt.