veritas NBU backup DB2

Question

我用NBU备份DB2，请问db2.conf文件应该放在什么地方，这个文件在什么情况下被谁调用呢？谢谢。

Answer 1

原帖由 aping2005 于 2008-10-20 10:14 发表
实践证明windows下db2.conf要放在Veritas卷管理软件安装的目录下面。
例如：
C:Program FilesVeritasNetBackupDbExtDB2

恩，不好意思，我前面给你的是for unix的手册，windows版的手册上描述是：

To create a db2.conf file
1.Log into a client machine.
2.Copy the sample db2.conf file from its location in the sample folder to its active location.
Its location in the sample folder is as follows:
install_pathNetBackupdbextdb2samples
The active location for the db2.conf file is as follows: install_pathNetBackupdbextdb2db2.conf
3. Edit the db2.conf file.

Answer 2

2008-10-20-09.52.24.062000+480 E3053926H532       LEVEL: Error
PID     : 3304                 TID  : 3768        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
EDUID   : 3768                 EDUNAME: db2logmgr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgInvokeUserexit, probe:1550
MESSAGE : ADM1833E  The user exit program returned an error when archiving log
          file "S0000017.LOG" from "F:DB2NODE0000SQL00002SQLOGDIR" for
          database "SAMPLE".  The error code was "8".

研究了下这种报错的原因大概是因为userexit找不到db2.conf，读不到里面定义的policy和schedule,所以NBU server的activity monitor 里面一点反应都没有。

Answer 3

实践证明windows下db2.conf要放在Veritas卷管理软件安装的目录下面。
例如：
C:Program FilesVeritasNetBackupDbExtDB2

Answer 4

$DB2_Instance_Home/db2.conf

The db2.conf file includes specifications for backups and restores, and it provides information on policies and schedules. The NetBackup for DB2 library and user exit program use the information in this file.