NMDA DB2 19.4.0.0 备份每晚随机失败,并显示错误 3

Summary: NMDA 19.4.0.0 DB2 多个 DB2 备份昨晚失败,出现错误 3。在两个存储节点中创建新设备和分散备份,并设置 DB2 重试和超时参数后,问题得到解决。

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Symptoms

NetWorker 客户端 19.4.0.0:AIX 7.2
NMDA 19.4.0.0、DB2 Server v11.1.4.4
DB2 备份每晚
随机失败 NMDA DB2 备份失败并出现错误 3
DB2 备份失败,并显示错误“lgto_auth for 'nsrmmd' failed: busy'There
is no networking or firewall issues

There are 1000's of below messages in daemon.raw in storage node:
”5004-nfs lookup failed (nfs:No such file or directory)“
”invalid save stream“
”Cannot stat active file“
”unable to collect deduplication statistics“
”was aborted and removed from volume“

Error in nmda-messages.log libnsrdb2.log with debug=9:
153929 2/9/2021 10:34:50 PM 4 7 987 1 18153790 0 (client) (pid18153790) NSR 严重 备份会话无法启动:忙碌。   <---这是美国东部时间时间,在我的实验室
中呈现 93412 2/9/2021 10:34:50 PM 3 5 0 1 18153790 0 (客户端) (pid18153790) NSR 错误无法执行作 2.状态已更改为 3。
153929 1612842069 4 7 987 1 19136950 0(客户端)(pid19136950) NSR 严重 39 备份会话无法启动:%s。1 49 8 0 4 busy <--- GMT 时间
93412 1612842069 3 5 0 1 19136950 0(客户端)(pid19136950) NSR 错误 62 无法执行作 %d。状态更改为 %d。2 1 1 2 1 1 3
(pid = 18809144) (02/09/21 21:40:00.338942) nsrdb2sv_log_program_args:/usr/bin/nsrdasv -LL -T db2 -s (NW server) -g (group) -a *policy action jobid=2297950 -a *policy name=(policy) -a *policy workflow name=(workflow) -a *policy action name=(action) -y Tue Feb 23 23:59:59 GMT-0600 2021 -w Tue Feb 23 23:59:59 GMT-0600 2021 -m (client) -a *policy action jobid restart=Yes -b (pool) -t 1612810625 -o ....

(pid = 18809144)(02/09/21 21:40:00.624767)备份 (DB) 数据库。
(pid = 18809144)(02/09/21 21:40:00.624939) set_db2_version:退出 set_db2_version():Return code: 10050000
(pid = 18809144) (02/09/21 21:49:08.731480) DbBackup:退出并显示错误:
由于备份请求失败,无法备份DB2MDME数据库,SQLCODE :-2025, SQL2025N An I/O error occurred.  Error code: "3".发生此错误的介质:“供应商”。

(pid = 18809144)(02/09/21 21:49:08.731631) libdb2sv_main:ERROR: DbBackup() 失败。
(pid = 18809144)(02/09/21 21:49:08.731685)由于备份请求失败,无法备份DB2MDME数据库,SQLCODE :-2025, SQL2025N An I/O error occurred.  Error code: "3".发生此错误的介质:“供应商”。

严重错误是 nsrmmd 繁忙错误,如下所示:
02/09/21 21:32:46 (PID 18153790):02/09/21 21:32:46.797073 lgto_auth for 'nsrd' succeeded
02/09/21 21:32:46 (pid 18153790):02/09/21 21:32:46.855631 lgto_parms for 'nsrmmd' succeeded
02/09/21 21:32:46 (pid 18153790):02/09/21 21:32:46.855705 got 'store index entries' value of 'Yes'02
/09/21 21:32:46 (pid 18153790):02/09/21 21:32:46.855803 Saving in pool 'IDC-DB2'.
02/09/21 21:32:46 (pid 18153790):02/09/21 21:32:46.855822 server enabled for immediate mode
02/09/21 21:32:46 (pid 18153790):02/09/21 21:32:46.882267 lgto_auth for 'nsrmmd' failed: busy
02/09/21 21:32:46 (pid 18153790):02/09/21 21:32:46.882349 无法获取直接保存 nsrmmd 身份验证的用户凭据: 忙碌。
02/09/21 21:32:46 (pid 18153790):02/09/21 21:32: 46.882439 错误类型为 0,严重性为 0,数字为-13,errnum 为-13,errstr 为“繁忙”。

Cause

配置/资源可用性问题。

Resolution

在执行以下更改后解决了问题。没有单一的根本原因,但创建新设备并在下面设置参数帮助最大:

1.在 SN03
2 中添加了 1 个新设备。将备份均匀分布到 SN01 和 SN03(目标会话等)
3.更改了备份开始时间
4.在 NMDA DB2 应用程序信息中添加了这些参数:

NSR_MAX_START_RETRIES=50
NSR_FXBUSY_RETRIES=10
NSR_MMDB_RETRY_TIME=10

5.将非活动超时增加到 300,重试次数 = 2,重试延迟 = 10

Affected Products

NetWorker Module for Databases and Applications
Article Properties
Article Number: 000183668
Article Type: Solution
Last Modified: 28 رجب 1447
Version:  6
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.