DB2 增量备份失败--file read failed(13)
Question/Issue:
操作系统：AIX 5.3
备份软件：Symantec Veritas Netbackup 6.5
数据库：DB2
Symptoms
这台服务器又3个DB2数据库实例，DB2全备成功，但是有一个数据库实例增量备份失败，job返回错误信息：file read failed(13)。
Trubleshoot：
检查超时设置，更改如下设置，但是备份仍然报错:
CLIENT_READ_TIMEOUT = 3600
CLIENT_CONNECT_TIMEOUT = 3600
LIST_FILES_TIMEOUT = 3600
MEDIA_CONNECT_TIMEOUT = 600
检查 bphdb 日志信息，发现policy刚发起就发生进程中断:
11:36:07.233 [512034] <16> bphdb do_backup: ERR - Script exited with status = 4 <archive file removal failed>
11:36:07.233 [512034] <32> bphdb sighandler: FTL - bphdb lost connection with server
11:36:07.233 [512034] <4> bphdb sighandler: INF - Killing all children in the same process group.
11:37:38.430 [917824] <4> bphdb keepalive_timeout: INF - bphdb still working.
11:37:38.430 [917824] <2> bphdb keepalive_timeout: INF - bphdb- Sending a keepalive.
11:40:08.431 [917824] <4> bphdb keepalive_timeout: INF - bphdb still working.
检查TRACKMOD模式为 ON;
检查DB2.conf;
DATABASE YYTORG
OBJECTTYPE ARCHIVE
POLICY yytlcdb2
SCHEDULE Default-Application-Backup
ARCFUNC COPY
ARCDIR /home/db2inst1/arcdir
RETDIR /home/db2inst1/arcdir
ENDOPER
Solution
检查DB2参数 LOGRETAIN,发现设置为 NO,这个参数会直接导致DB2 不能循环产生archive日志，db2 online备份需要数据库设置为循环日志模式，所以必须先设置LOGRETAIN,;
References
TN:
Technical Information
Case: 230673014
Internal Notes
Keywords (separate with commas)
71 none of the files in the file list exist
Product Versions
VERITAS Netbackup 6.5.3
VERITAS Netbackup for Vault 6.5.3
