由於 DB2 實例使用者或密碼已變更或到期,Avamar DB2 備份失敗,並顯示「安全性錯誤」 

Summary: Avamar DB2 備份失敗,avdb2 記錄檔顯示「安全性錯誤」。

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

Avamar DB2 備份失敗,並在備份記錄中產生下列錯誤。
 
2023-03-02 07:46:10 avdb2 Error <9004>: DB2 returned security error -30082
2023-03-02 07:46:10 avdb2 Info <9772>: Starting graceful (staged) termination, Unable to attach to the instance. (wrap-up stage)
2023-03-02 07:46:10 avdb2 Error <19177>: Snapup of db2portl/FDBKDB Terminated.
2023-03-02 07:46:47 avdb2 Info <6688>: Process 9437492 (/usr/local/avamar/bin/avtar) finished (code 0: success)
2023-03-02 07:46:47 avdb2 Error <16729>: Unable to get the list of backup images from the child process.
2023-03-02 07:46:47 avdb2 Info <9772>: Starting graceful (staged) termination, Unable to get the list of backup images from the child process. (wrap-up stage)
2023-03-02 07:46:47 avdb2 Error <43351>: Failed to create the snapview. However, the database data has been successfully backed up and is marked as a hidden backup. Restore is available through CLI only. See the plug-in documentation for information about restoring hidden backups.


db2diag.log 顯示db2agent 嘗試使用db2admin帳戶登入。由於密碼不正確,工作會失敗:
 
2023-03-05-23.00.11.998228-300 I8253775A506         LEVEL: Warning
PID     : 12911084             TID : 68893          PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000
APPHDL  : 0-42482              APPID: *LOCAL.db2portl.230306040019
HOSTNAME: db2_host_name
EDUID   : 68893                EDUNAME: db2agent (instance) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 67 bytes
Password validation for user db2admin failed with rc = -2146500507 

avdb2 記錄顯示已設定哪一個 db2 實例使用者:
 
 <flag type="string" pidnum="5009" value="db2admin" name="db2_inst_user" />
 <flag type="string" pidnum="5009" value="db2inst1" name="db2_inst_name" />

Cause

DB2 實例使用者或密碼已變更或過期。

Resolution

db2diag.log 向客戶資料庫管理員提供錯誤,以便確認使用者帳戶的狀態。可能與 db2admin 不同。

確認有效認證後,請在 DB2 資料集中更新這些欄位:
  • 實例管理員使用者名稱
  • 實例管理員密碼 

Additional Information

登入 Dell 支援以檢視本文,並提供收集記錄/db2diag.log

Avamar DB2 外掛程式的步驟:  疑難排解備份或還原故障所需的記錄。

Affected Products

Avamar Plug-in for IBM DB2
Article Properties
Article Number: 000211371
Article Type: Solution
Last Modified: 02 Jun 2023
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.