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 사용자에게 질문에 대한 답변 찾기
지원 서비스
디바이스에 지원 서비스가 적용되는지 확인하십시오.