Avamar DB2 online backup fails if database archive log config is blank, db2diag.log shows SQL2413N
概要: If any target database for an online Avamar DB2 backup has not been prepared with archive log configuration, backup fails with errors. In one example, the default DB2 "SAMPLE" test database was added to the dataset. The database has not been prepared for online backups and contained no user data. ...
この記事は次に適用されます：
この記事は次には適用されません：
この記事は、特定の製品に関連付けられていません。
すべての製品パージョンがこの記事に記載されているわけではありません。
現象
db2diag.log may contain the SQL2413N message indicating one of the target databases is in an incorrect state for online backup.
Check the database configuration for archive log with this command:
2023-04-10-11.30.14.627550+480 E1599095A1002
LEVEL: Severe PID : 38404382 TID : 3604 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-14367
PPID: *LOCAL.db2inst1.230410033043 AUTHID : DB2INST1 HOSTNAME: db2host
EDUID : 3604 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database utilities, sqlubInitCheck, probe:928
MESSAGE : SQL2413N Online backup is not allowed because the database is not recoverable or a backup pending condition is in effect.
Check the database configuration for archive log with this command:
db2 get db cfg for <database_name> | grep -i logarchmeth
First log archive method (LOGARCHMETH1) = OFF
Options for logarchmeth1 (LOGARCHOPT1) =
Second log archive method (LOGARCHMETH2) = OFF
Options for logarchmeth2 (LOGARCHOPT2) =原因
Steps for "preparing the database for backup" from DB2 guide were not followed.
DB2 includes a "SAMPLE" database that should not be included in backups. The user may have prepared their primary databases, but not this sample database.
In this case, the log would show SAMPLE as a target:
DB2 includes a "SAMPLE" database that should not be included in backups. The user may have prepared their primary databases, but not this sample database.
In this case, the log would show SAMPLE as a target:
2023-04-10 14:23:13 avdb2 Info <7084>: target[15]=db2inst1/SAMPLE
解決方法
Remove SAMPLE database from the list of targets unless the user wants it to be backed up.
Configure all target database logarch settings with steps from Avamar DB2 guide and try the backup again. See the "Preparing the database for backup" section.
If the backup continues to fail, collect the following for review by Dell Technical Support:
Configure all target database logarch settings with steps from Avamar DB2 guide and try the backup again. See the "Preparing the database for backup" section.
If the backup continues to fail, collect the following for review by Dell Technical Support:
- Another set of backup logs
- Output showing that database logarch config parameters have been set
- Another db2diag.log
対象製品
Avamar Plug-in for IBM DB2, Avamar Server文書のプロパティ
文書番号: 000212572
文書の種類: Solution
最終更新: 02 6月 2023
バージョン: 2
質問に対する他のDellユーザーからの回答を見つける
サポート サービス
お使いのデバイスがサポート サービスの対象かどうかを確認してください。